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

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.