COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: bibat on 21 Feb 2011 12:57:20 PM

Title: Urgent production help - Audit database doesn't log data after upgrade
Post by: bibat on 21 Feb 2011 12:57:20 PM
Hi frnds,

I upgraded 8.4 to 8.4.1 installed in new directory. Cognos services are up.
Everything looks fine but Audit reports doesn't pull latest data.
Log information is not saved to Audit database anymore.

Any configuration that needs to be changed?
Plz help.

Its urgent...its on production
Title: Re: Urgent production help - Audit database doesn't log data after upgrade
Post by: sashafay on 21 Feb 2011 03:47:48 PM
Check whether level of Cognos system login under Cognos Administration has been changed from Minimal to Basic, for normal non-debug system operation.
Title: Re: Urgent production help - Audit database doesn't log data after upgrade
Post by: bibat on 21 Feb 2011 07:20:25 PM
How do i check that?
Title: Re: Urgent production help - Audit database doesn't log data after upgrade
Post by: sashafay on 22 Feb 2011 10:40:05 AM
Depends which version you're using. If you on 8.3 or higher, go to Cognos Administration>Configuration>Dispatchers and Services. Select property icon on the right upper corner (you also can do this from each dispatcher property if you have more than one, but this is main property that applies everywhere) and then select second tab Settings. Change category from ALL to Logging and on the right side under Value you will see what your system is set to. You also can do those steps from Status>System>Settings and select property there (right lower window). Hope this helps...  ;)
Title: Re: Urgent production help - Audit database doesn't log data after upgrade
Post by: bibat on 22 Feb 2011 11:41:45 AM
Thanks Sashafay,

It was all Minimal.
I changed it to Basic.

But still logs are not being saved to database.

Do i need to Restart the cognos services to make this change affective?
Title: Re: Urgent production help - Audit database doesn't log data after upgrade
Post by: sashafay on 22 Feb 2011 11:45:39 AM
You can try to restart, but most importantly... you or your users start making some activity to see those tables start populating with a data.