Partition Manager throwing errors after manually deleting partitions

Continuing the discussion from Retrieve tag history from specific data source:

In the linked post, I described how I changed the automatic prune setting on a database connection from 12 months to 6 months, and then manually deleted some of the historical data partitions from MSSQL Express, to free up space and get historical data logging to resume. Now, the gateway is trying to delete those partitions and logging an error every 10 minutes about not being able to do so. How can I have the gateway accept that the partitions no longer require pruning?

Remove the relevant entries in the sqlth_partitions table, so that the historian no longer knows those particular tables exist.

1 Like

Thanks, that did the trick.