Exceeded configured maximum number of allowed input records.

Issue: While trying to open a report from Analytics, you may get an error stating"

Exceeded configured maximum number of allowed input records". Description:  This error occurs when the BI server tries to fetch up more records than the limit specified in instanceconfig.xml file. Solution: We need to change the row limit in instanceconfig.xml file which is in the location MW_HOME/instance/Instance1/config/OracleBIPresentationServicesComponent/ coreapplication_obips1/instanceconfig.xml file.(The same can be increased using console itself.)

• Note: Below mentioned tags has to be included in between <security> and </security> inorder to increase the maximum display limit in reports. 

<Cube>
<CubeMaxRecords>999999</CubeMaxRecords>
<CubeMaxPopulatedCells>180000</CubeMaxPopulatedCells>
</Cube>

<Charts>
        <MaxVisibleColumns>999999</MaxVisibleColumns>
        <MaxVisiblePages>999999</MaxVisiblePages>
        <MaxVisibleRows>999999</MaxVisibleRows>
        <MaxVisibleSections>999999</MaxVisibleSections>
        <JavaHostReadLimitInKB>999999</JavaHostReadLimitInKB>
 </Charts>

<Pivot>
<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
<DefaultRowsDisplayedInDownload>999999</DefaultRowsDisplayedInDownload>
<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
        <MaxVisibleColumns>999999</MaxVisibleColumns>
        <MaxVisiblePages>999999</MaxVisiblePages>
        <MaxVisibleRows>999999</MaxVisibleRows>
        <MaxVisibleSections>999999</MaxVisibleSections>
<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control--><DisableAutoPreview>false</DisableAutoPreview>
</Pivot>

•  Restart the BI Server after making the required changes. It is better if you could restart all of the coreappliaction components.