We upgraded to DBAmp V22 version. Have upgraded the Stored Procedures.
Regular SOQL queries work from the SQL server, but when try using SF_REPLICATE or SF_REFRESH we get the following error.
--- Starting SF_Replicate for Account V8304
09:56:45: Parameters: SALESFORCE Account Version: V8304
09:56:45: DBAmpAZ 22.0.8304.0 Copyright c 2021 CData Software, Inc.
09:56:45: Using options specified in Options parameter: soap
09:56:45: Obtaining Connection Props
09:56:46: Error: Unable to retrieve settings from sys_connection_props.
09:56:46: System.Data.SqlClient.SqlException (0x80131904): Cannot get the column information from 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, Boolean shouldCacheForAlwaysEncrypted)
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 afo220l.h.O(SqlConnection , Ue , Y )
ClientConnectionId:709c1c43-e7a7-4353-add7-6d05384896bd
Error Number:7350,State:2,Class:16
09:56:46: DBAmpAZ Operation FAILED.
09:56:47: Error: Replicate program was unsuccessful.
09:56:47: Error: Command string is C:\"Program Files"\CData\"CData DBAmp"\bin\DBAmpAZ.exe FullCopy "Account" "wn000054353" "OL_CHub" "SALESFORCE" "soap"
--- Ending SF_Replicate. Operation FAILED.
Msg 50000, Level 16, State 1, Procedure sf_replicate, Line 202 oBatch Start Line 1]
--- Ending SF_Replicate. Operation FAILED.
Can’t understand how to solve for this.
