ERP integration error System.FormatException: Input string was not in a correct format.
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 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.InventoryStockTransfer.CreateInventoryStockTransfer(DataRow[] objDataRow, DataSet objDataSetSerialBatch, Direction From, Direction To, String iVendSBOSTNumber, Boolean IsGoodReceiptST, DataRow[] objDataRowUserDefinedFields) at ReplicationSBOIntegrationWinSer.IntegrationObjects.Transactions.Replicate(Direction From, Direction To, Int32 DatasetRowID) at ReplicationSBOIntegrationWinSer.Integrator.MainStart(DateTime LastRetryAt, Boolean& Retried)
Proposed Solution:
Log Date Time is incorrect which seems causing the issue Log Date time ie. 20/8/2562:Suggested to check the date of Stock Transfer in SAP and compare it with iVend Transnational data
Steps if any:
NA
Constraints / Scenarios:
NA
Related Articles
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: ...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 ...