The report is use to delete logging table entries created before the last trigger was created.
If you are using the database system that requires multiple triggers for each table (this is the case for all DB systems except for Oracle), it might happen that some time elapses between the creation of the first and the last trigger for a certain table. Especially if the corresponding DB table undergoes many changing operations while the triggers are being created. In such a case, the following problem might occur (T n mean subsequent points in time):
- T1: Insert trigger is created
- T2: A record is inserted to the table
- T3: The same record is deleted from the table
- T4: Delete trigger is created
This means, we now have only one logging table entry for the corresponding original table record. This logging table record suggests an insertion. For the deletion of that record which happened before the delete trigger was created, we do not have a logging table record. If this situation is detected in the delta replay, this would be interpreted as an inconsistency, because the record in the original table does not exist. However, the logging table entries that were created before the last of the necessary triggers for this table became active can and should be disregarded
