• M
    mohd

    Thanks guys, clearing browser cache worked and all good now, but I found the follwing error in ma.log, Appreciate your help.

    ERROR 2016-06-07 11:10:00,014 (com.serotonin.m2m2.meta.JavaScriptPointLocatorRT.executeImpl:54) - TypeError: Cannot read property "value" from undefined in <eval> at line number
    8 in <eval> at line number 8
    javax.script.ScriptException: TypeError: Cannot read property "value" from undefined in <eval> at line number 8 in <eval> at line number 8
    at com.serotonin.m2m2.rt.script.ScriptExecutor.prettyScriptMessage(ScriptExecutor.java:211)
    at com.serotonin.m2m2.rt.script.CompiledScriptExecutor.execute(CompiledScriptExecutor.java:83)
    at com.serotonin.m2m2.meta.JavaScriptPointLocatorRT.executeImpl(JavaScriptPointLocatorRT.java:50)
    at com.serotonin.m2m2.meta.MetaPointLocatorRT.execute(MetaPointLocatorRT.java:291)
    at com.serotonin.m2m2.meta.MetaPointLocatorRT$ScheduledUpdateTimeout.run(MetaPointLocatorRT.java:206)
    at com.serotonin.timer.TimerTask.runTask(TimerTask.java:148)
    at com.serotonin.timer.OrderedTimerTaskWorker.run(OrderedTimerTaskWorker.java:29)
    at com.serotonin.timer.OrderedThreadPoolExecutor$OrderedTask.run(OrderedThreadPoolExecutor.java:278)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)
    Cheers,
    Mohammad

    posted in Mango Automation general Discussion read more
  • M
    mohd

    Hi,
    I could resolve the slowness issue by purging the events and could upgrade the MangoES to 2.7.10 successfully, but I have got another issue, I cannot see the data sources but can see the data points, do you have any idea?
    Cheers

    posted in Mango Automation general Discussion read more
  • M
    mohd

    Hi guys,
    Thanks for your support. I went for Joel solution and could restore the database on another mangoES 2.5.2 but when I tried to open whatch list or do any thing on Web interface, it's really slow (I could see the watch list), when I tried to open datasources I recived Server error:Timeout, and I couldn't upgrade that to version 2.7.10. I tried several backups for different days but the result was the same. I also tried to boot the mango in SAFE mode but that couldn't help. Appreciate your help.
    Cheers

    posted in Mango Automation general Discussion read more
  • M
    mohd

    Hi,
    I want to extract H2 database from a mangoES version 2.5.2 and restore it into a mangoES version 2.7.10. I tired that, but it didn’t work and the following is the log file output, I just want to know is it possible to do that with different version and how should I do that. I should say that I cannot upgrade the version 2.5.2 to 2.7.10 as it’s a running project and it’s in remote area, I want to restore the database one a mango with version 2.7.10 and send that to site to substitute. Appreciate your help in this regard.

    ERROR 2016-05-31 14:15:14,494 (com.serotonin.m2m2.Main.main:120) - Error during initialization
    com.serotonin.ShouldNeverHappenException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [CREATE TABLE templates ( id int NOT NULL auto_increment, xid varchar(50) NOT NULL, name VARCHAR(255), template
    Type VARCHAR(50), readPermission VARCHAR(255), setPermission VARCHAR(255), data longblob NOT NULL, PRIMARY KEY (id) ); ]; nested exception is org.h2.jdbc.JdbcSQLException: Table "TEMPLATES" already exists; SQL statement:
    CREATE TABLE templates ( id int NOT NULL auto_increment, xid varchar(50) NOT NULL, name VARCHAR(255), templateType VARCHAR(50), readPermission VARCHAR(255), setPermission VARCHAR(255), data longblob NOT NULL, PRIMARY KEY (id) ); [42101-
    181]
    at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:102)
    at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:34)
    at com.serotonin.m2m2.db.DatabaseProxy.initialize(DatabaseProxy.java:180)
    at com.serotonin.m2m2.Lifecycle.databaseInitialize(Lifecycle.java:602)
    at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:280)
    at com.serotonin.m2m2.Main.main(Main.java:116)
    Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [CREATE TABLE templates ( id int NOT NULL auto_increment, xid varchar(50) NOT NULL, name VARCHAR(255), templateType VARCHAR(50), readPermissio
    n VARCHAR(255), setPermission VARCHAR(255), data longblob NOT NULL, PRIMARY KEY (id) ); ]; nested exception is org.h2.jdbc.JdbcSQLException: Table "TEMPLATES" already exists; SQL statement:
    CREATE TABLE templates ( id int NOT NULL auto_increment, xid varchar(50) NOT NULL, name VARCHAR(255), templateType VARCHAR(50), readPermission VARCHAR(255), setPermission VARCHAR(255), data longblob NOT NULL, PRIMARY KEY (id) ); [42101-
    181]
    at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:415)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:439)
    at com.serotonin.m2m2.db.H2Proxy.runScript(H2Proxy.java:146)
    at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:129)
    at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:143)
    at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:134)
    at com.serotonin.m2m2.db.upgrade.Upgrade10.upgrade(Upgrade10.java:30)
    at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:98)
    ... 5 more
    Caused by: org.h2.jdbc.JdbcSQLException: Table "TEMPLATES" already exists; SQL statement:
    CREATE TABLE templates ( id int NOT NULL auto_increment, xid varchar(50) NOT NULL, name VARCHAR(255), templateType VARCHAR(50), readPermission VARCHAR(255), setPermission VARCHAR(255), data longblob NOT NULL, PRIMARY KEY (id) ); [42101-
    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.ddl.CreateTable.update(CreateTable.java:111)
    at org.h2.command.CommandContainer.update(CommandContainer.java:78)
    at org.h2.command.Command.executeUpdate(Command.java:254)
    at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:185)
    at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:159)
    at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:431)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:404)
    ... 12 more
    INFO 2016-05-31 14:15:14,500 (com.serotonin.m2m2.Lifecycle.terminate:344) - Mango Lifecycle terminating...

    posted in Mango Automation general Discussion read more
  • M
    mohd

    Hi Phildunlap,
    Thanks for the response. According to the following output of the commands, it looks database has got the largest size. I can delete the old backup files to have more size, but appreciate your idea in this regard, and also want to know how to purge the event table.

    0_1464224209786_du output.PNG

    Thanks,
    Mohammad

    posted in Mango Automation general Discussion read more
  • M
    mohd

    Hi,
    I received the following alert from MangoES regarding to full storage issue. following is the output of df command, I am wondering what caused this issue. Appreciate your help if you could let me know where should I check or is necessary to remove any file..

    0_1464157886959_Mango Alert.PNG
    mango@mangoES$df -a
    Filesystem Size Used Avail Use% Mounted on
    rootfs - - - - /
    /dev/root 7.0G 7.0G 0 100% /
    devtmpfs 746M 0 746M 0% /dev
    sysfs 0 0 0 - /sys
    proc 0 0 0 - /proc
    tmpfs 996M 0 996M 0% /dev/shm
    devpts 0 0 0 - /dev/pts
    tmpfs 996M 26M 971M 3% /run
    tmpfs 5.0M 0 5.0M 0% /run/lock
    tmpfs 996M 0 996M 0% /sys/fs/cgroup
    cgroup 0 0 0 - /sys/fs/cgroup/systemd
    cgroup 0 0 0 - /sys/fs/cgroup/cpuset
    cgroup 0 0 0 - /sys/fs/cgroup/debug
    cgroup 0 0 0 - /sys/fs/cgroup/cpu,cpuacct
    cgroup 0 0 0 - /sys/fs/cgroup/memory
    cgroup 0 0 0 - /sys/fs/cgroup/devices
    cgroup 0 0 0 - /sys/fs/cgroup/freezer
    cgroup 0 0 0 - /sys/fs/cgroup/perf_event
    systemd-1 0 0 0 - /proc/sys/fs/binfmt_misc
    mqueue 0 0 0 - /dev/mqueue
    debugfs 0 0 0 - /sys/kernel/debug
    configfs 0 0 0 - /sys/kernel/config
    tmpfs 996M 2.0M 994M 1% /tmp
    /dev/mmcblk0p1 127M 3.2M 124M 3% /media/boot
    tmpfs 200M 0 200M 0% /run/user/0
    tmpfs 200M 0 200M 0% /run/user/1000

    posted in Mango Automation general Discussion read more
  • M
    mohd

    Hi JoelHagger,
    Thanks for the response. I just changed the DNS IP address on MangoES, and it workes.
    Cheers

    posted in Mango Automation Installation read more
  • M
    mohd

    Hi,
    I tried to upgarde MangoES from version 2.7.2 to 2.7.10. but I recived the following error. Appreciate your help in this regard.
    0_1463110521226_Upgrade Error.PNG

    posted in Mango Automation Installation read more
  • M
    mohd

    Hi Phildunlap,
    The third solution redolved the issue. Thanks for your help and appreciate it.
    Cheers,
    Mohammad

    posted in Mango Automation Installation read more
  • M
    mohd

    Hi Phildunlap,
    Thanks for the response. When I am trying to stop/start the Mango I recive the following warnning, I think maybe the upgrading process has not been finished. Is there any way to run it again or do factory reset or something like this to have a fresh one and upgrade it again.Thanks.
    'WARN 2016-05-08 15:45:47,255 (com.serotonin.m2m2.rt.dataSource.PollingDataSource$2.execute:226) - Genset Controller: poll scheduled at 2016/05/08 15:45:47.254 aborted
    because Task Currently Running
    '

    posted in Mango Automation Installation read more