Oracle Business Intelligence Application Architect
☎ +91 9994883085
Don't miss

Sunday, 16 February 2014

LOGIN FAILED WHILE OPENING RPD IN ONLINE MODE IN OBIEE 11G


By on 06:34:00


FOLLOWING REASONS AND STEPS.

Login Failed Due to Invalid User Name and Password.

Reasons:

1.      This is because of wrong username and password.
2.      Sometimes Authentication not properly updated in GUID.
3.      Not able to create system user connection while Oracle Bi server startup.
4.      Due to lock of user in the database.

Error Details:
Logon failed due to: [nQSError: 43113] Message returned from OBIS.
[nQSError: 43126] Authentication failed: invalid user/password.
[nQSError: 37001] Could not connect to Oracle BI Server instance.



Check the password which you are giving is correct or not.
Check the username too, sometimes the username will take or assign as coreapplication change this to weblogic.

You will get login to the RPD in online mode. 


Changing username: Coreapplication to weblogic.

Then Login or open the RPD. Successfully you will get login.




If Not opened, try to go in another way.
Because of Authentication failure the RPD will not open also.

Error:
"Unable to Sign in An error occurred during Authentication" Error When A User Logs In OBIEE

Solution:
Open the RPD in offline mode,

Go to Manage (tab)à Identity in the users list check the user name weblogic is found or not.
If yes delete the user and save the RPD.


Use the saved RPD in EM à Coreapplicationà RPD.

Restart all the services. Then try to login in RPD .you will get successfully login.

Regenerating GUID (Refreshing the users)
Go to the location “\11G\instances\instance1\diagnostics\logs\Presentation, server components folders”.
Check the Logs. If any logs produce with an error you have to regenerate the GUID.

How to regenerate GUID. According to oracle documents. Change in the NQS Config file.
Take a backup of the files which you are going to edit.

Update the FMW_UPDATE_ROLE_AND_USER_REF_GUIDS parameter in NQSConfig.INI:
    Open NQSConfig.INI for editing at:
    ORACLE_INSTANCE/config/OracleBIServerComponent/coreapplication_obisn
    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;
    Save and close the file.

Update the Catalog element in instanceconfig.xml:
    Open instanceconfig.xml for editing at:
    ORACLE_INSTANCE/config/OracleBIPresentationServicesComponent/    coreapplication_obipsn
    Locate the Catalog element and update it as follows:
    <Catalog>
    <UpgradeAndExit>false</UpgradeAndExit>
    <UpdateAccountGUIDs>UpdateAndExit</UpdateAccountGUIDs>
    </Catalog>
    Save and close the file.
Restart the Oracle Business Intelligence system components
Set the FMW_UPDATE_ROLE_AND_USER_REF_GUIDS parameter in NQSConfig.INI back to NO.
Important: You must perform this step to ensure that your system is secure.
Update the Catalog element in instanceconfig.xml to remove the UpdateAccount GUIDs entry.
Restart the Oracle Business Intelligence system components

Check the User Cache:
Go to the location,
D:\11G\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\SampleAppLite\root\users\weblogic\_prefs
Delete the file cacheduserinfo and  cacheduserinfo.atr files.
Then restart the services.
If the Errors shows like this,
Odbc driver returned an error (SQLDriverConnectW).
[nQSError: 10018] Access for the requested connection is refused.
[nQSError: 43113] Message returned from OBIS.
[nQSError: 43126] Authentication failed: invalid user/password.

Then there will be the account of the user in the database will be locked.
To unlock the Account, use the following query.
1.      Select username, account_status from dba_users;
2.      If the status is shows locked, please unlock the accounts.
3.      Alter user Dev_MDS account unlock;
4.      Alter user Dev_BIPLATFORM account unlock;
5.      Then the reset the password for the user accounts.
6.      Alter user Dev_MDS identified by Admin123;
7.      Alter user Dev_BIPLATFORM identified by Admin123;
Then the restart the BI Services and database services also.


0 comments:

Post a Comment

Blog Archive

Labels

1z0-482 Dumps (2) 1Z0-525 Dumps (1) BI Apps Installation (1) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (46) Informatica Online Training (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) Normalization in Oracle (1) OBIA 11.1.1.7.1 (1) OBIA 7.9.6.3 (3) OBIA Installation (33) OBIEE (1) OBIEE 10G (8) OBIEE 11G (137) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)