SAP Knowledge Base Article - Public

2127029 - Error: 'Cannot obtain error message from server.' when refreshing a report based on Salesforce 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
         
               
  • Note: Images and data in this SAP Knowledge Base Article is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

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 of 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 Business View Manager , Problem

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016