IBM Support

JR48745: BOOTSTRAP FAILS AGAINST A DATABASE WITH DECIMAL=COMMA SET UP ON DB2/Z

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • bootstrap fails against a database with decimal=comma set up on
    DB2/z
    

Local fix

  • no
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  IBM BPM V8.5.0.1 Advanced ¯   ’Standard and
    *                  Express                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:  The bootstrapProcessServerData.sh      *
    *                      command fails when run against a DB2    *
    *                      for z/OS database with decimal=comma    *
    *                      set                                     *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When IBM BPM uses a DB2 for z/OS
    database with the decimal=comma
    setting,
    bootstrapProcessServerData.sh fails
    with the following
    BadSqlGrammarException error message:
    org.springframework.jdbc.BadSqlGrammarE
    xception: PreparedStatementCallback;
    bad SQL grammar [insert into
    LSW_ACL_ENTRY(acl_entry_id,group_id,po_
    type,po_id,mask)
    values(1,3,5000,?,127)]; nested
    exception is
    com.ibm.db2.jcc.am.SqlSyntaxErrorExcept
    ion: DB2 SQL Error: SQLCODE=-104,
    SQLSTATE=42601,
    SQLERRMC=,5000;MICROSECONDS
    MICROSECOND SECONDS SECOND MINUTES
    MINUTE HOURS, DRIVER=4.11.69
    

Problem conclusion

  • A fix for IBM BPM V8.5.0.1 is available that updates the
    SQL so that the error is eliminated and the
    bootstrapProcessServerData.sh script runs cleanly against a
    DB2 for z/OS database with decimal=comma configured.
    
    On Fix Central (http://www.ibm.com/support/fixcentral), search
    for JR48745:
    
    1. Select the product group, product, installed version, and
    platform, and click Continue.
    2. Select APAR or SPR, enter JR48745, and click Continue.
    
    When downloading fix packages, ensure that you also download
    the readme file for each fix. Review each readme file for
    additional installation instructions and information about the
    fix.
    
    After you apply the fix, rerun the
    boostrapProcessServerData.sh command.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR48745

  • Reported component name

    BPM ADVANCED

  • Reported component ID

    5725C9400

  • Reported release

    850

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-12-08

  • Closed date

    2014-01-15

  • Last modified date

    2014-01-15

  • 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 ADVANCED

  • Fixed component ID

    5725C9400

Applicable component levels

  • R800 PSY

       UP

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

Document Information

Modified date:
15 January 2014