If you are unable to create a new account, please email bspsoftware@techdata.com

Author Topic: Cogsever.log  (Read 1313 times)

Offline actcognosuser

  • Community Leader
  • *****
  • Join Date: Dec 2009
  • Posts: 197
  • Forum Citizenship: +0/-0
Cogsever.log
« 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?

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,544
  • Forum Citizenship: +673/-10
  • Cognos Software Muppet
Re: Cogsever.log
« Reply #1 on: 09 Sep 2022 12:48:12 pm »
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!

Offline cognostechie

  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 1,729
  • Forum Citizenship: +134/-7
    • Pervisol
Re: Cogsever.log
« Reply #2 on: 09 Sep 2022 02:00:27 pm »
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.

Offline actcognosuser

  • Community Leader
  • *****
  • Join Date: Dec 2009
  • Posts: 197
  • Forum Citizenship: +0/-0
Re: Cogsever.log
« Reply #3 on: 09 Sep 2022 02:53:32 pm »
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.