• phildunlap

    Hi jflores,

    Interesting! Can't say I can recall an issue anything like that. To recap, the report appears to have run at the right time with the right data but is taking an hour to appear in your email? The only way I would expect that behavior is if the report were taking an hour to finish, but that seems very long, or if the emails' timestamp is being viewed in a different timezone.

    Is this Excel Reports or Reports ? What version? What timezone is it set to? What timezone are you in? If you have the report 'Run now' does it finish quickly?

    posted in User help read more
  • phildunlap

    Hi Jorge,

    That would be done by adding the point that you have configured for the password registers to the context of a scripting data source, and then having the scripting data source set the value to the point on a cron pattern like 0 0/5 * * * ?

    passwordPoint.set(0xdeadbeef); //send this hexidecimal value as a set to the register
    

    posted in How-To read more
  • phildunlap

    Hi JoHn-Beer,

    It sounds like a time to use the PointValueQuery.

    var endDate = CONTEXT.getTimestamp();
    var startDate = endDate - CONTEXT.millisInPast(DAY, 30); //handles DST shenanigans
    var results = [];
    var callback = function(idValueTime) {
      results.push(idValueTime);
    };
    var pointsToQuery = [ p1.getDataPointWrapper().getId() ];
    PointValueQuery.rollupQuery( pointsToQuery, startDate, endDate, callback, LAST, 1, DAY);
    print(results);
    //Do want you want now with the results, or in the callback function
    

    Run on cron 0 0 8 * * ?

    posted in Dashboard Designer & Custom AngularJS Pages read more
  • phildunlap

    Hi psysak,

    I tried to run the report with a rollup of first and got nothing out. I assume that is because the point did not have any datapoints in that time range but I would have kind of expected it to give me whatever the last value of that point was.

    Providing the value before the period or the first value in the period is the distinction between the Start and First rollups.

    https://help.infiniteautomation.com/mango-rollups-and-statistics/

    posted in User help read more
  • phildunlap

    No, but it's possible your H2 database has grown large from other factors and trying to keep it in memory is causing issues.

    Can you check the developer console in the browser for errors on the page, and check the size of the H2 database at Mango/databases/mah2.h2.db ?

    Also, can you post the version of the Core and the Excel Reports module?

    posted in Mango Automation read more
  • phildunlap

    Memory and CPU usage

    Also could you right click on the page and click "Inspect" to see if there are errors in the console in the browser?

    posted in Mango Automation read more
  • phildunlap

    When you click the arrow to expand the dropdown what does it look like? By "the values" you mean the data points, right?

    Have you checked the resource consumption of Mango while you're doing this?

    posted in Mango Automation read more
  • phildunlap

    Hi gquiroz,

    That looks like it's the point selector that you're asking about. That's what I would expect to see if you do not have any data points with names containing "MTR03-"

    posted in Mango Automation read more
  • phildunlap

    Whenever a publisher or data source is saved, it is stopped and then started. You must save your changes for them to be in effect.

    posted in User help read more
  • phildunlap

    What is the recovery tool mentioned?

    That would be the H2 recovery tool. I've not used it before, so I'm not sure how it would help.

    It sounds like you have Mango running, so perhaps on the /sqlConsole.shtm page (or the /ui/administration/sql-console page) you can run.

    drop index if exists "DATA4";
    

    Do you have any existing core database backups in the Mango/backup directory? You could move your existing Mango/databases/ directory while Mango is off, then try restoring an older backup via the system settings page. If that works you could move in your old mangoTSDB directory to keep your data.

    posted in User help read more