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.

  • Update Data Point

    4
    0 Votes
    4 Posts
    2k Views
    phildunlapP
    I am not certain what you are seeing, you make it sound like it is not running at all? You didn't include validate output. Maybe this is a meta point and the context point is disabled? While I omit the wildcard for year in my cron patterns, that shouldn't be the cause.
  • Sorting an output array of ma-point-statistics

    7
    0 Votes
    7 Posts
    3k Views
    Jared WiltshireJ
    @uelojazz said in Sorting an output array of ma-point-statistics: Also do you have any link of User module URL examples (or an actual page that you are allowed to share) . https://help.infiniteautomation.com/getting-started-with-a-user-module/ Also search the forum, I have posted plenty of examples. https://forum.infiniteautomation.com/search?term=user module&in=titlesposts @uelojazz said in Sorting an output array of ma-point-statistics: Can you help me out how to sort an output of a ma-point-values ? What exactly are you trying to do? It looks like you are trying to find the points with the largest x-minute integral? Do you want this per point for each x-minute window? I would say you might need to write a custom component in a user module for this.
  • Use of CRON to schedule reports.

    2
    0 Votes
    2 Posts
    2k Views
    Jared WiltshireJ
    @pascal are you talking about Excel reports? The cron expression should be evaluated against the server timezone AFAIK (it uses the timezone from the OS/JVM by default, you can override this in your env.properties file). Are you sure you don't have your server timezone set to UTC? @pascal said in Use of CRON to schedule reports.: What is the behavior of the CRON expression when DST (daylight saving time) adjustments apply Good question. Our cron code is based on the Quartz scheduling library v2.1.0, so this should help - http://www.quartz-scheduler.org/documentation/faq.html#FAQ-daylightSavings Of course if its actually evaluating the expressions as UTC time then there is no DST.
  • DataPoints previous values

    2
    0 Votes
    2 Posts
    2k Views
    phildunlapP
    Hi arvand, The functions in "About Mango JavaScript" will work in Mango scripting contexts only, so Scripting data sources, meta data points, point links, etc. Judging from that snippet, is it part of a dashboard you're designing? If so, you could check out the existing getPointValue.js file in the UI module powering the ma-get-point-value directive, or check out the NodeJS style use of the REST API for point values, here: https://github.com/infiniteautomation/node-mango-client If it really is in the Mango JavaScript environments, you can print(p123); to see the available functions on the context point.
  • Problem with data point scripting

    16
    0 Votes
    16 Posts
    6k Views
    phildunlapP
    Thanks for sharing the resolution!
  • This topic is deleted!

    1
    0 Votes
    1 Posts
    1 Views
    No one has replied
  • Java memory usage

    5
    0 Votes
    5 Posts
    3k Views
    C
    Yes I tried to stop and start Mango again but it didn't help at all. Finally I resolved it by editing script in ma-start.bat - "%EXECJAVA%" %JPDA% %JAVAOPTS% -server -Xmx2500m -Xms1000m -Dma.home="%MA_HOME%" -cp "%MA_CP%" com.serotonin.m2m2.Main Maybe it's not elegant but now I see change in memory usage after starting Mango. Thanks for help. Greetings
  • Scripting to reset serial (MODBUS) data source

    5
    0 Votes
    5 Posts
    4k Views
    phildunlapP
    Hi Dan, Perhaps your Mango is quite old? The sleep function was added sometime ago as a wrapper for Thread.sleep. You may still be able to do java.lang.Thread.sleep(XXXX); if you are using Java 8.
  • How to identify the date of a returned value?

    6
    0 Votes
    6 Posts
    2k Views
    P
    something screwy about this new history purge feature. I made a mistake entering the end date when I ran the first time and it created records back to 1969. [image: nWb9Aw4.png]
  • Meta Data point with Excel Report

    17
    0 Votes
    17 Posts
    4k Views
    T
    TL;DR If you make an excel template, limit your named ranges to as small as possible Alrighty, so after a few more days of troubleshooting, @phildunlap took a look at my excel template. He determined that the named range I designated in Excel was too long (only by a million cells!) for EACH named range, of which there are about 50. So, the theory was that the POI Apache plugin that allows Mango to interact with Excel was loading these empty cells into memory somehow, and was sporadically causing a memory leak or memory usage at least until the point where it would cripple the amount of available memory to the JVM to VERY VERY low, and render the garbage collection useless. Thats a mouthful. And so, the problem only reared its ugly head once in awhile, it was hard to track down, but I've been operating for about a week now with no "crippling" memory issue, and I've launched thousands of reports without issue. For anyone who wants to know, the final template filled in is 82kb, has charts and 5 sheets of data, the time range spans 14 months and there are multiple different time ranges used and approximately 10-15 data points queried.
  • This topic is deleted!

    1
    0 Votes
    1 Posts
    6 Views
    No one has replied
  • Assistance needed with Mango 1.2 dslink for DGLux5

    10
    0 Votes
    10 Posts
    3k Views
    raylatbasixR
    Hi Terry, I've emailed you a log file separately regarding this issue. Thanks for the help!
  • Metadata Script execution when?

    docupdate rcdoc
    11
    0 Votes
    11 Posts
    5k Views
    phildunlapP
    Sure, you would do the same thing to get pvd, then do var values = pvd.getLatestPointValues(dataPointId, 2);
  • Comparison of scripting data sources

    7
    0 Votes
    7 Posts
    4k Views
    phildunlapP
    It is expected. Ideal or not, who can say. But, originally there was 'no change' to facilitate this kind of point, and it would do what you described. But, it also generated a 'point updated' event every poll period. So, in comes the non-polling virtual data source, which never schedules itself to do any work, it just sits there. I could understand using the start value even still in this situation: it does seem implied. But, it's just as easy to initialize them elsewhere.
  • How to make Data source page?

    5
    0 Votes
    5 Posts
    2k Views
    phildunlapP
    @te36051 said in How to make Data source page?: Sory for my English language. I want to build my page. May be include graphic, gauges or anything for my design. And one I want include datasource table and chart function same example below picture into my page too. Can you recommend me?😅 No worries. I would use the word "watchlist" for what you posted, and the chart would then be a "watchlist chart". That's what it will be called in the API docs
  • How to streaming video from IP camera to Mango dashboard.?

    6
    0 Votes
    6 Posts
    3k Views
    phildunlapP
    Nice! Glad you got it working!
  • How to set the poll times of a data source into a data point?

    1
    0 Votes
    1 Posts
    1k Views
    No one has replied
  • How to Enable/disable datasource by Script in active process command?

    5
    0 Votes
    5 Posts
    2k Views
    phildunlapP
    Glad to hear it! It should work in any script set point event handler, but you may need to give the handler sufficient script permissions (add 'superadmin' to the script permissions fields on the event handler) and ensure the event is raised.
  • Writing multiple Modbus devices triggered by a metadata or virtual source

    7
    0 Votes
    7 Posts
    3k Views
    P
    Thank you for your advice. I got this working last week, but as you indicate, it requires tree structures in Mango 2.8.8: one metadata point used for creating a context change from user input one metadata point to detect the context change then execute the script one scripting datasource to set multiple points each time the context of the first point changes I'm glad to hear this has been simplified in Mango 3.x.
  • Are there Point Link (pointLink) tutorials, or examples?

    pointlink point link
    22
    0 Votes
    22 Posts
    18k Views
    phildunlapP
    If the inserts are generated faster than they are processed, they would certainly not finish the queue. The SQL point values table hasn't been performance tested in quite some time. The NoSQL backend is so much faster it isn't really worth it. Our licensing in version 3 is such that only free licenses don't have an unrestricted NoSQL license. If using SQL you really need to keep that table small. I've not had issues with Aurora. I'm not sure that was the AWS RDS I've used by name but I've not had issues with the Amazon RDS in general. Using NoSQL would have behaved fine in the situation you describe to store data sufficient to charting it that way. Rollups should chart even if the value was log on change.