How to trace native SQL for relational DQM data sources:
How to trace native SQL for relational DQM data sources: 1) Locate the following file in your Cognos installation directory 2) Open it in an editor. Search for the section .. more reading Ref: http://www-01.ibm.com/support/docview.wss?uid...显示全部
查看其它 1 个回答kent的回答
Nice....
Resolving the problem
This needs to be done for all report servers.
1.Locate the following file in your Cognos installation directory
For Cognos 10.1.1 or earlier: c10\configuration\xqe.config.xml
For Cognos 10.2 or later : c10\configuration\xqe.diagnosticlogging.xml
2.Open it in an editor.
3.Search for the section
4.In that section look for
5.Change it to
6.From Cognos Administration restart the Query services. Please make sure the correct Java process disappears in Task Manager. If you are unsure restart the complete Service from Cognos Configuration.
After the restart, run the affected report. The native SQL is then located in the XQE trace files. They can be located in ..\logs\xqe. The filename starts with xqelog.
Disable the Trace by restoring the original XML file after collecting the required Logs and restart the Query Service again.
Resolving the problem
This needs to be done for all report servers.
1.Locate the following file in your Cognos installation directory
For Cognos 10.1.1 or earlier: c10\configuration\xqe.config.xml
For Cognos 10.2 or later : c10\configuration\xqe.diagnosticlogging.xml
2.Open it in an editor.
3.Search for the section
4.In that section look for
5.Change it to
6.From Cognos Administration restart the Query services. Please make sure the correct Java process disappears in Task Manager. If you are unsure restart the complete Service from Cognos Configuration.
After the restart, run the affected report. The native SQL is then located in the XQE trace files. They can be located in ..\logs\xqe. The filename starts with xqelog.
Disable the Trace by restoring the original XML file after collecting the required Logs and restart the Query Service again.
浏览499