IBM Support

PM63701: DRILL THROUGH FAILS WITH RQP-DEF-0354 WHEN MULTIPLE POWERCUBES ARE INCLUDED IN A SINGLE PACKAGE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • An RQP-DEF-0354 error occurs in the following scenario:??1) A
    package is published that contains at least two powercubes as
    well as at least 1 relational query subject??2) Source and
    target drill through reports are created against the package.
    Only one of the powercubes is referenced in the
    source/target)??- The source report uses a powercube??- The
    target report uses the relation query subject?Note: the drill
    through will work fine at this stage??3) The model is updated so
    that the powercube reference that is used in the source report
    is renamed, then the package is republished?4) The source report
    is updated so that it references the renamed powercube reference
    (drill through definition is updated as well)??After this
    sequence of events, the drill through will no longer work. We
    receive the following error on drill through:??
    ?Error:?QFS-ERR-0139 ?    The request has multiple errors.
    ???RQP-DEF-0354 The query contains one or more unresolved
    prompts.QE-DEF-0383 Invalid format for prompt 'period'. Expected
    format for datetime: CCYY-MM-DDThh:mm:ss.
    

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                                                       *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PM63701

  • Reported component name

    COG8 BI COG CON

  • Reported component ID

    5724W12CC

  • Reported release

    841

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-05-01

  • Closed date

    2013-06-11

  • Last modified date

    2013-06-11

  • 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

  • RA21 PSN

       UP

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

Document Information

Modified date:
11 June 2013