IBM Support

PM77654: WORKSPACE REPORTS IMPORTED FROM REPORT STUDIO FAIL WITH INVALID QUERY ERROR

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The client is trying to open a report in Workspace that she
    created Report Studio. In RS the report works flawlessly; she is
    able to drill down and up with no problem. If she saves the
    report, closes Report Studio, opens Business Insight and
    attempts to drill down on the report, she gets a the following
    errors    RSV-VAL-0032 The following expression is not valid:
    [Query1].[Prod Lines] in ('Personal Accessories'). If the item
    exists in a query but is not referenced in the layout, add it to
    a property list. CRX-API-0005 An error ocurred at or near the
    position '0'. The variable named '[Query1].[Prod Lines]' is
    invalid.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IBM Cognos Business Intelligence 10.2 Refresh     *
    * Pack 1 or                                                    *
    * Upgrade to IBM Cognos Business Intelligence 10.1.1 Fix Pack  *
    * 3 or                                                         *
    * Upgrade to IBM Cognos Business Intelligence 10.2 Fix Pack 3  *
    ****************************************************************
    

Problem conclusion

  • Code Fix
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM77654

  • Reported component name

    COG WRKSPC

  • Reported component ID

    5724W12BI

  • Reported release

    A11

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-23

  • Closed date

    2014-04-30

  • Last modified date

    2014-04-30

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    COG WRKSPC

  • Fixed component ID

    5724W12BI

Applicable component levels

  • RA20 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHNWM","label":"Workspace v11x"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A11","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
30 April 2014