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

error when replicating

Hi,

When running a replicate one of our users get's the below error, and it creates a temporary table called "DOMAIN\USER.Account_Previous"? - I'm guessing it's a permissions thing but don't know enough about it to fix the problem.

--- Starting SF_Replicate for Account V3.6.4
12:13:53: Parameters: salesforce_live Account Version: V3.6.4
12:13:53: Drop Account_Previous if it exists.
12:13:53: Create Account_Previous with new structure.
12:13:55: DBAmpNet2 3.6.4.0 (c) Copyright 2015-2017 forceAmp.com LLC
12:13:55: Parameters: replicate Account_Previous SQLSERVER\LIVE Salesforce_Live salesforce_live
12:14:00: Error: System.InvalidOperationException: Cannot access destination table 'Account_Previous'. ---> System.Data.SqlClient.SqlException: Invalid object name 'Account_Previous'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlBulkCopy.RunParser(BulkCopySimpleResultSet bulkCopyHandler)
at System.Data.SqlClient.SqlBulkCopy.CreateAndExecuteInitialQueryAsync(BulkCopySimpleResultSet& result)
at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestAsync(CancellationToken cts, TaskCompletionSource`1 source)
--- End of inner exception stack trace ---
at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestAsync(CancellationToken cts, TaskCompletionSource`1 source)
at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalAsync(CancellationToken ctoken)
at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServerAsync(Int32 columnCount, CancellationToken ctoken)
at System.Data.SqlClient.SqlBulkCopy.WriteToServer(IDataReader reader)
at DBAmpNet2.Processor.Run()
12:14:00: 0 rows copied.
12:14:00: DBAmpNet2 Operation FAILED.
12:14:02: Error: Replicate program was unsuccessful.
12:14:02: Error: Command string is C:\"Program Files"\DBAmp\DBAmpNet2.exe Exportsoap "Replicate" "Account_Previous" "SQLSERVER\LIVE" "Salesforce_Live" "salesforce_live"
--- Ending SF_Replicate. Operation FAILED.
Msg 50000, Level 16, State 1, Procedure SF_Replicate, Line 370 [Batch Start Line 2]
--- Ending SF_Replicate. Operation FAILED.

(1 row affected)

1 person has
this question
+1
Reply