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