Reprocessing Nightly Batch Files

When a nightly batch fails due to a corrupt or improperly formed data file, you may want to re-send just the fixed data file and not the entire nightly ZIP upload. An ad hoc POM process is available for uploading individual data files and appending them to the current nightly batch run. The process is called REPROCESS_ZIP_FILE_PROCESS_ADHOC. It expects a file RI_REPROCESS_DATA.zip to be uploaded using File Transfer Services (FTS). The ad hoc program will import and unpack the ZIP file and directly move any contents into the staging area with all existing data files sent from a previous upload. No existing file will be deleted; it will overwrite only the files provided in RI_REPROCESS_DATA.zip.

Once a new file has been placed, you will still need to re-run the jobs to import that file. Or, if a COPY job for that file is what failed, re-run that job and the batch will resume from there.