Question:
We were carrying out some loads in our SIT 1 tenant (H9uyPXKbmTJ40ew) and some records failed to load with an error saying, "Crosswalk is used for repoint in multiple ref attributes".
We could not understand what the error was about from the error file, and it would be highly appreciated if you could help us with the same.
CommonException: Code: REPOINT_CROSSWALK_SPECIFIED_IN_MULTIPLE_REF_ATTRS; Message parameters: []. Crosswalk is used for repoint in multiple ref attributes. CrosswalkTO {type: configuration/sources/AMS, sourceTable: null, value: 12228261_12228261_12228261_12228261} is used for repoint in multiple ref attributes. Current ref attribute has crosswalks: [configuration/sources/AMS/12228261_12228261_12228261_12228261] and is specified inside incoming entity with crosswalks: [configuration/sources/AMS/12228261]. Another ref attribute with the same crosswalk is specified inside incoming entity with crosswalks: [configuration/sources/AMS/12228261].
Answer:
When I check the entities which are having ID = 12228261 then I found the 1vX89UH entity
If we look at the start object of the relations
"startObject": {
"type": "configuration/entityTypes/HCP",
"objectURI": "entities/1Vh51aeR",
"label": "",
"directionalLabel": "has address",
"crosswalks": [
{
"uri": "entities/1vX89UH/crosswalks/4thuSkVUp",
"type": "configuration/sources/AMS",
"value": "12228261",
"reltioLoadDate": "2023-03-04T10:58:14.734Z",
"createDate": "2023-03-04T08:48:59.165Z",
"updateDate": "2023-03-04T08:48:59.165Z",
If we look at the end object of the relations
"endObject": {
"type": "configuration/entityTypes/Location",
"objectURI": "entities/W8hsBVh",
"label": "500 UNIVERSITY DR HERSHEY PA 17033 2360",
"directionalLabel": "locates",
"crosswalks": [
{
"uri": "entities/W8hsBVh/crosswalks/4R95fCbcU",
"type": "configuration/sources/AMS",
"value": "9ee162501cfeddc698c3b68c7c3e566b",
"reltioLoadDate": "2023-02-26T04:05:39.600Z",
"createDate": "2023-02-26T04:05:39.600Z",
"updateDate": "2023-02-26T04:05:39.600Z",
- Relation defined in the entity.
"refRelation": {
"type": "configuration/relationTypes/HasAddress",
"crosswalks": [
{
"uri": "entities/1vX89UH/crosswalks/48EN5rS.S6ylzSqU",
"type": "configuration/sources/AMS",
"value": "12228261_12228261_12228261_12228261",
"createDate": "2023-03-04T10:59:54.240Z",
"updateDate": "2023-03-04T10:59:54.240Z",
"attributeURIs": [
"entities/1vX89UH/attributes/Address/48EN5rS/AddressType/S6ylyVAs",
"entities/1vX89UH/attributes/Address/48EN5rS/ValidationStatus/S6ylzBnS",
"entities/1vX89UH/attributes/Address/48EN5rS/Status/S6ylz7XC",
"entities/1vX89UH/attributes/Address/48EN5rS/RequiresAttention/S6ylyz0g",
"entities/1vX89UH/attributes/Address/48EN5rS",
"entities/1vX89UH/attributes/Address/48EN5rS/Primary/S6ylymDu",
"entities/1vX89UH/attributes/Address/48EN5rS/PublishFlag/S6ylyqUA",
"entities/1vX89UH/attributes/Address/48EN5rS/RelationshipStartDate/S6ylyukQ"
]
}
],
"startRefPinned": false,
"endRefPinned": false,
"startRefIgnored": false,
"endRefIgnored": false,
"objectURI": "relations/48EN5rS"
},
Comments
Please sign in to leave a comment.