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
Does the id in your configuration have the correct permissions on the new db?