If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Setting up Logging in Cognos Configuration

Started by tmathew81, 02 Jun 2011 03:05:53 PM

Previous topic - Next topic

tmathew81

Cognos Configuration was initially setup to log to a SQL database called 'C10_Logs'. I made a backup of this database and restored it with a new name called 'Audit'. I then changed the logging database name in Cognos Configuration to be 'Audit' and restarted the services.

However, the 'Audit' database is not being updated with the latest information. As a test, I log in and out of Cognos Connection on 6/2/2011 at 4:00pm and then I run the following script against the 'Audit' database

select max(COGIPF_LOCALTIMESTAMP) from COGIPF_USERLOGON

and the resulting date/time is back when I created the 'Audit' database. However, if I run the same query against the old database 'C10_Logs', I get the date/time of my login from my test (6/2/2011, 4:00pm)

What do I need to do to switch Cognos Configuration to point to the new database 'Audit'?

Thanks,
Tom 

kmuller

Does the id in your configuration have the correct permissions on the new db?