Audit database is not a mandatory component in the cognos installation, yet, it is an important one. Once, I ran one of the audit report and realized that the DB was last updated a month ago. Cognos was not recording any information in the AUDIT tables. If you are also facing the same problem, keep reading :)
Check if the log level for each dispatcher is set to “Basic”. Launch Cognos Administration Goto Configuration -> Dispatcher and Services-> Set properties
Other most common problem is ipfclientconfig.xml, Audit database may not receive any data from the
system while the ipfclientconfig.xml is active. If you find this file at the location ../Configuration/. Rename it
(I like renaming it to ipfclientconfig.xml.off). The presence of this file indicates that AAA trace is being performed. Renaming will switch off the tracing, good thing is that, you don’t have to restart cognos services.
Lastly, if your problem is still unsolved, check this specific case. If you have not installed Fix Pack 1 for version 10.1.1 and you are using SQL Server 2008 for your audit database, there may be another reason. Even though, Audit DB tested successfully when you created the Audit DB in Cognos Configuration, the syntax “Servername\Instance” in Audit –Database – Resource Properties will not work. Change it to Servername:Portnumber.
Also, make sure you set the Enable TCP property to True.
If you have questions or suggestions, do comment.
thanks..
ReplyDelete