You need to sign in to do that
Don't have an account?
SimplySfdc
QUERY_TIMEOUT
Hi,
I keep get "QUERY_TIMEOUT: Your query request was running for too long." when do query. Can anybody help....
sq
I keep get "QUERY_TIMEOUT: Your query request was running for too long." when do query. Can anybody help....
sq
My query is "select count() from asset", total records in asset is around 210,000 records.
sq
Actually what is my program do is delete all records from Asset and reload with new data everyday.
So, I do query "select id from asset" ---> this often keep error, but sometimes it works.
Then I use list of ID for deletion.
This program has work for 6+ mths with no issue, but last few weeks this errors occured more often.
sq
Seems like my issue is solved. emptyrecyclebin is available from version 10 and above, while my code is written using api version 9.
Thanks buddy.
sq
I get error "invalid record id; no recycle bin entry found" when
call emptyRecycleBin, while the ID is available when I query
"Select Id from asset where isdeleted = true".
Why is this happen?
sq
Just saw in APEX_API.PDF.
"After records are deleted from the recycle bin using this call, they can be queried using queryAll for some time.Typically this time is 24 hours, but may be shorter or longer."
Sorry for this. So, let me check again tomorrow morning.
cheers.
sq
Hi Simon/werwolf.
even i am getting the QUERY_TIMEOUT exception when i tried to fetch the contact records from SFDC. There is not much deleted records available in recyclebin.
can we extend the time somewhere in sfdc?
I had this same problem. We delete all records in a custom object every day and load new records. I tried deleting my org's recycle bin and still couldn't get it to work.
I finally figured out to apply a filter to my query: Isdeleted=false
This has fixed the problem for me. Just thought I'd post in case anyone else is getting this error :)
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.