OBIEE 11g Queries Returning Large Data Sets Hangs During DXE Execution Step With SSL Enabled
Last updated on AUGUST 22, 2016
Applies to:Business Intelligence Server Enterprise Edition - Version 18.104.22.168.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.
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