Integration failure Error converting data type nvarchar to numeric
Environment
iVend 6.5 Update 4 With SAPB1 9.2
Problem Statement
Integration errors from SAPB1 to iVend as Product Update events:
System.Data.SqlClient.SqlException (0x80131904): Error converting data type nvarchar to numeric.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
Symptoms
N/A
Resolution/Work Around
Error converting data type nvarchar to numeric. It is suggested to compare the UDF definition in SAPB1 and iVend and Need to update the UDF values in SAPB1 and then check the integration events from SAPB1 to iVend.
Recommendations /Suggestion
It is recommended to keep the UDF information same in both places SAPB1 and iVend and once it is created, it definition shouldn't be changed.
Related Articles
System.Data.SqlClient.SqlException (0x80131904) Error converting data type nvarchar to numeric.
Environment: iVend Retail 6.6 7989 With SAP B1 10.0 Problem statement: iVend Optical Product Master Created in SAP Business, however those failed stuck in integration failure log from SAP To iVend with below error. System.Data.SqlClient.SqlException ...SAP to iVend Integration Error "Error converting data type nvarchar to numeric.
Environment: iVend 6.6 and SAP Business One Problem statement: SAP to iVend integration Error "System.Data.SqlClient.SqlException (0x80131904): Error converting data type nvarchar to numeric." for product Symptoms : The product created in SAP but ...Integration Err System.Data.SqlClient.SqlException (0x80131904): Error converting nvarchar data type
Product Version: 6.5 Update 6 Patch2 Problem Statement Incident ID - INC0012326 - Warehouse events stuck on Integration Failure Monitor from SAP to iVend with error message System.Data.SqlClient.SqlException (0x80131904): Error converting nvarchar ...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): ...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 ...