Help get this topic noticed by sharing it on Twitter, Facebook, or email.
I’m confused

sf_replicate fails with Error occurred creating primary key


We ave been using sf_refresh on a custom object for years and today it has started failing. We tried an sf_replicate to start fresh but this is also failing. refresh and replicate are still working fine on many objects.

The error message the refresh is giving is as follows.

--- Starting SF_Replicate for Tiered_Support__C
15:11:20: Drop Tiered_Support__C_Previous if it exists.
15:11:20: Create Tiered_Support__C_Previous with new structure.
15:11:20: Run the DBAmp.exe program.
15:11:20: DBAmp Bulk Operations. V3.1.5 (c) Copyright 2006-2015 LLC
15:11:20: Populating local table Tiered_Support__C_Previous , SQL2 / salesforce backups .
15:11:21: DBAmp is using the SQL Native Client.
15:11:21: Opening SQL Server rowset
15:11:35: 24426 rows copied.
15:11:35: Drop Tiered_Support__C if it exists.
15:11:35: Rename previous table from Tiered_Support__C_Previous to Tiered_Support__C
Caution: Changing any part of an object name could break scripts and stored procedures.
15:11:35: Create primary key on Tiered_Support__C
15:11:35: Error occurred creating primary key for table.
15:11:35: Error: Could not create constraint. See previous errors.
--- Ending SF_Replicate. Operation FAILED.
Msg 50000, Level 16, State 1, Procedure SF_Replicate, Line 252 [Batch Start Line 14]
--- Ending SF_Replicate. Operation FAILED.

Many thanks in advance for any assistance.

1 person has
this question