Troubleshooting
Problem
Running Reporting Fragments that uses DQM Reporting Framework package with prompt fails.
In OpenPages we see the following exception, OP-12013 The computation encountered an error
In Cognos logs we see the following exception, XQE-PLN-0537 The inverted parameter '<PROMPT_VARBLE>' can only be used in the context of an IN or IN_RANGE operator. Context is '<QUERY_SUBLECT> = ?<PROMPT_VARBLE>?'.
Symptom
Running Reporting Fragments which uses DQM Reporting Framework package with prompt fails.
Cause
There is Cognos product issue listed in this APAR PH30162: REPORTS RUN VIA SDK RESULT IN INVERTED PARAMETERS AND FAIL WITH XQE-PLN-0537 . This problem has not been resolved in Cognos 11.1.7.x or 11.2.0 or 11.2.1.
Diagnosing The Problem
In Cognos logs look for the following exception when the Reporting Fragment was executed in OpenPages.
XQE-PLN-0537 The inverted parameter '<PROMPT_VARBLE>' can only be used in the context of an IN or IN_RANGE operator. Context is '<QUERY_SUBLECT> = ?<PROMPT_VARBLE>?'.
Resolving The Problem
Use the workaround specified in the "Error Description" of this APAR PH30162: REPORTS RUN VIA SDK RESULT IN INVERTED PARAMETERS AND FAIL WITH XQE-PLN-0537 for the failing Reporting Fragment.
According to the Cognos instructions, you want to replace the = operator with an IN or NOT IN operator. You also need to handle the inverted results since the IN and NOT IN operators do not function as expected.
According to the Cognos instructions, you want to replace the = operator with an IN or NOT IN operator. You also need to handle the inverted results since the IN and NOT IN operators do not function as expected.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSFUEU","label":"IBM OpenPages with Watson"},"ARM Category":[{"code":"a8m50000000CkpmAAC","label":"Cognos and Reports"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.2.0;8.3.0"}]
Was this topic helpful?
Document Information
Modified date:
15 March 2022
UID
ibm16562429