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 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 error: line 9 col 23 (at pos 166)

Reproducing the issue
Prerequisites:

You are using Walldorf Intercompany version 51.

Scenario:

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 error: line 9 col 23 (at pos 166)

The steps are given below to reproduce the issue:
1. Create an A/R down payment invoice in the sender company.
2. Draft A/P down payment invoice is successfully created in the recipient company.
3. Syntax error or access violation error occurs in the intercompany message log for other participating companies. 

Expected behavior:

The A/R down payment invoice is successfully replicated to the participating company in the landscape.

Actual behavior:

Syntax error or access violation error occurs in A/R down payment invoice to A/P down payment invoice cycle

Workaround:

Attached zip files (count 2) are to be imported via BizStore Import of Control Center.

1. From your existing environment take the backup of "com.cxs.b1i.repository" and "com.sap.b1i.dev.scenarios.design" file as per the backup process below:
   
To take the backup of the repository files, perform the following steps:
  1. Login into Integration Framework 2.0.
  2. Goto Tools -->Control Center --> Maintenance -->BizStore Export.
  3. In the Exporting Content from BizStore, In the selection critera. Select the Dataset button.
  4. In the Choose Dataset, Choose Value "com.cxs.b1i.repository" and then press Submit button.
  5. Save the file in the relevant folder.
To take the backup of the package file, perform the following steps:
  1. Login into Integration Framework 2.0.
  2. Goto Tools -->Control Center --> Maintenance -->BizStore Export.
  3. In the Exporting Content from BizStore, In the selection critera. Select the Dataset button.
  4. In the Choose Dataset, Choose Value "com.sap.b1i.dev.scenarios.design", Choose Group "CXS.IC"  and then press Submit button.
  5. Save the file in the relevant folder.
2. Perform the following steps to import the Repository file:
  1. Login into Integration Framework 2.0.
  2. Goto Control Center --> Maintenance -->BizStore Import.
  3. In the Importing Content to BizStore, In the selection critera. In the Choose Archive, select the Choose File button. 
  4. Select the repository file "com.cxs.b1i.repository.zip".
  5. Select the checkbox Assume File System-Friendly Naming and then Submit.
3. Perform the following steps to import the Package file:
  1. Login into Integration Framework 2.0.
  2. Goto Control Center --> Maintenance -->BizStore Import.
  3. In the Importing Content to BizStore, In the selection critera. In the Choose Archive, select the Choose File button. 
  4. Select the package file "com.sap.b1i.dev.scenarios.design.zip".
  5. Select the checkbox Assume File System-Friendly Naming and then Submit.

Solution

The issue described above has been fixed in the Intercompany Integration Solutions version 52 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 2520001 - Overview Note for Intercompany integration solution Version 52 for SAP Business One