Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

OBIEE 11g: Exceeded configured maximum number of allowed input records

971988Nov 1 2012 — edited Sep 23 2013
I get the below error on a table prompt (drop down from a compound layout view). The are 31000 rows in the report and 808 distinct values for the column that has the table prompt.

Exceeded configured maximum number of allowed input records.
Error Details
Error Codes: EKMT3FK5:OI2DL65P
Location: saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads
SQL Issued: 167~o6oobclqncnfg2foffgju398ki

If I add a filter to limit the output to a few hundred rows and the table prompt values to one or two distinct values, it works.

The below setting in the instanceconfig.xml file did not help. Any other suggestions would be greatly appreciated.

<Cube>
<CubeMaxRecords>99999</CubeMaxRecords>
<CubeMaxPopulatedCells>9999999</CubeMaxPopulatedCells>
</Cube

Thanks,
Sathish

Comments

SriniVEERAVALLI
Check these links

http://deliverbi.blogspot.com/2011/12/obiee-11g-row-settings-table-and-pivot.html
http://123obi.com/2011/03/increase-number-of-rows-to-displayexport-to-excel-from-analysis/
2176623

If helps pls mark as correct or helpful
JaiG
This is a bug that was apparently fixed in 11.1.1.6.4: Bug 14115879 : EXCEEDED CONFIGURED MAX NUMBER INPUT RECORDS ERROR CODE: EKMT3FK5:OI2DL65P

Refer to Article ID 1487839.1 on Oracle Support for a workaround.

Please mark if helpful/correct.
971988
It did not work, after adding the below values before </Pivot> as shown.

<MaxVisibleColumns>5000</MaxVisibleColumns>
<MaxVisiblePages>2500</MaxVisiblePages>
<MaxVisibleRows>500000</MaxVisibleRows>
<MaxVisibleSections>5000</MaxVisibleSections>
</Pivot>
<Table>

Presentation services would not start when I added the below, so I had to remove it.

<MaxVisibleColumns>5000</MaxVisibleColumns>
<MaxVisiblePages>2500</MaxVisiblePages>
<MaxVisibleRows>500000</MaxVisibleRows>
<MaxVisibleSections>5000</MaxVisibleSections>
</Table>

Do you have a working version of the complete xml file with the above settings?

Thanks,
Sathish
971988
We are on 11.1.1.6.0. I will try the same after applying the patch.
SriniVEERAVALLI
Something gone wrong with content when your are doing copy and paste.
Copy to notepad and then to xml file

Check this
http://docs.oracle.com/cd/E25178_01/bi.1111/e10541/answersconfigset.htm#CIHJDHGI

If helps pls mark
971988
The below setting worked:

<ODBC>
<ResultRowLimit>999999</ResultRowLimit>
</ODBC>

<Views>
<Cube>
<CubeMaxRecords>9999999</CubeMaxRecords>
<CubeMaxPopulatedCells>999999999</CubeMaxPopulatedCells>
</Cube>
</Views>
971988
Getting a different error now: "Exceeded configured maximum number of allowed output prompts, sections, rows, or columns.“ This is on a similar report with table prompts built on on another column but built on the same table for the same criteria which returns the same number of rows but some additional values for the table prompt.I have the below in the instance config and its does not seem to work.

<Prompts>
<MaxDropDownValues>10000</MaxDropDownValues>
<AutoApplyDashboardPromptValues>true</AutoApplyDashboardPromptValues>
<AutoSearchPromptDialogBox>true</AutoSearchPromptDialogBox>
<AutoCompletePromptDropDowns>
<SupportAutoComplete>true</SupportAutoComplete>
<CaseInsensitive>true</CaseInsensitive>
<MatchingLevel>MatchAll</MatchingLevel>
<ResultsLimit>5000</ResultsLimit>
</AutoCompletePromptDropDowns>
</Prompts>
.......
.......
........

