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
UpdateAndExit
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:
]]
—————–
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
none
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)