Oracle Fusion Middleware: Exceeded configured maximum number of allowed input records Error - Maksimum Satır Sayısının Aşılması

The recent error that we encountered on OBI 11g is that we couldn't see the reports which had more 1 million records.

The error was like this:

------------
Error

Exceeded configured maximum number of allowed input records.
Error Details
Error code: EKMT3FK5: OI2DL65P

SQL issued: 195~6qt8lbhf1lvqgn51fqbcp544qq

---------

Solution:

We added the following lines into instanceconfig.xml which is found under for example: "E:\oracle\obia\instances\instance2\config\OracleBIPresentationServicesComponent\coreapplication_obips1 "

We then add the tags such as "MaxVisibleRows","MaxVisibleSections","MaxVisiblePages","MaxVisibleColumns" and "MaxCells" under the appropriate parts.

We also add "Cube" and "Charts" parts. You could just add all the missing parts compared to this instance config xml

After the addition, we should restart the application so that the changes could take effect

References:

1- Maximum number of allowed input records:

http://cherryqq.iteye.com/blog/1856962