PGS-220000 PostgreSQL error: ERROR: duplicate key value violates unique constraint “nmstrackingurl_tagid”

Description description

Environment

  • Campaign Classic
  • Campaign Classic v7

Issue/Symptoms
The OOTB workflow for the Prime connector called newRcpDeliveryLogReplication fails with the error:

PGS-220000 PostgreSQL error: ERROR: duplicate key value violates unique constraint “nmstrackingurl_tagid” DETAIL: Key (stagid) = (1c7bdec2) already exists.

Resolution resolution

This error can be mitigated by updating the *Update tracking URLs (writerTrackingUrls)*activity in the workflow with the ACS_ prefix to the @tagId source expression.

This error may occur in situations when both ACC and ACS instances are used to send emails with tracked URLs. Then a clash with duplicate URL tagIds may happen during the synchronization. By adding the prefix, we avoid creating duplicate records and workflow failure.

recommendation-more-help
3d58f420-19b5-47a0-a122-5c9dab55ec7f