• Recent
    • Tags
    • Popular
    • Register
    • Login
    1. Home
    2. mohd

    Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

    Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website Mango 5 Documentation Website
    M
    • Profile
    • Following 0
    • Followers 0
    • Topics 4
    • Posts 11
    • Best 0
    • Controversial 0
    • Groups 0

    mohd

    @mohd

    0
    Reputation
    640
    Profile views
    11
    Posts
    0
    Followers
    0
    Following
    Joined Last Online

    mohd Unfollow Follow

    Latest posts made by mohd

    • RE: Import H2 database from MangoES 2.5.2 to MangoES 2.7.10

      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
      M
      mohd
    • RE: Import H2 database from MangoES 2.5.2 to MangoES 2.7.10

      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
      M
      mohd
    • RE: Import H2 database from MangoES 2.5.2 to MangoES 2.7.10

      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
      M
      mohd
    • Import H2 database from MangoES 2.5.2 to MangoES 2.7.10

      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
      M
      mohd
    • RE: Full Storage issue on MangoES

      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
      M
      mohd
    • Full Storage issue on MangoES

      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
      M
      mohd
    • RE: Can not upgrdae MangoES 2.7.2 to version 2.7.10

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

      posted in Mango Automation Installation
      M
      mohd
    • Can not upgrdae MangoES 2.7.2 to version 2.7.10

      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
      M
      mohd
    • RE: Mango does not come up after upgrading to the new version

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

      posted in Mango Automation Installation
      M
      mohd
    • RE: Mango does not come up after upgrading to the new version

      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
      M
      mohd