# \#dbamp **URL:** https://community.cdata.com/tag/dbamp/48.md [Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md) --- ## [DBAmp RefreshAll Job Intermittent Failures After Hyperforce Migration](https://community.cdata.com/t/dbamp-refreshall-job-intermittent-failures-after-hyperforce-migration/1303)
**Author:** [@david.oraz](https://community.cdata.com/u/david.oraz)\ **Replies:** 0\ **Last updated:** [June 15, 2026, 10:19pm UTC](https://community.cdata.com/t/dbamp-refreshall-job-intermittent-failures-after-hyperforce-migration/1303 "2026-06-15T22:19:21Z")
We are experiencing intermittent failures with DBAmp RefreshAll jobs across random tables following our Hyperforce migration. We engaged DBAmp Support, and their analysis indicates that the HTTP callouts are occasionall… --- ## [DBAmp Massive API Calls after CPQ upgrade](https://community.cdata.com/t/dbamp-massive-api-calls-after-cpq-upgrade/1278)
**Author:** [@joshuawharp](https://community.cdata.com/u/joshuawharp)\ **Replies:** 0\ **Last updated:** [March 24, 2026, 1:28am UTC](https://community.cdata.com/t/dbamp-massive-api-calls-after-cpq-upgrade/1278 "2026-03-24T01:28:43Z")
After upgrading to the latest version of CPQ in salesforce the DBAMP software started sending tens of thousands of API calls to the platform. There are no sync jobs running, there are no daemon sessions in task manager. … --- ## [TSQL Order by with latest version of DbAmp](https://community.cdata.com/t/tsql-order-by-with-latest-version-of-dbamp/1234)
**Author:** [@MikeLawrenceNbf](https://community.cdata.com/u/MikeLawrenceNbf)\ **Replies:** 0\ **Last updated:** [November 7, 2025, 9:06pm UTC](https://community.cdata.com/t/tsql-order-by-with-latest-version-of-dbamp/1234 "2025-11-07T21:06:59Z")
Greetings, I sent a detailed example of this to support and I’ll put it here in case it’s something simple. I’m running into a lot of issue with dbamp and ordering by the account name. (both directly and also in t… --- ## [dbamp linked service failure pulling data from salesforce to sql](https://community.cdata.com/t/dbamp-linked-service-failure-pulling-data-from-salesforce-to-sql/1216)
**Author:** [@johnmiller](https://community.cdata.com/u/johnmiller)\ **Replies:** 2\ **Last updated:** [October 24, 2025, 7:47pm UTC](https://community.cdata.com/t/dbamp-linked-service-failure-pulling-data-from-salesforce-to-sql/1216 "2025-10-24T19:47:36Z")
version: 4.1.6.0 Description: All of my sql jobs pulling variations of sf\_refresh are failing as of 10/11/2025. Currently not bring any data down in our production environment ERROR: 10/11/2025 5:02:02 AM Log … --- ## [couple issue. just upgraded to latest version dbamp. Getting unspecified error when trying to bring dow 6k records from application object in salesforce using the linked server directly.](https://community.cdata.com/t/couple-issue-just-upgraded-to-latest-version-dbamp-getting-unspecified-error-when-trying-to-bring-dow-6k-records-from-application-object-in-salesforce-using-the-linked-server-directly/1223)
**Author:** [@johnmiller](https://community.cdata.com/u/johnmiller)\ **Replies:** 1\ **Last updated:** [October 24, 2025, 7:44pm UTC](https://community.cdata.com/t/couple-issue-just-upgraded-to-latest-version-dbamp-getting-unspecified-error-when-trying-to-bring-dow-6k-records-from-application-object-in-salesforce-using-the-linked-server-directly/1223 "2025-10-24T19:44:31Z")
i get error when trying to pull down application data that changed in last 4 days. I’m querying the linked server directly like this . it seems like i’m hitting some threshold and when it’s over a certain amount it gives… --- ## [cData DBAmp product support](https://community.cdata.com/t/cdata-dbamp-product-support/1215)
**Author:** [@PaulTinNZ](https://community.cdata.com/u/PaulTinNZ)\ **Replies:** 1\ **Last updated:** [October 24, 2025, 7:42pm UTC](https://community.cdata.com/t/cdata-dbamp-product-support/1215 "2025-10-24T19:42:22Z")
--- ## [🚨IF YOU USE API Access Control: Salesforce change may stop DBAmp on Nov 4, 2025 🚨](https://community.cdata.com/t/if-you-use-api-access-control-salesforce-change-may-stop-dbamp-on-nov-4-2025/1224)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [October 21, 2025, 1:26pm UTC](https://community.cdata.com/t/if-you-use-api-access-control-salesforce-change-may-stop-dbamp-on-nov-4-2025/1224 "2025-10-21T13:26:33Z")
TL&DR Salesforce announced on Wednesday, Oct 15, 2025 that it’s deprecating the “Use Any API Client” permission within API Access Control. If your Salesforce org has API Access Control enabled, only allow-listed Connecte… --- ## [DBAmp linked server Error 5103 after Salesforce Winter 2026 release applied to our test org](https://community.cdata.com/t/dbamp-linked-server-error-5103-after-salesforce-winter-2026-release-applied-to-our-test-org/1184)
**Author:** [@nrapoza](https://community.cdata.com/u/nrapoza)\ **Replies:** 16\ **Last updated:** [October 7, 2025, 4:00pm UTC](https://community.cdata.com/t/dbamp-linked-server-error-5103-after-salesforce-winter-2026-release-applied-to-our-test-org/1184 "2025-10-07T16:00:57Z")
We are on DBAmp version 4.1.8. We have a SQL Server Agent job running daily on our test org. After Salesforce Winter ‘26 was applied to the org, we started getting the following failure message. How can we resolve th… --- ## [Using CMDEXEC with SF\_Mirror when xp\_cmdshell is restricted](https://community.cdata.com/t/using-cmdexec-with-sf-mirror-when-xp-cmdshell-is-restricted/1205)
**Author:** [@nrapoza](https://community.cdata.com/u/nrapoza)\ **Replies:** 1\ **Last updated:** [September 26, 2025, 4:42pm UTC](https://community.cdata.com/t/using-cmdexec-with-sf-mirror-when-xp-cmdshell-is-restricted/1205 "2025-09-26T16:42:42Z")
We are upgrading from DBAMP v.4.1.8 to v.22. Because we are restricted from using xp\_cmdshell, most of our SQL Server Agent jobs run sf\_replicate. If I’m understanding the documentation correctly, we won’t be able to c… --- ## [Help with sf\_refresh MSOLEDB error on latest version of DBamp](https://community.cdata.com/t/help-with-sf-refresh-msoledb-error-on-latest-version-of-dbamp/1136)
**Author:** [@mrvince](https://community.cdata.com/u/mrvince)\ **Replies:** 0\ **Last updated:** [July 23, 2025, 6:33pm UTC](https://community.cdata.com/t/help-with-sf-refresh-msoledb-error-on-latest-version-of-dbamp/1136 "2025-07-23T18:33:49Z")
We’ve recently upgraded to the latest version of dbamp. Since doing so we are constantly seeing the following error on one of sf objects when we bring it down to SQL via the “exec sf\_refresh” command. Executing the quer… --- ## [Question on running DBAmp remotely](https://community.cdata.com/t/question-on-running-dbamp-remotely/1097)
**Author:** [@arijit1001](https://community.cdata.com/u/arijit1001)\ **Replies:** 1\ **Last updated:** [June 13, 2025, 1:18pm UTC](https://community.cdata.com/t/question-on-running-dbamp-remotely/1097 "2025-06-13T13:18:03Z")
Hi Everyone, I have a scenario to use Azure Managed SQL Instances and these are not supported for DBAmp because they do not allow the installation of 3rd-party linked servers on the Instance. So I am trying to install d… --- ## [DBAmp upgrades and licensing questions](https://community.cdata.com/t/dbamp-upgrades-and-licensing-questions/980)
**Author:** [@nrapoza](https://community.cdata.com/u/nrapoza)\ **Replies:** 1\ **Last updated:** [January 2, 2025, 5:58pm UTC](https://community.cdata.com/t/dbamp-upgrades-and-licensing-questions/980 "2025-01-02T17:58:33Z")
I just noticed the EOL announcement for CData DBAmp versions prior to v22 on this page. My organization is still on version 4.1.8. I’m interpreting this announcement to mean that version 4.1.8 will continue to wor… --- ## [SOQL passed via DBAmp to Salesforce using openquery does not return all rows.](https://community.cdata.com/t/soql-passed-via-dbamp-to-salesforce-using-openquery-does-not-return-all-rows/981)
**Author:** [@HRMiller](https://community.cdata.com/u/HRMiller)\ **Replies:** 0\ **Last updated:** [December 28, 2024, 12:25am UTC](https://community.cdata.com/t/soql-passed-via-dbamp-to-salesforce-using-openquery-does-not-return-all-rows/981 "2024-12-28T00:25:27Z")
soql passed through dbamp to salesforce using openquery syntax selects from Contact and includes select from child table. See query below. For the ID specified in the query there are 13 records in the child table whi… --- ## [Getting Errors during replication](https://community.cdata.com/t/getting-errors-during-replication/732)
**Author:** [@Peter\_Boelke](https://community.cdata.com/u/Peter_Boelke)\ **Replies:** 4\ **Last updated:** [July 29, 2024, 5:48am UTC](https://community.cdata.com/t/getting-errors-during-replication/732 "2024-07-29T05:48:21Z")
Hi, since two weeks we are getting error when replicating all of our salesforce objects. The error does occur randomly not specific to an object. See error example message: --- Starting SF\_Replicate for ContentWorksp… --- ## [DBAmp upgrade with SSIS](https://community.cdata.com/t/dbamp-upgrade-with-ssis/811)
**Author:** [@jitendrapp](https://community.cdata.com/u/jitendrapp)\ **Replies:** 1\ **Last updated:** [July 26, 2024, 5:46pm UTC](https://community.cdata.com/t/dbamp-upgrade-with-ssis/811 "2024-07-26T17:46:18Z")
Hello, I will really appreciate your help with below question related to version upgrade. Our team is planning to upgrade DBAmp version from 4.1.8.to V2022.While going thorugh release notes ,came across with statement… --- ## [DBAmp upgrade to V2022 with SSIS](https://community.cdata.com/t/dbamp-upgrade-to-v2022-with-ssis/812)
**Author:** [@jitendrapp](https://community.cdata.com/u/jitendrapp)\ **Replies:** 1\ **Last updated:** [July 26, 2024, 5:41pm UTC](https://community.cdata.com/t/dbamp-upgrade-to-v2022-with-ssis/812 "2024-07-26T17:41:49Z")
Hello, I will really appreciate your help with below question related to version upgrade. Our team is planning to upgrade DBAmp version from 4.1.8.to V2022.While going thorugh release notes ,came across with statement… --- ## [DBAmp – “TCP Provider” Error](https://community.cdata.com/t/dbamp-tcp-provider-error/749)
**Author:** [@DylanO](https://community.cdata.com/u/DylanO)\ **Replies:** 0\ **Last updated:** [June 6, 2024, 7:22pm UTC](https://community.cdata.com/t/dbamp-tcp-provider-error/749 "2024-06-06T19:22:58Z")
When using DBAmp, you may run into one of the following errors: TCP Provider: No connection could be made because the target machine actively refused it. TCP Provider: No such host is known. TCP Provider: An existing c… --- ## [CData DBAmp Winter 2024 Release is here!](https://community.cdata.com/t/cdata-dbamp-winter-2024-release-is-here/594)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 1\ **Last updated:** [January 25, 2024, 10:21pm UTC](https://community.cdata.com/t/cdata-dbamp-winter-2024-release-is-here/594 "2024-01-25T22:21:35Z")
:rocket: Exciting News from the DBAmp Team! The CData DBAmp Winter 2024 Release is here, bringing groundbreaking enhancements to your experience! :magnifying\_glass\_tilted\_left: What’s New? Significantly improved OpenQ… --- ## [Data transport when using DBAmp remotely](https://community.cdata.com/t/data-transport-when-using-dbamp-remotely/554)
**Author:** [@NeilH](https://community.cdata.com/u/NeilH)\ **Replies:** 1\ **Last updated:** [December 14, 2023, 5:14pm UTC](https://community.cdata.com/t/data-transport-when-using-dbamp-remotely/554 "2023-12-14T17:14:34Z")
If we configure DBAmp to use a remote server (e.g. Azure managed SQL), does all data flow through the server where DBAmp is installed? And if so, what is the transport-layer security between the DBAmp-server and the rem… --- ## [DBAmp Error – “QUERY\_TIMEOUT: Your query request was running for too long.”](https://community.cdata.com/t/dbamp-error-query-timeout-your-query-request-was-running-for-too-long/559)
**Author:** [@DylanO](https://community.cdata.com/u/DylanO)\ **Replies:** 0\ **Last updated:** [December 11, 2023, 10:41pm UTC](https://community.cdata.com/t/dbamp-error-query-timeout-your-query-request-was-running-for-too-long/559 "2023-12-11T22:41:05Z")
This error indicates that the request from your query took too long and timed out on Salesforce’s servers. This timeout limitation is set by Salesforce, so the only solution is to improve the speed of your query. If you… --- ## [DBAmp: ‘EXCEEDED\_ID\_LIMIT: EntityDefinition does not support queryMore(), use LIMIT to restrict the results to a single batch’ when executing a SELECT \* FROM \[(linked\_server\_name)\_Fields\] system view](https://community.cdata.com/t/dbamp-exceeded-id-limit-entitydefinition-does-not-support-querymore-use-limit-to-restrict-the-results-to-a-single-batch-when-executing-a-select-from-linked-server-name-fields-system-view/553)
**Author:** [@Ismete\_M](https://community.cdata.com/u/Ismete_M)\ **Replies:** 0\ **Last updated:** [December 6, 2023, 10:30pm UTC](https://community.cdata.com/t/dbamp-exceeded-id-limit-entitydefinition-does-not-support-querymore-use-limit-to-restrict-the-results-to-a-single-batch-when-executing-a-select-from-linked-server-name-fields-system-view/553 "2023-12-06T22:30:48Z")
Getting the following error after executing: SELECT \* FROM \[\\_Fields\]: “EXCEEDED\_ID\_LIMIT: EntityDefinition does not support queryMore(), use LIMIT to restrict the results to a single batch” This… --- ## [DBAmp: “MISSING\_ARGUMENT:(External ID field name) not specified:--" error when performing Upsert operation with SF\_TableLoader using an External ID](https://community.cdata.com/t/dbamp-missing-argument-external-id-field-name-not-specified-error-when-performing-upsert-operation-with-sf-tableloader-using-an-external-id/547)
**Author:** [@Ismete\_M](https://community.cdata.com/u/Ismete_M)\ **Replies:** 0\ **Last updated:** [December 1, 2023, 9:25pm UTC](https://community.cdata.com/t/dbamp-missing-argument-external-id-field-name-not-specified-error-when-performing-upsert-operation-with-sf-tableloader-using-an-external-id/547 "2023-12-01T21:25:11Z")
This error is thrown by Salesforce itself when attempting to Upsert an input table that does not always contain a value for the External ID field(in this case External\_ID\_\_c as shown in the example below). When performin… --- ## [Installing Dbamp Remotely](https://community.cdata.com/t/installing-dbamp-remotely/454)
**Author:** [@Srilatha](https://community.cdata.com/u/Srilatha)\ **Replies:** 2\ **Last updated:** [November 10, 2023, 7:01pm UTC](https://community.cdata.com/t/installing-dbamp-remotely/454 "2023-11-10T19:01:38Z")
Hi Everyone, I have a scenario to use Azure Managed SQL Instances and these are not supported for DBAmp because they do not allow the installation of 3rd-party linked servers on the Instance. So I am trying to install d… --- ## [Bad performance of DBAmp V22](https://community.cdata.com/t/bad-performance-of-dbamp-v22/511)
**Author:** [@DLI](https://community.cdata.com/u/DLI)\ **Replies:** 3\ **Last updated:** [November 8, 2023, 2:28pm UTC](https://community.cdata.com/t/bad-performance-of-dbamp-v22/511 "2023-11-08T14:28:07Z")
Why DBAmp V22 SF\_MirrorAll takes much more time (couple hours) than V5.1.9 SF\_RefreshAll? even I skipped many tables, like %History, %Share… Also there are many error messages: Error occurred creating primary key for tab… --- ## [Upgraded DBAmp and the SOQL queries don't work](https://community.cdata.com/t/upgraded-dbamp-and-the-soql-queries-dont-work/279)
**Author:** [@shrey](https://community.cdata.com/u/shrey)\ **Replies:** 2\ **Last updated:** [July 26, 2023, 2:36pm UTC](https://community.cdata.com/t/upgraded-dbamp-and-the-soql-queries-dont-work/279 "2023-07-26T14:36:59Z")
We upgraded DBAMp version on our SQL Server. Followed the instructions and created a new Linked Server. Stored procedures are running fine, but when I execute a SOQL query; we get the following error An invalid sche… --- ## [DBAmp/Pro Subscription has expired.](https://community.cdata.com/t/dbamp-pro-subscription-has-expired/278)
**Author:** [@Dani\_Moran](https://community.cdata.com/u/Dani_Moran)\ **Replies:** 0\ **Last updated:** [July 20, 2023, 8:48pm UTC](https://community.cdata.com/t/dbamp-pro-subscription-has-expired/278 "2023-07-20T20:48:19Z")
When running DBAmp commands, you might receive the following error message: “Error: DBAmp/Pro Subscription has expired. Please contact forceAmp.com for a valid key.” If your subscription has expired, then you should cont… --- ## [DBAmp error referencing 'xp\_cmdshell'](https://community.cdata.com/t/dbamp-error-referencing-xp-cmdshell/277)
**Author:** [@Dani\_Moran](https://community.cdata.com/u/Dani_Moran)\ **Replies:** 0\ **Last updated:** [July 20, 2023, 7:05pm UTC](https://community.cdata.com/t/dbamp-error-referencing-xp-cmdshell/277 "2023-07-20T19:05:38Z")
The error: “Error: SQL Server blocked access to procedure ‘sys.xp\_cmdshell’ of component ‘xp\_cmdshell’ because this component is turned off as part of the security configuration for this server.”, shows up because xp\_cmd… --- ## [Error: DBAmpWork directory does not exist.](https://community.cdata.com/t/error-dbampwork-directory-does-not-exist/276)
**Author:** [@Dani\_Moran](https://community.cdata.com/u/Dani_Moran)\ **Replies:** 0\ **Last updated:** [July 20, 2023, 5:38pm UTC](https://community.cdata.com/t/error-dbampwork-directory-does-not-exist/276 "2023-07-20T17:38:41Z")
To use the bulkapi (even the pkchunk variant for those tables where Salesforce supports it) you will need to have a Work Directory set up for DBAmp. How to do that depends on your version. If you have version 22 or late… --- ## [DBamp Stored procedures failing after upgrade to V2022: Unable to retrieve settings from sys\_connection\_props.](https://community.cdata.com/t/dbamp-stored-procedures-failing-after-upgrade-to-v2022-unable-to-retrieve-settings-from-sys-connection-props/274)
**Author:** [@shrey](https://community.cdata.com/u/shrey)\ **Replies:** 1\ **Last updated:** [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 "2023-07-20T15:46:59Z")
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\_Replicat… --- ## [DBAmp v22 with Multiple Serial Numbers](https://community.cdata.com/t/dbamp-v22-with-multiple-serial-numbers/275)
**Author:** [@Dani\_Moran](https://community.cdata.com/u/Dani_Moran)\ **Replies:** 0\ **Last updated:** [July 20, 2023, 3:04pm UTC](https://community.cdata.com/t/dbamp-v22-with-multiple-serial-numbers/275 "2023-07-20T15:04:37Z")
For your convenience, DBAmp is now set up so that one serial number will allow you to connect to all orgs you have licenses for. So put in any of the serial numbers given to you, and you will be good to go! [Next page](https://community.cdata.com/tag/dbamp/48.md?match_all_tags=true&page=1&tags%5B%5D=dbamp)