There are many reasons why users would want to clear old exceptions. They can be looking to remove sensitive information, keep exception manager from storing to much data.

There are two stored procedures in the exMon database to modify old exceptions, they are:

usp_maint_cleanup_rllissues_by_task

This procedure deletes exceptions. It takes in 6 parameters which determine which exceptions will be deleted

  • TaskId - The id of the query or compare query
  • TaskType – Specify the type of query or compare query. Queries use the type EBI_EVENT while compare queries use the type EBI_VALIDATION
  • Uat – Only exceptions created on this uat should be deleted
  • DeleteOlderInDays – Number of days. Exceptions older than the number will be deleted
  • DeleteOpenExceptions – A bit value, whether open exceptions should be deleted
  • DeleteNotAnException – A bit value, whether exceptions marked as “Not an exception” should be deleted

This procedure finds all exceptions that fulfill given conditions and deletes them.

 

 Example of legal parameters

  • TaskId: 30
  • TaskType: EBI_VALIDATION
  • Uat: PROD
  • DeleteOlderInDays: 60
  • DeleteOpenExceptions: 0
  • DeleteNotAnException: 0

A compare query with the id 30 will have all closed exceptions older than 60 days, that were created under the uat PROD deleted. Exceptions marked “Not and exception” will not be deleted.

 

usp_maint_cleanup_rllissues_columns_by_task

This prodecure clears data from exceptions. It takes 5 parameters which determine which exceptions will have their data cleared

  • TaskId - The id of the query or compare query
  • TaskType – Specify the type of query or compare query. Queries use the type EBI_EVENT while compare queries use the type EBI_VALIDATION
  • Uat – Exceptions created on this uat should be cleared of their data
  • DeleteOlderInDays – Number of days. Exceptions older than the number will be cleared of their data
  • ClearDataFromColumns – A comma separated list of columns whose data should be cleared

This procedure finds all exceptions that fulfill given conditions and clears all the columns specified.

 

Example of legal parameters

  • TaskId – 1
  • TaskType – EBI_EVENT
  • Uat – DEV
  • DeleteOlderInDays – 90
  • ClearDataFromColumns – user_id, name, email_address

A query with the id 1 will have all exceptions older than 90 days, that were created under the uat DEV cleared of their data in the columns [user_id], [name] and [email_address].