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

Error on Replicate all

Hi Team,

I am getting below error when try to run replicate all command.
Command : [dbo].[SF_ReplicateAll] 'SALESFORCE_DEV'

Error: SF_Replicate failed for table AcceptedEventRelation
Error 3701, Severity 11, State 5, Line 1
Cannot drop the table 'AcceptedEventRelation_Previous', because it does not exist or you do not have permission.

Please help on this.

Thanks.
1 person has
this question
+1
Reply
  • The DBAmp stored procedures assume that a schema of dbo is the default schema of the user running the proc.

    Questions:

    1. In your local database, do you have local tables with a schema other than dbo ? If so, you should delete all non-dbo schema tables for proper operation of the stored procedures ?
    2. Is the default schema of the user executing the command dbo ?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • I deleted the non dbo schemas. But I didn't understand the second point. Could you please elaborate?

    Thanks.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • All users connected to a SQL Server have a default schema.

    The only people running DBAmp stored procedures should be users where the default schema is dbo (for example, sql users who are the dbowner of the database)

    The fact that you had non-dbo schema tables indicates that you need to tighten who can run the procs.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • Hi Team,

    I am getting below error, when I try to run the refresh :
    EXEC SF_RefreshAll 'SALESFORCE_DEV', 'Yes'

    Executed as user: PRUDENTIAL\PIM-D-PCGSQL. ... Warning: Replicating tables that are non-refreshable or that have schema changes. [SQLSTATE 01000] (Message 0) --- Starting SF_Refresh for AcceptedEventRelation V3.1.7 [SQLSTATE 01000] (Message 0) 10:32:04: Using Schema Error Action of yes [SQLSTATE 01000] (Message 0) 10:32:05: Using last run time of 2018-07-20 14:31:00 [SQLSTATE 01000] (Message 0) 10:32:05: Identified 0 updated/inserted rows. [SQLSTATE 01000] (Message 0) 10:32:05: Using alternate method to determine deleted records. [SQLSTATE 01000] (Message 0) 10:32:05: Identified 0 deleted rows. [SQLSTATE 01000] (Message 0) --- Ending SF_Refresh. Operation successful. [SQLSTATE 01000] (Message 0) --- Starting SF_Refresh for Account V3.1.7 [SQLSTATE 01000] (Message 0) 10:32:05: Using Schema Error Action of yes [SQLSTATE 01000] (Message 0) 10:32:06: Using last run time of 2018-07-20 14:31:00 [SQLSTATE 01000] (Message 0) 10:32:06: Identified 0 updated/inserted rows. [SQLSTATE 01000] (Message 0) 10:32:06: Identified 0 deleted rows. [SQLSTATE 01000] (Message 0) --- Ending SF_Refresh. Operation successful. [SQLSTATE 01000] (Message 0) --- Starting SF_Refresh for AccountCleanInfo V3.1.7 [SQLSTATE 01000] (Message 0) 10:32:06: Using Schema Error Action of yes [SQLSTATE 01000] (Message 0) 10:32:06: Using last run time of 2018-07-20 14:32:00 [SQLSTATE 01000] (Message 0) 10:32:07: Identified 0 updated/inserted rows. [SQLSTATE 01000] (Message 0) 10:32:07: Identified 0 deleted rows. [SQLSTATE 01000] (Message 0) --- Ending SF_Refresh. Operation successful. [SQLSTATE 01000] (Message 0) --- Starting SF_Refresh for AccountContactRelation V3.1.7 [SQLSTATE 01000] (Message 0) 10:32:07: Using Schema Error Action of yes [SQLSTATE 01000] (Message 0) 10:32:07: Using last run time of 2018-07-20 14:32:00 [SQLSTATE 01000] (Message 0) 10:32:07: Identified 0 updated/inserted rows. [SQLSTATE 01000] (Message 0) 10:32:07: Identified 0 deleted rows. [SQLSTATE 01000] (Message 0) --- Ending SF_Refresh. Operation successful. [SQLSTATE 01000] (Message 0) --- Starting SF_Refresh for AccountContactRelation_History__Tag V3.1.7 [SQLSTATE 01000] (Message 0) 10:32:07: Using Schema Error Action of yes [SQLSTATE 01000] (Message 0) 10:32:08: Using last run time of 2018-07-20 14:32:00 [SQLSTATE 01000] (Message 0) 10:32:10: Identified 0 updated/inserted rows. [SQLSTATE 01000] (Message 0) 10:32:10: Using alternate method to determine deleted records. [SQLSTATE 01000] (Message 0) 10:32:10: Identified 0 deleted rows. [SQLSTATE 01000] (Message 0) --- Ending SF_Refresh. Operation successful. [SQLSTATE 01000] (Message 0) --- Starting SF_Refresh for AccountContactRelation_History__c V3.1.7 [SQLSTATE 01000] (Message 0) 10:32:10: Using Schema Error Action of yes [SQLSTATE 01000] (Message 0) 10:32:10: Using last run time of 2018-07-20 14:32:00 [SQLSTATE 01000] (Message 0) 10:32:10: Identified 0 updated/inserted rows. [SQLSTATE 01000] (Message 0) 10:32:10: Identified 0 deleted rows. [SQLSTATE 01000] (Message 0) --- Ending SF_Refresh. Operation successful. [SQLSTATE 01000] (Message 0) --- Starting SF_Refresh for AccountContactRole V3.1.7 [SQLSTATE 01000] (Message 0) 10:32:10: Using Schema Error Action of yes [SQLSTATE 01000] (Message 0) 10:32:10: Using last run time of 2018-07-20 14:32:00 [SQLSTATE 01000] (Message 0) 10:32:10: Identified 0 updated/inserted rows. [SQLSTATE 01000] (Message 0) 10:32:11: Identified 0 deleted rows. [SQLSTATE 01000] (Message 0) --- Ending SF_Refresh. Operation successful. [SQLSTATE 01000] (Message 0) --- Starting SF_Refresh for AccountHistory V3.1.7 [SQLSTATE 01000] (Message 0) 10:32:11: Using Schema Error Action of yes [SQLSTATE 01000] (Message 0) 10:32:11: Using last run time of 2018-07-20 14:32:00 [SQLSTATE 01000] (Message 0) 10:32:11: Identified 0 updated/inserted rows. [SQLSTATE 01000] (Message 0) 10:32:11: Identified 0 deleted rows. [SQLSTATE 01000] (Message 0) --- Ending SF_Refresh... The step failed.

    Could you please help on this ?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • The job output is truncated. In order to diagnose the issues, we need to see the complete message output from the job.

    We recommend that you capture DBAmp output to a table. You can do this on the Advanced tab of the job step by clicking "Log to Table". Then re-run the job and send the complete message output to support at forceamp.com. Do not post it here.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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