WDF 2500024 - "Syntax error or access violation" error occurs while canceling the Intercompany Branch Purchase Order to Sales Order

Symptom

The following error occurs while canceling the Intercompany Branch Purchase Order to Intercompany Branch Sales Order:

Syntax error or access violation;257 sql syntax error: incorrect syntax near ";": line 2 col 25 (at pos 67) -The di call #1 did fail.

Reproducing the issue

Prerequisites:

You are using Walldorf Intercompany version 50.

Scenario:

The following error occurs while canceling the Intercompany Branch Purchase Order to Intercompany Branch Sales Order:

Syntax error or access violation;257 sql syntax error: incorrect syntax near ";": line 2 col 25 (at pos 67) -The di call #1 did fail.

Expected behavior:

The Intercompany Branch PO to Intercompany Branch SO is successfully canceled.

Actual behavior:

"Syntax error or access violation" error occurs while canceling the Intercompany Branch Purchase Order to Sales Order.

Workaround:

Following are the steps to import the attached zip file in the Integration Server:

1. To take the backup of the package file, perform the following steps:

Login into Integration Framework 2.0.
Goto Tools -->Control Center --> Maintenance -->BizStore Export.
In the Exporting Content from BizStore, In the selection critera. Select the Dataset button.
In the Choose Dataset, Choose Value "com.sap.b1i.dev.scenarios.design", Choose Group "CXS.IC" and then press Submit button.
Save the file in the relevant folder.

2. Perform the following steps to import the Package file:

Login into Integration Framework 2.0.
Goto Control Center --> Maintenance -->BizStore Import.
In the Importing Content to BizStore, In the selection critera. In the Choose Archive, select the Choose File button.
Select the package file "com.sap.b1i.dev.scenarios.design.zip".
Select the checkbox Assume File System-Friendly Naming and then Submit.
Click on the Submit button. A caution message will appear. Click on the OK button.
SAP B1iP Control Center shows the Import Status.
Click on the close button to close the Control Center.

Solution

The issue described above has been fixed in the Intercompany Integration Solutions version 51 and higher versions.

Product

Product or Product Version

B1 INTERCOMPANY INTEGRATION

SAP B1 10.0 FOR SAP HANA

SAP B1 9.3 FOR SAP HANA

SAP BUSINESS ONE 10.0

SAP BUSINESS ONE 9.3

This document refers to :

WDF 2510001- Overview Note for Intercompany integration solution Version 51 for SAP Business One

Related Articles
WDF 3137653 - The requested action is not supported for this object error occurs in respective branch company while closing sales order or purchase order in source company
Symptom The requested action is not supported for this object error occurs in respective branch company while closing sales order or purchase order in source company Reproducing the issue Prerequisites: You are using Intercompany Integration Solution ...
WDF 2520025 - The "Syntax error or access violation" error occurs while replicating the A/R Debit Memo to the A/P Debit Memo document exchange cycle
Symptom The following error occurs while replicating the A/R Debit Memo to the A/P Debit Memo document exchange cycle: Syntax error or access violation;257 sql syntax error: incorrect syntax near "UPDATE": line 3 col 4 (at pos 149) -The di call #1 ...
WDF 2510015 - Syntax error or access violation error occurs while replicating the A/R down payment invoice to the A/P down payment invoice
Symptom The following error occurs in the intercompany message log while replicating the A/R down payment invoice to the A/P down payment invoice: Description: 1). [SAP AG][LIBODBCHDB DLL][HDBODBC] Syntax error or access violation;257 sql syntax ...
WDF 2510020 - Unable to create the Non-intercompany A/R invoice based on the sales order
Symptom The following error occurs while creating a non-intercompany type A/R invoice document based on the sales order if the intercompany solution add-on is connected: "This document cannot be added as the base document is not confirmed for ...
WDF 3242620 - Bad request error occurs while integrating master data from Dynamics 365 Sales to SAP if non english characters are used
Symptom Bad request error occurs while integrating master data from Dynamics 365 Sales to SAP if non english characters are used. Reproducing the issue Prerequisites: You are using Intercompany Integration Solution PL45 or lower. Scenario: Bad ...

WDF 2500024 - "Syntax error or access violation" error occurs while canceling the Intercompany Branch Purchase Order to Sales Order

WDF 2500024 - "Syntax error or access violation" error occurs while canceling the Intercompany Branch Purchase Order to Sales Order

Related Articles

WDF 3137653 - The requested action is not supported for this object error occurs in respective branch company while closing sales order or purchase order in source company

WDF 2520025 - The "Syntax error or access violation" error occurs while replicating the A/R Debit Memo to the A/P Debit Memo document exchange cycle

WDF 2510015 - Syntax error or access violation error occurs while replicating the A/R down payment invoice to the A/P down payment invoice

WDF 2510020 - Unable to create the Non-intercompany A/R invoice based on the sales order

WDF 3242620 - Bad request error occurs while integrating master data from Dynamics 365 Sales to SAP if non english characters are used