• C
    cmusselm

    What Craig said is correct. Load balancing doesn't require multiple servers. You can "load balance" one server, so technically yes, you could use a load balancer in front of Mango.

    posted in User help read more
  • C
    cmusselm

    Awesome, thank you! I'll try this out.

    posted in User help read more
  • C
    cmusselm

    Hi, Craig,

    Thanks for checking and offering to help. I'm trying to put a simple method to check if comms to the data source are acceptable (Would be modbus in prod, but for test, just using a scripting source to get the logic correct). My first post to the forum on this topic was around the Poll Success Percentage to get clarity how it worked. (https://forum.infiniteautomation.com/topic/4925/poll-success-percentage-over-what-timeframe)

    Since that is from the data source start time, the % wouldn't be affected enough to show if a data source is having comm issues over the previous few minutes.

    I was hoping the PSSP would be an easier method than creating scripts to hit the API to get the runtime status. I looked into the scripting/API route a bit but was not sure how I could hit the API from a scripting data source.

    To try and avoid that I set up a meta data point to say that if the PSSP value was -1 or > 7.5 then comms are good. If > 5.5 then OK, and if <= 5.5 we had some bad comms.

    I then created an event detector to notify us if the comms were bad for more than 2 minutes.

    I may be going about this the wrong way, so if you have suggestions I'm all ears (or eyes in this case).

    Thanks,
    Chad

    posted in User help read more
  • C
    cmusselm

    Hi, All,

    I am trying to use the internal metric "Previous Sequential Successful Polls" (PSSP) on one of my data sources but am unsure of a value I'm currently seeing. Any help to provide info around this is appreciated. Maybe I'm overlooking something obvious.

    How I Understand This To Work:

    • This metric doesn't seem to actually count the previous successful poll, but the number of successful polls since the last aborted poll, with a max value of 10
    • A value of -1 indicates that the data source has not had an aborted poll since it's last restart

    What I'm seeing in reality:

    • This was working how I understood it to work until this morning
    • I started to get all zeros for the value and not sure why

    Below is an image of the runtime status of the data source that PSSP is using to get its value:
    0_1600969603556_944d3226-3930-4761-8cc5-028cdcf1a340-image.png
    You can see that I did have 2 aborted polls in 2 consecutive seconds (The DS polls every second)

    This image is a chart of the PSSP data point showing the values over the past 24 hours. The interal data source polls every 5 seconds and this data point logs the average every minute.
    0_1600969681371_c62625f5-7e38-4059-bc0c-925576c4c9b6-image.png
    Yesterday it was 10 (assume this just says the previous 10 polls were successful) until we did a reboot. After that it was -1 (assume since no other polls aborted)

    Then around 11:30, when we got 2 consecutive polls being aborted, the value went to 0 and stayed there. Shouldn't the value have incrementally gone up and back to 10 since these are the only two aborted polls for the data source?

    Can the logic behind the values derived for the PSSP be explained in more detail? I looked through documentation, but couldn't find anything. We're using v3.7.7.

    Thanks,
    Chad

    posted in User help read more
  • C
    cmusselm

    I also get this error, but for the \rdsdbdata\db directory. We're running MySQL on Amazon RDS. I'm guessing Mango does not have permissions to view the file system, or is treating \rdsdbdata\db as a local directory when trying to view the usage?

    As Fox asked, any way to disable this check to save some errors in the log file?

    Thanks,
    Chad

    posted in Mango feedback read more
  • C
    cmusselm

    Thank you! That probably won't make the point usable for what we want, but is good to know. I guess we could use the /data-sources/status/{xid} API endpoint and parse the results to see if there are any failures over the past x minutes.

    posted in Mango Automation general Discussion read more
  • C
    cmusselm

    Hi, all,

    I'm working with a client that would like to know when he's starting to have communication issues with the data sources in the field. One measure we'd like to use is the internal metric of Poll Success Percentage for ModBus data sources.

    This could be very useful, but right now we're not sure of the timeframe, or number of past polls in which the success percentage is calculated. I've never seen the percentage drop below 99.x which leads me to believe this measures the percentage over at least the past hour or so. Is this correct?

    Is there any way to tell Mango the timeframe or # of previous polls over which we'd like this measurement to be taken? I looked at a couple of the parameter files, but didn't see anything that sticks out.

    Thanks,
    Chad

    posted in Mango Automation general Discussion read more
  • C
    cmusselm

    For anyone interested here's some basic markup that we used to get this going. Lots that can be done from there to show the data points on a graph, in a table, etc.

    Hopefully it is helpful.

    <div layout="column" layout-fill="" flex="">
        <div flex="" layout="row" layout-xs="column" layout-fill="">
            <div layout="column" flex="33" flex-xs="33">
                <md-card flex="" style="overflow-y: auto;">
                    <md-card-content>
                        <h3>Hierarchy</h3>
                        <ma-tag-hierarchy ng-model="page.selected" tags="['Tag 1', 'Tag 2', 'device']" points="page.points = $points"></ma-tag-hierarchy>
                    </md-card-content>
                </md-card>
            </div>
            <div layout="column" flex="" ng-app="ngMyApp">
                <md-card flex="" style="overflow-y: auto;">
                    <md-card-content>
                        <h3>Points Table</h3>
                        
                        <md-table-container ng-init="page.tableOrder='name'">
    
                            <table md-table="">
                                <thead md-head="" md-order="page.tableOrder">
                                <tr>
                                    <th md-column="" md-order-by="deviceName">Device Name</th>
                                    <th md-column="" md-order-by="name">Data Point</th>
                                    <th md-column="">Value</th>
                                    <th md-column="">Last Time Stamp</th>
                                </tr>
                                </thead>
                                <tbody md-body="">
                                <tr ng-repeat="point in page.points | orderBy: page.tableOrder" style="line-height: 30px;">
                                    <td md-cell="">{{point.deviceName}}</td>
                                    <td md-cell="">{{point.name}}</td>
                                    <td md-cell="">
                                        <ma-point-value point-xid="{{point.xid}}"></ma-point-value>
                                    </td>
                                    <td md-cell="">
                                        <ma-point-value point-xid="{{point.xid}}" display-type="dateTime"></ma-point-value>
                                    </td>
                                </tr>
                                </tbody>
                            </table>
                        </md-table-container>
                    </md-card-content>
                </md-card>
            </div>
        </div>
    </div>

    posted in Mango feedback read more
  • C
    cmusselm

    For anyone interested, I did find a way around this. The issue isn't with Mango, but how Windows works. By default Windows does not allow a service to "see" mapped network drives.

    The way around this was to create a link in C:\ to the folders we have set up on the network share.

    mklink /D C:\Backups \\yourSharedServer\share\Backups
    

    Doing this allows us to use the shared drive to house backups and other files. Before, when the drive was mapped as z:\ the Mango UI would say it couldn't find z:\Backups. Now it can find the link created and works well.

    Thanks,
    Chad

    posted in Mango Automation general Discussion read more