Integration Failure Monitor "System. Argument Exception: An Item with same key has been been added

--INTERNAL Document----

Product version:

6.5 Update 6 Patch2  

Problem statement :

Product update stucked with error message on Integration Failure Monitor from SAP to iVend “System. Argument Exception: An Item with same key has been already been added. 

 

Proposed solution:

Suggest customer to check master data udf integration screen and  user defined field in iVend.If there are two udfs with same name in  SAP however in iVend UDF there is one field with same name. 

Below are the query require to run to delete duplicate entry from SAP 

For Found duplicate entry against udf. 

SELECT * FROM "@CXS_UDFINTG" WHERE "U_CXS_UDF"='U_Des' 

 

Create Backup Table 

 

CREATEs TABLE CXS_UDFINTG_TempINC0011586 AS (SELECT * FROM "@CXS_UDFINTG") 

 

 

After Backup delete one entry. 

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

• 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 Error System. Exception DI 10001069 Item F1580000632 is inactive

  Environment iVend Retail 6.6 integrated with SAP B1 Problem Statement Sale transaction stucked on integration failure monitor with error message Error: System. Exception DI 10001069 Item F1580000632 is inactive at ReplicationSBOIntegrationWinSer. ...

• Integration Error System.Exception: DI:Target item number does not match base item number

  Environment 6.6 integrated with SAP Problem Statement Good Receipt stucked on Integration Failure Monitor with Error Message from iVend to SAP System.Exception: DI:Target item number does not match base item number. [PDN1.ItemCode][line: 2] ...

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