Item Group events stucked on Integration Failure Monitor String or binary data would be truncated

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