How to do the (in)famous "Refresh GUIDs" process

• Modify Presentation Server "instanceconfig.xml", under ServerInstance - Catalog, ensure the the setting "UpdateAccountGUIDs" is set to UpdateAndExit:

         <ServerInstance>
           <Catalog>
             <UpgradeAndExit>false</UpgradeAndExit>             <UpdateAccountGUIDs>UpdateAndExit</UpdateAccountGUIDs>           </Catalog>
         </ServerInstance>

• Modify BI Server "NQSConfig.INI", in the section "SERVER", change the FMW_UPDATE_ROLE_AND_USER_REF_GUIDS setting to YES:

         [SERVER]
         FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = YES;

• Go to $ORACLE_INSTANCE\bin (usually <install_dir>\instances\instance1\bin) and stop the BI Server and Presentation server:

         opmnctl stopproc ias-component=coreapplication_obis1
         opmnctl stopproc ias-component=coreapplication_obips1

• Start the two processes again in the right order (BI Server, then Presentation Server) - might take a bit longer that usual:

          opmnctl startproc ias-component=coreapplication_obis1
          opmnctl startproc ias-component=coreapplication_obips1
        

• The Presentation Server will shut down when the process is completed. To see that it completed succesfully, the following should be present in the newest sawlog file ($ORACLE_INSTANCE/diagnostics/logs/OracleBIPresentationServicesComponent/coreapplication_obips1/sawlog3.log)

[2014-11-04T12:23:31.000+01:00] [OBIPS] [NOTIFICATION:1] [] [saw.subsystem.catalog.initialize.upgrade] [ecid: ] [tid: ] Succeeded in updating account GUIDs from back end user population store[[

• Modify BI Server "NQSConfig.INI", in the "SERVER" section, set FMW_UPDATE_ROLE_AND_USER_REF_GUIDS back to NO

         [SERVER]
         FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = NO;

• Modify Presentation Server "instanceconfig.xml"Modify Presentation Server "instanceconfig.xml", under ServerInstance - Catalog, ensure the the setting "UpdateAccountGUIDs" is deleted or commented out:

         <ServerInstance>
           <Catalog>
             <UpgradeAndExit>false</UpgradeAndExit>
             <!--UpdateAccountGUIDs>UpdateAndExit</UpdateAccountGUIDs-->           </Catalog>
         </ServerInstance>

• Start Presentation Server again:

           opmnctl startproc ias-component=coreapplication_obips1

Once the Presentation Server is running again, you should be ready to continue.