,
the tables and the columns in each table are automatically created
when you start the Cognos 8 services.If you configure Cognos 8 to send log messages
to a database ,
the tables and the columns in each table are automatically created
when you start the Cognos 8 services.
To avoid name conflicts with database keywords, all column names in the log database have the prefix "COGIPF". If you are upgrading from ReportNet 1.1 MR1 or MR2 to Cognos Series 8, the prefixes exist in the log database already and you do not need to make any changes. However, if you are upgrading from a release before ReportNet 1.1 MR1, to continue using reports that are based on the sample model from the previous release, you must update your audit metadata package to reflect the new column names. You can either:
reimport the Sample Deployment Archive
republish the package using the sample model
If you have created your own log database model, you must add the prefix "COGIPF" to the column names of the logging database tables in the model.
Document the procedure below in the location where we describe the existing columns for the audit DB.
