SAP Knowledge Base Article - Public

1745816 - Database Connector Error: 'Unexpected', when refreshing a report based on Salesforce.com in Crystal Reports

Symptom

  • Database Connector Error: 'Unexpected' when refreshing a report connected to Salesforce.com in Crystal Reports.
  • The same report used to refresh successfully in Crystal Reports before.

Environment

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

Reproducing the Issue

  1. In Crystal Reports, open a report based on a Salesforce.com data source.
  2. Refresh the report, and it will generate the error:
         
     Database Connector Error: 'Unexpected'

Cause

  • The report was based on a Salesforce.com report (Stored Procedure), and the Stored Procedure was modified in Salesforce.com
  • Since some database fields where missing, the report failed to refresh.

Resolution

  • Perform a Set Data Source location from the same stored procedure, to detect the change, and remap the fields.
        
    1. Open the in Crystal Reports designer.
    2. Under the menu "Database", select "Set Datasource Location..."
    3. Select the stored procedure at the top window and the same stored procedure at the bottom.
    4. Click Update
    5. Proceed with Mapping if the stored procedure changed.

Keywords

SForce, SFDC, CR , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011