IBM Support

XQE-QTE-0003 The transformation "V5QueryRelationalPlanningTransformationLibrary - BuildRQPMetadataInstances" was applied but did not modify the query plan.

Troubleshooting


Problem

When running a Dashboard some widgets show an error saying:
Failure XQE-QTE-0003 The transformation "V5QueryRelationalPlanningTransformationLibrary - BuildRQPMetadataInstances" was applied but did not modify the query plan.

Symptom

[cognosserver.log]

2022-11-25T14:05:25.674+1100 ERROR com.ibm.bi.platform.commons.web.BIResponseWrapper [Default Executor-thread-42480] dvqG4l98vyG92hM284vwvyq9Gs4y9Cw9q2yh8wv2 dvqG4l98vyG92hM284vwvyq9Gs4y9Cw9q2yh8wv2 NA 0.0.0.0 57225 LoginUser1764527239 AggAAAAmUYljAAAAAAoAAAA7N1449zYCTsxLFAAAALM3DqsP6MdLaHzitjJSVmG2h0GgBwAAAFNIQS0yNTYgAAAAS8WvVDP/m1r4K0C0iPDFFCOH54je5rJpSXnsSTEkF+E= /v1/datasets/i5105B526871843E69DE4A7E1283389E5/data bi-service 6180 HttpServletResponseCode for /bi/v1/proxy/dataset-service/v1/datasets/i5105B526871843E69DE4A7E1283389E5/data is in error: 500

[cogaudit.log]

0.0.0.0:9300 10960 2022-11-25 14:05:25.596 +11 F6F7E8A6AEBB2808CC299F22363C1F76FACD66F3B8AA8F258E3B170D2B20B3E0 a4e8a55e-693e-4426-b5c9-8ceba881d0de:60352005-9ac0-4cb9-912e-edbf6d12b090 10425 DSS 0 3 Audit.RTUsage.qs.DSS Execute Exploration QueryService /content/folder[@name='FolderA']/exploration[@name='DashboardA'] Failure XQE-QTE-0003 The transformation "V5QueryRelationalPlanningTransformationLibrary - BuildRQPMetadataInstances" was applied but did not modify the query plan. <parameters><item name="model"><![CDATA[/content/folder[@name='FolderB']/module[@name='Data ModuleB']]]></item><item name="storeID"><![CDATA[i6F16E6AFDB894534980BC7E2104E0E3D]]></item></parameters>

[xqelog-*.xml]

<event component="XQE" group="Exception" level="ERROR" thread="10425" timestamp="2022-11-25 14:05:25.596"><![CDATA[Caught error in the Query Service: XQE-QTE-0003 The transformation "V5QueryRelationalPlanningTransformationLibrary - BuildRQPMetadataInstances" was applied but did not modify the query plan. at com.cognos.xqe.query.engine.Transformation.handleNoOpTransformation(Transformation.java:230) at com.cognos.xqeqte.QTETransformationEngine.applyTransformation(QTETransformationEngine.java:1187) at com.cognos.xqeqte.QTETransformationEngine.applyApplicableTransformation(QTETransformationEngine.java:1105) at com.cognos.xqeqte.QTETransformationEngine.applyTopDownFastOrBottomUpTransformations(QTETransformationEngine.java:720) at com.cognos.xqeqte.QTETransformationEngine.applyBottomUpTransformations(QTETransformationEngine.java:530) at com.cognos.xqeqte.QTETransformationEngine.transformationIteration(QTETransformationEngine.java:320) at com.cognos.xqeqte.QTETransformationEngine.applyTransformations(QTETransformationEngine.java:253) at com.cognos.xqe.query.engine.TransformationEngine.applyTransformations(TransformationEngine.java:219) at com.cognos.xqe.query.planner.QueryPlanner.plan(QueryPlanner.java:373) at com.cognos.xqe.query.planner.QueryPlanner.planQuery(QueryPlanner.java:506) at com.ibm.bi.qs.xqe.v5.BaseExecutor.planQuery(BaseExecutor.java:1026) at com.ibm.bi.qs.xqe.v5.BaseExecutor.planQuery(BaseExecutor.java:888) at com.ibm.bi.qs.xqe.v5.DataExecutor.planExecution(DataExecutor.java:2436) at com.ibm.bi.qs.xqe.v5.BaseExecutor.getLastModified(BaseExecutor.java:833) at com.ibm.bi.qs.rest.response.AbstractResultBuilder.getLastModifiedFromResource(AbstractResultBuilder.java:47) at com.ibm.bi.qs.rest.response.AbstractResultBuilder.getEtagFromResource(AbstractResultBuilder.java:74) at com.ibm.bi.rs.ResponseBuilderFactory.createGET(ResponseBuilderFactory.java:59) at com.ibm.bi.qs.rest.response.ServiceResponseBuilderFactory.createResponseBuilder(ServiceResponseBuilderFactory.java:125) at com.ibm.bi.qs.rest.endpoints.BaseEndPoint.createResponseBuilder(BaseEndPoint.java:266) at com.ibm.bi.qs.rest.endpoints.BaseEndPoint.getResponse(BaseEndPoint.java:249) at com.ibm.bi.qs.rest.endpoints.QueryServiceEndPoint.processDataRequest(QueryServiceEndPoint.java:670) at com.ibm.bi.qs.rest.endpoints.QueryServiceEndPoint.getDatasetData(QueryServiceEndPoint.java:187) at sun.reflect.GeneratedMethodAccessor107.invoke(Unknown Source)

Document Location

Worldwide

[{"Type":"MASTER","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":"a8m0z0000001jleAAA","label":"Dashboard"}],"ARM Case Number":"TS011283879","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.2.1"},{"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"}},{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
15 January 2026

UID

ibm16953491

Page Feedback