Symptom
- Error: 'Cannot Connect to Adaptive Processing Service'
- Unable to create a report based on any Universe (UNX) in Crystal Reports.
- When attempting to create a report based on a Universe (UNX), it displays the following error in the Query Panel, in Crystal Reports:
'Cannot Connect to Adaptive Processing Service'
Environment
- SAP Crystal Reports 2020
- SAP BusinessObjects Business Intelligence platform 4.3
Reproducing the Issue
- In Crystal Reports, create a new report.
- In the Database Expert, under "New Connection", double click on “Universe (UNX)
- Connect to the SAP BusinessObjects BI server repository, and select a Universe.
- It open the Query Panel, and display the error: 'Cannot Connect to Adaptive Processing Service'
Cause
- The error occurs when:
- The Adaptive Processing Server is down or disabled; or
- The Crystal Reports DSL Engine Service is missing from the Adaptive Processing Server; or
- The version of the SAP BusinessObjects Business Intelligence platform 4.3 is lower than Support Pack 04, because the Universe (UNX) connectivity was added from Support Pack 04.
Resolution
- Confirm the version of SAP BusinessObjects BI 4.3, is at Support Pack 04, or higher:
- Login to the Central Management Console (CMC)
- In the Central Management Console (CMC), at the top right corner, under “Help”, select “About”
- If the version of SAP BusinessObjects BI 4.3 is lower than Support Pack 04,
then download and install Support Pack 04, or higher of SAP BusinessObjects BI 4.3
- Login to the Central Management Console (CMC)
- Ensure the Adaptive Processing Server is Running and Enabled:
- Logon to the Central Management Console (CMC) using the Administrator user.
- Go to Servers.
- In Servers, in the left pane, select "Server List"
- Ensure the Adaptive Processing Server is Running, and Enabled.
If not, then start the server, and enable it.
- If it is Running and Enabled, then restart the Adaptive Processing Server.
- Logon to the Central Management Console (CMC) using the Administrator user.
- Ensure the Crystal Reports DSL Engine Service is added to the Adaptive Processing Server:
- Logon to the Central Management Console (CMC), using the Administrator user.
- Go to Servers
- In Servers, in the left pane, select "Server List"
- Stop the Adaptive Processing Server, by right clicking on the server, and selecting “Stop Server”
- Once stopped, right click on the “Adaptive Processing Server”, and select: “Select Services”
- In “Select Services”, confirm the following service is added to the list of Services on the right pane:
Crystal Reports DSL Engine Service
- If it is not added, select in the list of Available services, “Crystal Reports DSL Engine Service”,
and click the arrow “>” to add it.
- Click “OK”
- Back to the list of servers, start the Adaptive Processing Server.
- Logon to the Central Management Console (CMC), using the Administrator user.
Keywords
CR, UNX, Universe , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , Problem
Product
SAP Crystal Reports 2020