Exceeded configured maximum number of allowed output prompts, sections, rows, or columns.? — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Exceeded configured maximum number of allowed output prompts, sections, rows, or columns.?

Received Response
12
Views
2
Comments
SanthoshSreshta
SanthoshSreshta Rank 3 - Community Apprentice
edited Aug 13, 2024 7:09PM in Oracle Analytics Cloud and Server

Hi All,

I am trying to display more than 10,000,000. it is been showing error as Exceeded configured maximum number of allowed output prompts, sections, rows, or columns. , the columns were only just 5 and 2 prompts.

The links I have found were.

https://shivabizint.wordpress.com/2013/10/08/obiee-11g-configurations-maximum-limits/

I have goggled about this error and finally came to know that OBIEE can only able to display 9,999,999 records but there it is not mentioned as for 11.1.1.9 version, so I need some info regarding the maximum number of rows obiee can be able to display in PIVOT & TABLE. Need some official information regarding this.

and anyone help me in displaying such amount of data in reports.

In official oracle website I was able to find only default values but not max values .

http://docs.oracle.com/cd/E25178_01/bi.1111/e10541/answersconfigset.htm

I am using 11.1.1.9 version.

Please help.

Thanks,

Santhosh S.

Answers

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    If you want to download, unlimited row.

    Please,go to the follow path:

    <Oracle BI Instance>/instance<N>/config/OracleBIJavaHostComponent/coreapplication_obijh1

    Edit the "config.xml" file:

    XMLJava.png

    Go Oracle Enterprise Manager

    OEM.png

    Go to the

    <Oracle BI Instance>/instance<N>/config/OracleBIPresentantionServiceComponent/coreapplication_obips1\instanceconfig.xml


    instanceconfig.png

    If you want information in more detail please visit this web site https://docs.oracle.com/cd/E29542_01/bi.1111/e10541/answersconfigset.htm#BIESG1705




    Kind Regards,


  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    Samoth,

    Please, remember Oracle BI is a web analytics system, if you want to show from bi analytics these 10 millions rows, you first could have a real good storage in your server and your client.

    In my experience, to show that huge amount of data it's no practical for to end users.

    However, Oracle as a BI Enterprise Platform, has two ways for your requirement:

    1. If you want to show by default, you have to set up your instanceconfig.xm, check this links (Configuring and Managing Analyses and Dashboards - 11g Release 1 (11.1.1)),

    which is in <Oracle BI Instance>/instance<N>/config/OracleBIPresentantionServiceComponent/coreapplication_obips1\instanceconfig.xml

    instconfg.png

    2. Or you could set up, in Oracle BI Presentation,

    Pivot Table

    PivotTableRows.png

    Table:

    TablesProperties.png

    Kind Regards,