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.

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:

0_1578997281515_ad7a49b3-2b49-4a5b-bdcf-9577fd404f36-image.png

Settings now:

0_1578997216570_5c7fd5ef-9f5b-478a-8084-3f4391eea992-image.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...

Thank you - the ui settings works.

Yes, I can browse and connect to OPC DA servers installed locally using other clients such as by Matrikon etc. There is very little DCOM configuration needed when you are connecting to servers installed on local machine. As I mentioned, typically browsing locally installed OPC servers should not require any username or password. The help documentation for OPC DA data source does not give a proper example of how to browse and connect to an OPC DA Server.

Is there a video that explains how it works, similar to the video for SVG graphics?

@zhilin-chen said in Why this kind of <style> can not work?:

@thomaseinasto said in Why this kind of <style> can not work?:

!important

Yes!! It finally works!!! Thank you so much!!

Be careful using !important everywhere, it makes it hard to override elsewhere. Follow my instructions above and read this article -
https://developer.mozilla.org/en-US/docs/Web/CSS/Specificity