2 Replies Latest reply on Jan 19, 2018 9:50 AM by Robert Angel

    Union all report -  Error Exceeded configured maximum number of allowed output prompts, sections, rows, or columns

    3281045

      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>