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

Replicate_ALL failing on creating the primary key on the Event table

Recently the replicate_ALL process has failed when trying to create a primary key on the event table:

--- Starting SF_Replicate for Event V3.1.0
11:33:36: Drop Event_Previous if it exists.
11:33:36: Create Event_Previous with new structure.
11:33:36: Run the DBAmp.exe program.
11:33:36: DBAmp Bulk Operations. V3.1.0 (c) Copyright 2006-2015 LLC
11:33:36: Populating local table Event_Previous , FIPSQL01\SQL01 / Salesforce_Live .
11:33:37: DBAmp is using the SQL Native Client.
11:33:37: Opening SQL Server rowset
11:34:19: 44998 rows copied.
11:34:19: Drop Event if it exists.
11:34:19: Rename previous table from Event_Previous to Event
Caution: Changing any part of an object name could break scripts and stored procedures.
11:34:19: Create primary key on Event
11:34:19: Error occurred creating primary key for table.
11:34:19: Error: Could not create constraint. See previous errors.
--- Ending SF_Replicate. Operation FAILED.
Error: SF_Replicate failed for table Event
Error 50000, Severity 16, State 1, Line 293
--- Ending SF_Replicate. Operation FAILED.

Any ideas for a resolution? I run the drop and create key scripts but the error still remains.

Thanks in advance
1 person has
this question