SAP Knowledge Base Article - Public

1716438 - Error: 'The Database connector crdb_bwquery.dll could not be loaded' when refreshing a report in Crystal Reports

Symptom

  • Error: 'The Database connector crdb_bwquery.dll could not be loaded'
  • Reports created using the BW Query driver does not run in Crystal Reports anymore.
  • The same report refreshed successfully before upgrading to Crystal Reports 2011, 2013 or 2016.
  • Newly created reports in Crystal Reports using the SAP BW MDX Query Driver refresh successfully.
  • When attempting to refresh a report based on an SAP BW BEx Query in Crystal Reports, it fails with the error:
              
    'Failed to load database information. 
     Details: The Database connector crdb_bwquery.dll could not be loaded'

Environment

  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
      
  • SAP BW 7.x

Reproducing the Issue

  1. In Crystal Reports 2008 or lower, create a report off an SAP BW BEx Query using the "SAP BW Query Driver"
  2. Save the report locally or to SAP BusinessObjects Repository.
  3. In Crystal Reports 2011 designer or higher, open the report that was created in an earlier version of Crystal Reports.
  4. When attempting to refresh the report, it displays the error:
         
    'Failed to load database information Details: The Database connector crdb_bwquery.dll could not be loaded'

Cause

  • The driver: crdb_bwquery.dll, was used by the legacy SAP BW Query Driver, which is no longer available from Crystal Reports 2011.
        
  • The SAP BW Query Driver was deprecated from Crystal Reports XI, and was still available up to Crystal Reports 2008 to provide time to update or re-create reports that were created with the legacy SAP BW Query Driver, to the new and enhanced SAP BW MDX Query Drivers.

Resolution

  • Update the report to use the SAP BW MDX Query driver, or re-create the report:
       
    1. Open the report in Crystal Reports 2011 or higher.
        
    2. From 'Database' menu, select 'Set Datasource Location'
        
    3. In the "Set Datasource Location" window, create a new connection to SAP BW using the MDX query driver
        
    4. Create a new connection using "SAP BW MDX Query".
        
    5. Under the newly created connection, browse to the SAP BW BEX Query which is used in the current report.
        
    6. In the 'Current data source' section select the existing connection.
        
    7. Click on the "Update" button.
        
    8. If there are variables in the SAP BW BEx Query, it will be prompt you for it.
         
    9. The Map Fields window will open. Mp all the unmapped fields. Note that information is fetched differently with the SAP BW MDX Query driver.
          
    10. Save the report.
             
          
  • Important Note:
      
    • Mapping the database fields might be complex because the SAP BW BEx Query objects like: hierarchies, are fetched differently by the SAP BW MDX driver and in some cases, recreating the report is the only option.
          
    • Also note the database field names and type in some cases will be different, and some formulas might require type conversion before the report can successully be executed.

Keywords

crdb_bwquery.dll, CR 2011 database error, SAP BW MDX Query Driver, SAP BW Query Driver , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , BI-BIP , Business intelligence platform , Problem

Product

SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016