My Oracle Support Banner

Export To Excel Fails With Error: XLSX generation stopped; Long Nested Table (rows=20001) Detected, May Cause High Memory Usage. Please modify Template, or Increase the Maximum allowable Nested Table Row Count. (Doc ID 2813782.1)

Last updated on OCTOBER 22, 2021

Applies to:

Primavera Analytics Cloud Service - Version 21.4 and later
Information in this document applies to any platform.

Symptoms

On : 21.4 version, CLOUD: Unifier Analytics

When attempting to export a report form BIP to Excel ,
the following error occurs.

ERROR
-----------------------
XLSX generation stopped; Long nested table (rows=20001) detected, may cause high memory usage.
Please modify template, or increase the maximum allowable nested table row count.


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

  1.  Go the environment
  2.  Open the report
  3.  Run the report
  4.  Export the report to Excel
  5.  Received the error: XLSX generation stopped; Long nested table (rows=20001) detected, may cause high memory usage.
  6.  Please modify template, or increase the maximum allowable nested table row count.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot export report to Excel that have more then 20000 lines.

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.