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" when an item is updated.

Scenario :

After using the .EXE some of the records were not integrated as mentioned in the below screenshot, unable to update the item as well as employee details.

Solution:

1) Take the Back up of the integration exe.

2) One new integration exe is replaced. 

3) After that check the employee data update from SAP to iVend. 

Symptoms :

While updating the employee information system giving this error "Syntax error or access violation; 257 sql syntax error".

Resolution/Work Around:

We have applied a new integration exe after updating the integration exe we have checked the transactions all those transaction integrated successfully from SAP to IVend.

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

• iVend Inventory Audit Report display Error "Incorrect Syntax near 'order'

  Environment: iVend 6.6 Problem Statement: Inventory Audit was not working on Enterprise Management Console Its shows error message “Incorrect Syntax near 'order' Incorrect Syntax near the Keyword 'As' Statement(s) could not be prepared". Proposed ...

• Found error while login MC "Error encountered found in application"

  Environment: 6.6.7989 Short Description: Error found in the application Product Query:  While login in Management Console found error “Error found in the application” Resolution/Work Around: Not Applicable Recommendations /Suggestion: Ivend Database ...

• While sending the test email it thrown error as "The SMTP server requires a secure connection"

  Environment: iVend Version 6.6 Problem Statement: While sending the test email it thrown error as “The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.0 authentication required”. Error ...

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