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
- In Crystal Reports, create a new report.
- In the "Database Expert", select double click on the Universe connection.
- Enter yoour credential to login to the SAP BusinessObjects Business Intelligence Platform.
- 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:
- Logon to the Central Management Console (CMC) using the Administrator account.
- Got to: Servers
- If there is no Webi Intelligence Processing Server, then create a new Web Intelligence Processing Server, and then start it.
- 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