IBM Support

PI11426: ERROR WHEN TESTING A STORED PROCEDURE IN FRAMEWORK MANAGER

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • A stored procedure is imported into Framework Manager as a query
    subject.  The arguments to the procedure are parameterized using
    expressions of the form "?parameter?".  When attempting to test
    the query subject, Framework Manager does not prompt the user
    for input values, which causes the stored procedure to fail.
    One potential error is "ORA-06502 character to number conversion
    error", but the exact error may depend on the specific database
    and stored procedure.
    

Local fix

  • Instead of using the ?parameter? syntax in the arguments, use a
    prompt macro syntax instead.  e.g. #prompt('parameter','varchar(
    16)')#
    

Problem summary

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

Problem conclusion

  • Code Fix
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI11426

  • 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

    2014-02-10

  • Closed date

    2014-06-20

  • Last modified date

    2014-06-20

  • 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

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHNWR","label":"Framework and Map Manager v11x"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A21","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
20 June 2014