function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
SimplySfdcSimplySfdc 

QUERY_TIMEOUT: Your query request was running for too long.

Hi,

I have issue when query "select Id from asset", program keep error "QUERY_TIMEOUT: Your query request was running for too long." . But, when I try query from Apex Explorer, I can get the result in >30secs with >220+ records. Anyway to make this work?
FYI:
- sometimes, my program can running, but the chance very low <10-20%.
- windows a .Net application
- binding.Timeout = 120000
- WSDL version 11.0

Anyone can help me? Thx a lot.

sq
SimplySfdcSimplySfdc
correction, it should be 220.000+ records.

sq
SimplySfdcSimplySfdc
is there any difference in speed between WSDL 11 with older version?
I feel that query to this sfdc instance is slower than others, tried from apex explorer.
any advise?
SimplySfdcSimplySfdc
if I change query batchsize to smaller, will this help? need advise please...
JPlayEHRJPlayEHR

I was running into this same issue using the dataloader via CMD prompt and was able to get past that same error by changing "sfdc.extractionRequestSize=500" to "sfdc.extractionRequestSize=10" (or lower it however much you need to in order to make it work). 

 

Hope this helps somebody.
RaguRagu

Thought this might be useful to somebody,


Use limit keyword in your query. It will solve your problem. I solved my issue by just adding limit as 2000000 though my sf object has 900000 records.