[OBIEE 11g] Authentication Error after Environment Migration

During an Environment migration Authentication errors might result if the GUIDs are not refreshed and the system detects a mismatch for the user GUID.

To Resolve this Authentication errors that occurs during migration do the following steps exactly.

To refresh the user GUIDs:

1. Open the NQSConfig.INI file for editing. 
   
   
2. Locate the setting 
   
   FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = NO 
   
   and change its value to YES.
   
   
3. Modify the instanceconfig.xml file to instruct Presentation Services to refresh GUIDs on restart. Edit the file and find the following section:
   
   

   <Catalog>
      <UpgradeAndExit>false</UpgradeAndExit>
   </Catalog>
   

   Comment out the <UpgradeAndExit> line and add an extra line in this section as in the following example:
   
   

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

4. Stop and restart the managed processes using the opmnctl command with the parameters stopall and startall. You can use the parameter status to verify process status throughout.
   The following components are involved: Presentation Services, Oracle BI Server, Oracle BI Scheduler, Oracle BI Cluster Controller, and Oracle BI JavaHost.
   
   
   
5. Edit the NQSConfig.INI file to reset the FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = YES to NO and restart the Oracle BI Servers.
   
   
6. Comment out the line added in Step 3 and remove the commenting from the original line so that it reads as shown in the following example:
   
   

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

   
   </Catalog>
   

7. Restart Presentation Services for the instanceconfig.xml file that was updated.
   
   
8. Ensure that Oracle WebLogic Server and the system components are also running. If they are not running, then restart them.