• Recent
    • Tags
    • Popular
    • Register
    • Login

    Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

    Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website Mango 5 Documentation Website

    Mango wont start with > 300 data points

    Scheduled Pinned Locked Moved User help
    2 Posts 2 Posters 967 Views 2 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • James McPhailJ Offline
      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?

      1 Reply Last reply Reply Quote 0
      • phildunlapP Offline
        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.

        1 Reply Last reply Reply Quote 1
        • First post
          Last post