24 views

Description

Trying to export 100k of large data causes an out-of-memory exception:

worker.0 SEVERE *** ERROR *** Failure during scheduled run of job: 81c92ce9c0a8016400e5f0d2f784ea78
java.lang.OutOfMemoryError: Java heap space

 

Steps to Reproduce

  1. Create a list report to export the data
  2. Add all fields to list and select type to CSV
  3. Change the export limit on CSV to 1000000 [Ref. Export Limits ]
  4. Create a schedule report with some recipient email addresses and the report created above
  5. Execute the report and observe the [sys_email] table for outgoing email records
    Notice no record exists for the specified email address. Investigate the instance logs to retrieve the out of memory error.

Workaround

The workaround is to reduce the value in the property glide.csv.export.limit to specifically limit the size of CSV exports, and prevent out-of-memory errors. Until a fix will be available, the recommended max value to set the export limit is 50000 records.
Ref. Export Limits
 

Related Problem: PRB963728

Seen In

There is no data to report.

Intended Fix Version

Madrid

Safe Harbor Statement

This "Intended Fix Version" information is meant to outline ServiceNow's general product direction and should not be relied upon in making a purchasing decision. The information provided here is for information purposes only and may not be incorporated into any contract. It is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at ServiceNow's sole discretion.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2018-09-10 04:23:01
Published:2018-08-18