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

OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE" returned message "Error 1 : QUERY_TIMEOUT: Your query request was running for t

Hello. We are running into receiving this error: OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE" returned message "Error 1 : QUERY_TIMEOUT: Your query request was running for too long." Is there any reason why this error would all of a sudden begin occurring after about a year without any issues? It is a query to a custom object in Salesforce with about 80k records. DBAmp is using Salesforce credentials of an admin. user so permissions shouldn't be an issue.
1 person has
this problem
+1
Reply
  • The error message is from salesforce and indicates the query is consuming too many resources and therefore is timed out. The most common causes are:

    1. A change in the profile of the salesforce user. Try changing the user to the actual system admin profile (not a clone) as a test to see if their is something in the profile that is causing the issue,

    2. A large amount of deleted rows. If there has recently been a large number of rows that have been deleted, then salesforce slows down while it skips over the soft deleted rows..

    3. A change in the schema of the object. Adding a large number of formula / roll up fields can impact the query time on salesforce.

    One thing you can try is to resubmit the command immediately after it fails. Often the query result is sitting in the memory cache and it will work the second or third time.

    If we need to dive into this deeper, please send an email to support@forceamp.com with the command and the complete message output.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited sad, anxious, confused, frustrated