Troubleshooting
Problem
Resolving The Problem
The trace should only be enabled for troubleshooting a single query issue and not appropriate for use in a scenario with multiple reports or queries are being executed or for an extended period of time.
Example of setting up a trace for a native Oracle connection.
Steps:
1. In the <install_path>/bin directory, create a backup of the cogdmor.ini file.
2. In the <install_path>/bin directory, open the cogdmor.ini file in a text editor
NOTE: Ensure that your chosen editor does not alter the encoding of the file, or the product may not operate correctly.
3. Add the following lines to the bottom of the file:
[Trace]
Output=c:\temp\oracle_trace.txt
Flags=1111111111
For performance issues you can also add the timer=yes option.
4. Save the file.
5. Perform the test and review the file.
6. Disable the trace by removing the entries or commenting the lines with a semi-colon, and saving the file.
NOTE: This trace does not capture queries for Dynamic Query Mode (DQM) data sources.
Related Information
Was this topic helpful?
Document Information
Modified date:
29 October 2022
UID
swg22001201