Messages posted by: cora

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!

Is it possible to use Meta data Point on values recorded before the creation of the Meta point?

Thanks

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

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:28

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:5

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! ^^

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

Hello everybody,

I would like to calculate energy produced each minute by using the data received from a pv plant.( I collect the data from a ContransE power transducer, through a Modbus connection RS485) I get this error and all the communication system has shut down , and I can´t no more receive data from the transducer.

What does this error mean?
'Energy': Script error in point "Energy_I1_Minute": sun.org.mozilla.javascript.internal.WrappedException: Wrapped org.springframework.dao.ConcurrencyFailureException: PreparedStatementCallback; SQL [select pv.dataType, pv.pointValue, pva.textPointValueShort, pva.textPointValueLong, pv.ts, pva.sourceType, pva.sourceId from pointValues pv left join pointValueAnnotations pva on pv.id = pva.pointValueId where pv.dataPointId=? and pv.ts >= ? and pv.ts#1) in at line number 1 in at line number

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