IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    JR50242

  • Reported component name

    BPM ADVANCED

  • Reported component ID

    5725C9400

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-05-14

  • Closed date

    2014-06-05

  • Last modified date

    2014-06-05

  • 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

[{"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.0.1","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
05 June 2014