RSS

How to Solve OBIEE 11G Authentication failure issue

26 Aug

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

Advertisements
 
15 Comments

Posted by on August 26, 2011 in BI Publisher, OBI EE, OBIEE 11g

 

15 responses to “How to Solve OBIEE 11G Authentication failure issue

  1. Rajkiran Taraka

    August 29, 2011 at 2:47 pm

    The root cause of the issue is web catalog corruption. Deleting users from the Weblogic did not refresh the cached info. After deleting the following files for weblogic and Administrator user, there are no issues.

    \Middleware\instances\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\EnterpriseBusinessAnalytics\root\users\weblogic\_prefs
    cachedinfo
    cachedinfo.atr

    Another solution is to clean up the catalog by using the following settings in the instanceconfig.xml

    OnStartup
    None
    None
    Clean
    None

    After restarting the services, users were able to login with no issues.

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

     
    • Rajkiran Taraka

      August 29, 2011 at 2:48 pm

      \Middleware\instances\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\EnterpriseBusinessAnalytics\root\users\weblogic\_prefs
      cachedinfo
      cachedinfo.atr

      Another solution is to clean up the catalog by using the following settings in the instanceconfig.xml

      OnStartup
      None
      None
      Clean
      None

      After restarting the services, users were able to login with no issues.

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

       
    • Rajkiran Taraka

      August 29, 2011 at 2:49 pm

      Siva- Its Not allowing to send tags or Spl character.

       
      • Shiva Molabanti

        September 2, 2011 at 4:30 pm

        Raj,
        That’s what I mentioned in Post rt? 🙂 Instead of deleting manually, The steps I mentioned will do that too..

         
    • KrishnaKumar

      October 21, 2012 at 10:15 am

      Thanks..a ton…It resolved my issue….

       
  2. Sovitendu

    September 26, 2011 at 10:16 am

    Hi Shiva,
    I followed the steps mentioned by you, but iam still unable to log into the system.

    Could you please help.

    Regards,
    Sovi

     
  3. Joseph

    November 9, 2011 at 7:35 pm

    Hi Shiva,

    I tried the same. First refreshed the GUIDs as mentioned in the Oracle Documentation and then weblogic user was able to login successfully on the new machine. However weblogic not able to reach his ‘My Dashboard’. So I tried your recommended changes in instanceconfig.xml and restarted all BI Servers using opmnctl. Unfortunately weblogic is still not able to reach /My Dashboard’. Is there any thing which I am missing?

     
  4. Balamurugan S

    December 5, 2011 at 8:38 am

    Shiva,

    I tried both the options but still I am not able to access “My Folders” link. Error message is “access denied for user to path /users/…” Kindly help in fixing this issue

    Regards,
    Balamurugan

     
  5. Prashant

    May 16, 2013 at 7:11 am

    This was very helpfull in my case and its only the solution it worked for me. I try ed a lot to fix login issue. finaly this blog saved me to reinstall OBIEE. Thx a lot

     
  6. Srinivas Chindam

    August 16, 2013 at 9:28 pm

    Hi All,

    This is very useful topic and comments as well.

    On development server some one tried configuring AD Authentication with OBIEE 11g but was not successful.
    When am trying to login to presentation services login fails as “invalid user ID and password”.

    So when tried to debug in em and AD
    1) The default BI groups are missing like BI Administrators , BI Authors and BI Consumers groups are missing though default Roles are existing.
    2) Some other custom groups are loaded
    Not sure why and how it all happened.

    So now am trying resolve the issue.

    planning to remove or clean complete AD authentication and want to login with just WLS LDAP authentication first.

    if so to clean the AD Authentication and come back to default WLS config.

    Please suggest.

     
  7. Srinivas Chindam

    August 16, 2013 at 9:30 pm

    if so how to clean the AD Authentication and come back to default WLS config.

    Please suggest.

    Regards
    Srinivas Chindam

     
  8. arparihar

    February 10, 2014 at 6:37 pm

    Thanks guru …. it worked for me….. putting your reference on my blog

     
  9. anjan

    October 15, 2015 at 6:33 pm

    I have done all the aove mentioned steps but still when I am trying to login. I am getting error and showing “Account not found” in sawlog.

     
  10. Vyshak

    November 10, 2015 at 8:13 am

    Hi Shiva

    I tried the following steps. But the BI Presentation services are down after restarting the BI services from EM. Please help

    Regards
    Vyshak

     
  11. srinivas

    February 20, 2017 at 7:41 am

    Hi Shiva,

    One of the user is facing issue while accessing BIP report from OBIEE analytics,
    while accessing the report one pop up is getting asking for credentials.
    We observed that the user is having proper role assigned and the user is able to login OBIEE analytics.

    Can you please help to resolve the issue

     

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: