Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: cognos2014 on 03 May 2016 02:57:58 PM

Title: SOLVED:Audit Tables not populating - Cognos 10.2.2 and Oracle 12c database
Post by: cognos2014 on 03 May 2016 02:57:58 PM
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!!
Title: Re: Audit Tables not populating - Cognos 10.2.2 and Oracle 12c database
Post by: sunosoft on 04 May 2016 01:32:22 AM
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.
Title: Re: Audit Tables not populating - Cognos 10.2.2 and Oracle 12c database
Post by: cognos2014 on 04 May 2016 12:17:47 PM
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
Title: SOLVED: Audit Tables not populating - Cognos 10.2.2 and Oracle 12c database
Post by: cognos2014 on 04 May 2016 03:29:58 PM
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.
Text only | Text with Images