Hi,

You can find the screen to Cleanup Snapshot History Data here in Apps 8:

However, we did not have any luck using this screen to delete actual records from project_snapshot_data_tab table and ended up writing our own custom API based on Cleanup_Snapshot_Data.Cleanup_Snapshot_Data.

We’re on V9, so this might be a little different, we never tried to do this in V8, so sorry if this is not helpful.  It is called from the application here and used in this manner.

Procedure

Use the following procedure to perform a cleanup of snapshot history data for projects before a certain date:

1. Open the Snapshot History Data - Cleanup Information window.
2. Right-click anywhere in the window and then click Cleanup Snapshot History Data. The Delete Project Snapshot Data dialog box opens up.
3. Enter a value for the Company ID.
4. In the Project ID field, use the List button to select a project. You can also enter a wild card (%) to select all projects.
5. Enter a date in the History Cut Off Date field. All records for selected projects before this date will be deleted from the snapshot history table. Entering a date will also disable the check boxes Closed/Completed/Cancelled.
6. Click OK.
7. Populate the Snapshot History Data - Cleanup Information window to see information about data deletions.

Use the following procedure to perform a cleanup of snapshot history data for projects in status Closed/Completed/Cancelled:

1. Open the Snapshot History Data - Cleanup Information window.
2. Right-click anywhere in the window and then click Cleanup Snapshot History Data. The Delete Project Snapshot Data dialog box opens up.
3. Enter a value for the Company ID.
4. In the Project ID field, enter a wild card (%) to select all projects.
5. Leave the History Cut Off Date field empty. When no History Cut Off Date is entered, all history data according to the other parameters will be deleted and the check boxes Closed/Completed/Cancelled can be selected.
6. Select type of project status in the check boxes Closed, Completed and/or Cancelled. You can select one or more.
7. Click OK.
8. Populate the Snapshot History Data - Cleanup Information window to see information about data deletions.

ISSUE GOT SOLVED!!

Please share so if anyone else comes across the thread and has the same question the answer can be found here.

How did you solve it? 

And did the solution actually remove the data from the database for snapshots (across the myriad of tables involved)? Snapshots are consuming 25% of our diskspace after just 12 months of live running and there appears to be no way to remove them - I’ve raised a new topic here with the details: