Skip to Content
0

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

Dec 02, 2016 at 05:47 PM

66

avatar image

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!!!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Vitaly Izmaylov
Jul 14, 2017 at 11:02 PM
0

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?

    Share
    10 |10000 characters needed characters left characters exceeded