278 IBM Cognos Dynamic Cubes
10.5 Dynamic cube QueryService logging
Logging for the QueryService managing a dynamic cube and associated report executions
can be enabled through Dynamic Query Analyzer. Logging that is enabled in Dynamic Query
Analyzer is active only for those reports run from Dynamic Query Analyzer. Dynamic Query
logging provides insight into issues during report execution that are not available from the
query execution log.
QueryService logs are recorded under the <CognosInstall>/Logs/XQE folder in files with the
following name forma. A new log is created when the QueryService is started.
xqelog-<date>-<timestamp>.xml
To enable QueryService logging, use the steps described 10.6, “Dynamic cube query plan
tracing” on page 279. Then, select the Dynamic Query check box logging option on the
Preferences General dialog, available from the Window menu option.
For QueryService logging, you can set the level of detail that is added to the log file by
selecting one of the log level radio buttons. You can choose one of four levels, described in
the following list. Logging at more detailed levels can also include log messages from lower
levels. Establishing the log level at Info, for example, will include indications that are logged at
the Info, Warn, and Error levels. Verbose level indications will not be present in the file.
? Verbose: This level is the most detailed tracing level. Extensive and detailed tracing of
execution flow through the QueryService components will be logged. Verbose logging can
create significant amounts of log information.
? Info: This level contains detailed status messages, although the detail is more restricted
than Verbose logging. Info level is the default level of dynamic query logging.
? Warn: This level provides status indications that the administrator or developer might need
to address.
? Error: This level details critical incidents and unrecoverable errors that the administrator or
developer should be aware of because system behavior can be affected.
Use the following steps to view the QueryService log for a report, in Dynamic Query Analyzer:
1. Ensure dynamic query logging is enabled.
2. Run a report from the Content Store view.
3. Open the report’s query execution trace from the Report Logs view, if the trace is not
opened automatically.
4. Select File Show in Server Log to open the Dynamic Query log.
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.