SAP Knowledge Base Article - Public

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


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


  • Crystal Reports 2008
  • SAP Crystal Reports 2011

Reproducing the Issue

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


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


  • 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.


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


Crystal Reports 2008 V1 ; SAP Crystal Reports 2011