"System.Data.SqlClient.SqlException (0x80131904) String or binary data would be truncated.
Problem statement :
After creating the bank (CHINA CONSTRUCTION BANK) in SAP Business One, the event was stuck in the Integration Failure Log with the following error.
Bank Configuration in SAP B1
Error:
"System.Data.SqlClient.SqlException (0x80131904) String or binary data would be truncated.
iVend version :
6.6 8929
Symptoms:
N/A
Resolution / work around :
Log in to SAP Business One.
Identify the bank record that failed during integration.
Verify the Bank Code length and ensure it is 20 characters or fewer.
Remove the existing bank record from SAP Business One.
Request support to clear the corresponding error entry from the Integration Log.
Re-create the bank record in SAP Business One using a valid Bank Code (≤ 20 characters).
Trigger the integration process again.
Confirm that the bank record is successfully integrated with iVend Retail.
Related Articles
Item Group events stucked on Integration Failure Monitor String or binary data would be truncated
Environment : iVend 6.6 integrated With SAPB1 Problem Statement : Item Group add events stucked on Integration Failure Monitor from SAP Business one To iVend with below Message “System.Data.SqlClient.SqlException (0x80131904) String or binary data ...Udf events String or binary data would be truncated in table CXSRetail.dbo.PurPurchaseOrderDetail',
*****************For Internal purpose********************* Product Version iVend 6.6 integrated with SAP B1 Problem Statement Used defined field events stuck on Integration Failure Monitor with error message from SAP to iVend ...Integration Error System.Data.SqlClient.SqlException(0x80131904): Incorrect syntax near
Environment : iVend 6.6.8567 Problem Statement : Customer facing below integration error from SAP to iVend. “System.Data.SqlClient.SqlException(0x80131904): Incorrect syntax near ','” Symptoms: --We observed that the currency 'AUD' is mentioned in ...System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired
Problem Statement Getting an error message "System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding." in the iVend integration failure ...System.Data.SqlClient.SqlException (0x80131904) Error converting data type nvarchar to numeric.
Environment: iVend Retail 6.6 7989 With SAP B1 10.0 Problem statement: iVend Optical Product Master Created in SAP Business, however those failed stuck in integration failure log from SAP To iVend with below error. System.Data.SqlClient.SqlException ...