SAP Knowledge Base Article - Public

3564134 - Error: 'Cannot Connect to Adaptive Processing Service', when creating a report based on a Universe (UNX) in Crystal Reports

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

  1. In Crystal Reports, create a new report.
  2. In the Database Expert, under "New Connection", double click on “Universe (UNX)
  3. Connect to the SAP BusinessObjects BI server repository, and select a Universe.
  4. 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:
        
    1. Login to the Central Management Console (CMC)

    2. In the Central Management Console (CMC), at the top right corner, under “Help”, select “About”

    3. 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
        
         
  • Ensure the Adaptive Processing Server is Running and Enabled:
       
    1. Logon to the Central Management Console (CMC) using the Administrator user.
        
    2. Go to Servers.
        
    3. In Servers, in the left pane, select "Server List"
         
    4. Ensure the Adaptive Processing Server is Running, and Enabled.
      If not, then start the server, and enable it.
        
    5. If it is Running and Enabled, then restart the Adaptive Processing Server.
        
         
  • Ensure the Crystal Reports DSL Engine Service is added to the Adaptive Processing Server:
      
    1. Logon to the Central Management Console (CMC), using the Administrator user.
        
    2. Go to Servers
        
    3. In Servers, in the left pane, select "Server List"
         
    4. Stop the Adaptive Processing Server, by right clicking on the server, and selecting “Stop Server”
        
    5. Once stopped, right click on the “Adaptive Processing Server”, and select: “Select Services”
    6. In “Select Services”, confirm the following service is added to the list of Services on the right pane:

           Crystal Reports DSL Engine Service
        
    7. If it is not added, select in the list of Available services, “Crystal Reports DSL Engine Service”,
      and click the arrow “>” to add it.
        
    8. Click “OK”   

    9. Back to the list of servers, start the Adaptive Processing Server.

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