Help get this topic noticed by sharing it on Twitter, Facebook, or email.
I’m hopeful

"Your query request was running for too long." related to version?

I've seen the suggestions in https://getsatisfaction.com/dbamp/top..., but wondered if upgrading our DBAmp version could help, too.

We're using 2.11.4.

I only get this when working with the LeadHistory table- anything I try with this table times out with a query time of 00:30:01:

SELECT TOP 10 * FROM SALESFORCE...LeadHistory
SELECT COUNT([Id]) FROM [SALESFORCE]...[LeadHistory] WITH (NOLOCK)
SELECT * FROM OPENQUERY([SALESFORCE], 'SELECT COUNT() FROM LeadHistory')
EXEC SF_Replicate 'SALESFORCE','LeadHistory'

All return a variant of, "Your query request was running for too long."

We tried emptying our recycle bin- there was a LOT in there- and are now asking SFDC to increase our timeout. Is there anything else we can do in the meantime? I'd love to at least know how big this table is.
1 person has
this question
+1
Reply