AMI Readings Import (ARI) cleanup task

This task starts three sub-tasks, which run in parallel to purge data from gap fill interrogation (GFI) tables and file inventory tables as they relate to ARI.

The ARI cleanup sub-task that deletes GFI data purges GapFillRequestMessage tables.

The ARI cleanup sub-task that deletes file inventory data purges the following files and database tables:

• XML files from the file system and records from HVRIEntityMessage, FileInventory, and FileInventorySegment for each configured Import Data Manager service.

• Work Bin files from the file system.

• CleanReading files from the database server and the associated records from HVRIEntityMessage, FileInventory and FileInventorySegment.

Create a task template for this task containing the chunking parameters appropriate for your system. Configure a recurring schedule to define the frequency, schedule type, and holiday schedule. Then assign the task template to the Recurring schedules overview. Schedule this task to run after the ARI data collection window (DCW) ends and the estimation process finishes.

Use the following procedure to configure the ARI Cleanup task:

1. Go to System Operations > Task Management > Task Templates.

2. From the Task Type dropdown menu, select ARI Cleanup.

3. Configure the following parameters. The IEE installer populates many of these parameters with default values. The default value might not be the recommended or optimal setting for your specific IEE implementation. You must tune these values to achieve optimal system performance.

   GFI Chunk Size

   Defines the chunk size for the delete operation when purging old data in batches from the Gap Fill Interrogation (GFI) tables. Setting the chunk size to 0 turns off chunking.

   Tip: If you are unsure of the optimal GFI Chunk Size for this implementation, enter 10,000. You can change this value at any time.

   Default Chunk Size

   Defines the chunk size for the delete operation when purging records in batches from the following:

   • XML files from the file system and records from HVRIEntityMessage, FileInventory and FileInventorySegment for each configured AMI readings import receiver.

   • WorkBin files from the file system.

   • CleanReading files from the database server and the associated records from HVRIEntityMessage, FileInventory and FileInventorySegment.

   Setting default chunk size to 0 turns off chunking.

   Force FileInventory Cleanup

   Determines whether IEE forces the cleanup of ARI FileInventory files that don’t have child tasks created earlier than the specified days to keep. Such files may have issues associated with them; set this parameter to True only after investigating and resolving these issues. Future dated work bin files are not deleted by ARI Cleanup.