OBIEE12c: Once Login with Default Authenticator User, the Legacy External Table Authentication User cannot Login Again

(Doc ID 2231932.1)

Last updated on MARCH 14, 2017

Applies to:

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

Symptoms

On : 12.2.1.2.0 version

Setting up an External Table Authentication by the following documentation.

http://docs.oracle.com/middleware/12212/biee/BIESC/GUID-A97ABA69-743D-4001-94DC-AF748965AED0.htm#BIESC310

You can login BIEE with the External Table User.

Once you login with Default Authenticator User (such as weblogic), the Legacy External table Authentication User cannot login again.

bi_server1-diagnostic.log shows the following error message:

 [2016-12-29T00:18:25.590+00:00] [bi_server1] [ERROR] [][oracle.webservices.service] [tid: [ACTIVE].ExecuteThread: '3' for queue:
'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid:a77870c9-f385-4016-8ed8-b3b3f0b88f7f-000048a4,0] [APP: bi-security]
[partition-name: DOMAIN] [tenant-name: GLOBAL] [SI-Key: ssi] An error occurred for port: {http://oracle/bi/security/ws/}SecurityWebServicePort:
oracle.webservices.provider.ProviderException:
javax.xml.ws.WebServiceException: [OBI-SEC-00111] FailedAuthentication: BI Security access is denied - web service credentials are invalid..
[2016-12-29T00:18:30.588+00:00] [bi_server1] [NOTIFICATION] []
[oracle.bi.security.service] [tid: [ACTIVE].ExecuteThread: '5' for queue:
'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid:a77870c9-f385-4016-8ed8-b3b3f0b88f7f-000048a7,0] [APP: bi-security]
[partition-name: DOMAIN] [tenant-name: GLOBAL] [J2EE_APP.name: bi-security][J2EE_MODULE.name: bi-security] [WEBSERVICE.name: SecurityWebService][WEBSERVICE_PORT.name: SecurityWebServicePort] [SI-Key: ssi][SecurityService][oracle.bi.security.ws.runtime.ValidateExternalRolesAction::execute][OBI-SEC-00014] BI Security Service caught an unexpected error[[oracle.bi.security.ws.runtime.SecurityServiceException: [SecurityService]
[oracle.bi.security.ws.runtime.ValidateExternalRolesAction::execute][OBI-SEC-00014] BI Security Service caught an unexpected error
at
oracle.bi.security.ws.runtime.ValidateExternalRolesAction.execute(ValidateExternalRolesAction.java:182)
at
oracle.bi.security.ws.runtime.ValidateExternalRolesAction.execute(ValidateExternalRolesAction.java:33)

......

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:406)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:346)
Caused by:
oracle.security.jps.service.policystore.PolicyObjectNotFoundException:
JPS-10151: Application role authenticated-role does not exist
at
oracle.security.jps.internal.policystore.entitymanager.impl.ApplicationRoleManagerImpl.getApplicationRole(ApplicationRoleManagerImpl.java:4518)
at
oracle.security.jps.internal.policystore.entitymanager.impl.ApplicationRoleManagerImpl.getAppRole(ApplicationRoleManagerImpl.java:5892)
at
oracle.security.jps.internal.policystore.ldap.ApplicationRoleAuditManager.getAppRole(ApplicationRoleAuditManager.java:444)
at
oracle.bi.security.ws.runtime.ValidateExternalRolesAction.execute(ValidateExternalRolesAction.java:84)
... 59 more

]]
[2016-12-29T00:18:30.604+00:00] [bi_server1] [WARNING] [][oracle.webservices.jaxws] [tid: [ACTIVE].ExecuteThread: '5' for queue:
'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid:a77870c9-f385-4016-8ed8-b3b3f0b88f7f-000048a7,0] [APP: bi-security]
[partition-name: DOMAIN] [tenant-name: GLOBAL] [J2EE_APP.name: bi-security][J2EE_MODULE.name: bi-security] [WEBSERVICE.name: SecurityWebService]
[WEBSERVICE_PORT.name: SecurityWebServicePort] [SI-Key: ssi] Exception while executing the business logic: [SecurityService][oracle.bi.security.ws.runtime.ValidateExternalRolesAction::execute]
[OBI-SEC-00014] BI Security Service caught an unexpected error

Issue does not happen in 12.2.1.1 and before.

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