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 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 Customer group name showing customer group setup screen not showing in iVend screen
It is the part of OCRG table of SAP database.
Customer group also part of integration mapping table however is not integrated .
Later we analysis data and found customer group name string length is more than 20 character and and iVend only allowed desc upto 20 character .
Suggested customer to check length of customer group 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
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 ...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): ...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 ...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 ...Integration failure : Item Cost not found for one or more items.
INTERNAL DOCUMENT Problem Statement: Item Cost not found for one or more items. Version: iVend 6.5 Update 6 with SAPB1 9.2 Check Points: Item cost may not exist in warehouse for which transaction is integrating with SAPB1. User may find warehouse ...