Review Physical Delete Exceptions Report

The Review Physical Delete Exceptions Report is one of the PASI Nightly Reports and is responsible for highlighting the following two scenarios:

  • Records that have been logically deleted for more than 30 days, but these records have not been physically deleted. This is due to at least one of the 'child records' being updated after the 'parent record' was logically deleted.
  • Records that have been logically deleted for more than 30 days, but these records have not been physically deleted and are not part of the 'child record' scenario. It is expected that these records should be physically deleted, so their presence on the report indicates an issues with the physical delete processor that should be investigated.

This report is produced everyday at 6:00 am and results in an Excel file being generated and distributed via email.

Generated Email

Sent To PASITechnicalOpsTeam@gov.ab.ca
Subject PASI Monitor: Review Physical Delete Exceptions for YYYY-MM-DD [Contains Records / No Records]
Body

This report is produced daily by PASI.Monitor running on {Server}.
Data Source={Connection String}

Email Attachment

Attached to the email is a Microsoft Excel file that contains a summary of the records that were not deleted.

Parent Table Identifies the parent table containing the records that were not deleted.
Child Table Identifies the child table containing the records that were updated after the parent record was deleted.
Num of Child Records Updated after Parent Records Deleted Identifies the number of records in the child table updated after its parent record was deleted.
Num of Child Records Were Deleted Identifies the number of deleted records in the child table that were updated after its parent record was deleted.
Num of Child Records Were Not Deleted Identifies the number of non-deleted records in the child table that were updated after its parent record was deleted.

Change History

Changes done in release 9.22:

  • Include the GUID or record ID on the report o facilitate easier investigation.
  • Report on all records that have been logically deleted for greater than 30 days.