JR50242: QUERY ON A QUERYPROPERY OF TYPE LONG THROWS NUMBERFORMATEXCEPTION WHEN MORE THAN 10 DIGITS ARE SPECIFIED

Version 8.5 Refresh Pack 5 for the IBM Business Process Manager products
Download Version 8.0.1 Fix Pack 3 for the IBM Business Process Manager products
Version 8.5 Refresh Pack 6 for the IBM Business Process Manager products

APAR status

• Closed as program error.

Error description

• When a BPEL process is specified with a query property for a
  variable of type Long, a custom view is defined with a filter on
  that query property in BPC Explorer. When more than 10 digits
  are specified, you receive the following exception:
  
  NumberFormatException: For input string: "222222222222222"
   at java.lang.NumberFormatException.forInputString
    (NumberFormatException.java:59)
   at java.lang.Integer.parseInt(Integer.java:472)
   at java.lang.Integer.<init>(Integer.java:671)
   at com.ibm.bpe.database.Query.parseWhereClause(Query.java:2053)
   at com.ibm.bpe.database.Query.<init>(Query.java:237)
   at com.ibm.bpe.database.Tom.queryAll(Tom.java:11415)
   at com.ibm.bpe.database.WorkItemManagerImpl.queryAll
    (WorkItemManagerImpl.java:493)
   at com.ibm.bpe.framework.BusinessProcessServiceImpl.queryAll
    (BusinessProcessServiceImpl.java:29940)
   at com.ibm.bpe.framework.BusinessFlowManagerBean.queryAll
    (BusinessFlowManagerBean.java:19300)
   at com.ibm.bpe.api.EJSLocalStatelessGenericBusiness
    FlowManagerEJB_a412961d.queryAll(Unknown Source)
   at com.ibm.bpe.clientmodel.query.BFMQuery.
    executeGenericBFMQuery(BFMQuery.java:177)
   at com.ibm.bpe.clientmodel.query.BFMQuery.
    executeGenericBFMQuery(BFMQuery.java:154)
   at com.ibm.bpe.clientmodel.query.BFMQuery.
    executeBFMQuery(BFMQuery.java:130)
   at com.ibm.bpe.clientmodel.query.BFMQuery.executeBPCQuery
    (BFMQuery.java:107)
   at com.ibm.bpc.clientcore.BPCQuery.execute(BPCQuery.java:142)
   at com.ibm.bpe.jsf.handler.BPCListHandler.executeQuery
    (BPCListHandler.java:396)
  

Local fix

Problem summary

• Because Integer is selected instead of Long, the string value of
  the query property is not parsed correctly. As a result, numbers
  that exceeding the integer boundaries cannot be processed and
  you see the NumberFormat exception.
  

Problem conclusion

• A fix is available for IBM BPM V 8.0.1.2 that uses Long instead
  of Integer to parse the string value of the query property so
  that larger numbers can be processed.
  
  
  On Fix Central (http://www.ibm.com/support/fixcentral), search
  for JR50242:
  
  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 JR50242, 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

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

• R801 PSY

     UP