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.

@phildunlap Hello, yes I received your email, I will reply to the email.

@psysak It looks like you are using an older version of the BACnet4J library, I would suggest using the latest version 4.1.6 and see if you still have the problem. If you do then re-post the new stack trace so I can see how it fits in the latest code. I'm working on the library this week so if you can get the me the info before I move on then I'll make a fix if something is broken.

@phildunlap said in Excel Report:

the top section of /system_settings.shtm

I just checked the top section of /system_settings.shtm and I actually saw that you are using H2.

I think it was something of the update, because I made an update and since then it did not work anymore, but before that it was like MYSQL.

I will pass the database to MYSQL and check if the error will continue.

Good to know thanks Jared.

You could manually download the Data in CSV format, manipulate it and then upload it again.

If you need to have it automated I have a feeling you could write a metadata point script that would determine if data is being lost by looking at the last time data was logged and then average the spiked reading over the time the data was lost.

What are the logging settings you are using on the Data Point?

@joelhaggar Thanks for that the link to the manual upgrade. The upgrade worked, but there are still problems. The upgrade from 3.3.4 to 3.4.4 broke numerous metadata scripts (a problem someone else posted in https://forum.infiniteautomation.com/topic/3627/not-a-function). Also, the internal upgrade is still not working.

I just tried to upgrade the two modules listed on /ui/administration/modules/upgrade:

mangoNoSqlDatabase Time Series Data Store 3.4.0 3.4.1 MangoUI Provides an AngularJS user interface, 3.4.6 3.4.7

However, the automated download failed once again:

WARN 2018-07-11T20:40:26,229 (com.serotonin.m2m2.web.dwr.ModulesDwr$UpgradeDownloader.run:503) - Upgrade download error java.net.SocketException: Connection reset at java.net.SocketInputStream.read(SocketInputStream.java:210) ~[?:1.8.0_131] at java.net.SocketInputStream.read(SocketInputStream.java:141) ~[?:1.8.0_131] at org.apache.http.impl.io.SessionInputBufferImpl.streamRead(SessionInputBufferImpl.java:137) ~[httpcore-4.4.9.jar:4.4.9] at org.apache.http.impl.io.SessionInputBufferImpl.fillBuffer(SessionInputBufferImpl.java:153) ~[httpcore-4.4.9.jar:4.4.9] at org.apache.http.impl.io.SessionInputBufferImpl.read(SessionInputBufferImpl.java:206) ~[httpcore-4.4.9.jar:4.4.9] at org.apache.http.impl.io.ContentLengthInputStream.read(ContentLengthInputStream.java:176) ~[httpcore-4.4.9.jar:4.4.9] at org.apache.http.conn.EofSensorInputStream.read(EofSensorInputStream.java:135) ~[httpclient-4.5.5.jar:4.5.5] at org.apache.http.conn.EofSensorInputStream.read(EofSensorInputStream.java:148) ~[httpclient-4.5.5.jar:4.5.5] at com.serotonin.io.StreamUtils.transfer(StreamUtils.java:34) ~[mango-3.4.4.jar:?] at com.serotonin.io.StreamUtils.transfer(StreamUtils.java:27) ~[mango-3.4.4.jar:?] at com.serotonin.web.http.HttpUtils4.execute(HttpUtils4.java:105) ~[mango-3.4.4.jar:?] at com.serotonin.m2m2.web.dwr.ModulesDwr$UpgradeDownloader.run(ModulesDwr.java:499) [mango-3.4.4.jar:?] at com.serotonin.timer.Task.runTask(Task.java:179) [mango-3.4.4.jar:?] at com.serotonin.timer.TaskWrapper.run(TaskWrapper.java:23) [mango-3.4.4.jar:?] at com.serotonin.timer.OrderedThreadPoolExecutor$OrderedTaskCollection.run(OrderedThreadPoolExecutor.java:336) [mango-3.4.4.jar:?] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_131] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_131] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_131]

The ping time from my Mango server to infiniteautomation.com is close to 700ms. Perhaps there is a timeout in the Mango download function that is too strict to meet that loop time?

Thanks Jared.

For now we set web.security.iFrameAccess=ANY as a test and it works great. We might restrict it further in the future.

Thanks @phildunlap

Yes it was from a MPTCP Data source. I have altered and will see how it goes.

Thanks

Works great on LibreOffice and numbers! Excel just cant get it right I have tried all the delimiters.

@phildunlap said in Create event detector that applies to all/specific datapoints:

You'd have a bunch of options to hack it up.

You had me at hack
I've got a status dashboard doing something similar already. Although I can likely extend what you've done here and implement an email with a template listing all iffy datapoints. It's not an alarm per se but it sure is a darn good start.
I'll put it in the wishlist. I think it'd be good to datasource/point template wide alarm settings that individual points have.
Inidividual point alarms override template -> template override datasource. That's my idea.

Thanks again Phil!

Fox

https://forum.infiniteautomation.com/topic/3635/release-notes-for-mangoui-3-4-7

Phil,

Awesome, Thanks! I solved the immediate issue by using the database data source, but I did want to understand how the text file data source worked, so thanks for the import code, I will give it a look.

Hi gquiroz,

I do not understand the question. That code was intended to be added into the .java class file that would be placed into the appropriate Mango/web/modules/dataFile/web/CompilingGrounds/* folder to be compiled by the tool on the data file data source edit page into a .class file, which is then run to import the file or poll or whatever.

Hey Phil,

I was able to resolve it with the roll up function. Instead of First, I used Accumulator.

Sorry I forgot the /administration of the URL, I've updated the above post.

Interesting ideas Joel, thanks for that.

Thank you very much @phildunlap, I will try to prove with this what you tell me. What I need is just to show it.
Thanks again

The events table holds most of the information about an event, which some information about if a user has silenced it in the userEvents table. To delete all past event / alarm information one would purge these two tables (audit events are in the audit table)

................ yes?....

Thank you :)

I got around it by putting IllegalArgumentException since Instant extends it, but I will do it properly now