Hyperion IR Fails To Response When User Conduct A Query Which Takes a Long Time to Run

(Doc ID 1919545.1)

Last updated on AUGUST 08, 2016

Applies to:

Hyperion BI+ - Version and later
Information in this document applies to any platform.


We have developed a BQY report with data model and metatopics. Users by then use the report to construct their own query on IRWC.

User reported that after they define the query and process the report, the IRWC keep running for hours and does not return with any data. The status bar kept showing "Retrieving data". We checked that the query was successfully submitted to the database server and the database server had completed the query around 20 minutes after the user submission. The results is around 70,000 rows. However the IRWC cannot receive any response and keep waiting.

We asked the user to remove 1 of the filtering criteria and process the report again. The database query runs in 3 minutes and generate a result around 240,000 rows. This time the IRWC can retrieve the data successfully.

We simulate the above with different users ID and different PC, there result is the same. Therefore this problem is not user or PC specific.


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