Mango wont start with > 300 data points
James McPhail last edited by
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 last edited by 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.