Audit database failing to write to tables

[faouzis]

Hi

I am encountering a problem having Cognos to write to the Audit database. I am working with IBM COGNOS on this issue but wanted to check whether anyone has encountered the problem.

(We have Cognos on AIX (oslevel 6.1) and using INFORMIX database (using Informix versions 11.7 and 12)

The Audit database is created properly with the appropriate permission and tested from the Cognos configuration. I am getting the following error in cogserver.log everytime it tries to create to any Audit Table. This is an example of log error in cogserver.log:
172.20.100.70:9300      19530162        2014-11-07 14:32:32.850 -5
                        Thread-19       LOGSV   5001    1       server.Audit.IPF
        Execute AuditDatabaseConnection jdbc:db2://saturn:16018/cogaudit:allowNextOnExhaustedResultSet=true;:retrieveMessagesFromServerOnGetMessage=true;fullyMaterializeLobData=false; Failure Log Server generic error        <parameters><item name="DB URL"><![CDATA jdbc:db2://saturn:16018/cogaudit:allowNextOnExhaustedResultSet=true;:retrieveMessagesFromServerOnGetMessage=true;fullyMaterializeLobData=false;]]></item><item name="DB SQL Exception"><![CDATA[Failure to insert in COGIPF_ACTION, [jcc][10120][10943][3.66.46] Invalid operation: statement is closed . ERRORCODE=-4470, SQLSTATE=null]]></item></parameters>

Thanks

[AussiePete2011]

Hi there

Not really an export on Informix but have you read this article - https://www.ibm.com/developerworks/data/tutorials/dm-1106cognosinformixpart2/
It's usually caused by the jdbc driver not being properly loaded.

Cheers
AussiePete

[faouzis]

Hi AussiePete,

Thank you for your post.

The Cognos content store is already using the same jdbc and working fine.  But I will take your suggestion and look into the driver (I got a suggestion to use an older version as well).

I will keep you posted with my findings.

Regards
Faouzi

[MMcBride]

I am on AIX but using DB2 as my Content Store and Audit database

My Audit database is in a different Schema than my Content Store.

A situation I have seen in the past - if I lose connectivity to the Database for whatever reason, the Content Store will "self heal" but the Audit Logs will stop, they will not restart until I fully restart all of Cognos.

I have never looked into the reason behind this, I simply put in a rule to the DBA's that if they needed to stop the DB2 services for any reason I am told so that I can restart Cognos once they are finished.

[AussiePete2011]

Hi there

There is a possible other reason that the audit tables aren't being written to is because there may be an active ipfclientconfig.xml file active somewhere in your installation.
Check for an ipfclientconfig.xml file under your <Path>\Cognos\configuration directories.

There's another similar discussion here
http://www.cognoise.com/index.php?topic=8285.15

Also as a reference
http://www-01.ibm.com/support/docview.wss?uid=swg21587003

Hope you find a solution
Cheers
AussiePete

[faouzis]

Hi everyone

First of all thank you all for taking the time to respond to this Post and the good news I am able to log to the Informix Audit database.

After working with IBM Cognos Support, we found out that the jdbc driver version was the cause. We are using jdbc driver version v10.5 FP1, I had to go back to v9.7 FP6 to make the Audit database working.

FYI: Here is the url to find out the available version/fixpack:
http://www-01.ibm.com/support/docview.wss?uid=swg21363866

Best Regards
Faouzi