OBIEE 11g - Users Unable to Login in Analytics Page Using WebLogic Credentials (Doc ID 2019894.1)

Last updated on JULY 18, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

Unable to log-in to analytics with weblogic credential.

You may find the following error messages in Saw log and Managed server log:

[2015-06-11T15:27:31.000-10:00] [OBIPS] [ERROR:31] [] [saw.connectionPool.getConnection] [ecid: a890535a022cbaf2:-2a0ecc81:14de46de645:-8000-000000000000390d,0:1:1] [tid: 3480] Authentication Failure.
Odbc driver returned an error (SQLDriverConnectW).
State: 08004. Code: 10018. [NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for the requested connection is refused.
[nQSError: 43113] Message returned from OBIS.

[2015-06-11T15:37:11.851-10:00] [bi_server1] [ERROR] [OBI-SEC-00003] [oracle.bi.security.service] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 00iThpZIVySFw0zvvz06fz1^L6E1jomzi0001GO000000,0:1014:6:3] [APP: bisecurity#11.1.1] [J2EE_APP.name: bisecurity_11.1.1] [J2EE_MODULE.name: bisecurity] [WEBSERVICE.name: SecurityWebService] [WEBSERVICE_PORT.name: SecurityWebServicePort] Error during initialization[[
oracle.bi.security.service.SecurityServiceException: SecurityService::validateSystemUserPermissionGrantsSystem user has not been granted required permission oracle.bi.server.impersonateUser

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms