Duplicate error causing OOTB workflow issues

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

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;