Sunil S. Ranka's Weblog

Superior Data Analytics is the antidote to Business Failure

Issue with OBIEE 11.1.1.5 GUID Referesh Documentation

Posted by sranka on June 23, 2011

Hi All

Several blogs have been written on detail step for Refreshing the User GUIDs, the oracle documents also details the steps. You can refer Oracle’s Document On How To Refresh GUIDs. But there is one key difference between the documented steps and the actual reality. After performing all the steps, you will see that your presentation server is taking too long to start. 

In Nutshell following are the steps :

  • In NQSConfig.INI file Locate the setting FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = NO and change its value to YES.
  • Modify the instanceconfig.xml file to instruct Presentation Services to refresh GUIDs on restart. Edit the file to add the last line in the following instruction.                                                                                                                                              <ps:Catalog xmlns:ps=”oracle.bi.presentation.services/config/v1.1″>
    <ps:UpgradeAndExit>false</ps:UpgradeAndExit>
    <ps:UpdateAccountGUIDs>UpdateAndExit</ps:UpdateAccountGUIDs>
  • Stop and restart the managed processes using the opmnctl parameters stopall and startall.
  • Edit NQSConfig.INI file to reset the FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = YES to NO and restart the Oracle BI Servers.
  • Comment UpdateAccountGUIDs , where  in document its mentions to Remove, set to none, or comment out

 

To avoid that issue, instead of making “UpdateAccountGUIDs” to “none” , you will need to comment the whole tag and than restart the services.

Hope This Helps

Sunil S Ranka
“Superior BI is the antidote to Business Failure”

Advertisements

One Response to “Issue with OBIEE 11.1.1.5 GUID Referesh Documentation”

  1. yeah, I have the same problem…..

    […]Issue with OBIEE 11.1.1.5 GUID Referesh Documentation « Sunil S. Ranka’s Weblog[…]…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: