My Oracle Support Banner

OBIEE 11g Queries Returning Large Data Sets Hangs During DXE Execution Step With SSL Enabled (Doc ID 1967794.1)

Last updated on MARCH 04, 2019

Applies to:

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


Large reports are hanging on the DXE Execution step as seen when monitoring through Analytics Administration link >> Manage Sessions.

Issue is more consistent with larger reports having millions of rows, although reports with only 100,000 have hung as well.

Tracing the issue using SQL*Net shows rows being fetched, but also an  ORA-01403 - no data found error at the end of the trace.

The ORA error in the SQL*Net trace is not always seen when the issue is recreated.

Can run the same request again right away and it may work this time.  Issue is not consistent.


To view full details, sign in with your My Oracle Support account.

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

In this Document

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