FIX OBIEE 11g Authentication Error after Environment Migration | The Big Data - Business Intelligence by Sandeep Venu

Enter key word

FIX 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.




    Thanks,
    Sandeep


SHARE

About test

    Blogger Comment
    Facebook Comment

3 comments:

Unknown said...

I had the similar problem but as I am new to OBIEE 11g,just had few questions;
I have a RPD with a password which is different from the weblogic.Would you please tell me with what password I need to log in into presentation services the weblogic password or RPD password because with both of the password its not allowing to log in .

test said...

Hi Aparajita,

I guess you have already upgraded your rpd to your current obiee version:

assuming that then do the following:

Open your rpd and delete the existing weblogic user from the identity tab.

Once this is done, refresh the GUID as shown in this post.

after this restart the services and you should be able to login with your weblogic use now..

reach out to me if you have any issues..

sandeepv710@gmail.com

Gaurav Misra said...

Good Information... but point-4 needs little addition. We have to wait for presentation server component to come down while opmn bounce, then proceed with further steps. Rest all well explained.. :) (y)

Top Links

Upgrading BI Publisher

Add Google Search

OBIEE- LDAP

Change Admin Password

Best Practices

ORACLE 11GR2

Host Files

Customization

OBIEE-SIEBEL

Bug Fixes

Setting Default

OBIEE Installation failed

OBIEE Installation

Oracle Databse

Oracle In Linux

Loopback Adapter

Weblogic Failed

Yum Commands

Weblogic Admin

Linux Static IP

OBIEE LDAP

Admin Paswword

Scaling

Weblogic Starting Error

Localizing BI

Physical Schemas

Multimedia Dashboard

Video in OBIEE

Variables in OBIEE

Ago 30 Days

Email Link

ODI Installation

AGO Function

Sort Pivote table

OBIEE Patch

Reset Sys password

Date Calculation

Add Row in Report

Increase Row limit

OBIEE with Essbase

Reset Weblogic

BIP Login Error

MDS and BI Platform

ORA 28001 Error

ORA 12560 TNS Protocal Error

ORA 12154 TNS Error

OBIEE ON AIX

Pre Requsite

AIX Commands

Commands