OBIEE 11g & 12C: GUID Refresh:

Sometimes, when migrating between environments the GUIDs become out of sync, resulting in an authentication error when trying to sign in to presentation services. Follow the below steps to refresh the GUIDs.

ERROR:

“An error occurred during authentication. Try again later or contact your system administrator”.

Follow the below steps to GUID refresh.

1. Update the FMW_UPDATE_ROLE_AND_USER_REF_GUIDS parameter in NQSConfig.INI:

2. Take backup of NQSConfig.INI file.

a. Open NQSConfig.INI for editing at:

OBIEE 11g: ORACLE_INSTANCE/config/OracleBIServerComponent/coreapplication_obis1
OBIEE 12c: Middleware_Home/user_projects/domains/bi/config/fmwconfig/biconfig/OBIS

b. Locate the FMW_UPDATE_ROLE_AND_USER_REF_GUIDS parameter and set it to YES, as  follows:
FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = YES;

c. Save and close the file.

3. Update the Catalog element in instanceconfig.xml:

4. Take backup of instanceconfig.xml file.

a. Open instanceconfig.xml for editing at:

OBIEE 11g: ORACLE_INSTANCE/config/OracleBIPresentationServicesComponent/coreapplication_obips1
OBIEE 12c: Middleware_Home/user_projects/domains/bi/config/fmwconfig/biconfig/OBIPS

b. Locate the Catalog element and update it as follows:

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

c. Save and close the file

5. Restart the services

cd MW_HOME/instances/instance1/bin

./opmnctl stopall
./opmnctl startall

Note: Presentation Services may fail to start. Presentation Services refreshes the GUIDs and then shuts down due to the UpdateAccountGUIDs setting.

6. Set the FMW_UPDATE_ROLE_AND_USER_REF_GUIDS parameter in NQSConfig.INI back to NO.

7. Update the Catalog element in instanceconfig.xml to change the value of the recently added UpdateAccountGUIDs sub-element from UpdateAndExit to none:.

8. Restart the Oracle Business Intelligence system OPMN components again using opmnctl:

cd MW_HOME/instances/instance1/bin

./opmnctl stopall
./opmnctl startall

9. Retest the issue.