Troubleshooting
Problem
This technote describes how to enable a native SQL trace when using Dynamic Query Mode. By default Report Studio or XQE trace files will show MDX for DMR or Dynamic Cubes. This requires a restart of the Query Service in the IBM Cognos Analytics environment.
Cause
Determine what SQL is sent to the database.
Resolving The Problem
This needs to be done for all dispatchers with Query Service enabled.
In CA 11 : ..\configuration\xqe.diagnosticlogging.xml
1. Open it in an editor.
2. Search for the section <component name="XQE">
3. In that section look for <eventGroup name="JDBC"/>
4. Change it to <eventGroup name="JDBC" level="info"/>
5. 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, start the Dynamic Cube or 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.
Related Information
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg22002708