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 did fail.
Reproducing the issue
Prerequisites
You are using Intercompany Integration Solution version 47 to version 52.
Scenario:
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 did fail.
Expected Result:
The A/P Debit Memo document is successfully created in the receiver company based on the A/R Debit Memo document in the sender company.
Actual Result:
The "Syntax error or access violation" error occurs while replicating the A/R Debit Memo to the A/P Debit Memo document exchange cycle.
Workaround:
Attached zip files (count 1) is to be imported via BizStore Import of Control Center.
1. From your existing environment take the backup of "com.sap.b1i.dev.scenarios.design" file as per the backup process below:
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 hotfix file:
- Login into Integration Framework 2.0.
- Go to Maintenance and then Zip Import. In the Choose Archive, select the Choose File button.
- Select the hotfix file and Click the Submit button.
Solution
The issue described above will be fixed in the Intercompany integration solution PL53 for SAP Business One, 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 2530001 - Overview Note for Intercompany integration solution Version 53 for SAP Business One
Related Articles
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 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 ...WDF 2510007 - The document exchange cycle from A/R Credit Memo to A/P Credit Memo is supported
The intercompany solution now supports the A/R credit memo to A/P credit memo document exchange cycle in the intercompany trade. This development addresses specific business scenarios where the head office company manages accounts receivable, ...WDF 2480012 - Option to select the specific document(s) to replicate as a firm document is available in the Document Exchange cycle
The user can select the specific intercompany marketing document(s) that he wants to replicate as a “Firm document” in branch companies. This can be achieved by clicking the browse button next to the "Direct Creation of Firm Document" checkbox ...WDF 2510008 - The document exchange cycle from A/R Down Payment Invoice to A/P Down Payment Invoice is supported
The intercompany solution supports a new additional document cycle, the A/R down payment invoice to the A/P down payment invoice in the intercompany trade. The solution supports the creation of a draft or firm A/P down payment in the receiver ...