OBIEE 11g: Error: '[Nqserror: 43126] Authentication Failed: Invalid User/Password' when Logging into Answers

To Bottom

---

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.3.0 [1905] and later
Business Intelligence Suite Enterprise Edition - Version 11.1.1.3.0 [1905] and later
Information in this document applies to any platform.

Symptoms

The BISystemUser in OBIEE 11g (the Administrator User set up during the installation) is unable to log into Answers. But you can log in to Enterprise Manager (EM) and WebLogic Server (WLS) Administration Console without problem as this user.
The BI Server generates the following error:

[nQSError: 43126] Authentication failed: invalid user/password

The Managed Server generates the following error:

<Nov 11, 2010 12:54:49 AM PHT> <Notice> <Security> <server1.companyname.com> <bi_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1289408089797> <BEA-090078>

ver1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1289408089797> <BEA-090078> <User bisystemuser in security realm myrealm has had 5 invalid login attempts, locking account for 30 minutes.>

Cause

The BISystemUser account has become locked.

Solution

You have to create a new user with the same privileges and permissions:

1. Log in to the WebLogic Server Administration Console.
2. Create a new user and assign it to the Administrators Group.
3. Log in to Enterprise Manager to Add this new user to 'BISystem' Role.
4. Navigate to 'Weblogic Domain > bifoundation_domain'
5. Right click on bifoundation_domain.
6. From the resulting menu, click on Security/Credentials menu item
7. In the Credentials Screen expand oracle.bi.system.
8. Choose 'system.user' and click 'Edit'
9. In the resulting pop-up window, enter the new user name and password
10. Re-start the OBIEE components, Managed Server and Admin Server.
11. After ten minutes log in to Answers as the new user.