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

SF_ReplicateAll Table Errors

Hi, we are in the process of setting up a salesforce data recovery instance in our systems that will be refreshed daily in the event salesforce has a catastrophic failure and a bunch of the salesforce tables are failing. We are on DBAmp version 3.5.1.0 and are using SF_ReplicateAll. Please let me know what our options are. I would like to not have to upgrade DBAmp if possible. Can we use TableToSkip for these as one option? Let me now if you want me to post all the errors.

Tables failed: ApexPageInfo, AuraDefinitionBundleInfo, AuraDefinitionInfo, ContentFolderItem, ContentFolderMember, DataStatistics, DataType, DatacloudAddress, EntityDefinition, EntityParticle, FieldDefinition, FlexQueueItem, ListViewChartInstance, OutgoingEmail, OutgoingEmailRelation, OwnerChangeOptionInfo, PicklistValueInfo, PlatformAction, Publisher, RelationshipDomain, RelationshipInfo, SearchLayout, SiteDetail, UserEntityAccess, UserFieldAccess.

Thanks.
1 person has
this question
+1
Reply
  • I would need to see the complete message output from the SF_ReplicateAll in order to comment on the errors. But, by looking at the list of tables that are failing, upgrading would take care of most, if not all of the issues and errors you are seeing. Upgrading takes around 10 minutes or so to complete.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • Thanks Justin. Errors are below:

    14:39:47: Create primary key on ApexPageInfo [SQLSTATE 01000]
    14:39:47: Error occurred creating primary key for table. [SQLSTATE 01000]
    14:39:47: Error: Could not create constraint or index. See previous errors. [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]
    Error: SF_Replicate failed for table ApexPageInfo [SQLSTATE 01000]
    Error 50000, Severity 16, State 1, Line 252 [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]

    14:45:46: Create primary key on AuraDefinitionBundleInfo [SQLSTATE 01000]
    14:45:46: Error occurred creating primary key for table. [SQLSTATE 01000]
    14:45:46: Error: Could not create constraint or index. See previous errors. [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]
    Error: SF_Replicate failed for table AuraDefinitionBundleInfo [SQLSTATE 01000]
    Error 50000, Severity 16, State 1, Line 252 [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]

    14:45:47: Create primary key on AuraDefinitionInfo [SQLSTATE 01000]
    14:45:47: Error occurred creating primary key for table. [SQLSTATE 01000]
    14:45:47: Error: Could not create constraint or index. See previous errors. [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]
    Error: SF_Replicate failed for table AuraDefinitionInfo [SQLSTATE 01000]
    Error 50000, Severity 16, State 1, Line 252 [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]

    14:47:05: Error: RunQuery failed with com_error. [SQLSTATE 01000]
    14:47:05: MALFORMED_QUERY: Implementation restriction: ContentFolderItem requires a filter by Id or ParentContentFolderId using the equals or 'IN' operator [SQLSTATE 01000]
    14:47:05: Error: DBAmp.exe was unsuccessful. [SQLSTATE 01000]
    14:47:05: Error: Command string is D:\DBAmp\DBAmp.exe Export "ContentFolderItem_Previous" "PAERSCBD3003\SALESFORCE_U1" "SF_GIRG_BKUP" "SF_GIRG_UAT" [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]
    Error: SF_Replicate failed for table ContentFolderItem [SQLSTATE 01000]
    Error 50000, Severity 16, State 1, Line 244 [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]

    14:47:06: Error: RunQuery failed with com_error. [SQLSTATE 01000]
    14:47:06: MALFORMED_QUERY: Implementation restriction: ContentFolderMember requires a filter by a single Id, ChildRecordId or ParentContentFolderId using the equals operator [SQLSTATE 01000]
    14:47:06: Error: DBAmp.exe was unsuccessful. [SQLSTATE 01000]
    14:47:06: Error: Command string is D:\DBAmp\DBAmp.exe Export "ContentFolderMember_Previous" "PAERSCBD3003\SALESFORCE_U1" "SF_GIRG_BKUP" "SF_GIRG_UAT" [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]
    Error: SF_Replicate failed for table ContentFolderMember [SQLSTATE 01000]
    Error 50000, Severity 16, State 1, Line 244 [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]

    14:47:34: Error: RunQuery failed with com_error. [SQLSTATE 01000]
    14:47:34: EXTERNAL_OBJECT_UNSUPPORTED_EXCEPTION: Where clauses should contain StatType [SQLSTATE 01000]
    14:47:34: Error: DBAmp.exe was unsuccessful. [SQLSTATE 01000]
    14:47:34: Error: Command string is D:\DBAmp\DBAmp.exe Export "DataStatistics_Previous" "PAERSCBD3003\SALESFORCE_U1" "SF_GIRG_BKUP" "SF_GIRG_UAT" [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]
    Error: SF_Replicate failed for table DataStatistics [SQLSTATE 01000]
    Error 50000, Severity 16, State 1, Line 244 [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]

    14:47:35: Error occurred creating primary key for table. [SQLSTATE 01000]
    14:47:35: Error: Could not create constraint or index. See previous errors. [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]
    Error: SF_Replicate failed for table DataType [SQLSTATE 01000]
    Error 50000, Severity 16, State 1, Line 252 [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]

    14:47:36: Error: RunQuery failed with com_error. [SQLSTATE 01000]
    14:47:36: EXTERNAL_OBJECT_EXCEPTION: SObject - DATACLOUD_ADDRESS : Transient queries are not implemented [SQLSTATE 01000]
    14:47:36: Error: DBAmp.exe was unsuccessful. [SQLSTATE 01000]
    14:47:36: Error: Command string is D:\DBAmp\DBAmp.exe Export "DatacloudAddress_Previous" "PAERSCBD3003\SALESFORCE_U1" "SF_GIRG_BKUP" "SF_GIRG_UAT" [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]
    Error: SF_Replicate failed for table DatacloudAddress [SQLSTATE 01000]
    Error 50000, Severity 16, State 1, Line 244 [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]

    14:48:19: Create primary key on EntityDefinition [SQLSTATE 01000]
    14:48:19: Error occurred creating primary key for table. [SQLSTATE 01000]
    14:48:19: Error: Could not create constraint or index. See previous errors. [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]
    Error: SF_Replicate failed for table EntityDefinition [SQLSTATE 01000]
    Error 50000, Severity 16, State 1, Line 252 [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]

    14:48:20: Error: RunQuery failed with com_error. [SQLSTATE 01000]
    14:48:20: MALFORMED_QUERY: EntityParticle: a filter on a reified column is required [EntityDefinitionId,FieldDefinitionId,DurableId] [SQLSTATE 01000]
    14:48:20: Error: DBAmp.exe was unsuccessful. [SQLSTATE 01000]
    14:48:20: Error: Command string is D:\DBAmp\DBAmp.exe Export "EntityParticle_Previous" "PAERSCBD3003\SALESFORCE_U1" "SF_GIRG_BKUP" "SF_GIRG_UAT" [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]
    Error: SF_Replicate failed for table EntityParticle [SQLSTATE 01000]
    Error 50000, Severity 16, State 1, Line 244 [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]

    14:48:50: Error: RunQuery failed with com_error. [SQLSTATE 01000]
    14:48:50: MALFORMED_QUERY: FieldDefinition: a filter on a reified column is required [EntityDefinitionId,DurableId] [SQLSTATE 01000]
    14:48:50: Error: DBAmp.exe was unsuccessful. [SQLSTATE 01000]
    14:48:50: Error: Command string is D:\DBAmp\DBAmp.exe Export "FieldDefinition_Previous" "PAERSCBD3003\SALESFORCE_U1" "SF_GIRG_BKUP" "SF_GIRG_UAT" [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]
    Error: SF_Replicate failed for table FieldDefinition [SQLSTATE 01000]
    Error 50000, Severity 16, State 1, Line 244 [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]

    14:49:08: Error: RunQuery failed with com_error. [SQLSTATE 01000]
    14:49:08: EXTERNAL_OBJECT_UNSUPPORTED_EXCEPTION: The WHERE clause must contain a JobType field expression. [SQLSTATE 01000]
    14:49:08: Error: DBAmp.exe was unsuccessful. [SQLSTATE 01000]
    14:49:08: Error: Command string is D:\DBAmp\DBAmp.exe Export "FlexQueueItem_Previous" "PAERSCBD3003\SALESFORCE_U1" "SF_GIRG_BKUP" "SF_GIRG_UAT" [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]
    Error: SF_Replicate failed for table FlexQueueItem [SQLSTATE 01000]
    Error 50000, Severity 16, State 1, Line 244 [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]

    14:49:49: Error: RunQuery failed with com_error. [SQLSTATE 01000]
    14:49:49: EXTERNAL_OBJECT_UNSUPPORTED_EXCEPTION: Getting all ListViewChartInstances is unsupported [SQLSTATE 01000]
    14:49:49: Error: DBAmp.exe was unsuccessful. [SQLSTATE 01000]
    14:49:49: Error: Command string is D:\DBAmp\DBAmp.exe Export "ListViewChartInstance_Previous" "PAERSCBD3003\SALESFORCE_U1" "SF_GIRG_BKUP" "SF_GIRG_UAT" [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]
    Error: SF_Replicate failed for table ListViewChartInstance [SQLSTATE 01000]
    Error 50000, Severity 16, State 1, Line 244 [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]

    14:50:28: Error: RunQuery failed with com_error. [SQLSTATE 01000]
    14:50:28: EXTERNAL_OBJECT_UNSUPPORTED_EXCEPTION: This query is not supported on the OutgoingEmail object. [SQLSTATE 01000]
    14:50:28: Error: DBAmp.exe was unsuccessful. [SQLSTATE 01000]
    14:50:28: Error: Command string is D:\DBAmp\DBAmp.exe Export "OutgoingEmail_Previous" "PAERSCBD3003\SALESFORCE_U1" "SF_GIRG_BKUP" "SF_GIRG_UAT" [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]
    Error: SF_Replicate failed for table OutgoingEmail [SQLSTATE 01000]
    Error 50000, Severity 16, State 1, Line 244 [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]

    14:50:29: Error: RunQuery failed with com_error. [SQLSTATE 01000]
    14:50:29: EXTERNAL_OBJECT_UNSUPPORTED_EXCEPTION: This query is not supported on the OutgoingEmail object. [SQLSTATE 01000]
    14:50:29: Error: DBAmp.exe was unsuccessful. [SQLSTATE 01000]
    14:50:29: Error: Command string is D:\DBAmp\DBAmp.exe Export "OutgoingEmailRelation_Previous" "PAERSCBD3003\SALESFORCE_U1" "SF_GIRG_BKUP" "SF_GIRG_UAT" [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]
    Error: SF_Replicate failed for table OutgoingEmailRelation [SQLSTATE 01000]
    Error 50000, Severity 16, State 1, Line 244 [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]

    14:50:30: Error: RunQuery failed with com_error. [SQLSTATE 01000]
    14:50:30: MALFORMED_QUERY: OwnerChangeOptionInfo: a filter on a reified column is required [EntityDefinitionId,DurableId] [SQLSTATE 01000]
    14:50:30: Error: DBAmp.exe was unsuccessful. [SQLSTATE 01000]
    14:50:30: Error: Command string is D:\DBAmp\DBAmp.exe Export "OwnerChangeOptionInfo_Previous" "PAERSCBD3003\SALESFORCE_U1" "SF_GIRG_BKUP" "SF_GIRG_UAT" [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]
    Error: SF_Replicate failed for table OwnerChangeOptionInfo [SQLSTATE 01000]
    Error 50000, Severity 16, State 1, Line 244 [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]

    14:50:46: Error: RunQuery failed with com_error. [SQLSTATE 01000]
    14:50:46: MALFORMED_QUERY: PicklistValueInfo: a filter on a reified column is required [EntityParticleId,DurableId] [SQLSTATE 01000]
    14:50:46: Error: DBAmp.exe was unsuccessful. [SQLSTATE 01000]
    14:50:46: Error: Command string is D:\DBAmp\DBAmp.exe Export "PicklistValueInfo_Previous" "PAERSCBD3003\SALESFORCE_U1" "SF_GIRG_BKUP" "SF_GIRG_UAT" [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]
    Error: SF_Replicate failed for table PicklistValueInfo [SQLSTATE 01000]
    Error 50000, Severity 16, State 1, Line 244 [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]

    14:50:47: Error: RunQuery failed with com_error. [SQLSTATE 01000]
    14:50:47: EXTERNAL_OBJECT_UNSUPPORTED_EXCEPTION: Getting all PlatformAction entities is unsupported [SQLSTATE 01000]
    14:50:47: Error: DBAmp.exe was unsuccessful. [SQLSTATE 01000]
    14:50:47: Error: Command string is D:\DBAmp\DBAmp.exe Export "PlatformAction_Previous" "PAERSCBD3003\SALESFORCE_U1" "SF_GIRG_BKUP" "SF_GIRG_UAT" [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]
    Error: SF_Replicate failed for table PlatformAction [SQLSTATE 01000]
    Error 50000, Severity 16, State 1, Line 244 [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]

    14:51:00: Error occurred creating primary key for table. [SQLSTATE 01000]
    14:51:00: Error: Could not create constraint or index. See previous errors. [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]
    Error: SF_Replicate failed for table Publisher [SQLSTATE 01000]
    Error 50000, Severity 16, State 1, Line 252 [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]

    14:51:10: Error: RunQuery failed with com_error. [SQLSTATE 01000]
    14:51:10: MALFORMED_QUERY: RelationshipDomain: a filter on a reified column is required [FieldId,RelationshipInfoId,ParentSobjectId,ChildSobjectId,DurableId] [SQLSTATE 01000]
    14:51:10: Error: DBAmp.exe was unsuccessful. [SQLSTATE 01000]
    14:51:10: Error: Command string is D:\DBAmp\DBAmp.exe Export "RelationshipDomain_Previous" "PAERSCBD3003\SALESFORCE_U1" "SF_GIRG_BKUP" "SF_GIRG_UAT" [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]
    Error: SF_Replicate failed for table RelationshipDomain [SQLSTATE 01000]
    Error 50000, Severity 16, State 1, Line 244 [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]

    14:51:11: Error: DBAmp.exe was unsuccessful. [SQLSTATE 01000]
    14:51:11: Error: Command string is D:\DBAmp\DBAmp.exe Export "RelationshipInfo_Previous" "PAERSCBD3003\SALESFORCE_U1" "SF_GIRG_BKUP" "SF_GIRG_UAT" [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]
    Error: SF_Replicate failed for table RelationshipInfo [SQLSTATE 01000]
    Error 50000, Severity 16, State 1, Line 244 [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]

    14:51:19: Error: RunQuery failed with com_error. [SQLSTATE 01000]
    14:51:19: MALFORMED_QUERY: SearchLayout: a filter on a reified column is required [EntityDefinitionId,DurableId] [SQLSTATE 01000]
    14:51:19: Error: DBAmp.exe was unsuccessful. [SQLSTATE 01000]
    14:51:19: Error: Command string is D:\DBAmp\DBAmp.exe Export "SearchLayout_Previous" "PAERSCBD3003\SALESFORCE_U1" "SF_GIRG_BKUP" "SF_GIRG_UAT" [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]
    Error: SF_Replicate failed for table SearchLayout [SQLSTATE 01000]
    Error 50000, Severity 16, State 1, Line 244 [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]

    14:51:30: Error: RunQuery failed with com_error. [SQLSTATE 01000]
    14:51:30: MALFORMED_QUERY: SiteDetail: a filter on a reified column is required [DurableId] [SQLSTATE 01000]
    14:51:30: Error: DBAmp.exe was unsuccessful. [SQLSTATE 01000]
    14:51:30: Error: Command string is D:\DBAmp\DBAmp.exe Export "SiteDetail_Previous" "PAERSCBD3003\SALESFORCE_U1" "SF_GIRG_BKUP" "SF_GIRG_UAT" [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]
    Error: SF_Replicate failed for table SiteDetail [SQLSTATE 01000]
    Error 50000, Severity 16, State 1, Line 244 [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]

    14:52:19: Error: RunQuery failed with com_error. [SQLSTATE 01000]
    14:52:19: MALFORMED_QUERY: UserEntityAccess: a filter on a reified column is required [UserId,DurableId] [SQLSTATE 01000]
    14:52:19: Error: DBAmp.exe was unsuccessful. [SQLSTATE 01000]
    14:52:19: Error: Command string is D:\DBAmp\DBAmp.exe Export "UserEntityAccess_Previous" "PAERSCBD3003\SALESFORCE_U1" "SF_GIRG_BKUP" "SF_GIRG_UAT" [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]
    Error: SF_Replicate failed for table UserEntityAccess [SQLSTATE 01000]
    Error 50000, Severity 16, State 1, Line 244 [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]

    14:52:20: Error: RunQuery failed with com_error. [SQLSTATE 01000]
    14:52:20: MALFORMED_QUERY: UserFieldAccess: a filter on a reified column is required [DurableId] [SQLSTATE 01000]
    14:52:20: Error: DBAmp.exe was unsuccessful. [SQLSTATE 01000]
    14:52:20: Error: Command string is D:\DBAmp\DBAmp.exe Export "UserFieldAccess_Previous" "PAERSCBD3003\SALESFORCE_U1" "SF_GIRG_BKUP" "SF_GIRG_UAT" [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]
    Error: SF_Replicate failed for table UserFieldAccess [SQLSTATE 01000]
    Error 50000, Severity 16, State 1, Line 244 [SQLSTATE 01000]
    --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • You can use TablesToSkip to skip all of those tables in the SF_ReplicateAll. Or, you can upgrade to the latest version of DBAmp and those errors would be taken care of with the upgrade. Additionally, you are on a version that is about 2 years old and we recommend you upgrade DBAmp at least once a year.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • Good to know, we will plan to upgrade. Thanks for the help Justin!
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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