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.

Hi mlavelle,

There would be a couple options. You could do one of the following,

Figure out why that error is occurring and resolve it. Edit Mango/web/modules/BACnet/classes/i18n.properties edit event.bacnet.readDevice from 'Read properties from device at {0} failed: {1}' to 'Read properties from device at {0} failed' (This solution won't persist through any upgrades, but could be redone) Change the event level for that BACnet data source's "Device Error" to Do Not Log or Ignore

The best place to look is in upgrading to 2.8. These messages in 2.8 tell you what sort of task was rejected.

Off the bat you can know that it is a repeating task that will reschedule itself, and it is not actually a fatal error.

That works. Sure. Thanks.

Hi Chris,

Does anything come out in your Mango log files? What service file are you using? Is Java installed on a path that will be available to the runtime of the service? Is JAVA_HOME set?

Thanks Phil. Duh.... on my part.

Nice, thanks for sharing your solution!

I am somewhat surprised that could possibly find the old data but not record the new. Your Mango log files are at Mango/logs/ and the Mango log is ma.log. I have seen some people whose logs are in Mango/bin/logs/ on Windows.

Hi prezemom,

It's not really possible to give a limit in terms of data points, since different configurations will entail wildly different workloads for the Mango server (it is possible to write Meta points that slow everything down a lot, if you try). Generally, though, 5000 points shouldn't pose any problem. As far as HTTP, you can see that parsing 5000 values out of 1 page request is less work than 5000 data sources requesting 5000 pages to get 1 value. I would expect both to work on a fairly modest machine (four cores, 4-8Gb ram). We have many deployments with 20000 or more points, and some significantly larger than that.

Both the H2 and MySQL backends will handle 5000 points no problem. If you get significantly larger you may find reasons to prefer MySQL. The NoSQL database is also nice to have if you're taking in dense data, or lots of it, or if you intend to keep the values at the instance very long (without the NoSQL, you will store the values in a SQL table, which can slow things down over time).

Thanks Joel I will submit a support ticket today - the ES was being upgraded from core 2.7.2 to the latest available version.

The best way I found to do this was to create a second sheet and have Mango paste the data into that and then on the first sheet you simply link to the data on the second sheet.

See sample below. Highlight at least 2-3 rows and then in the formulas tab choose create from selection. These are now what you select in Mango. Format the columns before you upload the Excel file.

0_1478649010748_ExcelSample.png

Hi Chris,

Yes, BACnet heavy systems have been observed to behave somewhat better when everything is under one data source as opposed to many. You can increase the thread pool size maximum on the system settings page for the high priority pool.

@terrypacker
I'm clear. I'm appreciated for your reply.

Hello Jared, Thanks for your reply.

Look in your /logs/ma.log file for errors. There might be something more specific there.

Whoops! My mistake. I shouldn't have been using setDate(0); The first day of the month is 1, and it accepts negative numbers, so 0 is a day before 1.

Check your log file while you import.
Try it with a single line of data.

Thank phildunlap for your support.
I know it is not so straightforward. But we need it because it is proof to show demo and do estimate for our customer.

Awesome!!!

I'm not sure there is a hard and fast simplification for the selection of the type. That said, that's a fine intuition to start from.

Another kind of meta data point will be something like the 'Time since status' genre. In this case, I typically use a cron AND a context update. While just using a cron would enable you to recompute the minutes since the last update/change/negative value/whatever, but it isn't responsive and would probably never report a zero. So the context update is useful to zero it out.

Hi Chris,

Probably the right tool to resolve what is going on there is jstack, a thread dumping utility in Java. To use (if jstack is on your path. otherwise would be in jdk/bin/ ), you can type:

jstack -l 1704 > C:\Users\You\MangoStuff\stack-1704 jstack -l 1220 > C:\Users\You\MangoStuff\stack-1220

It could also be useful to know which is the parent PID, if one is the parent pid of the other (maybe you have two Java processes, maybe you have started two instances of Mango on different ports). It looks like you can get PPID numbers via this command at the command prompt:

wmic process where (processid=1704) get parentprocessid

My only familiarity with causing these forks to happen and hang uses Process Event Handlers, so if you have some I will invariably ask something about if that script runs and works.

im doing that now