View Display Error: Maximum total number of cells exceeded (Configured Limit: 50000) — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

View Display Error: Maximum total number of cells exceeded (Configured Limit: 50000)

Received Response
747
Views
3
Comments
3298808
3298808 Rank 2 - Community Beginner

Hello All,

I am using OBIEE 12.2.1.2.0 in Windows 2012R2 platform. This issue seems like a very easy one but somehow I am not able to fix the same. I am generating a table view with 6-7 columns which generates around 50000 rows. I am able to export everything into a CSV sucessfully but when I try to export it into excel 2007+ I get ~ 9000 rows exported. Rest are missing. Also when I am trying to see all the records in the table by clicking the arrow signs at the bottom of the table view I get the following error:

(View Display Error: Maximum total number of cells exceeded (Configured Limit: 50000).

Error Details

Error Codes: EY692ZW9

Location: saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads)

Now, one might think I haven't configured the parameters properly. So here is my instanceconfig.xml file views section.

"

       <Views>

            <Pivot>

                <DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>

                <DefaultRowsDisplayedInDownload>5000000</DefaultRowsDisplayedInDownload>

                <DisableAutoPreview>false</DisableAutoPreview>

  <MaxVisibleSections>25000</MaxVisibleSections>

  <MaxCells>10000000</MaxCells>

  <MaxVisibleColumns>5000</MaxVisibleColumns>

  <MaxVisibleRows>5000000</MaxVisibleRows>

  <MaxVisiblePages>25000</MaxVisiblePages>

            </Pivot>

            <Table>

                <DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>

                <DefaultRowsDisplayedInDownload>5000000</DefaultRowsDisplayedInDownload>

  <MaxVisibleSections>25000</MaxVisibleSections>

  <MaxVisibleRows>5000000</MaxVisibleRows>

                <MaxVisiblePages>25000</MaxVisiblePages>

                <DefaultRowsDisplayedInDownloadCSV>1000000</DefaultRowsDisplayedInDownloadCSV>

            </Table>

     <Cube>

  <CubeMaxRecords>10000000</CubeMaxRecords>

  <CubeMaxPopulatedCells>100000000</CubeMaxPopulatedCells>

     </Cube>

        </Views>

"

But for some reason the report shows the cell limit being 50000. That's why around 9000 rows are being exported successfully (wherever the cell limit is crossing 50000 it stops). But PDF, CSV and other exports work fine.

Kindly suggest. I have also modified the following section in the config.xml file placed under Middleware\user_projects\domains\bi\config\fmwconfig\biconfig\OBIJH

<XMLP> <InputStreamLimitInKB>1638400</InputStreamLimitInKB> </XMLP>

But to no effect. Please help.

Avik Dutta.

Answers

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Hi,

    This is probably caused by  MaxCells parameter (Table section) in instanceconfig.xml, at least in 11g (may be it works in 12c as well). Exporting that much amount of records using OBIEE in never recommended, see Oracle support document for guidelines.

    Oracle Support Document 2208710.1

    For reference from 11.1.1.9

    <Table>

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

    <DefaultRowsDisplayedInDelivery>100000</DefaultRowsDisplayedInDelivery>

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

    <DefaultRowsDisplayedInDownload>500000</DefaultRowsDisplayedInDownload>

    <MaxCells>1920000</MaxCells>

    <MaxVisiblePages>1000</MaxVisiblePages>

    <MaxVisibleRows>64000</MaxVisibleRows>

    <MaxVisibleSections>25</MaxVisibleSections>

    <DefaultRowsDisplayed>64000</DefaultRowsDisplayed>

    </Table>

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner
    3298808 wrote:Hello All,I am generating a table view with 6-7 columns which generates around 50000 rows.[snip]  <Views> <Pivot> <DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery> <DefaultRowsDisplayedInDownload>5000000</DefaultRowsDisplayedInDownload> <DisableAutoPreview>false</DisableAutoPreview> <MaxVisibleSections>25000</MaxVisibleSections> <MaxCells>10000000</MaxCells> <MaxVisibleColumns>5000</MaxVisibleColumns> <MaxVisibleRows>5000000</MaxVisibleRows> <MaxVisiblePages>25000</MaxVisiblePages> </Pivot>[snip]

    @3298808 So you are using a TABLE view but have configured the PIVOT section to have more MaxCells than the default and now you wonder why that does not work?

    Think about that statement for 5 seconds and then go change the instanceconfig accordingly. MaxCells exists for Table, Pivot and both Trellis types...oh and Treemap!