Skip to Content
avatar image
Former Member

Invalid Query Locator error in SAP Crystal Reports with Salesforce SIMBA driver

I am creating reports using SAP Crystal reports 4.0 enterprise edition also using 120 columns in my reports. While run the reports i am getting Invalid Query Locator. Here the problem is i am creating reports for sales force using sales force simba driver. When i search in google about this error clearly mentioned that from sales force we have to call queryMore at least every 15 minutes to keep the cursor alive i am not sure about this from salesforce side. Any resolution please posted for this solution from SAP crystal report perspective.

Can we use any other open DSN or driver level can we go for this. I refer below link

https://apps.support.sap.com/sap/support/knowledge/public/en/2383365

Some patch needs to update. Please suggest the best solution.

Thanks!!!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jul 14, 2017 at 11:02 PM

    SAP Crystal reports 4.0 (2011) does not come with Simba driver, but uses SAP internal salesforce.com driver based on Java.

    SFDC Simba driver shipped with CR 2013 and 2016 (4.1 and 4.2 versions)

    Also there is no enterprise or any other editions after Crystal Reports XI R2. Starting from CR 2008 it is a single Edition.

    According to the KBA you referred the issue resolved in
  • Crystal Reports 2013
    • Support Pack 09
  • Crystal Reports 2016
    • Support Pack 04
  • What is the version of Crystal Reports are you using?

Add comment
10|10000 characters needed characters exceeded