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.

The good news: I finally migrated the data. I think. The bad news: I still don't know why java crashes In frustration, I finally ran the migration with 1 low-priority thread, and in about 15 minutes, it finally completed — sort of. I tried updating java to 1.8.0_152; no effect Added 4GB swap (in addition to the 1GB already configured): no effect I executed the migration on a VirtualBox VM: no problem, success in about 3 minutes Finally, migrated on the server in question with 1 low-priority thread, It executed for 923 seconds — then stopped. I feared it had crashed again, but I noticed mango was still alive, so I checked a few things. That's when it got interesting. The migration page was seemingly stalled at 19648161 of 38879054 [image: McgFVBY.png] But in the log file, it claimed to have successfully completed: INFO 2017-12-15T16:03:36,024 (com.infiniteautomation.nosql.maint.MangoNoSqlMigrationWorkItem.execute:70) - Starting Data Migration, please wait... INFO 2017-12-15T16:18:59,072 (com.infiniteautomation.nosql.maint.MangoNoSqlMigrationWorkItem.execute:151) - Migrated 19648161 point values. INFO 2017-12-15T16:18:59,072 (com.infiniteautomation.nosql.maint.MangoNoSqlMigrationWorkItem.execute:155) - Finished Data Migration, 19648161 point values migrated to Time Series Datastore took 923.048s Eventually my eye caught that the 19648161 was (approximately) the same number I had seen in my successful simulation on the VirtualBox instance: [image: c0rx7bJ.png] But a quick query on the original db shows: MariaDB [mango]> SELECT COUNT(*) FROM pointValues; +----------+ | COUNT(*) | +----------+ | 38879054 | +----------+ Curiously, the “successful” migrations show about half the total. I also notice (especially on the actual server) that the total changes a few times during the migration. So please help me understand: did the data migrate? Or only half? What am I not understanding? The crashing seems obvious to be a java problem, but I can't glean any diagnostic information to pursue further. Note that this instance is running on an Arm architecture, so that might be a factor as well.

We just installed a ClickPLC and are using Modbus TCP. This connection is going through a single hop through a Cisco switch. Right now I've only configured 1 point as a test. For our 1 point, I just checked with a 25 ms update period, and it's been stable for the past 10 minutes, as I haven't seen any errors on Mango's side. I'm sure how the polling is affected with more points. I plan on polling at 250 ms, as that is more than adequate for our needs.

Yeah, sorry, that was a bug. Got the fix in, though.

I meant to say it will use the NoSQL if installed. That's what I meant by prefer. I don't believe we created any tools to covert existing reportInstanceData tables to the NoSQL data store. So, I would expect any old report instances you have don't have their data available.

Upon examining the server, I observed all data from the SQL database had been successfully migrated. It was speculated the data that was sought hadn't been in the SQL database, and this is why it didn't appear after the migration.

Hi guys, Thanks very much for the advice. Upon @Jared-Wiltshire's recommendation I pasted my Google Analytics Property ID into the UI settings page. It's then as simple as creating an onclick event: https://developers.google.com/analytics/devguides/collection/analyticsjs/events <div flex layout="column" onclick="ga('send', 'event', 'buttons', 'click','B005');"></div> From here I was able to view real-time and historic page interactions based on clicking. I could also create events for mouse moving, but it generates a lot of events as you would expect and in google analytics you are limited to 500 hits per session or 10 million events per month. <div flex layout="column" onmousemove="ga('send', 'event', 'mouse', 'move','B005');"></div> Really happy though - exactly what I was after. [image: VyOiGCS.png]

Understood, but there was no such file. There is a file named com.serotonin.m2m2.db.upgrade.Upgrade17.log but it's empty -rw-r--r-- 1 mango mango 0 Nov 22 14:44 com.infiniteautomation.mango.scheduling.db.upgrade.Upgrade4.log -rw-r--r-- 1 mango mango 0 Nov 22 12:58 com.serotonin.m2m2.db.upgrade.Upgrade13.log -rw-r--r-- 1 mango mango 35 Nov 22 12:58 com.serotonin.m2m2.db.upgrade.Upgrade14.log -rw-r--r-- 1 mango mango 0 Nov 22 12:58 com.serotonin.m2m2.db.upgrade.Upgrade15.log -rw-r--r-- 1 mango mango 0 Nov 22 12:58 com.serotonin.m2m2.db.upgrade.Upgrade16.log -rw-r--r-- 1 mango mango 0 Nov 22 12:58 com.serotonin.m2m2.db.upgrade.Upgrade17.log The one file which isn't completely empty only reads: Updated 0 user comments with XIDs.

Hi te36051, Interesting! Thanks for sharing the solution. I wasn't familiar with that mysql option. The same problem may be solvable by modifying the connection string to use whatever pipe that configuration was creating. Some relevant information here: https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-configuration-properties.html But, I would think binding the loopback address (127.0.0.1) would be adequate for most situations.

Was this ever resolved?

Get it! thanks

Now, I can login, but only in google chrome, internet explorer don't run.

Hmm. Well, I'll think about it more but I'm fairly confident Modbus4J handles it properly. Yeah you should be able to unpack the string the same way you packed it. Edit: My recommendation, to prove what you're saying, would be to disable all the points on your modbus data source, the enable IO logging and the two points as 4 byte variants. Do the read, disable the points. Enable the 8 byte single point, do a read. Post the resultant IO log.

Thanks Joel, I'll keep that in mind! Cheers!

Hi bwmasterson, Yes, there are both BACnet and Modbus publishers that can expose any data Mango has gathered over BACnet or Modbus. We have also looked into adding an SNMP publisher. There is of course the HTTP publisher as well but you're probably more interested in device protocols.

Hi eksantrik, The JDBC driver for MSSQL is not bundled with Mango. You can download it here: https://docs.microsoft.com/en-us/sql/connect/sql-connection-libraries#anchor-20-drivers-relational-access (has links for 6.0 and 6.2 for Java currently). You want the .tar.gz download, it'll have the driver compiled for Java 8, so copy that jar into your Mango/overrides/lib directory and try again.

thank you!

I tested publish information and is ok, but I can´t suscriber, I think that is a problem of the Broker in Blumix, Thank