Partition Manager throwing errors after manually deleting partitions

Ignition
1

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?

2

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

2 Likes
3

Thanks, that did the trick.

4

Hello am new to sql , but I am facing same error , can you guide me how to delete those references from the sqlth_partitions table

5

No. Contact support. The risk of doing something else wrong is too high.

1 Like
6

Yes I understand, I took help of database team to delete the reference now the issue is fixed , thanks for the reply and time , this post helped me to resolve the issue

1 Like