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.

Ok, I'll take a look at those options. Making a meta data point seems like I'm just going to be doubling my points and since this is a point-based license, well...

I'd follow this version, it's more manual and involved, but will allow you to check your install step by step https://help.infiniteautomation.com/linux-installation Fox

My pleasure, always here if needed Fox

Look around the forums, there are numerous topics you can tap into. I have written a custom dashboard system so feel free to call on me if desired. As for permissions, i strongly recommend a combination of them with datapoint tags. Gives you a lot of freedom for your dashboard structure and behaviour. Fox

There is no explainable reason why you would lose your JSON data by deleting your events data. I highly doubt it was caused by that. I would start mango up with a fresh DB and restore to one of your backed up versions where the JSON data is still there and then try to delete the events again.

Sounds good. I downloaded and installed the free version. I'm guessing I should download and replace the free version with the enterprise version?

Ok, I found a solution! The old thread pool settings: [image: 27VaYgI.png] Settings now: [image: 8Xk61qq.png] The setup with more than 120 BACnet-Devices needs a lot of threads, so the ptp-sync hasn't enough and failed. Now it needs more CPU (20-45%) but it is working, that is fine.

Yep. You are right. Thank you!

@craigweb Thank you; Port 8080 is being used and that was the isssue.

Thanks, Joel, appreciate the quick reply!

Okay. There is Definitely a Bug in Mango- I just upgraded one of my sites from 3.5.x to 3.7.3 and had all of the devices on one of my USB to Serial converters not work. This system has (2)- One is talking to inverters, the other is talking to a meter and some other stuff. The "meter and other stuff" one is fine, but the inverter one is most certainly Not Fine. So far, I've been unable to get this going. This is a USB to Serial converter attached to a Linux box, running on Java 8. To stress again: This was working Fine before the upgrade, and I just upgraded it, and it isn't working. Reboot isn't solving the problem this time. I've already upgraded to the latest JSSC. What changed in the serial drivers here?

Thanks for the response on this-- I'll start looking into doing this via CSV.. The last time I tried this I was getting a bit annoyed at the wrong things updating. I'll try the process outlined for the next set of projects I bring up. I actually got very quick doing this with the legacy view page by copying and just changing the two blanks, then clicking and changing the modbus addresses of the points. Went right quick.

@ralf said in SQL Data Source Insert and Update rows: INSERT INTO table_xz ( IDNr, StartSum, StartTemp, ValveNr, LineNr, StartTime) VALUES (?,?,?,'KS0717','B',NOW()) I know you can extend the insert query by just adding another batch of values after in brackets. INSERT INTO table_xz ( IDNr, StartSum, StartTemp, ValveNr, LineNr, StartTime) VALUES (?,?,?,'KS0717','B',NOW()),(?,?,?,'KS0717','B',NOW()) You may need to insert the actual values though.

@thomaseinasto Thanks Thomas , I made a silly mistake in the Calc, Its working as expected now. Cheers mate

Hello all, This issue happens more often than not - and the site is hosted with mangoautomation. Am I better off selfhosting this? Can someone please let me know why this is occurring, and some pro / cons to self hosting. Best Regards, Maurice

@MattFox - posted issue in Mango Feedback, should you have any thoughts.

