OBIEE 11.1.1 - Web catalog upgrade from 10g to 11g corrupted some user permissions
By Ahmed Awan-Oracle on Apr 18, 2012
Web catalog upgrade from 10G to 22.214.171.124 or 126.96.36.199 or 188.8.131.52 corrupted some user permissions, this may cause slow user login time and also slowness in accessing the dashboard.
- Cleanup Web catalog via instanceconfig.xml using the steps documented in "Validating the Catalog" in System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.
- Runcat cmd line commands to cleanup all permissions that appears to be Invalid.
Tip: It is recommended to run all above tasks each & every time content is delivered from a development environment into the production environment (e.g. weekly), as part of the OBIEE administrator's regular backup & maintenance of the catalog
Applies to: OBIEE 184.108.40.206 or 220.127.116.11 or 18.104.22.168
Long login time, long navigation time (dashboard drop down list), long search time (on web catalog especially), especially using Internet Explorer.
Web Catalog Permissions are invalid for several users. Web Catalog is not clean and appears to be corrupted for each Invalid occurrence (please see Picture 1)
Putting ONLY securities on another machine with a standard Web Catalog is showing optimal answer time.
Picture 1: Example of corrupted permissions
Take a backup of full web catalog and open it in Offline mode using OBIEE Catalog Manager
There are 2 steps that are MANDATORY to perform to resolve performances issues:
1. Clean up invalid permissions in web catalog:
Here are the command/instructions to remove
the users from the Web catalog:-
1) Open your Web Catalog using Catalog manager in Offline Mode
2) Locate “/” folder and Edit the permissions
3) In Additional Users and Application Roles box, choose in “User” and click on List button
4) On table result displayed, filter by Type of users, putting “Invalid” one on top
5) List all Invalid users to be cleaned
6) Create a file called cleanusers.cmd in
the directory containing runcat.cmd file as follow
runcat -cmd forgetAccounts -username xxxxx -cleanup -offline "web catalog PATH"
7) Run the command cleanuser.cmd as follow:
8) Open your Web Catalog using Catalog manager in Offline Mode
9) Locate “/” folder and Edit the permissions
10) In Additional Users and Application Roles box, choose in “User” and click on List button
11) Verify that all Users are valid for now
Sometimes you will that it is not possible to erase permissions running runcat commands.
The best is to do the following:
It can appear that those users are in fact linked to Agents.
Clean appropriately to get rid of last Invalid permissions
2. Run an automated clean via Presentation Server. Note: Refer to steps documented in "Validating the Catalog" in System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.