Duplicate error causing OOTB workflow issues

Description description

Environment

Adobe Campaign Classic v8

Issue/Symptoms

OOTB ffdaReplicateStagingData workflow is not synching the data because of the following error:

nlmoduleStagingSchema    ODB-240000 Erreur ODBC : Duplicate row detected during DML action Row Values: [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1197, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, "questions@getlemasquefrancais.com", NULL, "L��on", NULL, "Taing", NULL

Resolution resolution

Delete the duplicate data via a custom workflow and re-run the ffdaReplicateStagingData workflow.

Cause

Duplicate data is stored in the nmsrecipientstg table, caused by composite custom primary key. To identify this data, you can run the following queries, where composite-key-columns is the custom composite key:

  • SELECT composite-key-columns FROM nmsrecipientstg GROUP BY composite-key-columns HAVING COUNT > 1;
  • SELECT URECIPIENTID FROM nmsrecipientstg GROUP BY URECIPIENTID HAVING COUNT > 1;
recommendation-more-help
3d58f420-19b5-47a0-a122-5c9dab55ec7f