The SncAppFiles.syncAllAppFiles() API is executed as a background script job during installations and upgrades. The purpose of this script job is to ensure that applicable metadata records have a peer sys_app_file record. An out-of-memory error occurred when processing the sys_documentation metadata records when the volume of this table was > 1 million records (see attached stack trace).

The hypothesis for this issue is two-fold:
1. We are using DBQuery instead of GlideRecord to retrieve these metadata records.
2. We are copying the entire DBQuery result set into an in-memory list object.

The proposed solution is to use GlideRecord to retrieve these records and to simply process the results by iterating through the result set via GlideRecord.

Steps to Reproduce

1. Load a large data set in any update_synch table.
2. Upgrade the instance.


This issue has been fixed.

Related Problem: PRB589467

Seen In

Calgary Patch 2 Hot Fix 2
Calgary Patch 7 Hot Fix 2
Calgary Patch 7 Hot Fix 4
Calgary Patch 7 Hot Fix 5
Eureka Patch 11
Calgary Patch 2 Hot Fix 2

Fixed In

Dublin EA 0

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2016-01-29 17:20:00