WDF 2560041 – Entry already exists error may occur while replicating Item Master with barcode

WDF 2560041 – Entry already exists error may occur while replicating Item Master with barcode

Symptom

The following error occurs while adding/replicating the Item Master with barcode information in the SAP HANA environment:
DI Error: (-2035) This entry already exists in the following tables (ODBC -2035)-The di call #1 did fail

Reproducing the Issue
Prerequisites

You are using Intercompany Integration Solution version 52.0 to 56.0 on SAP Business One for HANA.

Scenario
  1. Create a global item master containing the BarCode information.
  2. Edit any existing item master and add a new BarCode.
  3. Observe that the “This entry already exists” error may appear while updating the item master.
Expected Result

The Item Master, including its barcode information, is replicated successfully across the connected companies.

Actual Result

The replication process fails and displays the error “This entry already exists.”

Workaround:

A. Restore the numbering file in all the databases.

B. The attached zip file "IC_xmlproc.xml" is to be imported via BizStore Import of Control Center.

1. From your existing environment, take a backup of the "com.sap.b1i.dev.scenarios.design" file as per the backup process below:   

    1. Log in to Integration Framework 2.0.
    2. Go to Tools -->Control Center --> Maintenance -->BizStore Export.
    3. In the Exporting Content from BizStore, in the selection criteria. Select the Dataset button.
    4. In the Choose Dataset, choose Value "com.sap.b1i.dev.scenarios.design", Choose Group "CXS.IC", and then press the Submit button.
    5. Save the file in the relevant folder.

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

    1. Log in to Integration Framework 2.0.
    2. Go to Tools and Control Center --> Maintenance -->BizStore Import.
    3. In the Importing Content to BizStore, in the selection criteria. 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.
C. To import the attached "CXS.B1BC.SL.B1ITM2B1ITM.R" and "CXS.B1BC.B1ITM2B1ITM.R" files one by one, please follow the instructions below:
1. Take a backup of the scenario package:
i. Log in to Integration Framework 2.0
ii. From the top menu bar, click Scenarios.
iii. From the left menu, right-click on Packages and Open Package.
iv. Select CXS.IC package and click Open.
v. Right-click on CXS.IC package and Actions, then Export package
2. The following are the steps to update the intercompany package in the Integration framework:
i. Log in to Integration Framework 2.0.
ii. From the top menu bar, click Scenarios.
iii. From the left menu, right-click on Packages.
iv. Select CXS.IC, the package, and click Open.
v. Right-click on CXS.IC package and Actions, then update the Package.
vi. Click on Choose file and select the attachments and Submit.
vii. A new window will be opened up, then click on Import.
viii. An Import report will be opened up, then click on Close.

D. Log in to the Intercompany Administration Console, navigate to the Landscape, and redeploy the IC solution.

Solution

The issue described above has been fixed in the Intercompany integration solution version 57 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