OBIEE 11g Answers Report Hangs When Clicking on the 2 Down Arrows to Display 'All Rows' or the Last Page of the Report (Doc ID 1958962.1)

Last updated on AUGUST 24, 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

When creating a report with 3 OBIEE columns with 80k rows of data, the query runs fast and displays the results. However when clicking 2 down arrows to go to the last page of data respectively display "all rows", the report will hang and have problem to move/add/remove/sort column.

This is the case with many subject areas.

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