My Oracle Support Banner

OBIEE 11.1.1.6 Agent failed with Error Codes: IHVF6OM7:OPR4ONWY:U9IM8TAC [nQSError: 13039] The impersonator does not exist in the BI Security Service (Doc ID 1446877.1)

Last updated on AUGUST 15, 2019

Applies to:

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

Goal

In OBIEE 11.1.1.6, using Agent. It failed to deliver to external OID LDAP users to any of the
destinations(dashboard or delivery profile) and is hit with below errors.

[nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred
while processing the request. The server responded with: Authentication
Failure.
Error Codes: IHVF6OM7:OPR4ONWY:U9IM8TAC
Location: saw.connectionPool.getConnection,
saw.securitysubsystem.checkauthentication.runimpl,
saw.securitysubsystem.checkauthentication, saw.delivers.rpc.getDeviceContent,


saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection,
saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads
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.
[nQSError: 13039] The impersonator does not exist in the BI Security Service.
(08004)


Error Codes:
Location: saw.delivers.rpc.getDeviceContent, saw.rpc.server.responder,
saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch,
saw.threadpool.socketrpcserver,saw.threads


Have already checked to ensure the €œBISystemUser€ exists with the correct credentials.

The managed server logs show the following error:
Identity found "user.lastname@abc.com" but could not be asserted.

This issue is affecting OBIEE 11.1.1.6.0 customers who use impersonation in some way (SSO, Delivers etc) if they have users where the LDAP Attribute holding the User Login ID has a different value to the LDAP attribute holding the User Name.

This is particularly common for customers using Active Directory or if they use the email ID to logon rather then the userID.

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.