Well, if you can’t drop the records from the web interface, then you can delete the datacache entirely.
- If you can afford a little downtime, then disable your database connection. If not, then disable the disk cache in store and forward settings for the database.
- Navigate to
${ignitionInstallDirectory}/data/datacache/
and delete the entire folder with the name of your database connection. - Re-enable the DB connection or disk cache. A new disk cache should be automatically generated.