JR41283: CMVC 216178 - RESOLVE NUMBERFORMATEXCEPTION WHEN CONVERTING KEY VALUE FROM STRING TO BIGINT TYPE & PERSISTING TO PPCEXTDAT TABLE

7.0.0-WS-WCServer-FP009
WebSphere Commerce Version 7.0.0.6 Fix Pack
WebSphere Commerce Version 7.0.0.7 Fix Pack
WebSphere Commerce Version 7.0.0.8 Fix Pack
WebSphere Commerce Version 7.0.0.9 Fix Pack

APAR status

• Closed as program error.

Error description

• Customer will face NumberFormatException if they are using
  primary keys larger than 2147483647 for PPCPAYINST and
  PPCPAYTRAN, and try to persist to the PPCEXTDATA table, even if
  these columns are defined as BigInt type in the table schema of
  PPCPAYTRAN.
  
  Below could be an example of the exception:
  [11/16/11 17:33:14:384 EST] 00000070 RemoteExcepti E
  CNTR0020E: EJB threw an unexpected (non-declared) exception
  during invocation of method "findExtendedDataForPI" on bean
  "BeanId(WC_perfinc#Payments-Plugin-Controller.jar#PluginControll
  erJDBCHelper, null)". Exception data:
  java.lang.NumberFormatException: For input string: "3007084391"
      at
  java.lang.NumberFormatException.forInputString(NumberFormatExcep
  tion.java:59)
      at java.lang.Integer.parseInt(Integer.java:472)
      at java.lang.Integer.parseInt(Integer.java:510)
      at
  com.ibm.commerce.payments.plugincontroller.beans.PluginControlle
  rJDBCHelperBean.findExtendedDataForPI(PluginControllerJDBCHelper
  Bean.java:488)
      at
  com.ibm.commerce.payments.plugincontroller.beans.PluginControlle
  rJDBCHelperBean.findExtendedDataForPI(PluginControllerJDBCHelper
  Bean.java:461)
      at
  com.ibm.commerce.payments.plugincontroller.beans.EJSRemoteStatel
  essPluginControllerJDBCHelper_13b00758.findExtendedDataForPI(EJS
  RemoteStatelessPluginControllerJDBCHelper_13b00758.java:73)
      at
  com.ibm.commerce.payments.plugincontroller.beans._PluginControll
  erJDBCHelper_Stub.findExtendedDataForPI(_PluginControllerJDBCHel
  per_Stub.java:1525)
      at
  com.ibm.commerce.payment.ppc.bean.commands.PPCPIExtendedDataCmdI
  mpl.performExecute(PPCPIExtendedDataCmdImpl.java:68)
      at
  com.ibm.commerce.command.ECCommandTarget.executeCommand(ECComman
  dTarget.java:157)
      at
  com.ibm.ws.cache.command.CommandCache.executeCommand(CommandCach
  e.java:332)
  

Local fix

• This error will not occur if you use a key value less than
  2147483647
  

Problem summary

• USERS AFFECTED:
  WebSphere Commerce users on v6.0 and v7.0 who may use primary
  key larger than 2147483647 for PPCPAYINST and PPCPAYTRAN table.
  
  PROBLEM ABSTRACT:
  NumberFormatException occurs when converting key value from
  String to BigInt type and persisting it to PPCEXTDATA table.
  
  BUSINESS IMPACT:
  Customer data will not be able to persist into the database.
  
  RECOMMENDATION:
  

Problem conclusion

• The exception is caused by incorrect program code. The current
  code is using Integer.parseInt(String piid) to do the
  conversion, if the key value is larger than 2147483647, the
  exception will throw.
  
  The code change in the fix is to use Long.parseLong(String
  piid), which will handle the conversion properly.
  -------------------------------------------------------------
  The latest available maintenance information can be obtained
  from the Recommended Fixes for WebSphere Commerce technote:
  http://www.ibm.com/support/docview.wss?rs=3046&uid=swg21261296
  

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

  WC BUS EDITION

• Fixed component ID

  5724I3800

Applicable component levels

• R700 PSY

     UP