The
purpose of this Post is to provide steps to troubleshoot "Unable to
Sign in. An error occurred during Authentication. Try again later or
contact your system administrator" errors when a user logs in to Oracle
Business Intelligence Enterprise Edition (OBIEE)11g.
NOTE:
You may not need to complete all steps (i.e. Step A, Step B, C.).
After completing all sub-tasks in each stepped section, please retest
login and if the login still fails, then proceed to the next step.
I found a simple way to fix this issue by following the below steps.
1) Open the RPD in the Offline mode
2) Manage --> Identity--> Check for the user name with what user your trying to login into presentation services (Analytics), For example if you are using weblogic user to login to Analytics then search for weblogic user in rpd opened in offline mode.
3) Delete the user (in our example weblogic) from the offline RPD and save the RPD.
4) Deploy this rpd in to BI Server and restart the services.
Note : Restarting of all the services is recommended.
5) Now try to login with the weblogic user , now you can see the user is able to successfully login.
The issue is with the GUID. It is always recommended to check the user references in the offline rpd before deploying it. If you find any of the users in offline mode,delete them and save the RPD then deploy it.
Step A: Refreshing GUIDs (or Regenerating User GUIDs)
- Check to see if any error messages regarding GUID mismatch is seen in the sawlog located in \OBI11g\instances\instance3\diagnostics\logs\OracleBIPresentationServicesComponent\coreapplication_obips1 folder/directory.
- If yes, follow steps to refresh GUID as documented in Section 3.2.7 "Regenerating User GUIDs" of the Oracle Fusion Middleware Administrator's Guide.
- After completing step 2, login to OBIEE as the problematic user to verify if you still encounter any login errors.
Step B: Delete user from Repository (RPD) file, if present
- Launch admin tool and open RPD in OFFLINE Mode.
- Click Manage -> Identity -> Users tab to verify if you see this user present
Note : Normally you will only see list of users when you open RPD in ONLINE mode. Unless the users were created manually in RPD, no users should be visible in OFFLINE mode.
- If the user is present, delete this user entry from RPD.
- Save RPD and deploy this changed RPD using EM.
- Restart OBI Server component.
- Re-login as the problematic user to see if you still encounter log in error.
Step C: Delete the cacheduserinfo files from webcatalog
If login errors persist after completing Step A and Step B above, then complete the following.
Note : In the illustration example below, the
catalog name is "SampleApp" and the user who gets "Iœnvalid Login" error
is the "Administrator" user.
- Take a backup of your webcatalog.
- Navigate to \OBIEE11G\instances\instance2\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\SampleApp\root\users\Administrator\_prefs
- Delete the files named "cacheduserinfo" and "cacheduserinfo.atr."
- Open web browser and retest OBIEE 11g login for that user.
Note :
1. The cacheduserinfo and cacheduserinfo.atr files get automatically recreated when the user logs in next time
1. The cacheduserinfo and cacheduserinfo.atr files get automatically recreated when the user logs in next time
