APAR status
Closed as Permanent restriction.
Error description
A report view upgraded from 11.1.6 to 11.1.7 fails with XQE-PLN-0537 The inverted parameter '<parameter_name>' can only be used in the context of an IN or IN_RANGE operator. Context is '?parameter_name? = 'T''.
Local fix
Clear all saved prompt values of the report view, and set anew.
Problem summary
**************************************************************** * USERS AFFECTED: * * n/a * **************************************************************** * PROBLEM DESCRIPTION: * * see description * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
A code fix was provided in 11.20 and higher releases for related APAR PH30162 REPORTS RUN VIA SDK RESULT IN INVERTED PARAMETERS AND FAIL WITH XQE-PLN-0537. This addresses reports created moving forward. However, report views that were created while the defect was active need to be corrected following the steps in the https://supportcontent.ibm.com/support/pages/reports-executed-us ing-sdk-invert-parameters-or-cause-dynamic-query-throw-xqe-pln-0 537..
Temporary fix
Comments
APAR Information
APAR number
PH35400
Reported component name
COGNOS ANALYTIC
Reported component ID
5724W12XX
Reported release
B0D
Status
CLOSED PRS
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-03-16
Closed date
2023-01-09
Last modified date
2023-01-09
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"Cognos Analytics"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B0D","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
09 January 2023