Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
View Display Error: Maximum total number of cells exceeded (Configured Limit: 50000)

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
-
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>
0 -
Please check below link.
https://docs.oracle.com/middleware/1221/biee/BIESG/answersconfigset.htm#BIESG3278
0 -
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!
0