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

Cogsever.log

Started by actcognosuser, 09 Sep 2022 10:31:10 AM

Previous topic - Next topic

actcognosuser

Hi Users,

Does Cogserver.log save information for

1. Activity /reports run from My folders on the cognos connection
2. Analysis studio queries?

If it doesn't where is this information stored to troubleshoot any failures or long running queries?

MFGF

Quote from: actcognosuser on 09 Sep 2022 10:31:10 AM
Hi Users,

Does Cogserver.log save information for

1. Activity /reports run from My folders on the cognos connection
2. Analysis studio queries?

If it doesn't where is this information stored to troubleshoot any failures or long running queries?

Hi,

Typically you would add an Audit database to your instance and configure auditing to start collecting activity on the server.

https://www.ibm.com/support/pages/how-configure-audit-reporting-cognos-analytics

Cheers!

MF.
Meep!

cognostechie

Quote from: actcognosuser on 09 Sep 2022 10:31:10 AM
Hi Users,

Does Cogserver.log save information for

1. Activity /reports run from My folders on the cognos connection
2. Analysis studio queries?

If it doesn't where is this information stored to troubleshoot any failures or long running queries?

There is a way to figure out which queries/containers are taking how much time which might tell you which queries are slow (presuming you have multiple queries and are trying to find out which ones are the culprit).

Turn on the Diagnostic Logging and enable 'Include Performance Details' in the report run options.

Run the report and it will show you which list/crosstab/chart took how much time.

actcognosuser

Thank You all for your response. An Audit DB is not configured. One of the queries caused a lock on the DB tables. So we are
unable to figure out the user that ran the report.