SOLVED:Audit Tables not populating - Cognos 10.2.2 and Oracle 12c database

[cognos2014]

Hi Gurus,

Followed all the steps and set up audit configuration, database and logging levels. The tables are created but no data in them. Have found few posts with same issue but the solution doesn't work for us.

Anyone has had similar experience? FYI - One of the main solution provided by IBM was to ensure no ipfclientconfig.xml is present under the configuration folder which we don't have.

Any help appreciated.

Thanks!!

[sunosoft]

What does log file say ? any specific errors there ? Did you check with your DBA if the userid being used in Cognos configuration is having write access to Audit database.

[cognos2014]

No specific errors in the logfile. The user does have write access to the database. I tried adding few rows to one of the table and it works. Have also eliminated tablespace quota for the user. Waiting to hear back from IBM on the PMR

[cognos2014]

Problem Solved! In case anyone runs into similar issues, we had to have ojdbc7.jar file ( we had ojdbc6.jar). Once we copied it from the Oracle client, tables started getting written.