<MaxVisibleColumns>50000</MaxVisibleColumns>
<MaxVisiblePages>2500</MaxVisiblePages>
<MaxVisibleRows>100000000</MaxVisibleRows>
<MaxVisibleSections>5000</MaxVisibleSections>
<DefaultRowsDisplayed>30</DefaultRowsDisplayed>
</Pivot>
<Charts>
<MaxVisibleColumns>50000</MaxVisibleColumns>
<MaxVisiblePages>25000</MaxVisiblePages>
<MaxVisibleRows>10000000</MaxVisibleRows>
<MaxVisibleSections>50000</MaxVisibleSections>
<JavaHostReadLimitInKB>10240</JavaHostReadLimitInKB>
</Charts>
<Table>
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<DefaultRowsDisplayedInDownload>99999</DefaultRowsDisplayedInDownload>
</Table>
<Cube>
<CubeMaxRecords>100000000</CubeMaxRecords>
<CubeMaxPopulatedCells>100000000</CubeMaxPopulatedCells>
</Cube>
</Views>
836330
Has similar issue and realized it was report related. This issue did not occur with 11.1.1.5.0 but was happening in 11.1.1.6.8 version.

At report view
1. Click on "Results" tab
2. Click on the table or Pivot table and click on the pencil (Edit View)
3. Remove any column(s) that is in the "Excluded" section of the Layout that isn't in your report.
Sasi Nagireddy
Have u done this?

<Prompts>
<MaxDropDownValues>10000</MaxDropDownValues>
<AutoApplyDashboardPromptValues>true</AutoApplyDashboardPromptValues>
<AutoSearchPromptDialogBox>true</AutoSearchPromptDialogBox>
<AutoCompletePromptDropDowns>
<SupportAutoComplete>true</SupportAutoComplete>
<CaseInsensitive>true</CaseInsensitive>
<MatchingLevel>MatchAll</MatchingLevel>
<ResultsLimit>5000</ResultsLimit>
</AutoCompletePromptDropDowns>
</Prompts>
.......
.......
........

<MaxVisibleColumns>50000</MaxVisibleColumns>
<MaxVisiblePages>2500</MaxVisiblePages>
<MaxVisibleRows>100000000</MaxVisibleRows>
<MaxVisibleSections>5000</MaxVisibleSections>
<DefaultRowsDisplayed>30</DefaultRowsDisplayed>
</Pivot>
<Charts>
<MaxVisibleColumns>50000</MaxVisibleColumns>
<MaxVisiblePages>25000</MaxVisiblePages>
<MaxVisibleRows>10000000</MaxVisibleRows>
<MaxVisibleSections>50000</MaxVisibleSections>
<JavaHostReadLimitInKB>10240</JavaHostReadLimitInKB>
</Charts>
<Table>
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<DefaultRowsDisplayedInDownload>99999</DefaultRowsDisplayedInDownload>
</Table>
<Cube>
<CubeMaxRecords>100000000</CubeMaxRecords>
<CubeMaxPopulatedCells>100000000</CubeMaxPopulatedCells>
</Cube>
</Views>

Thanks,
user2685777

After upgrading from 10g to 11g ( our current version of OBIEE is 11.1.1.7.0 ) we were also getting the same error ( Exceeded configured maximum number of allowed output prompts, sections, rows, or columns ) and all the reports use to fail if the resulting row count was over 40000. We did add the following XML tags with new section for NArrative and Ticker to instanceconfig.xml and re-started the BI services which FIXED the ISSUE. We even changed the "MaxRecords" count to over over 200K and the reports worked

  <Narrative>

    <MaxRecords>64000</MaxRecords>

    <DefaultRowsDisplayed>30</DefaultRowsDisplayed>

  </Narrative>

  <Ticker>

    <MaxRecords>64000</MaxRecords>

  </Ticker>

Venky

1 - 10
Locked Post
New comments cannot be posted to this locked post.

Post Details