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

Exporting and Importing to another Mango Problem


  • Hi,

    I'm using version 1.11.0 and noticed a problem. I have two mango instances and am trying to duplicate the systems.

    I have 3 virtual datapoints with event handlers and a VMStats Data Source. I has able to export and import all of these.

    I was not able to import the watch list of the datapoints from the VMStats Data Source. If I export and then re-import on the same system it works fine.

    I've attached two text files with the data I'm trying to import

    This is the error I get when importing the watch list:
    PreparedStatementCallback; SQL [insert into watchListPoints values (?,?,?)]; INSERT on table 'WATCHLISTPOINTS' caused a violation of foreign key constraint 'WATCHLISTPOINTSFK1' for key (0). The statement has been rolled back.; nested exception is java.sql.SQLIntegrityConstraintViolationException: INSERT on table 'WATCHLISTPOINTS' caused a violation of foreign key constraint 'WATCHLISTPOINTSFK1' for key (0). The statement has been rolled back., caused by: 'INSERT on table 'WATCHLISTPOINTS' caused a violation of foreign key constraint 'WATCHLISTPOINTSFK1' for key (0). The statement has been rolled back.', caused by: 'INSERT on table 'WATCHLISTPOINTS' caused a violation of foreign key constraint 'WATCHLISTPOINTSFK1' for key (0). The statement has been rolled back.', caused by: 'INSERT on table 'WATCHLISTPOINTS' caused a violation of foreign key constraint 'WATCHLISTPOINTSFK1' for key (0). The statement has been rolled back.'
    Import complete

    Here is the report I get when trying to import the datapoints:

    com.serotonin.json.JsonNumber cannot be cast to com.serotonin.json.JsonString
    com.serotonin.json.JsonNumber cannot be cast to com.serotonin.json.JsonString
    com.serotonin.json.JsonNumber cannot be cast to com.serotonin.json.JsonString
    com.serotonin.json.JsonNumber cannot be cast to com.serotonin.json.JsonString
    com.serotonin.json.JsonNumber cannot be cast to com.serotonin.json.JsonString
    Data point 'FTP_On-Off': saved
    Data point 'SSH_On_Off': saved
    Data point 'Restart': saved
    Import complete

    Any thoughts on this would be appreciated.

    Thanks,
    Joel.

    Attachment: download link


  • It's a bug. :( But an easy one. :) Fix will be in the next release.


  • Thanks, I'm impressed with how fast you guys put out new releases.

    Thanks,
    Joel.