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 220.127.116.11.140715 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