Thursday, October 18, 2012

[OBIEE 11g] Refresh User Guid's


Refresh User GUID's - OBIEE 11G

- Update the user GUIDs after changing the directory server used as the data source for the authentication provider. If the same user name exists in both directory servers (original and new), the original user GUID may conflict with the user GUID contained in new directory server. 


 A refresh forces the system to reference the user GUID contained in the new directory server. Authentication errors may result if the GUIDs are not refreshed and the system detects a mis-match for the user GUID.

To refresh the user GUIDs:


1.Open the NQSConfig.INI file for editing.Locate the setting FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = NO and change its value to YES.



2. Modify the instanceconfig.xml file to instruct Oracle BI Presentation Server to refresh GUIDs on restart.  Edit the file to add the last line in the following instruction



      3. <ps:Catalog xmlns:ps="oracle.bi.presentation.services/config/v1.1">           <ps:UpgradeAndExit>false</ps:UpgradeAndExit> <ps:UpdateAccountGUIDs>UpdateAndExit<ps:UpdateAccountGUIDs>




From a terminal window, stop and restart the managed processes using the opmnctl parameters stopall and startall. You can use the parameter status to verify process status throughout.



1. Edit the NQSConfig.INI file to reset the FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = YES to NO and restart the Oracle BI Servers.



2. Remove, set to none, or comment out the line (see UpgradeAndExit in the following example) added to the instanceconfig.xml file (that instructs Oracle BI Presentation Server to refresh GUIDs on restart).

<ps:Catalog xmlns:ps="oracle.bi.presentation.services/config/v1.1">

<ps:UpgradeAndExit>false</ps:UpgradeAndExit>

<ps:UpdateAccountGUIDs>none<ps:UpdateAccountGUIDs>

Restart the Presentation Server for the instanceconfig.xml file that was updated.



3.Make sure Oracle WebLogic Server and the system components are also running, if they are not running, restart them.


2 comments:

  1. https://ssssupport.blogspot.com/2013/03/tableau-measure-names-and-measure.html?showComment=1633926946891#c2853555650989489167

    ReplyDelete
  2. Thanks for helping us understand this topic. you have written it in a way that makes it
    very simple to understand. Thanks you so much.

    click here

    ReplyDelete