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
- In Crystal Reports, create a new report.
- In the "Database Expert", click on: Universes
- Login to the SAP BusinessObjects BI Server
- Select the Universe
- 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.
- In a browser, login to the Central Management Console (CMC) using the Administrator.
( http://<Server Name>:<port>/BOE/CMC )
- Under "Manage", select "Applications"
- In "Applications", right click on "Web Intelligence", and select: "User Security"
- 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 )
- In "Assign Security", click on the "Advanced" tab
- In the "Advanced" tab, click on "Add/Remove Rights" ( It is right under the "Advanced" tab )
- In "Add/Remove Rights", in the left pane, under "Application", select: "Web Intelligence"
- On the right side, under "General Rights for Web Intelligence", grant the right for "Log on to Web Intelligence"
- At the bottom right corner, click "Apply", then "OK"
- Back to "Assign Security", click "Apply", then "OK"
- 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