How to Solve OBIEE 11G Authentication failure issue

After you migrate your RPD and Web Catalog t new environment,it is best practice to update the user GUIDs. If the same user name exists in both directory servers (original and new), then the original user GUID might conflict with the user GUID that is contained in new directory server. A refresh forces the system to reference the user GUID that is contained in the new directory server. Authentication errors might result if the GUIDs are not refreshed and the system detects a mismatch for the user GUID. And even after GUIDS referesh OBIEE 11g System will cache the UserID in webcatalog and always the cached ID will be callup instead of new GUID for User.This wrong GUID calling will leads to Authentication failure errors. Sometimes we can delete the user and recreate to solve this. But, This recreation of same user again miss its ID reference for Catalog objects.And We will end up with Missing My Folders and other objects. Because OBIEE 11G maps the RPD objects and Catalog objects based on system assigned GUID.To solve this we need to validate the Useraccounts to map the OBIEE RPD and Catalog object links.

To do this perform the following steps

1) Backup Instanceconfig.xml file from location:

<Middleware_HOME>\instances\instance1\config\OracleBIPresentationServicesComponent\

coreapplication_obips1\instanceconfig.xml

2) Open instanceconfig.xml, And update it with the content specified as following:

<Catalog>

<UpgradeAndExit>false</UpgradeAndExit>

<Validate>OnStartup</Validate>

<ValidateItems>None</ValidateItems>

<ValidateLinks>None</ValidateLinks>

<ValidateAccounts>Clean</ValidateAccounts>

<ValidateHomes>None</ValidateHomes>

</Catalog>

3) Save the file and re-start all of the BI Services through Enterprise Manager.

4) Now yo should be able to login to OBIEE 11g and you can see all your artifacts like My Folder content.

Once resolved, dont forget to remove the settings used to clean up the Cached catalog accounts in instanceconfig.xml. Restart the services. Test the login to make sure there are no issues.

Thanks,

Shiva