Union all report - Error Exceeded configured maximum number of allowed output prompts, sections, ro

User_R93U9

I have created report using union all of 4 reports. Total count of these four reports is around 600k.

I am getting Error Exceeded configured maximum number of allowed output prompts, sections, rows, or columns.

Table and pivot view settings seem fine to me. Does union report uses Chart or Cube section of instance config xml?

OBIEEE version : 11.1.1.9.5

Insance config file setting

<Cube>

<CubeMaxRecords>10000000</CubeMaxRecords>

<CubeMaxPopulatedCells>100000000</CubeMaxPopulatedCells>

</Cube>

<Pivot>

<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->

<DefaultRowsDisplayedInDelivery>100</DefaultRowsDisplayedInDelivery>

<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->

<DefaultRowsDisplayedInDownload>900000</DefaultRowsDisplayedInDownload>

<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->

<DisableAutoPreview>false</DisableAutoPreview>

<MaxPagesToRollOutInDelivery>1000</MaxPagesToRollOutInDelivery>

<MaxVisibleColumns>100000</MaxVisibleColumns>

<MaxVisiblePages>2500000</MaxVisiblePages>

<MaxVisibleRows>90000000</MaxVisibleRows>

<MaxVisibleSections>6000</MaxVisibleSections>

<DefaultRowsDisplayed>50</DefaultRowsDisplayed>

<MaxCells>99000000</MaxCells>

</Pivot>

<Table>

<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->

<DefaultRowsDisplayedInDelivery>100</DefaultRowsDisplayedInDelivery>

<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->

<DefaultRowsDisplayedInDownload>900000</DefaultRowsDisplayedInDownload>

<DefaultRowsDisplayedInDownloadCSV>900000</DefaultRowsDisplayedInDownloadCSV>

<MaxVisiblePages>2500000</MaxVisiblePages>

<MaxCells>50000000</MaxCells>

<MaxPagesToRollOutInDelivery>1000</MaxPagesToRollOutInDelivery>

<MaxVisibleRows>900000000</MaxVisibleRows>

<MaxVisibleSections>6000</MaxVisibleSections>

<DefaultRowsDisplayed>50</DefaultRowsDisplayed>

</Table>

<Charts>

<MaxVisibleColumns>10000</MaxVisibleColumns>

<MaxVisiblePages>10000</MaxVisiblePages>

<MaxVisibleRows>100000</MaxVisibleRows>

<MaxVisibleSections>250</MaxVisibleSections>

<JavaHostReadLimitInKB>6144</JavaHostReadLimitInKB>

</Charts>

<Narrative>

     <MaxRecords>200000</MaxRecords>

     <DefaultRowsDisplayed>30</DefaultRowsDisplayed>

</Narrative>

<GridViews>

<DefaultScrollingEnabled>false</DefaultScrollingEnabled>

</GridViews>

</Views>

<Catalog>

         <UpgradeAndExit>false</UpgradeAndExit>

      <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control--><EnableMultiTenancy>false</EnableMultiTenancy>

</Catalog>

<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->

<Listener port="9710" ssl="false"/>

<JavaHostProxy ssl="false">

         <Hosts>

            <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control--><Host name="coreapplication_obijh1" address="s616455nj3vl328.uspswy6.savvis.net" port="9810"/>

         </Hosts>

      </JavaHostProxy>

      <Alerts>

User_R93U9

Additional info: when total count is around i 165k , i dont get this error. However, when total count is around 204k i get this error. And this error coming only for union report.

Robert Angel

There are VIRTUAL_TABLE_PAGE_SIZE and MAX_SET_OPERATION_BLOCKS both of which were directly limit union (and other virtual table / set based limits)