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

    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
    C
    • Profile
    • Following 0
    • Followers 0
    • Topics 3
    • Posts 8
    • Best 0
    • Controversial 0
    • Groups 0

    cora

    @cora

    0
    Reputation
    517
    Profile views
    8
    Posts
    0
    Followers
    0
    Following
    Joined Last Online
    cora Unfollow Follow

    Latest posts made by cora

    • Interactive graphical view

      Hello!

      I would like to create an interactive graphical view in which the user could choose the data points he wants to see (with a series of checkboxes) as an image chart and the period of the chart and some statistics of other points for the same period.

      Practically, It should be a sort of report but only with one image chart with all the points chosen by the user and some statistics about other points (just numbers, no graphs) on the period choosen by the user. I created the checkboxes and the calendar to choose the period as HTML objects, but I have no idea about how to link these objects with my meta data points and to the function which create charts. (I suppose i have to modify some Javascripts...)
      I am running on Mango 1.12.0 on windows xp.

      Thank you!

      posted in User help
      C
      cora
    • RE: Interactive graphical view

      Hello!

      I would like to create an interactive graphical view in which the user could choose the data points he wants to see (with a series of checkboxes) as an image chart and the period of the chart and some statistics of other points for the same period.

      Practically, It should be a sort of report but only with one image chart with all the points chosen by the user and some statistics about other points (just numbers, no graphs) on the period choosen by the user. I created the checkboxes and the calendar to choose the period as HTML objects, but I have no idea about how to link these objects with my meta data points and to the function which create charts. (I suppose i have to modify some Javascripts...)
      I am running on Mango 1.12.0 on windows xp.

      Thank you!

      posted in User help
      C
      cora
    • RE: Derby->MySQL: ERROR 42X05: Table/View 'SYSTEMSETTINGS' does not exist.

      tomcat 6.0.20
      Mango 1.12.4
      Windows XP (2002)
      I am trying to swich from a new empty derby to Mysql

      posted in User help
      C
      cora
    • Derby->MySQL: ERROR 42X05: Table/View 'SYSTEMSETTINGS' does not exist.

      INFO: Initializing Spring root WebApplicationContext
      08.07.2011 16:19:51 org.apache.catalina.core.StandardContext listenerStart
      SCHWERWIEGEND: Exception sending context initialized event to listener instance of class com.serotonin.mango.MangoContextListener
      com.serotonin.ShouldNeverHappenException: java.sql.SQLSyntaxErrorException: Table/View 'SYSTEMSETTINGS' does not exist.
      at com.serotonin.mango.db.DatabaseAccess.initialize(DatabaseAccess.java:125)
      at com.serotonin.mango.MangoContextListener.databaseInitialize(MangoContextListener.java:255)
      at com.serotonin.mango.MangoContextListener.contextInitialized(MangoContextListener.java:94)
      at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934)
      at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429)
      at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
      at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
      at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)
      at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:987)
      at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:909)
      at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:495)
      at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1206)
      at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:314)
      at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
      at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
      at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
      at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
      at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
      at org.apache.catalina.core.StandardService.start(StandardService.java:516)
      at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
      at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
      at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
      Caused by: java.sql.SQLSyntaxErrorException: Table/View 'SYSTEMSETTINGS' does not exist.
      at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
      at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown Source)
      at com.serotonin.mango.db.DBConvert.copyTable(DBConvert.java:109)
      at com.serotonin.mango.db.DBConvert.execute(DBConvert.java:58)
      at com.serotonin.mango.db.DatabaseAccess.initialize(DatabaseAccess.java:122)
      ... 26 more
      Caused by: java.sql.SQLException: Table/View 'SYSTEMSETTINGS' does not exist.
      at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
      ... 37 more
      Caused by: ERROR 42X05: Table/View 'SYSTEMSETTINGS' does not exist.
      at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
      at org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(Unknown Source)
      at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(Unknown Source)
      at org.apache.derby.impl.sql.compile.FromList.bindTables(Unknown Source)
      at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(Unknown Source)
      at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(Unknown Source)
      at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
      at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
      at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
      at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
      at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
      ... 31 more
      08.07.2011 16:19:51 org.apache.catalina.core.ApplicationContext log
      INFO: Closing Spring root WebApplicationContext

      Any help is welcome! ^^

      posted in User help
      C
      cora
    • RE: Derby->MySQL: ERROR 42X05: Table/View 'SYSTEMSETTINGS' does not exist.

      INFO: Initializing Spring root WebApplicationContext
      08.07.2011 16:19:51 org.apache.catalina.core.StandardContext listenerStart
      SCHWERWIEGEND: Exception sending context initialized event to listener instance of class com.serotonin.mango.MangoContextListener
      com.serotonin.ShouldNeverHappenException: java.sql.SQLSyntaxErrorException: Table/View 'SYSTEMSETTINGS' does not exist.
      at com.serotonin.mango.db.DatabaseAccess.initialize(DatabaseAccess.java:125)
      at com.serotonin.mango.MangoContextListener.databaseInitialize(MangoContextListener.java:255)
      at com.serotonin.mango.MangoContextListener.contextInitialized(MangoContextListener.java:94)
      at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934)
      at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429)
      at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
      at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
      at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)
      at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:987)
      at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:909)
      at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:495)
      at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1206)
      at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:314)
      at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
      at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
      at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
      at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
      at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
      at org.apache.catalina.core.StandardService.start(StandardService.java:516)
      at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
      at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
      at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
      Caused by: java.sql.SQLSyntaxErrorException: Table/View 'SYSTEMSETTINGS' does not exist.
      at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
      at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown Source)
      at com.serotonin.mango.db.DBConvert.copyTable(DBConvert.java:109)
      at com.serotonin.mango.db.DBConvert.execute(DBConvert.java:58)
      at com.serotonin.mango.db.DatabaseAccess.initialize(DatabaseAccess.java:122)
      ... 26 more
      Caused by: java.sql.SQLException: Table/View 'SYSTEMSETTINGS' does not exist.
      at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
      ... 37 more
      Caused by: ERROR 42X05: Table/View 'SYSTEMSETTINGS' does not exist.
      at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
      at org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(Unknown Source)
      at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(Unknown Source)
      at org.apache.derby.impl.sql.compile.FromList.bindTables(Unknown Source)
      at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(Unknown Source)
      at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(Unknown Source)
      at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
      at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
      at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
      at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
      at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
      ... 31 more
      08.07.2011 16:19:51 org.apache.catalina.core.ApplicationContext log
      INFO: Closing Spring root WebApplicationContext

      Any help is welcome! ^^

      posted in User help
      C
      cora
    • RE: Converting from Derby to MySQL

      I have the same problem that gus mentioned before. Is there a solution? anyone has a suggestion?

      posted in User help
      C
      cora
    • How to collect and manipulate data in Mango?

      Hello!

      I am using Mango for monitoring a PV plant. I collect the data from a ContransE power transducer, throught a Modbus connection, i would like to know :

      • How and where I can store the data collected : Current, Voltage, Active and Reactive power (what is Derby and how can i use it?)
      • I would like to calculate the total energy using the running time of my panels (time when Voltage is not null) is it possible to do this directly in Mango?

      Thank you

      posted in How-To
      C
      cora
    • RE: How to collect and manipulate data in Mango?

      Hello!

      I am using Mango for monitoring a PV plant. I collect the data from a ContransE power transducer, throught a Modbus connection, i would like to know :

      • How and where I can store the data collected : Current, Voltage, Active and Reactive power (what is Derby and how can i use it?)
      • I would like to calculate the total energy using the running time of my panels (time when Voltage is not null) is it possible to do this directly in Mango?

      Thank you

      posted in How-To
      C
      cora