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 would be truncated.

The statement has been terminated”

Symptoms:

NA

Resolution/Work Around:

Suggested customer to check length of Item  group desc in SAP. iVend only allowed desc upto 100 character.

We can check problematical item group  by execute below query in sap.

SELECT len(itmsgrpnam) FROM OITB  where len(itmsgrpnam)>100

Recommendations /Suggestion:

Additionally , Item Group ID length is permitted with 20 Chars in iVend so when it is created in SAPB1, it shouldn't be more than 20 chars

• Related Articles

• 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 ...

• Failure Integration Event :Vendor Group not found in iVend

  Environment : iVend 6.6 integrated With SAPB1 Problem Statement : CustomerGroup add events stucked on Integration Failure Monitor from SAP Business one To iVend with below Message “System.Data.SqlClient.SqlException (0x80131904): String or binary ...

• Failure Integration Event :CustomerGroup not found in iVend

  Environment : iVend 6.6 integrated With SAPB1 Problem Statement : CustomerGroup add events stucked on Integration Failure Monitor from SAP Business one To iVend with below Message “System.Data.SqlClient.SqlException (0x80131904): String or binary ...

• SAP Business One - iVend Retail Integration Points

  Introduction SAP Business One software is created specifically for small and midsized businesses. It is a powerful application and iVend Retail seamlessly integrates with it to help retailers better manage every aspect of their daily retail ...

• Good Receipt data fetch for Error Insufficient quantity for item with batch on Integration Monitor

  **********Internal Purpose to CXS Support************** Environment : iVend 6.6 With SAPB1 Problem Statement : Stock transfer and Sale transaction events stucked on Integration Failure Monitor with error message “Insufficient quantity for item with ...