All OBIEE services are up but the application page is not opening

LDAP how restrict the login to members of certain groups in OBIEE?
March 4, 2009
How to set session variables using url variables
March 6, 2009

After changing password for OBI repository Administrator user, impersonator and OBIEEConnect HR database user, it is no longer possible to log into OBIEE. The following error is displayed:

‘The page cannot be displayed’

OBIEE 10.1.3.3.0 is installed on Linux and deployed on Oracle 10gAS with SSO implemented

So, when you go to http://servername/analytics, it should bring you to the SSO login page e.g ‘Not logged in’ should be displayed. Instead the above error is displayed.
Cause

The issue is caused by the following setup/step:

a). The Oracle Application Server is unable to render OBIEE as an application

b). Credentialstore.xml has not been updated with the change in impersonator password
Solution

The following resolved the problems

1). Redeploy ‘analytics’ application in the OC4J Admin Console, restart all the OBI processes and attempt to log in again.

Now, OBIEE page displayed ‘Not Logged In..’ which is the expected page as SSO is enabled.

This step is described in

–> Oracle Business Intelligence Infrastructure Installation and Configuration Guide> Configuring Oracle BI Presentation Services > Creating a WAR File for Oracle BI Presentation Services

a.In 0c4j admin console
b. Click on ‘analytics’ application
c. Choose default settings or use existing application files
d. Redeploy application
e. Restart all services

2). Add the change in the impersonator user credentials to the Oracle BI Presentation Services Credential Store. To obtain the impersonator user credentials, Oracle BI Presentation Services will search the credential store for a username-password credential with an alias of impersonation

These steps are documented in

–> Oracle Business Intelligence Enterprise Edition Deployment Guide > Implementing Single Sign-On Products With Oracle Business Intelligence > Enabling SSO Authentication for Oracle Business Intelligence > Creating the Oracle BI Server Impersonator User

–> Oracle Business Intelligence Enterprise Edition Deployment Guide > Implementing Single Sign-On Products With Oracle Business Intelligence > Enabling SSO Authentication for Oracle Business Intelligence > Adding Impersonator User Credentials to Oracle BI Presentation Services Credential Store

Leave a Reply