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.

Cause

Changing the name of a query subject will change the query item path that was embedded in the query specifications when the report was created from the original package with original query subject name.

Resolving The Problem

Remap the query items to the new or the renamed query subject manually in each report that is based of the modified package.

Steps:

  1. Open the report in Report Studio
  2. Double click the first list item i.e. QueryItem1
  3. Change the: [PackageName].[Query Subject 1].[QueryItem1] expression to [PackageName].[Query Subject 0001].[QueryItem1] and click OK
  4. Repeat these steps for QueryItem2.
  5. Validate the report, and the QE-DEF-0459 and RSV-VAL-0004 errors should disappear

If familar with SDK an automated approach can be performed by auto-replacing the package references in the report specification. The Dynamic Report Specification Updater Diagnostic provides this for some Cognos BI Versions.

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"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":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21340312