Under certain circumstances, old data can be orphaned (not cleaned) in a couple of DPA repository tables (CONSS and CONSW). When DPA detects orphaned rows, you will see an error message like this in the logs:
Note: In the above message, "15" is the monitored database ID, and CONSS_15 is the table containing orphaned rows. You might also see messages for CONSW_xx tables.
This article explains how you can safely delete the orphaned rows.
1) Find Cutoff Date for Orphans:
To find out the cutoff date for orphaned records, you can run the following query (replace xx with the database id matching the message):
You can safely delete any rows in the CONSS_xx and CONSW_xx tables that have dates older than the date returned by the above query. You may want to count the number of orphaned rows prior to deleting them. If there are a large number of rows, you may want to do them in batches.
2) Count Orphans:
3) Clean Orphans:
If there are few enough orphaned rows (e.g. less than 250,000) you can safely delete them all at once: