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

Unable to retrieve session properties

Error: Unable to retrieve session properties. [SQLSTATE 01000]

I have just recently started using SF_Replicate.

I am using this call.
EXEC [dbo].[SF_Replicate] 'SalesForce_Prod' , 'Case' , 'pkchunk'

I call it hourly but it fails about 1/2 of the time with an error.

Below is the content of the logging of the job step.

Job 'SFDCProd_Replicate' : Step 55, 'Case' : Began Executing 2017-07-13 06:25:24

Msg 50000, Sev 16, State 1, Line 361 : --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 42000]
Msg 0, Sev 16, State 1, Line 19 : --- Starting SF_Replicate for Case V3.4.7 [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 25 : 06:25:24: Parameters: SalesForce_Prod Case pkchunk Version: V3.4.7 [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 79 : 06:25:24: Drop Case_Previous if it exists. [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 88 : 06:25:24: Create Case_Previous with new structure. [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : 06:25:24: DBAmpNet2 3.4.7.0 (c) Copyright 2015-2017 forceAmp.com LLC [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : 06:25:24: Parameters: export Case_Previous RWSSSIS SFDCProd SalesForce_Prod pkchunk [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : 06:25:26: Job 7502A00000AjCpfQAF created on salesforce. [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : 06:25:26: Using the bulkapi with polling every 60 seconds [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : 06:25:26: Job still running. [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : 06:25:42: Job still running. [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : 06:26:42: Job still running. [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : 06:27:43: Job Complete. [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : 06:27:51: File downloaded successfully: D:\DBAmpWork\7502A00000AjCpfQAF-7512A00000D2G1MQAV-7522A000003ifUW.csv [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : 06:27:51: File downloaded successfully: D:\DBAmpWork\7502A00000AjCpfQAF-7512A00000D2G8bQAF-7522A000003ifUl.csv [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : 06:27:51: File downloaded successfully: D:\DBAmpWork\7502A00000AjCpfQAF-7512A00000D2G8WQAV-7522A000003ifUg.csv [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : 06:27:51: File downloaded successfully: D:\DBAmpWork\7502A00000AjCpfQAF-7512A00000D2G8XQAV-7522A000003ifUb.csv [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : 06:27:51: Files downloaded complete. [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : 06:32:56: Error: Unable to retrieve session properties. [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : 06:32:56: System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : out [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : at System.Data.SqlClient.SqlDataReader.get_MetaData() [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : at System.Data.SqlClient.SqlCommand.ExecuteReader() [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : at DBAmpNet2.TableLoader.RetrieveSessionProperties() [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : ClientConnectionId:692a2327-cc37-4d8a-843b-eb489df140ed [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : Error Number:-2,State:0,Class:11 [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 190 : 06:32:56: DBAmpNet2 Operation FAILED. [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 205 : 06:32:56: Error: Replicate program was unsuccessful. [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 208 : 06:32:56: Error: Command string is C:\"Program Files"\DBAmp\DBAmpNet2.exe Export:pkchunk "Case_Previous" "RWSSSIS" "SFDCProd" "SalesForce_Prod" [SQLSTATE 01000]
Msg 0, Sev 16, State 1, Line 358 : --- Ending SF_Replicate. Operation FAILED. [SQLSTATE 01000]
1 person has
this problem
+1
Reply