1294566 - Error: Query Locator time out, when refreshing a report based on Salesforce.com in Crystal Reports

SAP Knowledge Base Article - Public

1294566 - Error: Query Locator time out, when refreshing a report based on Salesforce.com in Crystal Reports

Symptom

  • Error: Query Locator time out
  • When refreshing a report based on a Salesforce.com data source in Crystal Reports, it fails with the error:
     
      "Query Locator Time out"

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
        
  • Salesforce.com

Cause

  • When joining large-sized Salesforce.com tables in Crystal Reports, you may run into a query locator time out error.
  • The query locator is a server-side cursor generated by Salesforce.com and is used to navigate the query result.
  • The Salesforce.com cursor will expire in 15 minutes of inactivity. For more information see the Salesforce.com Knowldege Article 4410

Resolution

Keywords

SFDC, Sforce, CR , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016