Integration Failed records from SAP to iVend "Input string was not in a correct format"

***************** Internal Article *****************

Problem Statement 

Integration Failed records (Customer type, update events) from SAP to iVend. Below is the error coming:

System.FormatException: Input string was not in the correct format. at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)at System.Number.ParseInt64(String value, NumberStyles options, NumberFormatInfo numfmt)at System.Convert.ToInt64(String value) at ReplicationSBOIntegrationWinSer.IntegrationObjects.Customer.Replicate(Direction From, Direction To, Int32 DatasetRowID)at ReplicationSBOIntegrationWinSer.Integrator.MainStart(DateTime LastRetryAt, Boolean& Retried)

Reason 

Check there may be Null values in CommentKey in iVend for any customer in the CusCustomerComment table.

Proposed Solution/Workaround

Run SQL queries and correct the null values with 0 then re-trigger all failed records. Which in-return should sync into iVend.

• Related Articles

• Integration Failed records from SAP to iVend "Input string was not in a correct format"

  ***************** Internal Article ***************** Problem Statement Integration Failed records (Customer type, update events) from SAP to iVend. Below is the error coming: System.FormatException: Input string was not in the correct format. at ...

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

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

• ERP integration error System.FormatException: Input string was not in a correct format.

  ***************** Internal Article ***************** Product Version: iVend 6.5 Update 6 with SAP B1 Problem Statement Record stuck on Integration Failure Monitor with error message from SAP to iVend. System.FormatException: Input string was not in ...

• Integration error "System.FormatException: Input string was not in a correct format"

  This KB is for Internal Purpose Only for CitiXsys Environment : iVend 6.6 /6.5 Update 5 with SAPB1 Problem Statement : Facing the following Integration issue when integrating Item update events from SAP to iVend. Below is the error: ...