Problem Enabling The Audit Database

[Peewee71]

Hi, I'm trying to enable the audit database so that i can find out useful information on my cognos system, like users logged in, which reports are not being used etc.

If I load up the cognos configuration and check 'Enviornment -> Logging -> Audit DB. I have database Dnet_audit defined. I have tested the connection by right cliking and selecting test and it is ok.  The logging levels are all set to set to basic, request or trace and i have restarted the service. My cognos version is 8.2.

I have logged into this database ok, but cannot find any of the cogipf_* tables.

Have i missed a step? Shouldn't these tables be automatically created?

[Peewee71]

One thing that i thought i'd mention is that:

'Enviornment -> Data Access-> Content Manager -> LoanIQ Datanet' also points to the same database
as  'Enviornment -> Logging -> Audit DB ->  Dnet_audit'. 

Logging into this database i can see plenty of active connections from the machine where cognos config is running using the login details which we have defined in cognos configuration. There are plenty of tables in this data such as CMDATA which i presume is the content manager data, but no cogipf_* tables exists here.

[Peewee71]

I am getting the following log message about the auditdatabase:

11.160.189.47:9300 4852 2011-02-22 12:58:04.667 +0     Thread-10 LOGSV 1929 1 server.Audit.IPF Execute AuditDatabaseConnection jdbc:oracle:thin:@LON3310XUS.FM.RBSGRP.NET:1621:dnetda2 Failure Log Server generic error <parameters><item name="DB URL"><![CDATA[jdbc:oracle:thin:@LON3310XUS.FM.RBSGRP.NET:1621:dnetda2]]></item><item name="DB SQL Exception"><![CDATA[ORA-01400: cannot insert NULL into ("DNET_USR"."COGIPF_PARAMETER"."COGIPF_REQUESTID")

[sashafay]

Which database you're using? If this Oracle that is ok to use same name, but if you have SQL Server, I would not recommend doing so. Create a new DB for Audit, separated from Content Store. Also, did you enable audit login from Cognos Connection by changing default from Minimal to Basic, for normal non-debug system operation?

[Peewee71]

The tables have been created now and are being populated. Not sure what caused the change..

thx