IBM Support

JR53684: FAILED EVENT MANAGER QUERIES FAIL ON DATABASE SYSTEMS THAT USE A COMMA INSTEAD OF A DECIMAL POINT AS A SEPARATOR

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Failed event manager database queries return insufficient
    results if you configured your database to use a comma as a
    separator instead of a decimal point (.).
    

Local fix

Problem summary

  • When the IBM BPM database is configured to use a comma (,)
    instead of a decimal point (.) as a separator, some failed event
    manager  database queries don't work. As a result, incorrect or
    incomplete data might be returned from those queries. The APAR
    inserts additional white space characters into coded SQL queries
    so that comma-separated integers cannot be mistaken for a
    decimal number. This approach follows a recommendation given in
    the IBM DB2 for z/OS documentation: Decimal point representation
    (www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z1
    0.doc.sqlref/src/tpc/db2z_decimalpointrepresentation.dita).
    

Problem conclusion

  • A fix is available for IBM BPM V8.5.5.0 that changes the failed
    event manager queries to run correctly on databases that use
    separators other than the decimal point.
    
    On Fix Central (http://www.ibm.com/support/fixcentral), search
    for JR53684:
    
    1. Select IBM Business Process Manager with your edition from
      the product selector, the installed version to the fix pack
      level, and your platform, and then click Continue.
    
    2. Select APAR or SPR, enter JR53684, and click Continue.
    
    When you download 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.
    

Temporary fix

  • Not applicable
    

Comments

APAR Information

  • APAR number

    JR53684

  • Reported component name

    BPM ADVANCED

  • Reported component ID

    5725C9400

  • Reported release

    855

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-06-24

  • Closed date

    2015-08-21

  • Last modified date

    2015-08-21

  • 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

  • R855 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":"855","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
21 August 2015