IBM Support

JR48878: "BAD SQL GRAMMAR" WHEN UPGRADING TO BPM 8.0.1.2 WITH DB2 9.5

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • If you upgrade to BPM 8.0.1.2 or install IFix JR46470 on top of
    BPM 8.0.1.1 while using DB2 9.5, a DB2 error "bad SQL grammar" /
    "SQLCODE=-104, SQLSTATE=42601" will prevent the system from
    working correctly.
    

Local fix

  • n/a.
    

Problem summary

  • Upgrading to BPM 8.0.1.2 with DB2 9.5 leads to "BAD SQL GRAMMAR"
    error in SystemOut.log
    
    PROBLEM DETAILED DESCRIPTION:
    In BPM 8.0.1.2, some queries were restructured. Especially, the
    query that retrieves alive Event Managers is now done with the
    'WITH UR' clause to reduce locking behavior.  Unfortunatly,
    this query is used as a sub query, and 'WITH UR' in sub queries
    is not supported by DB2 9.5.
    

Problem conclusion

  • This IFix introduces code changes that determine whether DB2 9.5
    is in use, and if so, the code strips the 'WITH UR' clause from
    the sub query that retrieves the alive Event Managers.
    
    FIX AVAILABILITY:
    iFix for 8.0.1.1 is/will be available on Fix Central; search for
    APAR JR48878 at http://www.ibm.com/support/fixcentral/
    iFix for 8.0.1.2 is/will be available on Fix Central; search for
    APAR JR48878 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

    JR48878

  • Reported component name

    BPM ADVANCED

  • Reported component ID

    5725C9400

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-12-19

  • Closed date

    2014-02-19

  • Last modified date

    2014-02-19

  • 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

  • R801 PSY

       UP



Document information

More support for: IBM Business Process Manager Standard

Software version: 8.0.1

Reference #: JR48878

Modified date: 19 February 2014


Translate this page: