We delete the user and then recreate and attempt to log in, application access is restored. However this is not a viable option because when deleting the user, the internal attribute ID defining ‘My Folders’ access and any other user based privileges will not have an association with the newly re-created user account (this in itself is another application issue).
The root cause of the issue is web catalog corruption. Deleting users from the Weblogic did not refresh the cached info. After deleting the following files for weblogic and Administrator user, there are no issues.
<Oracle>\Middleware\instances\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\EnterpriseBusinessAnalytics\root\users\weblogic\_prefs
cachedinfo
cachedinfo.atr
cachedinfo
cachedinfo.atr
Another solution is to clean up the catalog by using the following settings in the instanceconfig.xml
<ps:Validate>OnStartup</ps:Validate>
<ps:ValidateItems>None</ps:ValidateItems>
<ps:ValidateLinks>None</ps:ValidateLinks>
<ps:ValidateAccounts>Clean</ps:ValidateAccounts>
<ps:ValidateHomes>None</ps:ValidateHomes>
<ps:ValidateItems>None</ps:ValidateItems>
<ps:ValidateLinks>None</ps:ValidateLinks>
<ps:ValidateAccounts>Clean</ps:ValidateAccounts>
<ps:ValidateHomes>None</ps:ValidateHomes>
After restarting the services, users were able to login with no issues.
Once resolved, remove the settings used to clean up the catalog in instanceconfig.xml. Restart the services. Test the login to make sure there are no issues
