The Import Set Deleter job cleans records in the import tables. A problem that was fixed in Fuji addressed out of memory exceptions that arise from MultipleDelete, which Import Set Deleter utilizes. However, the fixes did not completely prevent memory concerns for the Import Set Deleter job.
Steps to Reproduce
- Create a large number of import sets (for example, 10,000).
Each import set needs to have a nominal load (for example, 2,000) of records to be imported.
- Navigate to System Import Sets > Scheduled Cleanup.
- Change Days from 7 to 0.
- Click Execute now.
The deleter job runs on all import sets. Note that memory consumption increases substantially while the deleter job is running. The job is loading GlideRecords, but it only needs the names of staging tables.
- Navigate to Script Includes > ImportSetCleaner.
- Change the line:
Notice that the line is now commented out.
Related Problem: PRB709421