Integration Error System.Data.SqlClient.SqlException(0x80131904): Incorrect syntax near
Environment :
iVend 6.6.8567
Problem Statement
:
Customer facing below integration error from SAP to iVend.
“System.Data.SqlClient.SqlException(0x80131904): Incorrect
syntax near ','”
Symptoms:
--We observed that the currency 'AUD' is mentioned in the SAP item master details, but it is not configured in the SAP currency master.
-- User can check the data by running below query in SAP
select * from ITM1 where ItemCode= 'Put the problematic item'
Resolution/workaround:
1. Remove the additional currency from the item master.
2. Configure the currency in SAP currency setup which is mentioned as additional currency in item master.
Reference Ticket: #17665
Related Articles
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 ...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 ...System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired
Problem Statement Getting an error message "System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding." in the iVend integration failure ...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 ...