Troubleshooting
Problem
Queries, that were executing prior to Cognos Analytics (CA) 11.1.7 can fail with errors including;
XQE-GEN-0005 Found an internal error:java.lang.NullPointerException
XQE-GEN-0010 Found an internal error: 'GenerateSubqueriesForSelfReferencingCalcs: Max subqueries exceeded'.
XQE-GEN-0002 An unexpected exception occurred:java.lang.StackOverflowError
XQE-GEN-0005 Found an internal error: com.cognos.xqe.ast.rqp.RQPDataItemRef incompatible with com.cognos.xqe.ast.v5Exp.V5BoundModelIdentifier
Database errors due to CLOB columns such as thrown by Db2
XQE-GEN-0005 Found an internal error:java.lang.NullPointerException
XQE-GEN-0010 Found an internal error: 'GenerateSubqueriesForSelfReferencingCalcs: Max subqueries exceeded'.
XQE-GEN-0002 An unexpected exception occurred:java.lang.StackOverflowError
XQE-GEN-0005 Found an internal error: com.cognos.xqe.ast.rqp.RQPDataItemRef incompatible with com.cognos.xqe.ast.v5Exp.V5BoundModelIdentifier
Database errors due to CLOB columns such as thrown by Db2
The statement was not processed because the data type, length or value of the argument for the parameter in position "string-expr" of routine "SYSIBM.TRIM" is incorrect.
Improper use of a string column, host variable, constant, or function "Group by column 63"..
Cause
Internal transformations within the query engine produced incorrect plans.
Resolving The Problem
Upgrade from Cognos Analytics (CA) 11.1.7 to CA 11.1.7 FP1 or later releases.
If an upgrade to CA 11.1.7 FP1 is not possible, disable a query transformation rule on CA 11.1.7 application servers running Dynamic Query.
Go to the <cognos>\configuration folder, copy xqe.config.xml as xqe.config.custom.xml, apply the following changes.
Add the element generateSubqueryForCalcs within the queryPlanning element, as shown in the following example:
<queryPlanning>
<generateSubqueryForCalcs enabled="false"/>
...
This change is not required with CA 11.1.7 FP1 or later releases, the XML file does not need to be copied into servers running those releases.
If an upgrade in-place to CA 11.1.7 FP1 or higher is performed, the generateSubqueryForCalcs can be removed from any xqe configuration file.
If an upgrade to CA 11.1.7 FP1 is not possible, disable a query transformation rule on CA 11.1.7 application servers running Dynamic Query.
Go to the <cognos>\configuration folder, copy xqe.config.xml as xqe.config.custom.xml, apply the following changes.
Add the element generateSubqueryForCalcs within the queryPlanning element, as shown in the following example:
<queryPlanning>
<generateSubqueryForCalcs enabled="false"/>
...
This change is not required with CA 11.1.7 FP1 or later releases, the XML file does not need to be copied into servers running those releases.
If an upgrade in-place to CA 11.1.7 FP1 or higher is performed, the generateSubqueryForCalcs can be removed from any xqe configuration file.
Do not enable the rule by changing the enabled attribute to true.
Document Location
Worldwide
[{"Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl3zAAC","label":"Administration"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1.7"},{"Product":{"code":"SS6G84","label":"IBM Cognos Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Was this topic helpful?
Document Information
Modified date:
06 May 2025
UID
ibm16352905