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