IBM Support

JR48073: SCHEMAGENERATOR FOR SAVED SEARCH OPTIMIZATION GENERATES INVALID SQL ON ORACLE AND DB2.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The generated screen output or SQL file of the SchemaGenerator
    shell script is incorrect. If it is performed against the BPM
    database, then it fails in the creation of the Stored Procedure.
    

Local fix

  • manually modify the script
    

Problem summary

  • The generated screen output or SQL file of the SchemaGenerator
    shell script is incorrect.  If it is performed against the BPM
    database, then it fails in the creation of the Stored Procedure.
    
    PROBLEM DETAILED DESCRIPTION:
    Stored procedure definitions in SQL files needs a special
    handling, which is different for the RDBMS provider.  The SQL
    file generated by the SchemaGenerator has generated the stored
    procedure part incorrectly.
    

Problem conclusion

  • The SchemaGenerator generates the stored procedure RDBMS
    specific now.
    
    FIX AVAILABILITY:
    iFix for 8.0.0.0 is available on Fix Central, search for APAR
    JR48073 at http://www.ibm.com/support/fixcentral/
    Fix is also targetted for inclusion in next fixpack for BPM
    8.0.1
    
    When obtaining any of the above fixes, be sure to download the
    accompanying readme, for itself, and any prerequisite fixes, and
    review them thorougly.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR48073

  • Reported component name

    BPM STANDARD

  • Reported component ID

    5725C9500

  • Reported release

    800

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-10-15

  • Closed date

    2014-01-22

  • Last modified date

    2014-01-22

  • 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

    BPM STANDARD

  • Fixed component ID

    5725C9500

Applicable component levels

  • R800 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
22 January 2014