CReplicator MapLocations Error: 457 : This key is already associated with an element of this collection

Created by Datapel Integration, Modified on Fri, 6 Jun at 4:19 PM by Datapel Integration

Description

This only works for error CReplicator MapLocations.

Important Reminder

Only Datapel Support should perform this task.

Open the db and run select query below to see the issueselect * from adr_addresslist order by adr_cardrecordid.
select adr_cardrecordid, count(adr_cardrecordid) from adr_addresslist group by adr_cardrecordid having count( adr_cardrecordid) > 1
Backup DB.
Run Maintenance Replication.
Delete all records from adr_addresslist table.
Perform Maintenance Replication.

None