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

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

This error can be mitigated by updating the *Update tracking URLs (writerTrackingUrls)*activity in the workflow with the ACS_ prefix to the @tagIdsource 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 tagIdsmay happen during the synchronization. By adding the prefix, we avoid creating duplicate records and workflow failure.

On this page