Refresh Oracle Business Intelligence GUIDs

Refresh Oracle Business Intelligence GUIDs

Get Social!

webcatWhen copying or making significant changes to the OBIEE 11G web catalog, users can experience difficulty with login. This includes OBIEE patching and upgrades, or moving to a new server such as releasing. To correct this issue, you must force OBIEE to refresh the web catalog. This is done by manually editing two configuration files, restarting the OBIEE system, removing the changes and restarting the OBIEE system once more.

Open the following file for editing:

Locate the attribute FMW_UPDATE_ROLE_AND_USER_REF_GUIDS and change the value to YES.

Save and close the file.

Open the following file for editing:

Locate the following text:

Add “<UpdateAccountGUIDs>UpdateAndExit</UpdateAccountGUIDs>” to match below:

Save and close the file.

Restart the OBIEE system components using opmnctl in a terminal window.

Change the settings back to the original values. Open the following file for editing:

Locate the attribute FMW_UPDATE_ROLE_AND_USER_REF_GUIDS and change the value to NO.

Save and close the file.

Open the following file for editing:

Locate the following text:

Remove “<UpdateAccountGUIDs>UpdateAndExit</UpdateAccountGUIDs>” to match below:

Save and close the file.

Restart the OBIEE system components using opmnctl in a terminal window.

Your OBIEE server will now start up normally and your users should be able to log in.


Visit our advertisers

Search

Quick Poll

Are you using Docker.io?

Visit our advertisers