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

Replicate All Failing

Hi,
We have a long standing SQL job that "replicates all" overnight.

over the last three days it's failed with the below error message, (and fails even when run manually):

Any ideas where to look?

Date 11/02/2019 08:35:39
Log Job History (SalesForce - ReplicateAll)

Step ID 1
Server Fxxxxxx\LIVE
Job Name SalesForce - ReplicateAll
Step Name SF_ReplicateAll
Duration 00:52:13
Sql Severity 16
Sql Message ID 50000
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: CFH\xxxxxxxSQLAgent. ...e 0) --- Starting SF_Replicate for AG1__Call_Planner__Share V3.6.4 [SQLSTATE 01000] (Message 0) 08:36:06: Parameters: SALESFORCE_LIVE AG1__Call_Planner__Share Version: V3.6.4 [SQLSTATE 01000] (Message 0) 08:36:06: Drop AG1__Call_Planner__Share_Previous if it exists. [SQLSTATE 01000] (Message 0) 08:36:06: Create AG1__Call_Planner__Share_Previous with new structure. [SQLSTATE 01000] (Message 0) 08:36:08: DBAmpNet2 3.6.4.0 (c) Copyright 2015-2017 forceAmp.com LLC [SQLSTATE 01000] (Message 0) 08:36:08: Parameters: replicate AG1__Call_Planner__Share_Previous Fxxxxxx\LIVE Salesforce_Live SALESFORCE_LIVE [SQLSTATE 01000] (Message 0) 08:36:13: 332 rows copied. [SQLSTATE 01000] (Message 0) 08:36:13: DBAmpNet2 Operation successful. [SQLSTATE 01000] (Message 0) 08:36:14: Drop AG1__Call_Planner__Share if it exists. [SQLSTATE 01000] (Message 0) 08:36:14: Rename previous table from AG1__Call_Planner__Share_Previous to AG1__Call_Planner__Share [SQLSTATE 01000] (Message 0) Caution: Changing any part of an object name could break scripts and stored procedures. [SQLSTATE 01000] (Message 15477) 08:36:15: Create primary key on AG1__Call_Planner__Share [SQLSTATE 01000] (Message 0) --- Ending SF_Replicate. Operation successful. [SQLSTATE 01000] (Message 0) --- Starting SF_Replicate for AG1__Call_Planner__Tag V3.6.4 [SQLSTATE 01000] (Message 0) 08:36:15: Parameters: SALESFORCE_LIVE AG1__Call_Planner__Tag Version: V3.6.4 [SQLSTATE 01000] (Message 0) 08:36:15: Drop AG1__Call_Planner__Tag_Previous if it exists. [SQLSTATE 01000] (Message 0) 08:36:15: Create AG1__Call_Planner__Tag_Previous with new structure. [SQLSTATE 01000] (Message 0) 08:36:15: DBAmpNet2 3.6.4.0 (c) Copyright 2015-2017 forceAmp.com LLC [SQLSTATE 01000] (Message 0) 08:36:15: Parameters: replicate AG1__Call_Planner__Tag_Previous Fxxxxxx\LIVE Salesforce_Live SALESFORCE_LIVE [SQLSTATE 01000] (Message 0) 08:36:17: 0 rows copied. [SQLSTATE 01000] (Message 0) 08:36:17: DBAmpNet2 Operation successful. [SQLSTATE 01000] (Message 0) 08:36:18: Drop AG1__Call_Planner__Tag if it exists. [SQLSTATE 01000] (Message 0) 08:36:18: Rename previous table from AG1__Call_Planner__Tag_Previous to AG1__Call_Planner__Tag [SQLSTATE 01000] (Message 0) Caution: Changing any part of an object name could break scripts and stored procedures. [SQLSTATE 01000] (Message 15477) 08:36:18: Create primary key on AG1__Call_Planner__Tag [SQLSTATE 01000] (Message 0) --- Ending SF_Replicate. Operation successful. [SQLSTATE 01000] (Message 0) --- Starting SF_Replicate for AG1__Call_Planner__c V3.6.4 [SQLSTATE 01000] (Message 0) 08:36:18: Parameters: SALESFORCE_LIVE AG1__Call_Planner__c Version: V3.6.4 [SQLSTATE 01000] (Message 0) 08:36:18: Drop AG1__Call_Planner__c_Previous if it exists. [SQLSTATE 01000] (Message 0) 08:36:18: Create AG1__Call_Planner__c_Previous with new structure. [SQLSTATE 01000] (Message 0) 08:36:19: DBAmpNet2 3.6.4.0 (c) Copyright 2015-2017 forceAmp.com LLC [SQLSTATE 01000] (Message 0) 08:36:19: Parameters: replicate AG1__Call_Planner__c_Previous Fxxxxxx\LIVE Salesforce_Live SALESFORCE_LIVE [SQLSTATE 01000] (Message 0) 08:36:21: 178 rows copied. [SQLSTATE 01000] (Message 0) 08:36:21: DBAmpNet2 Operation successful. [SQLSTATE 01000] (Message 0) 08:36:22: Drop AG1__Call_Planner__c if it exists. [SQLSTATE 01000] (Message 0) 08:36:22: Rename previous table from AG1__Call_Planner__c_Previous to AG1__Call_Planner__c [SQLSTATE 01000] (Message 0) Caution: Changing any part of an object name could break scripts and stored procedures. [SQLSTATE 01000] (Message 15477) 08:36:22: Create primary key on AG1__Call_Planner__c [SQLSTATE 01000] (Message 0) --- Ending SF_Replicate. Operation successful. [SQLSTATE 01000] (Message 0) --- Starting SF_Replicate for APXTConga4__Conga_Composer_Settings__Tag V3.6.4 [SQLSTATE 01000] (Message 0) 08:36:23: Parameters: SALESFORCE_LIVE APXTConga4__Conga_Composer_Settings__Tag... The step failed.
2 people have
this question
+1
Reply