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

Salesforce Replicate Failing after 3 tables

We use DBAmp to bring our Salesforce back to our local SQL server and I recently have added a few more tables to the normal job that has been running, and now I am getting an error when trying to replicate the data to SQL. It seems to get through 3 tables and then on the 4th table it will fail. Below is the error message I am getting.

Executed as user: OFB\svc_sqlruth. ...1000] (Message 0) 13:22:56: Drop ssc_emp_id__c_Previous if it exists. [SQLSTATE 01000] (Message 0) 13:22:56: Create ssc_emp_id__c_Previous with new structure. [SQLSTATE 01000] (Message 0) 13:22:58: Run the DBAmp.exe program. [SQLSTATE 01000] (Message 0) 13:22:58: DBAmp Bulk Operations. V3.5.2 (c) Copyright 2006-2017 forceAmp.com LLC [SQLSTATE 01000] (Message 0) 13:22:58: Populating local table ssc_emp_id__c_Previous , OFB-RUTH / salesforce_data . [SQLSTATE 01000] (Message 0) 13:22:58: DBAmp is using the SQL Native Client. [SQLSTATE 01000] (Message 0) 13:22:58: Opening SQL Server rowset [SQLSTATE 01000] (Message 0) 13:23:00: 876 rows copied. [SQLSTATE 01000] (Message 0) 13:23:00: Drop ssc_emp_id__c if it exists. [SQLSTATE 01000] (Message 0) 13:23:00: Rename previous table from ssc_emp_id__c_Previous to ssc_emp_id__c [SQLSTATE 01000] (Message 0) Caution: Changing any part of an object name could break scripts and stored procedures. [SQLSTATE 01000] (Message 15477) 13:23:01: Create primary key on ssc_emp_id__c [SQLSTATE 01000] (Message 0) --- Ending SF_Replicate. Operation successful. [SQLSTATE 01000] (Message 0) --- Starting SF_Replicate for Account [SQLSTATE 01000] (Message 0) 13:23:01: Drop Account_Previous if it exists. [SQLSTATE 01000] (Message 0) 13:23:01: Create Account_Previous with new structure. [SQLSTATE 01000] (Message 0) 13:23:01: Run the DBAmp.exe program. [SQLSTATE 01000] (Message 0) 13:23:01: DBAmp Bulk Operations. V3.5.2 (c) Copyright 2006-2017 forceAmp.com LLC [SQLSTATE 01000] (Message 0) 13:23:01: Populating local table Account_Previous , OFB-RUTH / salesforce_data . [SQLSTATE 01000] (Message 0) 13:23:02: DBAmp is using the SQL Native Client. [SQLSTATE 01000] (Message 0) 13:23:02: Opening SQL Server rowset [SQLSTATE 01000] (Message 0) 13:30:03: 202832 rows copied. [SQLSTATE 01000] (Message 0) 13:30:03: Drop Account if it exists. [SQLSTATE 01000] (Message 0) 13:30:03: Rename previous table from Account_Previous to Account [SQLSTATE 01000] (Message 0) Caution: Changing any part of an object name could break scripts and stored procedures. [SQLSTATE 01000] (Message 15477) 13:30:03: Create primary key on Account [SQLSTATE 01000] (Message 0) --- Ending SF_Replicate. Operation successful. [SQLSTATE 01000] (Message 0) --- Starting SF_Replicate for Contact [SQLSTATE 01000] (Message 0) 13:30:04: Drop Contact_Previous if it exists. [SQLSTATE 01000] (Message 0) 13:30:04: Create Contact_Previous with new structure. [SQLSTATE 01000] (Message 0) 13:30:04: Run the DBAmp.exe program. [SQLSTATE 01000] (Message 0) 13:30:04: DBAmp Bulk Operations. V3.5.2 (c) Copyright 2006-2017 forceAmp.com LLC [SQLSTATE 01000] (Message 0) 13:30:04: Populating local table Contact_Previous , OFB-RUTH / salesforce_data . [SQLSTATE 01000] (Message 0) 13:30:05: DBAmp is using the SQL Native Client. [SQLSTATE 01000] (Message 0) 13:30:05: Opening SQL Server rowset [SQLSTATE 01000] (Message 0) 13:35:06: 182388 rows copied. [SQLSTATE 01000] (Message 0) 13:35:06: Drop Contact if it exists. [SQLSTATE 01000] (Message 0) 13:35:06: Rename previous table from Contact_Previous to Contact [SQLSTATE 01000] (Message 0) Caution: Changing any part of an object name could break scripts and stored procedures. [SQLSTATE 01000] (Message 15477) 13:35:06: Create primary key on Contact [SQLSTATE 01000] (Message 0) --- Ending SF_Replicate. Operation successful. [SQLSTATE 01000] (Message 0) --- Starting SF_Replicate for Opportunity [SQLSTATE 01000] (Message 0) 13:35:06: Drop Opportunity_Previous if it exists. [SQLSTATE 01000] (Message 0) 13:35:06: Create Opportunity_Previous with new structure. [SQLSTATE 01000] (Message 0) 13:35:07: Run the DBAmp.exe program. [SQLSTATE 01000] (Message 0) 13:35:07: DBAmp Bulk Operations. V3.5.2 (c) Copyright 2006-2017 forceAmp.com LLC [SQLSTATE 01000] (Message 0) 13:35:07: Populating local table Opportunity_Previous , OFB-RUTH / salesfor... The step failed.
1 person has
this question
+1
Reply