SAP Knowledge Base Article - Public

1715902 - Error: 'Unknown database connector error.' when creating a report base on a Universe in Crystal Reports

Symptom

  • Error when attempting to create a report off a Universe.
  • Able to create a new report in Crystal Reports off the database used by the Universe.
  • In the Universe Designer, it can connect successfully to the database used by the Universe.
  • When attempting to create a new report off a Universe in Crystal Reports, it fails with the error:
        
    "Unknown Database Connector Error.
       
      Details: All the servers with CMS <SAP BusinessObjects BI Server Name>:<Port Number>,
      cluster @<Cluster Name>, kind webiserver which host service <Service Name>, are down or disabled."

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020

Reproducing the Issue

  1. In Crystal Reports, create a new report. 
  2. In the "Database Expert", select double click on the Universe connection.  
  3. Enter yoour credential to login to the SAP BusinessObjects Business Intelligence Platform.    
  4. In the list of Universe, select a specific Universe to connect to, and click "Next". It then fails with the error:
           
    "All the servers with CMS <SAP BusinessObjects BI Server Name>:<Port Number>,
      cluster @<Cluster Name>, kind webiserver which host service <Service Name>, are down or disabled."

Cause

  • When creating a report based on a Universe in Crystal Reports, it communicates with the Web Intelligence Processing Server to retrieve the Universe information.
  • If the Web Intelligence Processing Server is not running, disabled, or simply does not exist, then it will fail with the error.

Resolution

  • To be able to create, or refresh a report based on a Universe in Crystal Reports, start and enable the Web Intelligence Processing Server on the SAP BusinessObjects Business Intelligence Platform:
       
    1. Logon to the Central Management Console (CMC) using the Administrator account.
          
    2. Got to: Servers
          
    3. If there is no Webi Intelligence Processing Server, then create a new Web Intelligence Processing Server, and then start it.
        
    4. If the Web Intelligence Processing Server is down or disable, then start and enable it.

Keywords

Crystal Report based on Universe, Unknown Database connector error, CR , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , BI-RA-WBI , Web Intelligence , Problem

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020