PM93395: Input parameters for stored procedure query subject fail when using prompts

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • Stored Procedure with parameters cannot be validated or
    tested??Compatible Query mode (CQM) returns:?RQP-DEF-0354 The
    Query contains one or more unresolved prompts.?QE-DEF-0144
    Prompt '<abc>' has no substitution values.??Dynamic Query Mode
    (DQM) returns:?XQE-QRY-0404 There are parameters or variables
    that require values.??The behavior varies depending on the
    stored procedure type: Data Query or Data Modification. Then the
    error occurs already when validating otherwise when testing.?In
    case the SP is tested the error occurs although the SP passed
    successfully the validation and has its Status set to 'Valid'
    

Local fix

  • Test the stored procedure using constant values, not parameters/
     variables.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IBM Cognos Business Intelligence 10.2.1 Fix Pack  *
    * 1 or upgrade to IBM Cognos Business Intelligence 10.2.1 Fix  *
    * Pack 2                                                       *
    ****************************************************************
    

Problem conclusion

  • Code Fix
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM93395

  • Reported component name

    COG FRAMEWRK MG

  • Reported component ID

    5724W12FM

  • Reported release

    A21

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-07-19

  • Closed date

    2013-09-10

  • Last modified date

    2014-01-31

  • 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 FRAMEWRK MG

  • Fixed component ID

    5724W12FM

Applicable component levels

  • RA21 PSN

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Cognos Business Intelligence
Framework Manager

Software version:

10.2.1

Reference #:

PM93395

Modified date:

2014-01-31

Translate my page

Machine Translation

Content navigation