OBIEE 11.7.0.0.1+ GUID Refresh
1. Please follow instructions given in
How to fix “Unable to Sign in. An error occured during Authentication” error when a user logs in OBIEE 11g (Doc ID 1302924.1) step by step, for those steps you have done, please double check and make sure what you’ve done are correct.
2. You are still not able to logon because you have missed a few steps as the following:
8. Edit the NQSConfig.INI file to reset the FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = YES to NO and restart the Oracle BI Servers.
9. Remove, set to none, or comment out the line (see UpgradeAndExit in the following example) added to the instanceconfig.xml file (that instructs Oracle BI Presentation Server to refresh GUIDs on restart).
10. <ps:Catalog xmlns:ps=”oracle.bi.presentation.services/config/v1.1″>
11. <ps:UpgradeAndExit>false</ps:UpgradeAndExit>
12. <ps:UpdateAccountGUIDs>none</ps:UpdateAccountGUIDs>
13. Restart the Presentation Server for the instanceconfig.xml file that was updated.
14. Make sure Oracle WebLogic Server and the system components are also running, if they are not running, restart them.
b) Relogin as the problematic user to verify if you still see the “Unable to Sign In” error
Step 2 : Delete user from rpd if present
a)Launch admin tool and open rpd in OFFLINE Mode
b)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
c)If the user is present, delete this user entry from rpd
d)save rpd and deploy this changed rpd using EM
e)restart OBI Server component
f)relogin as the problematic user to see if you still see “Unable to Sign In” error
Step 3 : Delete the cacheduserinfo file from webcatalog
If Step1 and Step2 does not work, then do the following
Note : In the example below, catalog name is SampleApp and the user who gets “invalid Login” error is Administrator user.
a)Take a backup of your webcatalog
b)Navigate to C:\OBIEE11G\instances\instance2\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\SampleApp\root\users\Administrator\_prefs
c)Delete the files name cacheduserinfo and cacheduserinfo.atr
d)Launch OBIEE 11.1.1.3 and test by logging in as the specific user.
No Comments