• P
    Phillip Weeks

    @mattfox Yes how do you find these old posts? I knew I asked this before just could not find it.

    posted in Dashboard Designer & Custom AngularJS Pages read more
  • P
    Phillip Weeks

    I know this was asked before but how do I clear the edit page from loading a the last edited page, which hangs my screen. This also goes for the Dashboard designer.
    Thanks in Advance

    posted in Dashboard Designer & Custom AngularJS Pages read more
  • P
    Phillip Weeks

    OK Thank-you,
    I will clear these and rebuild it per this 255char constraint

    posted in User help read more
  • P
    Phillip Weeks

    I am able to retrieve a set of points based on devicename = MU2 and when I try to apply the permissions I get this error... Mango XHR request failed, status=error, error=Server Error, url=/rest/v1/data-points/bulk-apply-read-permissions?deviceName=match=MU2

    Checking the log it complains about value too long for the column. Can someone tell me what the issue is? I am trying to add "polycorp" to the read permissions column of this data set "user312,Quser,superadmin".

    org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; Value too long for column "READPERMISSION VARCHAR_IGNORECASE(255) SELECTIVITY 2": "CAST('MU2user207,MU2user208,MU2user209,MU2user203,MU2user302,MU2user204,MU2user303,MU2user205,MU2user206,polycorp,superadmin,MU2... (266)"; SQL statement:
    UPDATE "PUBLIC"."DATAPOINTS" SET "ID"=? ,"READPERMISSION"=? ,"SETPERMISSION"=?  WHERE "ID"=? [22001-196]; nested exception is org.h2.jdbc.JdbcSQLException: Value too long for column "READPERMISSION VARCHAR_IGNORECASE(255) SELECTIVITY 2": "CAST('MU2user207,MU2user208,MU2user209,MU2user203,MU2user302,MU2user204,MU2user303,MU2user205,MU2user206,polycorp,superadmin,MU2... (266)"; SQL statement:
    UPDATE "PUBLIC"."DATAPOINTS" SET "ID"=? ,"READPERMISSION"=? ,"SETPERMISSION"=?  WHERE "ID"=? [22001-196]
    	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:246) ~[spring-jdbc-5.0.10.RELEASE.jar:5.0.10.RELEASE]
    	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) ~[spring-jdbc-5.0.10.RELEASE.jar:5.0.10.RELEASE]
    	at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1402) ~[spring-jdbc-5.0.10.RELEASE.jar:5.0.10.RELEASE]
    	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:620) ~[spring-jdbc-5.0.10.RELEASE.jar:5.0.10.RELEASE]
    	at com.serotonin.m2m2.db.dao.DataPointDao.bulkUpdatePermissions(DataPointDao.java:1421) ~[mango-3.5.6.jar:?]
    	at com.serotonin.m2m2.web.mvc.rest.v1.DataPointRestController.bulkApplyReadPermissions(DataPointRestController.java:876) ~[?:?]
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_171]
    

    posted in User help read more
  • P
    Phillip Weeks

    Is there a way mango can report the total kilobytes transferred through a tcp connection in last 24 hours?

    posted in User help read more
  • P
    Phillip Weeks

    With an HTML page I generate dynamically using NG-REPEAT, how do I get the
    "Powered by Mango Automation v3.5.6 ©2019 Infinite Automation Systems, Inc. All rights reserved."
    footer to actually go to the footer of the generated page?

    posted in Dashboard Designer & Custom AngularJS Pages read more
  • P
    Phillip Weeks

    @craigweb said in Using <ma-state-params:

    <ma-watch-list-parameters id="ac84b0bc-6c9a-4963--3ae644855233" ng-model="designer.parameters" watch-list="designer.watchList" ng-change="updateParams = designer.parameters" ></ma-watch-list-parameters>

    Thank you Thank you I followed your suggestion and got it working correctly now.

    posted in Dashboard Designer & Custom AngularJS Pages read more
  • P
    Phillip Weeks

    I thought I followed the conversation on using this directive however something is not right. The page does not select the deviceName I supply with DN. Any suggestions? I am trying to set deviceName parameter by URL?DN=SBUTLER using this button from another page. This button click loads the page but with no DN parameter in the url .

    <md-button class="md-raised md-accent" ui-state="'ui.residentialClients.usermonitor3'" ui-state-params="{'DN':'SBUTLER'}"></md-button>

    <ma-state-params on-change="designer.parameters.DN= $stateParams.DN; stateParams = $stateParams" update-params="updateParams"></ma-state-params>

    <ma-watch-list-get ng-model="designer.watchList" auto-state-params="true" parameters="designer.parameters" on-points-change="designer.points = $points" id="8b1acf1a-e537-48bc-b2a4-92e2c856845a" watch-list-xid="WL_SelectedClient"></ma-watch-list-get>

    <ma-watch-list-parameters id="5508aac6-c7bd-4c5e-af06-f3cb71e80727" watch-list="designer.watchList" ng-model="designer.parameters" ng-change="updateParams = designer.parameters"></ma-watch-list-parameters>

    Page loads but the watchlist is empty as no parameter had been supplied. When I select a item from the parameter list the DN value populates in updateParams.

    posted in Dashboard Designer & Custom AngularJS Pages read more
  • P
    Phillip Weeks

    I am copying modbus I/P data sources from our 2.8.8 cloud server to a local 3.5 cloud server. With some DS the JSON import works fine and they begin polling immediately but with several the DS reports java.net.NoRouteToHostException: No route to host (Host unreachable)) when I try to read a register.
    What should I look for to correct this issue with these data sources. They are all coming from the same machine and all working on the 2.8.8 box.

    posted in User help read more