SAP Knowledge Base Article - Public

1204042 - Error: "Failed to initialize Web Intelligence session." when creating a report based off a Universe in Crystal Reports

Symptom

  • Error: "Failed to initialize Web Intelligence session."
  • Unable to create a report based on a Universe in Crystal Reports.
  • Other users are able to create reports based on Universes in Crystal Reports.
  • When attempting to create a report based off a Universe in Crystal Reports, it fails with the error:

         "Failed to initialize Web Intelligence session.
          Check that you have permissions to use the server."

         "Error returned from returned from Web Intelligence server:
          Component:WISErrorCode: 30553ErrorType: USERMessage: session"
             
    Followed by:
        
         "Unknown Database Connector Error
          Details: Failed to initialized Web Intelligence session.
          Check that you have permissions to use the server.
          Previous Error:Error returned from Web Intelligence server:
          Component:WISErrorCode: 30553ErrorType:
          USERMessage: session is closed. Prefix:ERR"       
      
    And then by:
       
         "Unknown Database Connector Error"

Environment

  • SAP BusinessObjects Business Intelligence platform 4.1
  • SAP BusinessObjects Business Intelligence platform 4.2
  • SAP BusinessObjects Business Intelligence platform 4.3
         
  • 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", click on: Universes
  3. Login to the SAP BusinessObjects BI Server
  4. Select the Universe
  5. It fails with the error:

           "Failed to initialize Web Intelligence session.
             Check that you have permissions to use the server."

Cause

  • To connect to a Universe, Crystal Reports communicate with the Web Intelligence server. The Web Intelligence server retreive the information from the Universe, then send the database information and SQL Query to Crystal Reports.

  • The error occurs when the SAP BusinessObjects User does not have the rights to Log on to the Web Intelligence server.

Resolution

  • In the Central Management Console (CMC), explicitly grant the right: "Log on to Web Intelligence", to the user, or group of users. 

    1. In a browser, login to the Central Management Console (CMC) using the Administrator.
      ( http://<Server Name>:<port>/BOE/CMC )
         
    2. Under "Manage", select "Applications"
         
    3. In "Applications", right click on "Web Intelligence", and select: "User Security"
          
    4. In "User Security: Web Intelligence", select the user or the group the user belongs to, and then click on "Assign Security"
      ( If the user or group the user belongs to does not exist, click on "Add Principals" to add it to the list )
        
    5. In "Assign Security", click on the "Advanced" tab
        
    6. In the "Advanced" tab, click on "Add/Remove Rights" ( It is right under the "Advanced" tab )
        
    7. In "Add/Remove Rights", in the left pane, under "Application", select: "Web Intelligence"
        
    8. On the right side, under "General Rights for Web Intelligence", grant the right for "Log on to Web Intelligence"

       Log on to Web Intelligence.png
        
    9. At the bottom right corner, click "Apply", then "OK"
        
    10. Back to "Assign Security", click "Apply", then "OK"
         
    11. Back to "User Security: Web Intelligence", click "Close"

Keywords

CR, UNV, WEBI , KBA , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

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