WDF 2560042 – AbsEntry already exists error occurs while syncing Discount Group

WDF 2560042 – AbsEntry already exists error occurs while syncing Discount Group

Symptom

The following error occurs while synchronizing the Discount Group in the SAP HANA environment:
unique constraint violated: Table(OEDG) with error: unique constraint violation on pos=0 for table TDB::<DBName>:OEDGen, key: AbsEntry=274 already exists as udiv=180
OR

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 Discount Group in the source company.
  2. Go to Inventory → Price Lists→ Synchronize Special Prices
  3. Trigger the synchronization process.
  4. Observe that the synchronization fails with the error “AbsEntry already exists.”
Expected Result

The Discount Group is synchronized successfully across the participating companies in the landscape.

Actual Result

The synchronization process fails and displays the error “AbsEntry already exists.”

Workaround:

A. Restore the numbering file in all the databases.

B. To import the attached "CXS.B1BC.SYNC2SYNC.S" and "CXS.B1BC.SYNC2SYNC.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.

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