After adding an audit database with COG_IPF tables already existing, activity is no longer logged. There are no error messages displayed or other indications of an error other than the absence of data in the audit database.
The COG_IPF tables need to be created when configuring the audit database for the first time. If there is already an existing table structure in the audit database, data will not be properly logged.
Resolving the problem
Create a new audit database and configure ReportNet/Cognos 8 or 10 against that. If an existing audit database is to be used, you can create a new one to allow the appropriate tables to be created during configuration, then restore the existing database using the database client tools.
Make sure audit logging levels are set to at least 3 (Basic/Request), and native query is enabled. Also, there must not be an ipfclientconfig.xml file present in the configuration folder as this will interfere with normal logging activity. (it is fine to have renamed versions such as ipfclientconfig.xml.sample)
Note: If you are in a multi-server distributed environment, this will need to be performed on each Content Manager and Application Tier install.
|Business Analytics||Cognos 8 Business Intelligence||Cognos Connection|
|Business Analytics||Cognos 8 Business Intelligence||Install and Config|
|Business Analytics||Cognos 8 Business Intelligence||Report Studio|
|Business Analytics||Cognos ReportNet||ReportNet|