Data no longer logged in a new Audit Database with existing COG_IPF tables..

Technote (troubleshooting)


Problem(Abstract)

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.

Cause

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.

Related information

1339620 - No data is being logged to the audit database

Historical Number

1016726

Rate this page:

(0 users)Average rating

Document information


More support for:

Cognos Business Intelligence
Install and Config

Software version:

8.3, 8.4, 8.4.1, 10.1, 10.1.1, 10.2, 10.2.1, 10.2.2

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:

1339201

Modified date:

2014-12-04

Translate my page

Machine Translation

Content navigation