Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Failed Replicate job due to 'duplicate key value' for Account

I have a simple replicate job that continues to fail for this line:

'exec SF_replicate3 'salesforce', 'account', 'pkchunk''

SQL Server shows this error message:
ecuted as user: NT SERVICE\SQLAgent$SALESFORCEQA. --- Starting SF_Replicate3 for recordtype V3.5.4
[SQLSTATE 01000] (Message 0) 01:00:00: Drop recordtype_Previous if it exists.
[SQLSTATE 01000] (Message 0) 01:00:00: Create recordtype_Previous with new structure.
[SQLSTATE 01000] (Message 0) 01:00:02: Drop recordtype if it exists.
[SQLSTATE 01000] (Message 0) 01:00:03: Rename previous table from recordtype_Previous to recordtype
[SQLSTATE 01000] (Message 0) Caution: Changing any part of an object name could break scripts and stored procedures.
[SQLSTATE 01000] (Message 15477) 01:00:03: 165 rows copied.
[SQLSTATE 01000] (Message 0) 01:00:03: Create primary key on recordtype
[SQLSTATE 01000] (Message 0) --- Ending SF_Replicate3. Operation successful.
[SQLSTATE 01000] (Message 0) The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.account' and the index name 'PK_account_Id'. The duplicate key value is (0010c00001zJpyJAAS).
[SQLSTATE 23000] (Error 1505) Could not create constraint or index. See previous errors.
[SQLSTATE 42000] (Error 1750) --- Starting SF_Replicate3 for account V3.5.4
[SQLSTATE 01000] (Error 0) 01:00:04: Drop account_Previous if it exists.
[SQLSTATE 01000] (Error 0) 01:00:04: Create account_Previous with new structure. [SQLSTATE 01000] (Error 0) 04:51:25: Drop account if it exists.
[SQLSTATE 01000] (Error 0) 04:51:26: Rename previous table from account_Previous to account
[SQLSTATE 01000] (Error 0) Caution: Changing any part of an object name could break scripts and stored procedures.
[SQLSTATE 01000] (Error 15477) 04:51:32: 469115 rows copied. [SQLSTATE 01000] (Error 0) 04:51:32: Create primary key on account
[SQLSTATE 01000] (Error 0) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.

I query my SFDC db on SQL server and I get 31 records back for the ID mentioned above.

I query SFDC directly and I only get one record. I also queried SFDC for the email address associated with the ID above an Salesforce returns only one record.

I deleted all records in the SFDCBackup.Account table in SQL and ran my replicate again and received the same results.

This appears to be an issue with DBAmp? We have not changed our SQL jobs running the replicate processes, but we have created new fields in SFDC on the Account object right before this started happening.

HELP! TIA
1 person has
this problem
+1
Reply