You need to sign in to do that
Don't have an account?
niranjan
Invalid Query Locator Error
Hi
I have taken querysize = 2000. And when I am trieng to process more than 2000 records I am getting Invalid Query Locator Error.
But if I take querysize = 500 and when I process the application, Query Locator is working fine for 4 batches of 500 each. and then failing at 5th batch i.e, its unable to locate 2001st record in any case.
Is there any restriction on querysize maximum value as 2000. If any one knows the solution please post the solution in this forum.
Thanks and regards,
Niranjan.
Thanks for your help. I implemented my logic so that the gap between query and querylocator calls to
the salesforce api is reduced to less than 15 minutes. Now it is working fine.
But as the process has to retrieve 40,000 records from AccountShare table.
I observed the from the execution of the process is that it is taking very long time for the subsequent records.
i.e, it took - 3 hours - for first 4500 records
for next - 3 hours - it processed only 1500 records.
for next - 3 hours - it processed only 500 records
If anyone know why it is taking so long time for the subsequent queries please intimate.
Awaiting for your reply.