OTBI Agent Fails While Adding Application Roles In Recipients (Doc ID 3027205.1)

Last updated on JUNE 21, 2024

Applies to:

Symptoms

On : 11.13.23.07.0 version, Analytics

OTBI Agent fails while adding application roles in recipients

The requirement is to burst those reports to all the users with specific roles : sales representative , sales manager and sales administrator.

The agent is working fine when we add a direct E-mail or Users but the agent is failing when I try to add roles in the recipients.

Below is the error:



ERROR
-----------------------
AGEGTYVF,UMSSP69Z, HTTP error code: '500'.[nQSError: 77006]
[nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: Soap invocation to security service failure. HTTP error code: '500'.
Error Codes: UMSSP69Z
Location: saw.security.BISecurityIdentityService.getRoleUsers, saw.security.userpopulationmanagerimpl.directmembers, saw.delivers.rpc.getMetadata, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads
.
Error Codes: AGEGTYVF
, in call Session openIBot AgentID: /users/pooja.kumari/30 days contract reminder agent
  ...Trying main Agent loop again.... Sleeping for 5 seconds.[nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: Soap invocation to security service failure. HTTP error code: '500'.
Error Codes: UMSSP69Z
Location: saw.security.BISecurityIdentityService.getRoleUsers, saw.security.userpopulationmanagerimpl.directmembers, saw.delivers.rpc.getMetadata, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads
.
Error Codes: AGEGTYVF
, in call Session openIBot AgentID: /users/pooja.kumari/30 days contract reminder agent
  ...Trying main Agent loop again.... Sleeping for 6 seconds.[nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: Soap invoca



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log in to BI > Edit OOTB BI Agent > Click on Recipients tab > Provide Job roles instead of user names > throws error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot burst the report based on the roles.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.