Refreshing Presentation Catalog GUIDs

The process of synchronizing the GUIDs revolves completely around the fact that user identities are stored atomically within the Presentation Catalog, not by username but by a globally unique identifier (GUID). In certain circumstances, specifically when moving between environments with different identity providers or changes to users within those providers are made, the GUIDs can get out of synchronization. Following this process of GUID synchronization allows the catalog to stay organized.
At this point, the Oracle BI 11g system components should still be stopped or made offline as we have not started them since the restart to WLS. Check Enterprise
Manager and confirm that all system components are stopped. If not, go ahead and stop all system components.

Two core configuration files must be modified for this synchronization exercise—NQSConfig.INI and instanceconfig.xml.

[ Note: Please make back-up copies of these files before making any modifications so that you maintain the ability to revert: ]

1. Navigate to <ORACLE_INSTANCE>/config/OracleBIServerComponent/
coreapplication_obis1/ and open the NQSConfig.INI file for editing.
2. Locate the text FMW_UPDATE_ROLE_AND_USER_REF_GUIDS parameter and
change its value to YES as follows:
FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = YES;
3. Save and close the file.
4. Open the instanceconfig.xml file for editing. This file is located at, <ORACLE_INSTANCE>/config/OracleBIPresentationServicesComponent/coreapplication_obips1/.
5. Locate the Catalog XML element which should contain only the
UpgradeAndExit subelement.
6. Add a new subelement to the Catalog element called UpdateAccountGUIDs with a value of UpdateAndExit.
<Catalog>
<UpgradeAndExit>false</UpgradeAndExit>
<UpdateAccountGUIDs>UpdateAndExit</UpdateAccountGUIDs>
</Catalog>
7. Save and close the file.
8. Start all Oracle BI system components using the Enterprise Manager Fusion
Middleware Control GUI.
9. Presentation Services should fail to come up but should not throw any errors. If an error is presented to you in the resulting start-up prompt, you most likely have a syntax error resulting from editing of the configuration files.

10. While the other services are started and the Presentation Services system component is down, open the NQSConfig.INI file again for editing.
11. In the NQSConfig.INI file change the value of FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = YES;to FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = NO.
12. Save and close the NQSConfig.INI file.
13. Open the instanceconfig.xml file again for editing.
14. Modify the instanceconfig.xml file by changing the value of the recently
added UpdateAccountGUIDs subelement from UpdateAndExit to none:
<Catalog>
<UpgradeAndExit>false</UpgradeAndExit>
<UpdateAccountGUIDs>none</UpdateAccountGUIDs>
</Catalog>

15. Save and close the file.
16. Restart all system components using the Enterprise Manager GUI.
17. Once the system components have been started, open the analytics portal using the default URL, http://server_name:9704/analytics/.
18. Login with the WebLogic administrator’s credentials.
19. The log in should be successful. If so, log out.