IBM Support

Upgrading Cognos Analytics 11.0.5 report with filter to 11.0.6 produces RSU-SPC-0191 error

Troubleshooting


Problem

Upgrading a Cognos Analytics 11.0.5 filtered report that uses a data module as a data source to Cognos Analytics 11.0.6 might produce the following error: RSU-SPC-0191 The data type of the filter item could not be determined so a default type of "string" was used. If this is incorrect, the filter should be deleted and re-created. Validating the report will clear the errors.

Cause

In 11.0.5 report specifications, the data type of data items in filters does not have to be specified; it is optional. Cognos Analytics 11.0.6 requires this information. By default, the upgrade process uses 'string' when the data type is not specified.

Resolving The Problem

Validating the report removes the error. However, the report will not run if 'string' is not the correct data type of the data item in the filter, and you must correct the report specification. There are two ways that you can correct the report specification.

Solution A

  1. In Cognos Analytics - Reporting, copy the upgraded report specification to the clipboard, and then paste the specification in a text editor.
  2. Locate the <detailFilter> element that contains the error message. The error message appears as a comment.
  3. Under <detailFilter>, locate the <filterInValues> element, and change the dataType attribute to the correct data type.
  4. Copy the report specification to the clipboard.
  5. Paste the report specification in Cognos Analytics - Reporting.


Solution B
  1. Open the upgraded report in Cognos Analytics - Reporting.
  2. Delete the filter.
  3. From the data tree, add the data item that is used in the filter to the query.
    This step adds a new data item that shows you the data type of the data item.
  4. Copy the report specification to the clipboard, and then paste the specification in a text editor.
  5. Close the report in Cognos Analytics - Reporting.
  6. In the text editor, locate the <dataItem> element of the new data item, and select and copy the entire <XMLAttributes> element.
  7. Locate the <dataItem> element that is used in the filter, and paste the <XMLAttributes> element from the previous step.
    When you recreate the filter in Cognos Analytics - Reporting, the data item will now appear in the Filter dialog.
  8. Copy the report specification to the clipboard.
  9. Paste the report specification in Cognos Analytics - Reporting.
  10. Recreate the filter.

[{"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Report Authoring v11x","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg22000107

Page Feedback