IBM Support

Receiving Data Truncation exception when order inserts long payment data into PAYORDINFO table *|* -0283C33A668C314485257

Question & Answer


Question

Receiving Data Truncation exception when order inserts long payment data into PAYORDINFO table *|* -0283C33A668C314485257299007DA6B8- *|*

Answer

Technote (troubleshooting)


Problem(Abstract)

When payment data to be inserted (For example: VBV) to ORDPAYINFO and its length exceeds the limit an data truncation exception is thrown affecting the order logic flow.

Cause

Data being inserted to ORDPAYINFO exceeds the length limit.

Resolving the problem

When data being inserted into ORDPAYINFO exceeds the length allowed for data-value pair inside PAYORDINFO table an data truncation exception is thrown with similiar stack trace as shown below.

It is recommended to keep the length of data within the length allowable by the ORDPAYINFO indicated in 5.6 and 5.61 Information Center.

An alternative to resolve this issue is to apply the APAR SE28250 or upgrade to WebSphere Commerce 5.6.1.3.

About APAR SE28250.

The Order logic is enhanced so that it does pre-validation on the name-value data pair before inserting data into ORDPAYINFO table. If the data length exceeds the limit the pre-validation logic ignores the problematic data and continue. As a result the order flow does not attempt inserting data to the ORDPAYINFO table and the problematic data does not affect the order logic flow.

Please contact Commerce Support for information about APAR SE28250.

Sample stack trace when data truncation happens:


[2/27/07 5:19:22:691 EST] 5420ef27 ExceptionUtil E CNTR0019E: Non-application exception occurred while processing method "create". Exception data: com.ibm.websphere.cpi.CPIException: ; nested exception is:
java.sql.DataTruncation: Data truncation
java.sql.DataTruncation: Data truncation
java/lang/Throwable.<init>(Ljava/lang/String;)V+0 (Throwable.java:84)
java/lang/Exception.<init>(Ljava/lang/String;)V+0 (Exception.java:33)
java/sql/SQLException.<init>(Ljava/lang/String;Ljava/lang/String;)V+2 (SQLException.java:55)
java/sql/SQLWarning.<init>(Ljava/lang/String;Ljava/lang/String;)V+3 (SQLWarning.java:44)
java/sql/DataTruncation.<init>(IZZII)V+5 (DataTruncation.java:34)
com/ibm/db2/jdbc/app/DB2PreparedStatementRuntimeImpl.handleString(IILjava/lang/String;)I+?? (DB2PreparedStatementRuntimeImpl.java:??)
com/ibm/db2/jdbc/app/DB2PreparedStatementRuntimeImpl.nativeHandleString(IILjava/lang/String;)I+0 (DB2PreparedStatementRuntimeImpl.java:321)
com/ibm/db2/jdbc/app/DB2PreparedStatement.setString(ILjava/lang/String;)V+0 (DB2PreparedStatement.java:2626)
com/ibm/ejs/cm/cache/CachedStatement.setString(ILjava/lang/String;)V+0 (CachedStatement.java:403)
com/ibm/ejs/cm/proxy/PreparedStatementProxy.setString(ILjava/lang/String;)V+0 (PreparedStatementProxy.java:161)


[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SS73G6","label":"Sterling Total Payments for Financial Services"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
12 October 2021

UID

ibm10764627

Page Feedback