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

Last updated on AUGUST 22, 2016

Applies to:

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

Symptoms

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.

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