Retry Process

Retry mechanism is introduced to reprocess the record(s), which failed already during DL.COPY.PROCESS and DL.PURGE.PROCESS. The failed records are captured in RO.ERROR.KEYLIST. This section provides details on how this process works.

DL.ERROR.PROCESS service reads the error records from RO.ERROR.KEYLIST and processes the records as per the definition captured in the ERROR records.

The ERROR record contains the error message, SQL query, and process name in which the record got failed.

Error record in RO.ERROR.KEYLIST

Content of RO.ERROR.KEYLIST

The following screen capture shows the error occurred during DL.PURGE.PROCESS as the T24_GETPDATEPURGEKEYS function is not created in the LIVE database.

The T24_GETPDATEPURGEKEYS function is created in the LIVE database to resolve the above error.

Record count in the LIVE table before executing the DL.ERROR.PROCESS

You need to execute the DL.ERROR.PROCESS service to reprocess the records in RO.ERROR.KEYLIST.

After the retry process is successful, the respective records will be deleted from RO.ERROR.KEYLIST.

The respective table count after the retry process is shown in the following screen capture.