Mango wont start with > 300 data points

[James McPhail]

Our mango server will not start as it seems it has reached its maximum data point limit. From the ma.log

ERROR 2018-11-16T15:54:42,888 (com.serotonin.m2m2.Main.main:138) - Error during initialization
com.serotonin.m2m2.LicenseViolatedException: You have reached the maximum number of data points permitted for your 'Free' license: 300

Is it possible to remove data points from the terminal or otherwise salvage the installation/database so we can prune it as required?

[phildunlap]

Hi James, welcome to the forum!

You could use the Mango/bin/h2-web-console script to launch the H2 web console, then after logging in with the credentials from the H2 section of your Mango/overrides/properties/env.properties file (or Mango/classes/env.properties) to login and DELETE FROM dataPoints WHERE id=(SELECT MAX(id) FROM dataPoints); You can find more about the web console here: https://help.infiniteautomation.com/about-the-h2-database

Or you could move your Mango/databases/ directory, then start with a clean database and restore a backup. That should give you a little time to poke around before it shuts down due to too many points.