1

I'm trying to migrate the analytics data from Sitecore 8.2.4 to 9.0.2. The tool worked about 12 hours and failed with the following message:

10152 19:08:25 ERROR [Data Exchange] An error occurred when trying to add the entity to the xConnect client. (thread id: 4, pipeline: Process Single Interaction from MongoDB Pipeline, pipeline step: Add Interaction Model to xConnect Batch, pipeline step identifier: f5fdb6f1-3557-461e-a75c-3cd9179077fe, entity model internal description: e298e777-8a40-4fb5-99fd-453560881695)

10152 19:08:25 ERROR [Data Exchange] Exception while submitting batch to xConnect. (thread id: 4, pipeline: Process Single Interaction from MongoDB Pipeline, pipeline step: Add Interaction Model to xConnect Batch, pipeline step identifier: f5fdb6f1-3557-461e-a75c-3cd9179077fe) 10152 19:08:25 ERROR [Data Exchange] One or more errors occurred. (thread id: 4, pipeline: Process Single Interaction from MongoDB Pipeline, pipeline step: Add Interaction Model to xConnect Batch, pipeline step identifier: f5fdb6f1-3557-461e-a75c-3cd9179077fe)

10152 19:08:25 ERROR [Data Exchange] START AGGREGATE EXCEPTION (thread id: 4, pipeline: Process Single Interaction from MongoDB Pipeline, pipeline step: Add Interaction Model to xConnect Batch, pipeline step identifier: f5fdb6f1-3557-461e-a75c-3cd9179077fe, ID: 1, HResult: -2146233088) ---- An error occurred when trying to add the entity to the xConnect client. (thread id: 4, pipeline: Process Single Interaction from MongoDB Pipeline, pipeline step: Add Interaction Model to xConnect Batch, pipeline step identifier: f5fdb6f1-3557-461e-a75c-3cd9179077fe, entity model internal description: e298e777-8a40-4fb5-99fd-453560881695)

---- ---- An error occurred when trying to add the entity to the xConnect client. (thread id: 4, pipeline: Process Single Interaction from MongoDB Pipeline, pipeline step: Add Interaction Model to xConnect Batch, pipeline step identifier: f5fdb6f1-3557-461e-a75c-3cd9179077fe, entity model internal description: e298e777-8a40-4fb5-99fd-453560881695) Operation #2, ReferenceNotFound, Contact, Emails (thread id: 4, pipeline: Process Single Interaction from MongoDB Pipeline, pipeline step: Add Interaction Model to xConnect Batch, pipeline step identifier: f5fdb6f1-3557-461e-a75c-3cd9179077fe) ---- ---- An error occurred when trying to add the entity to the xConnect client. (thread id: 4, pipeline: Process Single Interaction from MongoDB Pipeline, pipeline step: Add Interaction Model to xConnect Batch, pipeline step identifier: f5fdb6f1-3557-461e-a75c-3cd9179077fe, entity model internal description: e298e777-8a40-4fb5-99fd-453560881695) Operation #3, ReferenceNotFound, Contact, Personal (thread id: 4, pipeline: Process Single Interaction from MongoDB Pipeline, pipeline step: Add Interaction Model to xConnect Batch, pipeline step identifier: f5fdb6f1-3557-461e-a75c-3cd9179077fe) ---- ---- An error occurred when trying to add the entity to the xConnect client. (thread id: 4, pipeline: Process Single Interaction from MongoDB Pipeline, pipeline step: Add Interaction Model to xConnect Batch, pipeline step identifier: f5fdb6f1-3557-461e-a75c-3cd9179077fe, entity model internal description: e298e777-8a40-4fb5-99fd-453560881695) Operation #4, ReferenceNotFound, Contact, PhoneNumbers (thread id: 4, pipeline: Process Single Interaction from MongoDB Pipeline, pipeline step: Add Interaction Model to xConnect Batch, pipeline step identifier: f5fdb6f1-3557-461e-a75c-3cd9179077fe) ... END AGGREGATE EXCEPTION (thread id: 4, pipeline: Process Single Interaction from MongoDB Pipeline, pipeline step: Add Interaction Model to xConnect Batch, pipeline step identifier: f5fdb6f1-3557-461e-a75c-3cd9179077fe, ID: 2, HResult: -2146233088)

What is the reason of the issue and how I can deal with it? I guess it should skip the contact in question and continue, but it aborts the execution at all.

Improve this question
4
  • 1
    Anything in the xconnect site logs?
    – Chris Auer
    Commented Jan 21, 2019 at 1:11
  • Nothing useful, it just says that xConnect started
    – Pavel Ivashchenko
    Commented Jan 21, 2019 at 8:45
  • As one of the option to skip failed batch is enable checkbox field "Do Not Close All Threads On Exception" on "Iterate MongoDB Contacts and Run Pipelines" pipeline step
    – Vlad Shpak
    Commented Jan 23, 2019 at 1:52
  • Yes, I did it but it did not help. If a critical error occurred it interrupts the whole process.
    – Pavel Ivashchenko
    Commented Jan 23, 2019 at 5:45

1 Answer 1

Reset to default
1

I've received the same error before. After reaching out to SC Support about it, they told us to ensure that we have no data in the Connect Shard databases. This applies if you are not running it in "Resume mode."

To the issue of removing the xConnect data, I've had success with the ADM module (version 4.0.0 or 4.0.1 for 9.0.x and 9.x, respectively.) One must remove the three default "Data Remover Configurators" to delete all of the data, however.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.