• R
    Rodrigo

    Hi Phil,

    Thanks for replying!
    It's actually as you said, pointS x1, x2, x3 ,............,xn need to take a value at a given time, it doesn't have to be like the photo I included before. It's a group of something like 20 fan coils that need to be turned on in the morning and turned off in the afternoon.
    DGLux is running all the time (except when there's a power outage, but in this scenario they will have to check the state of everything after the power is reinstated), maybe something with the date picker from DGLux and the computer time will be enough.

    What do you think?
    Best,
    Rodrigo

    posted in DGLux Graphic Dashboards read more
  • R
    Rodrigo

    Hi Guys,

    I there someone here still using DGLux 2?
    I need to do a scheduler for an installation and have no idea how, attached there's an image of the scheduler I found on DGBox, does anyone knows how to create something like this?
    0_1533529162199_schedule_overview.jpg
    In this scheduler one can create, for example, a Occupancy schedule and assign this property to the points you want this schedule to act on.

    Thanks in advance,
    Best,
    Rodrigo

    posted in DGLux Graphic Dashboards read more
  • R
    Rodrigo

    @phildunlap

    Absolutely, It was my lack of patience :$

    Thanks again Phil,

    Regards

    posted in User help read more
  • R
    Rodrigo

    @phildunlap

    How do I know if the database has finished restoring?
    After hitting restore it just stays there.

    My mango version is 2.5.2

    "Using C:\Mango as MA_HOME
    C:\Mango\overrides\classes;C:\Mango\classes;C:\Mango\overrides\properties;C:\Man
    go\overrides\lib*;C:\Mango\lib*
    Using Java at java
    INFO 2017-05-26 14:51:16,416 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'asciiFile', v1.1.5 by Infinite Automation
    INFO 2017-05-26 14:51:16,423 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'BACnet', v2.1.3 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,427 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'controlcore', v1.0.5 by Infinite Automation
    INFO 2017-05-26 14:51:16,429 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'dashboards', v1.0.3 by Infinite Automation
    INFO 2017-05-26 14:51:16,430 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'dataFile', v1.0.8 by Infinite Automation
    INFO 2017-05-26 14:51:16,435 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'dataImport', v1.3.6 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,438 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'dglux', v1.2.0 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,440 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'dnp3', v1.5.0 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,443 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'galil', v1.4.5 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,445 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'graphicalViews', v1.5.2 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,463 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'http', v1.4.7 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,467 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'internal', v1.4.6 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,469 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'jmxds', v1.4.5 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,472 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'jspViews', v2.0.5 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,482 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'log4jDS', v1.0.2 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,485 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'log4JReset', v1.0.6 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,486 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'loggingConsole', v1.0.2 by Infinite Automation
    INFO 2017-05-26 14:51:16,487 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'maintenanceEvents', v1.4.8 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,490 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'mangoApi', v1.0.3 by Infinite Automation
    INFO 2017-05-26 14:51:16,491 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'mbus', v1.0.7 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,496 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'meta', v2.1.1 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,500 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'modbus', v1.5.4 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,509 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'onewire', v1.4.6 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,512 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'opcda', v1.5.7 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,513 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'openv4j', v1.0.5 by aploese
    INFO 2017-05-26 14:51:16,515 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'pachube', v1.4.8 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,517 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'persistent', v1.5.8 by Infinite Automation Systems Inc.
    INFO 2017-05-26 14:51:16,520 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'pointLinks', v1.4.6 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,522 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'pop3', v1.4.5 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,525 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'reports', v2.1.3 by Infinite Automation Systems Inc.
    INFO 2017-05-26 14:51:16,529 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'scheduledEvents', v1.4.7 by (unknown vendor)
    INFO 2017-05-26 14:51:16,531 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'scripting', v1.0.8 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,535 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'serial', v1.1.5 by Infinite Automation
    INFO 2017-05-26 14:51:16,537 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'snmp', v1.4.6 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,540 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'sqlConsole', v1.4.5 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,542 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'sqlds', v1.5.7 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,545 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'ssh', v1.0.5 by Infinite Automation Systems Inc.
    INFO 2017-05-26 14:51:16,548 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'sstGlobalScripts', v1.4.6 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,550 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'sstGraphics', v1.0.6 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,551 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'sstTheme', v1.0.6 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,551 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'TCPIP', v1.0.3 by Infinite Automation Systems Inc.
    INFO 2017-05-26 14:51:16,554 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'templateConfig', v1.0.5 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,556 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'twilio', v1.0.4 by (unknown vendor)
    INFO 2017-05-26 14:51:16,560 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'virtualDS', v1.4.5 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,563 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'vmstat', v1.4.7 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,569 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'watchlists', v1.6.1 by Infinite Automation Systems Inc.
    INFO 2017-05-26 14:51:17,306 (com.serotonin.m2m2.Lifecycle.loadLic:411) - Check
    ing license...
    INFO 2017-05-26 14:51:17,373 (com.serotonin.m2m2.db.H2Proxy.initializeImpl:42)

    • Initializing H2 connection manager
      INFO 2017-05-26 14:51:22,014 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgr
      ade:36) - Starting instance with core version 2.5.2, db 9
      Exception in thread "main" org.springframework.jdbc.BadSqlGrammarException: Prep
      aredStatementCallback; bad SQL grammar [select id, xid, alias, data from eventHa
      ndlers where eventTypeName=? and eventSubtypeName=? and (eventTypeRef1=? or ev
      entTypeRef1=0) and (eventTypeRef2=? or eventTypeRef2=0)]; nested exception is o
      rg.h2.jdbc.JdbcSQLException: Tabla "EVENTHANDLERS" no encontrada
      Table "EVENTHANDLERS" not found; SQL statement:
      select id, xid, alias, data from eventHandlers where eventTypeName=? and eventSu
      btypeName=? and (eventTypeRef1=? or eventTypeRef1=0) and (eventTypeRef2=? or
      eventTypeRef2=0) [42102-181]
      at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.d
      oTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)
      at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslat
      or.translate(AbstractFallbackSQLExceptionTranslator.java:73)
      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:
    1. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:69
    2.  at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:72
      
    3.  at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:73
      
    4.  at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:78
      
    5.  at com.serotonin.db.DaoUtils.query(DaoUtils.java:308)
       at com.serotonin.m2m2.db.dao.EventDao.getEventHandlers(EventDao.java:611
      

    )
    at com.serotonin.m2m2.db.dao.EventDao.getEventHandlers(EventDao.java:581
    )
    at com.serotonin.m2m2.rt.EventManager.setHandlers(EventManager.java:415)

        at com.serotonin.m2m2.rt.EventManager.raiseEvent(EventManager.java:94)
        at com.serotonin.m2m2.rt.event.type.SystemEventType.raiseEvent(SystemEve
    

    ntType.java:97)
    at com.serotonin.m2m2.Lifecycle.terminate(Lifecycle.java:321)
    at com.serotonin.m2m2.Main.main(Main.java:108)
    Caused by: org.h2.jdbc.JdbcSQLException: Tabla "EVENTHANDLERS" no encontrada
    Table "EVENTHANDLERS" not found; SQL statement:
    select id, xid, alias, data from eventHandlers where eventTypeName=? and eventSu
    btypeName=? and (eventTypeRef1=? or eventTypeRef1=0) and (eventTypeRef2=? or
    eventTypeRef2=0) [42102-181]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
    at org.h2.message.DbException.get(DbException.java:179)
    at org.h2.message.DbException.get(DbException.java:155)
    at org.h2.command.Parser.readTableOrView(Parser.java:5227)
    at org.h2.command.Parser.readTableFilter(Parser.java:1221)
    at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1860)
    at org.h2.command.Parser.parseSelectSimple(Parser.java:1969)
    at org.h2.command.Parser.parseSelectSub(Parser.java:1854)
    at org.h2.command.Parser.parseSelectUnion(Parser.java:1675)
    at org.h2.command.Parser.parseSelect(Parser.java:1663)
    at org.h2.command.Parser.parsePrepared(Parser.java:433)
    at org.h2.command.Parser.parse(Parser.java:305)
    at org.h2.command.Parser.parse(Parser.java:277)
    at org.h2.command.Parser.prepareCommand(Parser.java:242)
    at org.h2.engine.Session.prepareLocal(Session.java:446)
    at org.h2.engine.Session.prepareCommand(Session.java:388)
    at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1189)
    at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:7

    1.  at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:277)
       at org.springframework.jdbc.core.JdbcTemplate$SimplePreparedStatementCre
      

    ator.createPreparedStatement(JdbcTemplate.java:1557)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:

    1. ... 12 more
      "

    posted in User help read more
  • R
    Rodrigo

    Hi Phil,
    Thanks for answering so fast!

    I followed the point 2,

    • moved the mah2.h2.db somewhere else
    • started mango with ma-start.bat (it started and everything I had on Mango and DGLux dissapeared, including licenses)
    • went to system settings, Database Backup Settings, Get backups,
    • choosed one from a month ago and clicked restore database, here I closed the browser and the command prompt, I couldn't do anything else.
    • restarted from m-start.bat and now the loading lines goes to 100% and says "Running shutdown tasks", and keeps refreshing but it doesn't finish loading and mango doesn't starts.

    The point 1 you recommended, I don't have the h2-web-console.bat file in that folder, or any other folder.

    posted in User help read more
  • R
    Rodrigo

    Hi guys,

    I have a problem with my Mango Installation, described below, I've submitted a ticket for this, but I will also post this here, maybe someone knows the solution for this or maybe the developers would like to solve it through here so anyone can use this later. Let's keep our forum dynamic! :)

    Mango is installed on a windows 7 professional PC and I installed the service with the yajsw, it worked perfectly for most than a year.
    The computer was also (sadly) used to surf the web, so this is what may have caused the problems.
    The user says there was an electrical problem and the computer "blinked" twice and after that, Mango + DGLux stopped working.

    The symptoms:

    1. The service doesn't starts automatically.
    2. If I manually start the service, it stops automatically after a few minutes.
    3. If I manually start the service and launch Mango, I get the following error from the browser,
      "RequestError: Unable to load /status/mango.json?time=1495810520615 status 0"
      and the Mango Initialization stops at 55%, when
      Initializing Event Manager, and at the loading lines it states
      "INFO 2017-05-26 10:55:15,985 (com.serotonin.m2m2.dg.upgrade.DBUpgrade.checkUpgrade:36) - Starting instance with core version 2.5.2, db 9

    I tried the following:
    Tried to delete the service and the yajsw folders and reinstal, no luck.
    Recover the computer to an early date backup, no luck.

    Regards,
    Rodrigo

    posted in User help read more
  • R
    Rodrigo

    @JoelHaggar

    Thanks Joel, I'll try that, now I'm trying to use the json import export.
    I have 70 fan coils on a building an each fan coil controller has 10 points or so, I created all the points for one controller, exported this in json format and now I'm modifying that file and adding the points of the rest, let's see how it goes.

    Regards,
    Rodrigo

    posted in User help read more
  • R
    Rodrigo

    Hi Joel,
    In the video you recommended, you say that in a future video you are going to explain how to use CSV files to import lots of data points, you haven't made that video yet, right?
    In this video you explain how to use the property template, I found this tool to be extremely useful, but my lack of imagination :) doesn't let me understand how to use that to import lots of data points, are you trying to tell me that I should create the points one by one, and use the property template to assign the same properties to all of them?

    Hi Phil
    I thank you for your attempt to help me, but I know nothing about coding, so for me, what you wrote may well be chinese :$
    I really appreciate your message though.

    Regards,
    Rodrigo

    posted in User help read more
  • R
    Rodrigo

    I answer more than a month late, but thanks (better late, than never).

    I'll check on your sugestions now.

    Regards
    Rodrigo

    posted in User help read more