Steps to refresh GUIDS and what to expect from the logs for successfull completion

What to expect in the logs to confirm GUID refresh has completed successfully.

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)

Labels: , ,