280 IBM Cognos Dynamic Cubes
10.8.1 Configuring Cognos Dynamic Cubes logging
This section describes how to configure logging for dynamic cubes to capture information that
can help with diagnosing the issue.
Logging is configured by using the configuration/xqe.diagnosticlogging.xml file. It is
enabled by specifying a level of either Info or Trace for an event group, such as in the
following example:
<eventGroup name="ROLAPCubes.Management" level="trace"/>
Separate event groups exist for separate parts of the code.
The logging information is written to files by using the following format:
logs/XQE/xqelog-*.xml.
The following sections describe several common problem areas.
Dynamic Query Server configuration (JVM parameters) or Dynamic
Query Server not starting
If a dynamic cube fails to start, you can enable the "InitTerm" event group, which causes the
DQM server to write additional information regarding the initialization of a dynamic cube to
the log file.
? Event group or groups to change:
<eventGroup name="InitTerm" level="trace"/>
? Sample logging information returned:
<event ...><![CDATA[Using JVM heap sizes: -Xms1024m, -Xmx1024m, -Xmnx512m,
-Xmns512m]]></event>
Dynamic Query Server configuration (non-JVM parameters) or Dynamic
Cube configuration
When you are diagnosing a problem, a helpful step is to confirm the configuration parameters
that are applied to a cube. Among other information, enabling the "ROLAPCubes.Management"
event group will write the configuration parameters of the cube to the log file.
? Event group or groups to change:
<eventGroup name="ROLAPCubes.Management" level="trace"/>
? Sample logging information returned:
<event ...><![CDATA[Configured ROLAP advanced settings values: qsMax
CubeLoadThreads=16,...]]></event>
<event ...><![CDATA[[Updating a ROLAP configuration parameter:
rolap.qsMultiDimensionalQuerySizeLimit=0]]]></event>
<event ...><![CDATA[[Before: ROLAP configuration:
[ROLAPConfiguration:...,qsMultiDimensionalQuerySizeLimit=0,...]]]]></event>
<event ...><![CDATA[[After: ROLAP configuration:
[ROLAPConfiguration:...,qsMultiDimensionalQuerySizeLimit=0,...]]]]></event>
Chapter 10. Troubleshooting 281
Dynamic cube management (start, stop)
Depending on the problem being diagnosed, a useful step is to track the various
administrative commands that are issued to a cube, such as start and stop. Enabling the
"ROLAPCubes.Management" and "ROLAPCubes.Info" event groups will add this information to
the log file.
? Event group or groups to change:
<eventGroup name="ROLAPCubes.Management" level="trace"/>
<eventGroup name="ROLAPCubes.Info" level="info"/>
? Sample logging information returned:
<event ...><![CDATA[Manager task submitted cube start with source cubes task
for cube RolapSimpleCube_V5_DB2]]></event>
<event ... rolapCube="RolapSimpleCube_V5_DB2"><![CDATA[Cube start
executing]]></event>
<event ... rolapCube="RolapSimpleCube_V5_DB2" ...><![CDATA[Cube start
succeeded]]></event>
<event ...><![CDATA[Manager task retrieved the status of the cube start with
source cubes task for cube RolapSimpleCube_V5_DB2. The cube start with source
cubes task was successful.]]></event>
Dynamic cube hierarchy load
If a cube encounters problems when it starts, a helpful step might be to obtain additional
information about the loading of each of the hierarchies in the cube, one of the primary
activities during cube startup. Enabling the "ROLAPCubes.Loader" event group will add
information about the loading of hierarchies to the log file.
? Event group or groups to change:
<eventGroup name="ROLAPCubes.Loader" level="trace"/>
? Sample logging information returned:
<event ... rolapCube="RolapSimpleCube_V5_DB2" rolapDimension="Product"
rolapHierarchy="Product" ...><![CDATA[Hierarchy load began.]]></event>
<event ... rolapCube="RolapSimpleCube_V5_DB2" rolapDimension="Product"
rolapHierarchy="Product" ...><![CDATA[Started populating level members for
hierarchy [Product]]]></event>
<event ... rolapCube="RolapSimpleCube_V5_DB2" rolapDimension="Product"
rolapHierarchy="Product" ...><![CDATA[[Product] loaded 3 members.]]></event>
<event ... rolapCube="RolapSimpleCube_V5_DB2" rolapDimension="Product"
rolapHierarchy="Product" ...><![CDATA[Finished populating level members for
hierarchy [Product]]]></event>
<event ... rolapCube="RolapSimpleCube_V5_DB2" rolapDimension="Product"
rolapHierarchy="Product" ...><![CDATA[Hierarchy load succeeded.]]></event>
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.