# DBamp Stored procedures failing after upgrade to V2022: Unable to retrieve settings from sys\_connection\_props. **URL:** \ **Category:** CData DBAmp\ **Tags:** sql, question, salesforce, dbamp\ **Created:** [July 20, 2023, 2:58pm UTC](https://community.cdata.com/t/dbamp-stored-procedures-failing-after-upgrade-to-v2022-unable-to-retrieve-settings-from-sys-connection-props/274 "2023-07-20T14:58:15Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![shrey](https://avatars.discourse-cdn.com/v4/letter/s/b5a626/32.png) [@shrey](https://community.cdata.com/u/shrey)\ **Post date:** [July 20, 2023, 2:58pm UTC](https://community.cdata.com/t/dbamp-stored-procedures-failing-after-upgrade-to-v2022-unable-to-retrieve-settings-from-sys-connection-props/274/1 "2023-07-20T14:58:15Z")
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 [Batch Start Line 1] --- Ending SF\_Replicate. Operation FAILED. Can’t understand how to solve for this. ---
**Author:** ![Dani\_Moran](https://avatars.discourse-cdn.com/v4/letter/d/2acd7d/32.png) [@Dani\_Moran](https://community.cdata.com/u/Dani_Moran)\ **Post date:** [July 20, 2023, 3:46pm UTC](https://community.cdata.com/t/dbamp-stored-procedures-failing-after-upgrade-to-v2022-unable-to-retrieve-settings-from-sys-connection-props/274/2 "2023-07-20T15:46:59Z")
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: [https://cdn.cdata.com/help/AFH/dbampd/Installation\_Upgrading.html#creating-the-dbamp-linked-server](https://cdn.cdata.com/help/AFH/dbampd/Installation%5C_Upgrading.html#creating-the-dbamp-linked-server)