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

SF_Replicate Fails with error "Error: Unable to retrieve session properties."

Running SF_Replicate 'SALESFORCE','ACCOUNT' throws below error in SSMS. Please help

--- Starting SF_Replicate for ACCOUNT V3.4.9
10:40:59: Parameters: SALESFORCE ACCOUNT Version: V3.4.9
10:40:59: Drop ACCOUNT_Previous if it exists.
10:40:59: Create ACCOUNT_Previous with new structure.
10:41:03: DBAmpNet2 3.4.9.0 (c) Copyright 2015-2017 forceAmp.com LLC
10:41:03: Parameters: exportsoap ACCOUNT_Previous L7-D2P5H062 salesforcebackups SALESFORCE
10:41:04: Error: Unable to retrieve session properties.
10:41:04: System.Data.SqlClient.SqlException (0x80131904): Cannot initialize the data source object of OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE".
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.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParamet
erEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolea
n inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at DBAmpNet2.SFDataLayer3.RetrieveSessionProperties()
ClientConnectionId:639fc357-c8b1-4257-bc24-4d4306570161
Error Number:7303,State:1,Class:16
10:41:04: DBAmpNet2 Operation FAILED.
10:41:06: Error: Replicate program was unsuccessful.
10:41:06: Error: Command string is C:\"Program Files"\DBAmp\DBAmpNet2.exe Exportsoap "ACCOUNT_Previous" "L7-D2P5H062" "salesforcebackups" "SALESFORCE"
--- Ending SF_Replicate. Operation FAILED.
Msg 50000, Level 16, State 1, Procedure SF_Replicate, Line 364
--- Ending SF_Replicate. Operation FAILED.
3 people have
this problem
+1
Reply