2 Replies Latest reply: Feb 1, 2013 12:24 AM by sayak RSS

    Exceeded configured maximum number of allowed input records.

    User472204-OC
      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>