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): ...

• CASABAT-PA: Syntax error or access violation;257 sql syntax error

  Environment : I-Vend 6.6 Patch 7825 Problem Description : Client having problem with the .exe that was applied to us to solve the employee integration. Since the integration sends the error: "Syntax error or access violation; 257 sql syntax error" ...

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

• Getting integration error "System.Exception: DI:To generate this document, first define the number

  Problem Statement Integration error "generate this document, first define the numbering series in the Administration module" Issue in detail Getting integration error "System.Exception: DI:To generate this document, first define the numbering series ...