How to refresh GUIDs for OBIEE 11g ?

Purpose

The purpose of this document is to provide clear steps for refreshing GUIDs in OBIEE 11g. The document also shows what to expect in the logs to confirm GUID refresh has completed successfully.

Details

1) Stop all obiee services (opmnctl stopall) 

2) Edit presentation server instanceconfig.xml with the following - put it inside Catalog tag
<UpdateAccountGUIDs>UpdateAndExit</UpdateAccountGUIDs> 

3) Edit obiee server NQSconfig.INI file with the following
FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = YES; 

4) Start OBIEE services (opmnctl startall) 

5) Wait until presentation services are listed as down (opmnctl status) 

6) stop obiee services (opmnctl stopall) 

The saw log should show the following:
-----------------
Saw.log
[2012-12-19T09:38:03.000-07:00] [OBIPS] [NOTIFICATION:1] [] [saw.subsystem.catalog.initialize.upgrade] [ecid: ] [tid: ] Starting to update Account GUIDs[[
File:initializecatalog.cpp
Line:1046
Location:
   saw.subsystem.catalog.initialize.upgrade
   saw.subsystem.catalog.initialize
   saw.subsystems.catalogbootstrapper.loadcatalog
   saw.webextensionbase.init
   saw.sawserver
ecid:
]]
[2012-12-19T09:38:07.000-07:00] [OBIPS] [NOTIFICATION:1] [] [saw.subsystem.catalog.initialize.upgrade] [ecid: ] [tid: ] Succeeded in updating account GUIDs from back end user population store[[
File:initializecatalog.cpp
Line:1131
Location:
   saw.subsystem.catalog.initialize.upgrade
   saw.subsystem.catalog.initialize
   saw.subsystems.catalogbootstrapper.loadcatalog
   saw.webextensionbase.init
   saw.sawserver
ecid:
]]

7) Edit presentation server instanceconfig.xml with the following
<UpdateAccountGUIDs>none</UpdateAccountGUIDs> 

8) Edit obiee server NQSconfig.INI file with the following
FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = NO; 

9) Start OBIEE services (opmnctl startall) 

10) Verify OBIEE services are up (opmnctl status)

Reference:

http://docs.oracle.com/cd/E14571_01/bi.1111/e10543/privileges.htm#CHDHGAAH

Cheers!

Bose