COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: SynexusStuart on 20 Jul 2012 10:08:13 AM

Title: Solved - Cognos Audit stopped logging
Post by: SynexusStuart on 20 Jul 2012 10:08:13 AM
All,

I have a strange problem with the Cognos Audit Database.

For some reason it has stopped collecting data in a particular table called COGIPF_USERLOGON.

Other tables such as COGIPF_RUNREPORT are still collecting data correctly and seem unaffected.

To my knowledge, we did not make any changes to the configs.

Can anyone shed any light on this issue?

Stuart
Title: Re: Cognos Audit stopped logging
Post by: dcsoke on 20 Jul 2012 10:52:45 AM
I'm sure you've heard this one, but did you try restarting services? Have any changes taken place with security or fix packs been applied?
Title: Re: Cognos Audit stopped logging
Post by: SynexusStuart on 23 Jul 2012 02:53:58 AM
Not around the time it stopped working.

We are moving to C10 soon and i wanted to do a full audit of users and content store before moving and this has kind of knackered it up a bit.

I already tried to restart services. Any other cideas?

Stuart
Title: Re: Cognos Audit stopped logging
Post by: SynexusStuart on 15 Aug 2012 04:03:07 AM
OK we worked out how to fix it if anyone is intersted...

Somehow the logging level on the server had re-set to "Basic". We re-set that to "Request" but it still didn't kick the COGIPF_USERLOGON Audit Table into action.

The missing piece of the puzzle was to rename (or delete) the file ipfinternalconfig.xml on the Audit server. Once this was renamed (or deleted), we restarted the Cognos Services and this file was recreated and the Audit logging resumed as normal.

Hope that helps someone in future.

Stuart


Title: Re: Cognos Audit stopped logging
Post by: Grim on 15 Aug 2012 09:27:59 AM
Anytime you enable a trace using "ipfclientconfig.xml" in the /configuration directory it will stop auditing.

PS. Update the title of your OP to [Solved] :)
Title: Re: Cognos Audit stopped logging
Post by: SynexusStuart on 22 Aug 2012 07:44:50 AM
Hi, Where do you mark it as solved?
Title: Re: Solved - Cognos Audit stopped logging
Post by: MFGF on 24 Aug 2012 03:49:02 AM
Just edit the title of the thread. Have this one for free on the Muppet :)