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

ReplicateALL scheduled job failing

We have a scheduled job to execute ReplicateALL every night at 1am. This failed last night with not much info as to why. We had issues with all scheduled jobs that we found yesterday (related to the security token of the Salesforce user), that was fixed and we were able to manually execute ReplicateALL yesterday. However the scheduled job failed last night. I tried to manually execute ReplicateALL today and that also failed. The final message in the output was:
--- Ending SF_ReplicateAll. Operation FAILED.

The only other errors I can find are:
09:42:07: Error occurred creating primary key for table.
09:42:07: Error: Could not create constraint or index. See previous errors.
--- Ending SF_Replicate. Operation FAILED.
Error: SF_Replicate failed for table AuraDefinitionBundleInfo
Error 50000, Severity 16, State 1, Line 340
--- Ending SF_Replicate. Operation FAILED.

09:42:09: Error occurred creating primary key for table.
09:42:09: Error: Could not create constraint or index. See previous errors.
--- Ending SF_Replicate. Operation FAILED.
Error: SF_Replicate failed for table AuraDefinitionInfo
Error 50000, Severity 16, State 1, Line 340
--- Ending SF_Replicate. Operation FAILED.

09:44:52: Error: RunQuery failed with com_error.
09:44:52: UNKNOWN_EXCEPTION: An unexpected error occurred. Please include this ErrorId if you contact support: 1612731005-68134 (-1284100941)
09:44:52: Error: DBAmp.exe was unsuccessful.
09:44:52: Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe Export "DatacloudAddress_Previous" "BI-SQL-TEST" "salesforce backups" "SALESFORCE"
--- Ending SF_Replicate. Operation FAILED.
Error: SF_Replicate failed for table DatacloudAddress
Error 50000, Severity 16, State 1, Line 332
--- Ending SF_Replicate. Operation FAILED.

Any help would be greatly appreciated!!!
1 person has
this question
+1
Reply
  • The tables listed below are the tables that failed and their error messages:

    Table Name: AuraDefinitionInfo, AuraDefinitionBundleInfo
    Error Message: Error: Could not create constraint or index
    Comments: This error occurs because the Primary Key column on this table can contain duplicates. Therefore, we cannot replicate this table. To skip the table locally follow the instructions below.

    Table Name: DatacloudAddress
    Error Message: UNKNOWN_EXCEPTION: An unexpected error occurred. Please include this ErrorId if you contact support: 1231054101-80323 (1005878622)
    Comments: This is a Salesforce bug, read the following support article for more information: https://success.salesforce.com/issues...
    We are recommending you skip DatacloudAddress from being replicated or refreshed. To skip the table locally follow the instructions below.

    ——

    To modify SFRefreshAll and SF_ReplicateAll, follow the steps below:

    1. Using SQL Server Management Studio, right click on the SF_ReplicateAll stored procedure and choose Modify

    In the SF_replicateAll stored procedure you will find a line that looks like this: if @tn = ‘Vote’ Continue

    Add the following lines at the same spot:
    If @tn = ‘AuraDefinitionInfo’ Continue
    If @tn = ’DatacloudAddress’ Continue
    If @tn = ‘AuraDefinitionBundleInfo’ Continue

    Execute the script to update the code of the stored procedure
    2. Repeat step 1 of the SF_RefreshAll stored procedure
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited kidding, amused, unsure, silly indifferent, undecided, unconcerned sad, anxious, confused, frustrated

  • This worked perfectly for the manual replicate! I'll have to wait until 1am tonight to see if the scheduled job works, but it is looking very promising.
    Thanks so much!!!
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited kidding, amused, unsure, silly indifferent, undecided, unconcerned sad, anxious, confused, frustrated