function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
FIS TeamFIS 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!!!
Banwari KevatBanwari Kevat
   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.

FIS TeamFIS Team
Thanks Banwari,

No its single api call that retrieves the data (using Select) and there is no other SOQL in the transaction


Raj VakatiRaj Vakati
Set Seesion Time out to 24 hrs in Salesforce and try ..