@nathanRona I just did a quick test against test.mosquitto.org and was able to publish and receive JSON with Timestamp based values. I'm posting the JSON config so you can import it and see for yourself. I can't see exactly what is wrong with your setup but this confirms that it does in fact work. In the configuration I'm providing there are 2 data points, when you set the value for one it will publish to the receiving topic of the other. { "dataSources":[ { "xid":"DS_b911d1a5-dcfd-424d-ab07-77134185f2a8", "name":"Test.Mosquitto.ORG Client", "enabled":true, "type":"MqttClient", "alarmLevels":{ "DATA_SOURCE_EXCEPTION_EVENT":"URGENT", "MQTT_CONNECTION_FAILURE_EVENT":"URGENT", "MQTT_PUBLISH_FAILURE_EVENT":"URGENT", "POINT_READ_EXCEPTION_EVENT":"URGENT", "MQTT_UNKNOWN_TOPIC":"IGNORE", "POINT_WRITE_EXCEPTION_EVENT":"URGENT" }, "purgeType":"YEARS", "brokerUri":"tcp:\/\/test.mosquitto.org:1883", "x509CaCrt":"", "clientId":"Mango Automation MQTT Client 148709547341099", "userName":"", "userPassword":"", "topicFilters":"infiniteautomation\/test\/#", "autoReconnect":true, "cleanSession":true, "keepAliveInterval":60, "connectionTimeout":30, "qosType":"EXACTLY_ONCE", "editPermission":"", "purgeOverride":false, "purgePeriod":1 } ], "dataPoints":[ { "xid":"DP_ba31c77f-9c4f-4f02-802c-afcfae830441", "name":"number", "enabled":true, "loggingType":"ALL", "intervalLoggingPeriodType":"MINUTES", "intervalLoggingType":"AVERAGE", "purgeType":"YEARS", "pointLocator":{ "dataType":"NUMERIC", "subscribeTopicType":"JSON_WITH_TIMESTAMP", "subscribeJsonTimestampPath":"\/ts", "subscribeJsonTimestampPattern":"yyyy-MM-dd'T'HH:mm:ss.SSSSSSSSSX", "subscribeJsonValuePath":"\/d", "subscribeTopic":"infiniteautomation\/test\/number", "publishTopicType":"JSON_WITH_TIMESTAMP", "publishJsonTimestampName":"ts", "publishJsonTimestampPattern":"yyyy-MM-dd'T'HH:mm:ss.SSSSSSSSSX", "publishJsonTimestampZone":"UTC", "publishJsonValueName":"d", "publishTopic":"infiniteautomation\/test\/set\/number" }, "eventDetectors":[ ], "plotType":"STEP", "rollup":"NONE", "unit":"s", "simplifyType":"NONE", "chartColour":"", "chartRenderer":{ "type":"IMAGE", "timePeriodType":"DAYS", "numberOfPeriods":1 }, "dataSourceXid":"DS_b911d1a5-dcfd-424d-ab07-77134185f2a8", "defaultCacheSize":1, "deviceName":"Test.Mosquitto.ORG Client", "discardExtremeValues":false, "discardHighLimit":1.7976931348623157E308, "discardLowLimit":-1.7976931348623157E308, "intervalLoggingPeriod":1, "intervalLoggingSampleWindowSize":0, "overrideIntervalLoggingSamples":false, "preventSetExtremeValues":false, "purgeOverride":false, "purgePeriod":1, "readPermission":"", "setExtremeHighLimit":1.7976931348623157E308, "setExtremeLowLimit":-1.7976931348623157E308, "setPermission":"", "tags":{ }, "textRenderer":{ "type":"ANALOG", "useUnitAsSuffix":true, "format":"0.00" }, "tolerance":0.0 }, { "xid":"DP_0460c207-8a22-4b7c-92b6-ab70c1c41d1c", "name":"number-recieve", "enabled":true, "loggingType":"ALL", "intervalLoggingPeriodType":"MINUTES", "intervalLoggingType":"INSTANT", "purgeType":"YEARS", "pointLocator":{ "dataType":"NUMERIC", "subscribeTopicType":"JSON_WITH_TIMESTAMP", "subscribeJsonTimestampPath":"\/ts", "subscribeJsonTimestampPattern":"yyyy-MM-dd'T'HH:mm:ss.SSSSSSSSSX", "subscribeJsonValuePath":"\/d", "subscribeTopic":"infiniteautomation\/test\/set\/number", "publishTopicType":"JSON_WITH_TIMESTAMP", "publishJsonTimestampName":"ts", "publishJsonTimestampPattern":"yyyy-MM-dd'T'HH:mm:ss.SSSSSSSSSX", "publishJsonTimestampZone":"UTC", "publishJsonValueName":"d", "publishTopic":"infiniteautomation\/test\/number" }, "eventDetectors":[ ], "plotType":"STEP", "rollup":"NONE", "unit":"s", "simplifyType":"NONE", "chartColour":"", "chartRenderer":{ "type":"IMAGE", "timePeriodType":"DAYS", "numberOfPeriods":1 }, "dataSourceXid":"DS_b911d1a5-dcfd-424d-ab07-77134185f2a8", "defaultCacheSize":1, "deviceName":"Test.Mosquitto.ORG Client", "discardExtremeValues":false, "discardHighLimit":1.7976931348623157E308, "discardLowLimit":-1.7976931348623157E308, "intervalLoggingPeriod":15, "intervalLoggingSampleWindowSize":0, "overrideIntervalLoggingSamples":false, "preventSetExtremeValues":false, "purgeOverride":false, "purgePeriod":1, "readPermission":"", "setExtremeHighLimit":1.7976931348623157E308, "setExtremeLowLimit":-1.7976931348623157E308, "setPermission":"", "tags":{ }, "textRenderer":{ "type":"ANALOG", "useUnitAsSuffix":true, "format":"0.00" }, "tolerance":0.0 } ] }

No worries, Sorry about that you are right, that was a node.js code snippet not JSON. And yes those codes are also very common. In v3 of the REST api we are going to put some effort into making the Swagger output accurate AND useful...