IBM Support

What changes need to made to reports after changing query subject name in Framework Manager model.

Troubleshooting


Problem

Once an underlying query subject name has been changed in Framework Manager model and package is published, the original report will fail to validate or execute as the path name to the query item has been changed. Take this example, where query subject name was changed from "Query Subject 1" to "Query Subject 0001". (Project structure looks like following in Framework Manager) ->Project Name -->Namespace --->Query Subject 1 ----->QueryItem1 ----->QueryItem2 --->Query Subject 2 --->Query Subject 3 Changed to and package republished: ->Project -->Namespace --->Query Subject 0001 (Query subject name changed) ----->QueryItem1 ----->QueryItem2 --->Query Subject 2 --->Query Subject 3 In the above example, "Query Subject 1" has been renamed to "Query Subject 0001". When a report based on the above package is run, following error message appears: QE-DEF-0459 CCLException QE-DEF-0030 Expression parsing error. QE-DEF-0359 The query contains a reference to at least one object '[PackageName].[Query Subject 1].[QueryItem1]' that does not exist. QE-DEF-0459 CCLException QE-DEF-0030 Expression parsing error. QE-DEF-0359 The query contains a reference to at least one object '[PackageName].[Query Subject 1].[QueryItem2]' that does not exist. RSV-VAL-0004 Unable to find query information for the item QueryItem1. RSV-VAL-0004 Unable to find query information for the item QueryItem2. Note that the report that we are using in this example is a simple list report with "QueryItem1" and "QueryItem2" from "Query Subject 1".

Symptom

QE-DEF-0459 CCLException
QE-DEF-0030 Expression parsing error
QE-DEF-0359 The query contains a reference to at least one object '[PackageName].[Query Subject 1].[QueryItem1]' that does not exist.
QE-DEF-0459 CCLException
QE-DEF-0030 Expression parsing error
QE-DEF-0359 The query contains a reference to at least one object '[PackageName].[Query Subject 1].[QueryItem2]' that does not exist.
RSV-VAL-0004 Unable to find query information for the item QueryItem1.
RSV-VAL-0004 Unable to find query information for the item QueryItem2.

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Framework Manager","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.2.2;10.2.1;10.2","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"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"}}]

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

More support for:
Cognos Business Intelligence

Software version:
10.2.2, 10.2.1, 10.2

Operating system(s):
AIX, Linux, Solaris, Windows

Document number:
368495

Modified date:
08 May 2025

UID

swg21340312

Manage My Notification Subscriptions