OBIEE 11g: Listing the Members of an Application Role in the Identity Manager in the RPD Throws the Error: [nQSError: 46169] An HTTP operation timed out after 420 seconds. Operation aborted.

(Doc ID 2223248.1)

Last updated on FEBRUARY 09, 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

An Administrator opens the RPD in Online mode in the BI Admin Tool and navigates to Manage > Identity > BI Repository - Application Roles.   See multiple roles are listed like: BISystem, BIAdministrator, BIAuthor etc.

The user double-clicks on the 1st role (BISystem), and the members (users) of the role are listed.

The user double-clicks on the 2nd role (BIAdministrator) or any other subsequent role, and after some time, see the following error is thrown:-

 

The following "stuck thread" message is observed in the Managed Server log (bi_server1.log):-

... <BEA-000337> <[STUCK] ExecuteThread: '21' for queue: 'weblogic.kernel.Default (self-tuning)' has been busy for "636" seconds working on the request "weblogic.servlet.internal.ServletRequestImpl@1161d272[
...
]", which is more than the configured time (StuckThreadMaxTime) of "600" seconds. Stack trace:
java.net.SocketInputStream.socketRead0(Native Method)
java.net.SocketInputStream.read(SocketInputStream.java:129)
oracle.net.nt.MetricsEnabledInputStream.read(TcpNTAdapter.java:730)
oracle.net.ns.Packet.receive(Packet.java:302)
oracle.net.ns.DataPacket.receive(DataPacket.java:108)
oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:317)
oracle.net.ns.NetInputStream.read(NetInputStream.java:262)
oracle.net.ns.NetInputStream.read(NetInputStream.java:187)
oracle.net.ns.NetInputStream.read(NetInputStream.java:104)
oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:126)
oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:82)
oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1178)
oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:314)
oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1315)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1441)
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)
weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
oracle.ods.virtualization.engine.backend.db.DBEntrySet2.hasMoreInternal(DBEntrySet2.java:307)
oracle.ods.virtualization.engine.backend.db.DBEntrySet2.initialize(DBEntrySet2.java:187)
oracle.ods.virtualization.engine.backend.db.DBEntrySet2.initialize(DBEntrySet2.java:173)
oracle.ods.virtualization.engine.backend.db.BackendDB.getMatches(BackendDB.java:2151)
oracle.ods.virtualization.engine.backend.db.BackendDB.getMatches(BackendDB.java:1838)
oracle.ods.virtualization.engine.backend.db.BackendDB.get(BackendDB.java:886)
...
oracle.ods.virtualization.operation.SearchOperation.process(SearchOperation.java:203)
oracle.ods.virtualization.operation.SearchOperation.process(SearchOperation.java:47)
oracle.ods.virtualization.service.DefaultVirtualizationSession.processOperation(DefaultVirtualizationSession.java:384)
oracle.ods.virtualization.service.DefaultVirtualizationSession.search(DefaultVirtualizationSession.java:173)
oracle.ods.virtualization.service.DefaultVirtualizationSession.search(DefaultVirtualizationSession.java:161)
oracle.ods.virtualization.service.DefaultVirtualizationSession.search(DefaultVirtualizationSession.java:154)
oracle.security.idm.providers.libovd.util.LibOVDIdentityRelationsSearchResponse.fetchNextIdentity(LibOVDIdentityRelationsSearchResponse.java:204)
oracle.security.idm.providers.libovd.util.LibOVDIdentityRelationsSearchResponse.hasNext(LibOVDIdentityRelationsSearchResponse.java:126)
oracle.security.idm.providers.libovd.LibOVDSearchResponse.hasNext(LibOVDSearchResponse.java:79)
oracle.bi.security.service.URIdentityStoreProvider.collectUsersFromSearchResponse(URIdentityStoreProvider.java:295)
oracle.bi.security.service.URIdentityStoreProvider.collectUsersFromGroups(URIdentityStoreProvider.java:140)
oracle.bi.security.service.GetRoleUsersAction.execute(GetRoleUsersAction.java:112)
oracle.bi.security.service.GetRoleUsersAction.execute(GetRoleUsersAction.java:24)
oracle.bi.security.service.AbstractSecurityServiceAction$1.run(AbstractSecurityServiceAction.java:139)
java.security.AccessController.doPrivileged(Native Method)
oracle.bi.security.service.AbstractSecurityServiceAction.invoke(AbstractSecurityServiceAction.java:134)
oracle.bi.security.service.SecurityServiceBean.getRoleUsersWithPropertiesByTenant(SecurityServiceBean.java:415)
.....
>

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