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
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
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
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.
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
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