My Oracle Support Banner

Error Creating a Pivot Table in Analytics: Exceeded Configured Maximum Number of Allowed Input Records (Doc ID 2755603.1)

Last updated on JULY 09, 2021

Applies to:

Primavera Analytics - Version 19.12.6.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
When creating an Analytics pivot table, the following error is generated

ERROR
-------------

Exceeded configured maximum number of allowed input records.
ResultRowLimit(table) OR CubeMaxRecords(Pivot/Chart) needs to be reset in the config file. Please check with your administrator.
  Error Details
Error Codes: EKMT3FK5

WHAT IS WORKING
-----------------------
Removing the Project Id will generate the table, but with incorrect values

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Log into Analytics Dev
  2. Create a Cash flow analysis:
    • Criteria:
    • Project ID
    • Cash Flow Name
    • Month Name
    • Baseline(Baseline)
  3. Check the results
  4. Create the Pivot table
  5. Notice the error:
    • View Display Error
    • Exceeded configured maximum number of allowed input records.
    • ResultRowLimit(table) OR CubeMaxRecords(Pivot/Chart) needs to be reset in the
    • config file. Please check with your administrator.
    •   Error Details
    • Error Codes: EKMT3FK5
  6. Remove Project ID
  7. Notice the values are much higher than expected



Cause

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
Symptoms
Cause
Solution
References


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