10 Replies Latest reply: Sep 23, 2013 1:07 PM by user2685777 RSS

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

    971988
      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
        • 1. Re: OBIEE 11g: Exceeded configured maximum number of allowed input records
          Srini VEERAVALLI
          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/
          OBIEE 11g - Download All/Display All of rows in Answers

          If helps pls mark as correct or helpful
          • 2. Re: OBIEE 11g: Exceeded configured maximum number of allowed input records
            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.
            • 3. Re: OBIEE 11g: Exceeded configured maximum number of allowed input records
              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
              • 4. Re: OBIEE 11g: Exceeded configured maximum number of allowed input records
                971988
                We are on 11.1.1.6.0. I will try the same after applying the patch.
                • 5. Re: OBIEE 11g: Exceeded configured maximum number of allowed input records
                  Srini VEERAVALLI
                  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
                  • 6. Re: OBIEE 11g: Exceeded configured maximum number of allowed input records
                    971988
                    The below setting worked:

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

                    <Views>
                    <Cube>
                    <CubeMaxRecords>9999999</CubeMaxRecords>
                    <CubeMaxPopulatedCells>999999999</CubeMaxPopulatedCells>
                    </Cube>
                    </Views>
                    • 7. Re: OBIEE 11g: Exceeded configured maximum number of allowed input records
                      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>
                      • 8. Re: OBIEE 11g: Exceeded configured maximum number of allowed input records
                        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.
                        • 9. Re: OBIEE 11g: Exceeded configured maximum number of allowed input records
                          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,
                          • 10. Re: OBIEE 11g: Exceeded configured maximum number of allowed input records
                            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