Integration Error System.Data.SyntaxErrorException: Syntax error: Missing operand after 'd130'

Product Version

6.6 integrated with SAP 

Problem Statement 

Transaction stucked on Integration Failure Monitor with error message from iVend to SAP

“System.Data.SyntaxErrorException: Syntax error: Missing operand after 'd130' operator”

 

Proposed Solution

Issue is only reported on dated version iVend ver. 6.6 and Fixed on the latest branch of iVend release available for the production use.

Steps 

NA

Constraints / Scenarios 

NA

 

• Related Articles

• 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 ...

• 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.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 ...

• Syntax error: The operand after the 'UseDrawer' operator is missing

  Problem: After upgrading to 6.6 it was reported that below error was coming while assigning Till to POS. Syntax error: The operand after the 'UseDrawer' operator is missing" Root Cause: "UseDrawer" SP missing from Store database. Resolution: Store ...

• SAP Business One - iVend Retail Integration Points

  Introduction SAP Business One software is created specifically for small and midsized businesses. It is a powerful application and iVend Retail seamlessly integrates with it to help retailers better manage every aspect of their daily retail ...