Apex Code Development You need to sign in to do that
Don't have an account?
FIS Team Session Timeout error on fetching records with limit 50000 in the SOQL called through SOAP API call
Hi ,
We have requirement where we need to fetch maximum number of records from Salesforce by calling SOQL through SOAP Api in our DotNet Code. Keeping in view the governor limits we set Limit 50000 in our SOQL and it was working fine for months but now in past few 2 weeks it started giving following error when SOQL runs through SOAP API.
INVALID_SESSION_ID: Invalid Session ID found in SessionHeader: Illegal Session. Session not found, missing session hash: CoCuOVP4fYbJhzxMKONd9HFIw7kGz9/ZEBHwT7Ed0PY= This error usually occurs after a session expires or a user logs out._
if we reduce the limit size to 4000 or less SOQL runs without any issues.Please suggest what could have gone wrong ?
Thank you in advance!!!
We have requirement where we need to fetch maximum number of records from Salesforce by calling SOQL through SOAP Api in our DotNet Code. Keeping in view the governor limits we set Limit 50000 in our SOQL and it was working fine for months but now in past few 2 weeks it started giving following error when SOQL runs through SOAP API.
INVALID_SESSION_ID: Invalid Session ID found in SessionHeader: Illegal Session. Session not found, missing session hash: CoCuOVP4fYbJhzxMKONd9HFIw7kGz9/ZEBHwT7Ed0PY= This error usually occurs after a session expires or a user logs out._
if we reduce the limit size to 4000 or less SOQL runs without any issues.Please suggest what could have gone wrong ?
Thank you in advance!!!
The reason of issue might be that you added some queries that also retrieving the records in same transaction. In a one transaction maximum 50000 records can we retrived by all queires.
Lets take an example
Query1 retriveing 10000 records and in same transaction query2 retrieving 49000 records that total records would be 59000 that is greater than 50000. That is the reason you are facing issue.
Thanks,
Banwari
No its single api call that retrieves the data (using Select) and there is no other SOQL in the transaction
regards