3

When i try to pull many contacts using SOAP API i get NVALID_QUERY_LOCATOR exception. INVALID_QUERY_LOCATOR exception occurre when any query having sub query takes a long time (more than 15 Mins) to execute at SF server and meanwhile SF DB object gets expired.

This exception occurred while executing below query – 

Select street, city, country, email, firstname, mobilephone, lastname, postalcode, state, phone, fax, id from lead where Email!=Null and BH4SF__Opted_Out__c = false and id in (select leadid from CampaignMember where campaignId = '70160000000Mk5FAAS') order by Email, CreatedDate

any help on how to resolve this?

AtulRajguru9
  • 254
  • 7
  • 12

1 Answers1

1

You are having problems with the governor limits of salesforce. Too many records are being pulled with your query. You can use a list to store the query example:

List<Account> accountsAndCases= [SELECT id, name, (SELECT id, subject, description FROM Cases) FROM Account];

Then work with the list and at the end update your database. Or maybe you can also use the limit call at the end of your query to limit the amount of records you’ll get. Example: 

SELECT id, name FROM Account limit 100;

This link might be helpful: https://help.salesforce.com/apex/HTViewSolution?id=000004410&language=en_US

Levementum
  • 11
  • 2
  • I dont think you got the problem. Batch work fine for 100k + records. This particulate problem takes place when I use sub query and it take long time to pull all of the data from API/ – AtulRajguru9 Jun 22 '16 at 03:57