Duplicate error causing OOTB workflow issues

This article explains how the resolve the Adobe Campaign issue where the OOTB ffdaReplicateStagingData workflow is not syncing the data. The error that causes this issue can be resolved by deleting the duplicate data with a custom workflow.

Description description

Environment

Adobe Campaign Classic v8

Issue/Symptoms

The 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, "email@provider.com" NULL, "XXX" NULL, "XXX" 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