My Oracle Support Banner

Oracle Analytics Server (OAS) Pivot Analysis Errors With 'Exceeded configured maximum number of allowed input records.' (Doc ID 2729586.1)

Last updated on JULY 27, 2023

Applies to:

Oracle Analytics Server - Version 5.5.0 and later
Oracle Fusion Transportation Intelligence - Version 6.5.2 to 6.5.2 [Release 6.5]
Information in this document applies to any platform.


When try to open a pivot table with 7 columns and  75,907 rows, receiving the following error:


Error in Retrieving Data.
Exceeded configured maximum number of allowed input records.


The row limit has been configured in the instanceconfig.xml or Fusion Middleware Control EM, but the analysis still fails at greater than 40,025 rows.

This issue occurs when attempt to run any pivot report with more than 40,025 output rows.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.