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:
System.FormatException: Input string was not in a correct format. at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) at System.Convert.ToInt32(String value) at ReplicationSBOIntegrationWinSer.IntegrationObjects.Item.GetItemPrice(String ItemCode, Int64 WarehouseKey) at ReplicationSBOIntegrationWinSer.IntegrationObjects.Item.Replicate(Direction From, Direction To, Int32 DatasetRowID) at ReplicationSBOIntegrationWinSer.Integrator.MainStart(DateTime LastRetryAt, Boolean& Retried)
Symptoms :
Not Applicable
Resolution/Work Around :
The Retail Price-List code was changed by a user in the iVend mistakenly, putting an “I” instead of the number “6” that originally was the Price list code. Means, SAP has the Price-list Code "6" however it is "I" in iVend now, this is why the Integration monitor was throwing a data type error.
So in the Management Console, replace the "I" code with "6" again and It should start integrating.
Below is the incorrect Code Screenshot in iVend which needs to revert "6"
Recommendations /Suggestion :
Related Articles
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 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 ...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 ...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 ...Server Error in '/iVendReplication' Application.Input string was not in a correct format on
Problem Statement Replication is not working on Store Error : Server Error in '/iVendReplication' Application.Input string was not in a correct format. Version ivend 6.6 Recommendation: Please check the web config file on Store and check Below tag ...