Direct links to fixes
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 number
JR41283
Reported component name
WC BUS EDITION
Reported component ID
5724I3800
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-11-23
Closed date
2012-01-12
Last modified date
2012-01-12
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSYSYL","label":"WebSphere Commerce Enterprise"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
12 January 2012