Failure Integration Event :Vendor Group not found in 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 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

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

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

    • 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 Failure Error :Vendor Update : DI Address is empty

      Environment iVend 6.6 with SAPB1 Problem Statement There is integration failure monitor customer UPDATE event from iVend to SAP B1 with error message : System.Exception DI Address is empty [OCRD.CardCode][line 0] at ...