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 data would be truncated.
The statement has been terminated”
Symptoms:
NA
Resolution/Work Around:
We checked below point :
In SAP screen we checked that problematic Vendor group name showing Vendor group setup screen not showing in iVend screen.
It is the part of OCRG table of SAP database.
Vendor group also part of integration mapping table however is not integrated .
Later we analysis data and found Vendor group name string length is more than 20 character and and iVend only allowed desc upto 20 character .
Suggested customer to check length of VendorGroup name in SAP. iVend only allowed desc upto 20 character.
We can check problematical item group by execute below query in sap.
SELECT len(GroupName),GroupName FROM OCRG where len(GroupName)>20
Recommendations /Suggestion:
NA
Related Articles
Error in Integration Monitor (SAP to iVend) in version 6.6 for event type "Customer"
*****************For Internal purpose********************* Product Version: iVend 6.6 Issue: Error in Integration Monitor (SAP to iVend) in version 6.6 for event type "Customer": Integration Error: System.Data.SqlClient.SqlException (0x80131904): ...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 ...General Settings in SAP Business One
Introduction The iVend Add-on helps in setting up some configurations required for integrating iVend with SAP Business One. The following sections of this document capture the functionality of the new screens created and new fields added to the SAP ...Integration Error "Vendor Catalog not found in SBO"
***********For Internal Purpose Only*********** Environment: iVend 6.5 & 6.6 SAP B1 9.3 Problem statement: SAP to iVend integration Error “System.Exception: Vendor Catalog not found in SBO” Root Cause: This issue occurs due to if vendor is created on ...Integration Error "System.Data.Odbc.OdbcException (0x80131937): ERROR [HY000] [SAP AG][LIBODBCHDB"
Environment: iVend 6.6 integrated with SAPB1 HANA Problem Statement: Integration was not working and its showing below message on Event Viewer Log “System.Data.Odbc.OdbcException (0x80131937): ERROR [HY000] [SAP AG][LIBODBCHDB DLL][HDBODBC] General ...