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

8.5.5.0-WS-BPM-IFJR53684
Version 8.5 Refresh Pack 7 for the IBM Business Process Manager products

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