General OBIEE

Get Involved. Join the Conversation.

Topic

    Antony Hooper
    Exceeded configured maximum number of allowed input recordsAnswered
    Topic posted January 23, 2017 by Antony HooperRed Ribbon: 250+ Points, tagged OTBI, Report Output, SQL 
    66 Views, 3 Comments
    Title:
    Exceeded configured maximum number of allowed input records
    Summary:
    Error message received when running report
    Content:

    Hi, could someone explain why I get the attached error? 

    Many thanks,

    Antony.

    Image:

    Best Comment

    Rachel Martorelli

    I'm not sure what view you're using, but there are too many records.  For instance if it is a pivot table you may have too many columns or if it is a regular table you may have too many rows.

    Comment

     

    • Rachel Martorelli

      I'm not sure what view you're using, but there are too many records.  For instance if it is a pivot table you may have too many columns or if it is a regular table you may have too many rows.

    • Antony Hooper

      Thanks, my ROWNUM filter was not working correctly - I now remember you need to use RCOUNT instead.

    • Vijaya Kumar

      Hi ,

      I think you are used filter in the report in the selection.

      Maximum limit is 300 , if it exceed it result in this error.

      Regards,

      Vijiay S