Why "FAILED_TO_MERGE_RELATIONS_WITH_THE_SAME_CROSSWALK" error is happening

Problem

The error below displays while loading a record using the Reltio data load jar.

"errorCode": 1001, 
"errorDetailMessage": "Internal error occurred while operating with database, message - Code: FAILED_TO_MERGE_RELATIONS_WITH_THE_SAME_CROSSWALK; Message parameters: [[DEA/HasAddressHCPMF2588981]]. Failed to merge relations that have the same crosswalk [DEA/HasAddressHCPMF2588981]..

Analysis

Relation crosswalk might already be in a tenant with a different combination of start object and end object.

To check why the error is happening, do the following:

1. Check whether the same crosswalk in error message is already available in a tenant.

Using the example API below, we can get the relations based on the crosswalk:

GET: https://{env}.reltio.com/reltio/api/{tenant}/relations/_byCrosswalk/HaessPMF2588981?type=DA

2. Compare start and end objects from the current response and what is loading using the jar.

In this case, the relation crosswalk "DA/HaessPMF2588981" is already available in a tenant with one set of combination of start object and end object.

Solution

Do not re-load the existing relationship with different start or end objects.

 

 

 

 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.