2127029 - Error: 'Cannot obtain error message from server.' when refreshing a report based on a Salesforce.com in Crystal Reports

SAP Knowledge Base Article - Public

2127029 - Error: 'Cannot obtain error message from server.' when refreshing a report based on a Salesforce.com in Crystal Reports

Symptom

  • Error: Database Connector Error: 'Cannot obtain error message from server.'
  • No data returned on a report based on a Salesforce.com connection.
  • When refreshing a report based on Salesforce.com Stored Procedure or tables in Crystal Reports, it fails with the errors:
      
      "Failed to retreive data from the database"
         
       Sforce - Error - 01.png
       
        
      "Database Connector Error: 'Cannot obtain error message from server.' "
       
        Sforce - Error - 02.png

Environment

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

Reproducing the Issue

  1. In Crystal Reports, create a new report, and select the Salesforce.com connection.
  2. Select any Stored Procedure or tables and connect
  3. Drag and drop any field to Details section of the report.
  4. Refresh the report.
     
    It will then display the error:   "Database Connector Error: 'Cannot obtain error message from server.' "

Cause

  • The report was set to perform the query asynchronously, which is not supported when reporting off a Salesforce.com Stored Procedure or Tables.

Resolution

  • Uncheck the report option "Perform Query Asynchronously":
       
    1. Open the report in Crystal Reports.
    2. Under the menu "File", select "Report Options"
    3. In the "Report Options" window, uncheck the option "Perform Query Asynchronously"
    4. Click "OK", and save the report.
       
              
  • Note: The above is to change the option for one report. If you want to ensure the option is not check by default for any future reports, then  follow the steps below:
      
    1. In Crystal Reports, under the menu "File", select "Options"
    2. In the "Options" window, under the tab "Database", uncheck the option "Perform Query Asynchronously"

Keywords

CR2013, SFDotCom, SFDC reports, SProc, Simba , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016