Hi Experts,
When I am trying to export large reports to Excel from OBIEE 11.1.1.6.0, but I get the following error:
Error
View Display Error
Exceeded configured maximum number of allowed input records.
Error Details
Error Codes: EKMT3FK5
Location: saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool, saw.threadpool, saw.threads
When I am trying to export large reports to CSV from OBIEE 11.1.1.6.0, but I get the following error:
Exceeded configured maximum number of allowed input records EKMT3FK5'
But I search the material ,unfortunally it did not solve my problem.
Note: My report is table view ,and the rows is about 140000.Why it does not be sucessful? I know CSV does not limit the rows,right?
I have increased the limit as below:
instanceconfig.xml
<ODBC>
<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
<ResultRowLimit>200000</ResultRowLimit>
</ODBC>
<Views>
<Cube>
<CubeMaxRecords>5000000</CubeMaxRecords>
<CubeMaxPopulatedCells>15000000</CubeMaxPopulatedCells>
</Cube>
<Pivot>
<MaxCells>4000000</MaxCells>
<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
<DefaultRowsDisplayedInDelivery>60000</DefaultRowsDisplayedInDelivery>
<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
<DefaultRowsDisplayedInDownload>200000</DefaultRowsDisplayedInDownload>
<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
<DisableAutoPreview>false</DisableAutoPreview>
<DefaultRowsDisplayed>50</DefaultRowsDisplayed>
</Pivot>
<Table>
<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
<DefaultRowsDisplayedInDelivery>60000</DefaultRowsDisplayedInDelivery>
<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
<MaxCells>4000000</MaxCells>
<MaxVisibleRows>200000</MaxVisibleRows>
<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control--><DefaultRowsDisplayedInDownload>200000</DefaultRowsDisplayedInDownload>
<DefaultRowsDisplayed>50</DefaultRowsDisplayed>
</Table>
</Views>