cognos 10.2 Audit database tables have no data written

[ricky_ru]

Dears,

I just followed the Administration and Security guilde to setup the audit database. I am sure it is ok. Because the test connection is passed and I checked the schema has those tables whose name start with COGIPF_

So, I also setup openldap successfuly and I am able to login cognos with the users stored in the provider.

I then modified the loggig value to Request for CM service and Dispatcher. But there is still no data written in the COGIPF_USERLOGON table. I also restarted the service even the whole cognos instance, unluckly, it does not work.
I also modified all the services' logging value to Request but still failed to log to database when I login and logoff with users.

Do you have any clue on this problem?

[CAM-AAA]

Maybe re start the cognos service(s) and then see if that helps?
I have see that happen before. Also, make sure you do not place the Audit tables in the Content Store DB.
I know this is basic info, but it seems you have your bases covered. Most people forget to turn up the logging level.

[Jaking]

We are experiencing the same thing but only with the COGIPF_USERLOGON table.  What database technology are you using for your audit database?  Could it be something at the database level?

[CAM-AAA]

Do you have a CM only install? If yes, does your Cognos Config contain the Audit DB connection info? If your CM isn't writing to the audit db, then you wont get the logon info.

[ricky_ru]

I am using Oracle database. And I found several people around me encountering the same problem.

The installation is a single one. CM and App tier components are residing the same Linux machine.

[culori]

Have you solved this issue? I am using Cognos 8.4 on Oracle 11g, with separate schemes for CM and Audit.
Only the COGIPF_USERLOGON is not updated.

Thanks!

[ricky_ru]

Yeah...I fixed that. The possible reasons are

1) check the user permission. My problem was that the user does not have quota for the tablespace even he has create table(owner) permission.
2) Check the CM and dispatch logging level. (Minimal level will not record information to audit database. Change to basic)
3) If only some tables do not have logging information, it may be caused by the UDP protocol. Change the Enable TCP? to true.

Hope it helps

[clayton]

hi,

Only the COGIPF_USERLOGON is not updated, I will change the Enable TCP? to true.

[saikrishna86]

Hi All,

Any one have solution this problem,  I am also facing the same problem, I can see all tables created, the connection test was successful from Cognos Configuration, But none of the tables are updated, all tables are with Zero records. Please help me in fixing the problem. Thank you..

[jharmor]

Hello,
Change your logging level from minimal to basic.