Hi I have a strange issue here. When I run the SF_ReplicateAll procedure it replicates all tables except the Account. I tried it multiple times but nothing worked. Below is a section of log which shows me failure to replicate Account table. Any help is appreciated
DBAmpNet2 3.4.9.0 (c) Copyright 2015-2017 forceAmp.com LLC [SQLSTATE 01000] (Message 0) 12:00:11: Parameters: exportsoap Account_Previous PAERSCBD0506\PGIMRE_T2 PGIMRE_IGOVERN Salesforce [SQLSTATE 01000] (Message 0) 12:00:18: 2756 rows copied. [SQLSTATE 01000] (Message 0) 12:00:18: DBAmpNet2 Operation successful. [SQLSTATE 01000] (Message 0) 12:00:20: Drop Account if it exists. [SQLSTATE 01000] (Message 0) 12:00:20: Error occurred dropping and renaming the table. [SQLSTATE 01000] (Message 0) 12:00:20: Error: Cannot drop the table 'Account', because it does not exist or you do not have permission. [SQLSTATE 01000] (Message 0) --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000] (Message 0) Error: SF_Replicate failed for table Account [SQLSTATE 01000] (Message 0) Error 50000, Severity 16, State 1, Line 370 [SQLSTATE 01000] (Message 0) --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000] (Message 0)
Help get this topic noticed by sharing it on
Twitter,
Facebook, or email.


-
Couple of questions:
1. Are you running this command in the salesforce backups database?
2. Are you a DBO of that database so that all tables you create have a schema of dbo?
3. Have you ran this command before and it is now just not working? -
-
1. This is running in a SQL Server job. It's executing SF_ReplicateAll procedure
2. Job runs as SA so has dbo access on the database
3. In Past we have run it successfully in other databases. But this issue is happening with a new database we created recently
All other tables get replicated without any issues, so I don't think it has anything to do with the access -
-
Is there an Account or Account_Previous table in the database where these tables are being replicated to? Are they under DBO schema or under another schema?
-