DBamp Stored procedures failing after upgrade to V2022: Unable to retrieve settings from sys_connection_props.

  • 20 July 2023
  • 1 reply

Userlevel 1

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
   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 )
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 [Batch Start Line 1]
--- Ending SF_Replicate. Operation FAILED.

Can’t understand how to solve for this.


Best answer by Dani Moran 20 July 2023, 17:46

View original

1 reply

Userlevel 4

That error indicates that you did not create a linked server for v22. The linked server setup for the new version is very different from what it was before - for one thing, it uses a different provider, which is how I noticed the discrepancy. You will need to follow the directions here to get a new linked server setup that matches with the v22 stored procedures: