[Logo] Mango M2M Community
  [Search] Search   [Recent Topics] Recent Topics   [Members]  Member Listing   [Groups] Back to home page 
[Register] Register /  [Login] Login 
Version upgrade  XML
Forum Index -> Mango installation
Author Message
[Post New]09/09/2009 08:14:06
    Subject: Version upgrade
[Up]
Bot

Initiate
[Avatar]

Joined: 08/07/2007 17:33:52
Messages: 5
Location: Sweden
Offline
I try to upgrade version 1.60 to version 1.64 and get follows error:
Code:
:
 2009-sep-09 13:56:07 org.apache.catalina.core.AprLifecycleListener init
 INFO: Loaded Apache Tomcat Native library 1.1.12.
 2009-sep-09 13:56:07 org.apache.catalina.core.AprLifecycleListener init
 INFO: APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
 2009-sep-09 13:56:08 org.apache.coyote.http11.Http11AprProtocol init
 INFO: Initializing Coyote HTTP/1.1 on http-8080
 2009-sep-09 13:56:08 org.apache.coyote.ajp.AjpAprProtocol init
 INFO: Initializing Coyote AJP/1.3 on ajp-8009
 2009-sep-09 13:56:08 org.apache.catalina.startup.Catalina load
 INFO: Initialization processed in 1143 ms
 2009-sep-09 13:56:08 org.apache.catalina.core.StandardService start
 INFO: Starting service Catalina
 2009-sep-09 13:56:08 org.apache.catalina.core.StandardEngine start
 INFO: Starting Servlet Engine: Apache Tomcat/6.0.14
 2009-sep-09 13:56:09 org.apache.catalina.core.ApplicationContext log
 INFO: Initializing Spring root WebApplicationContext
 INFO  2009-09-09 13:56:09,562 (org.springframework.web.context.ContextLoader.initWebApplicationContext:189) - Root WebApplicationContext: initialization started 
 INFO  2009-09-09 13:56:09,640 (org.springframework.context.support.AbstractApplicationContext.prepareRefresh:412) - Refreshing org.springframework.web.context.support.XmlWebApplicationContext@18f1d7e: display name [Root WebApplicationContext]; startup date [Wed Sep 09 13:56:09 CEST 2009]; root of context hierarchy 
 INFO  2009-09-09 13:56:09,750 (org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions:323) - Loading XML bean definitions from ServletContext resource [/WEB-INF/applicationContext.xml] 
 INFO  2009-09-09 13:56:09,812 (org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory:427) - Bean factory for application context [org.springframework.web.context.support.XmlWebApplicationContext@18f1d7e]: org.springframework.beans.factory.support.DefaultListableBeanFactory@161dfb5 
 INFO  2009-09-09 13:56:09,937 (org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons:414) - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@161dfb5: defining beans [CompoundEventsDwr,DataPointDetailsDwr,DataPointEditDwr,DataSourceEditDwr,DataSourceListDwr,EmportDwr,EventHandlersDwr,EventsDwr,MailingListsDwr,MiscDwr,PointHierarchyDwr,PublisherEditDwr,PublisherListDwr,ReportsDwr,ScheduledEventsDwr,SystemSettingsDwr,UsersDwr,ViewDwr,WatchListDwr,localeResolver,messageSource]; root of factory hierarchy 
 INFO  2009-09-09 13:56:10,109 (org.springframework.web.context.ContextLoader.initWebApplicationContext:209) - Root WebApplicationContext: initialization completed in 547 ms 
 INFO  2009-09-09 13:56:10,109 (com.serotonin.mango.MangoContextListener.contextInitialized:73) - Mango context starting 
 INFO  2009-09-09 13:56:10,343 (com.serotonin.mango.db.DerbyAccess.initializeImpl:69) - Initializing derby connection manager 
 WARN  2009-09-09 13:56:12,312 (com.serotonin.mango.db.upgrade.DBUpgrade.checkUpgrade:81) - Upgrading instance from 1.6.0 to 1.6.1 
 INFO  2009-09-09 13:56:12,328 (com.serotonin.mango.db.upgrade.Upgrade1_6_0.upgrade:43) - Running script 1 
 INFO  2009-09-09 13:56:14,562 (com.serotonin.mango.db.upgrade.Upgrade1_6_0.upgrade:49) - Running script 2 
 WARN  2009-09-09 13:56:15,671 (com.serotonin.mango.db.upgrade.DBUpgrade.checkUpgrade:81) - Upgrading instance from 1.6.1 to 1.6.2 
 INFO  2009-09-09 13:56:15,750 (com.serotonin.mango.db.upgrade.Upgrade1_6_1.upgrade:36) - Running script 1 
 WARN  2009-09-09 13:56:18,546 (com.serotonin.mango.db.upgrade.DBUpgrade.checkUpgrade:81) - Upgrading instance from 1.6.2 to 1.6.3 
 INFO  2009-09-09 13:56:18,546 (com.serotonin.mango.db.upgrade.Upgrade1_6_2.upgrade:40) - Running script 1 
 WARN  2009-09-09 13:56:18,656 (com.serotonin.mango.db.upgrade.DBUpgrade.checkUpgrade:81) - Upgrading instance from 1.6.3 to 1.6.4 
 INFO  2009-09-09 13:56:18,671 (com.serotonin.mango.db.upgrade.Upgrade1_6_3.upgrade:40) - Running script 1 
 INFO  2009-09-09 13:56:18,687 (com.serotonin.mango.db.upgrade.Upgrade1_6_3.upgrade:43) - Running script 2 
 INFO  2009-09-09 13:56:18,734 (com.serotonin.mango.db.upgrade.DBUpgrade.checkUpgrade:76) - Starting instance with version 1.6.4 
 INFO  2009-09-09 13:56:19,906 (org.quartz.simpl.SimpleThreadPool.initialize:258) - Job execution threads will use class loader of thread: Thread-1 
 INFO  2009-09-09 13:56:19,937 (org.quartz.core.SchedulerSignalerImpl.<init>:63) - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 
 INFO  2009-09-09 13:56:19,937 (org.quartz.core.QuartzScheduler.<init>:215) - Quartz Scheduler v.1.6.3 created. 
 INFO  2009-09-09 13:56:19,937 (org.quartz.simpl.RAMJobStore.initialize:141) - RAMJobStore initialized. 
 INFO  2009-09-09 13:56:19,937 (org.quartz.impl.StdSchedulerFactory.instantiate:1224) - Quartz scheduler 'DefaultQuartzScheduler' initialized from default resource file in Quartz package: 'quartz.properties' 
 INFO  2009-09-09 13:56:19,937 (org.quartz.impl.StdSchedulerFactory.instantiate:1228) - Quartz scheduler version: 1.6.3 
 INFO  2009-09-09 13:56:19,937 (org.quartz.core.QuartzScheduler.start:461) - Scheduler DefaultQuartzScheduler_$_NON_CLUSTERED started. 
 INFO  2009-09-09 13:56:19,984 (org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions:323) - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml] 
 INFO  2009-09-09 13:56:20,046 (org.springframework.jdbc.support.SQLErrorCodesFactory.<init>:128) - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase] 
 2009-sep-09 13:56:20 org.apache.catalina.core.StandardContext listenerStart
 ALLVARLIG: Exception sending context initialized event to listener instance of class com.serotonin.mango.MangoContextListener
 org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select id, typeId, typeRef1, typeRef2, activeTs, rtnApplicable, rtnTs, rtnCause, alarmLevel, message from events where rtnApplicable=? and rtnTs is null]; nested exception is java.sql.SQLSyntaxErrorException: Column 'RTNTS' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'RTNTS' is not a column in the target table.
 	at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.translate(SQLExceptionSubclassTranslator.java:78)
 	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:237)
 	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:606)
 	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:640)
 	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:669)
 	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:677)
 	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:709)
 	at com.serotonin.db.spring.ExtendedJdbcTemplate.query(ExtendedJdbcTemplate.java:140)
 	at com.serotonin.db.DaoUtils.query(DaoUtils.java:172)
 	at com.serotonin.mango.db.dao.EventDao.getActiveEvents(EventDao.java:141)
 	at com.serotonin.mango.rt.EventManager.initialize(EventManager.java:237)
 	at com.serotonin.mango.MangoContextListener.eventManagerInitialize(MangoContextListener.java:324)
 	at com.serotonin.mango.MangoContextListener.contextInitialized(MangoContextListener.java:88)
 	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3830)
 	at org.apache.catalina.core.StandardContext.start(StandardContext.java:4337)
 	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:525)
 	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)
 	at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883)
 	at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
 	at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
 	at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
 	at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
 	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
 	at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
 	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:566)
 	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: Column 'RTNTS' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'RTNTS' is not a column in the target table.
 	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.EmbedPreparedStatement.<init>(Unknown Source)
 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source)
 	at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source)
 	at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
 	at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
 	at org.springframework.jdbc.core.JdbcTemplate$SimplePreparedStatementCreator.createPreparedStatement(JdbcTemplate.java:1309)
 	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:584)
 	... 34 more
 Caused by: java.sql.SQLException: Column 'RTNTS' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'RTNTS' is not a column in the target table.
 	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
 	... 49 more
 Caused by: ERROR 42X04: Column 'RTNTS' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'RTNTS' is not a column in the target table.
 	at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
 	at org.apache.derby.impl.sql.compile.ColumnReference.bindExpression(Unknown Source)
 	at org.apache.derby.impl.sql.compile.ResultColumn.bindExpression(Unknown Source)
 	at org.apache.derby.impl.sql.compile.ResultColumnList.bindExpressions(Unknown Source)
 	at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(Unknown Source)
 	at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(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)
 	... 43 more
 2009-sep-09 13:56:20 org.apache.catalina.core.StandardContext start
 ALLVARLIG: Error listenerStart
 2009-sep-09 13:56:20 org.apache.catalina.core.StandardContext start
 ALLVARLIG: Context [] startup failed due to previous errors
 INFO  2009-09-09 13:56:20,062 (com.serotonin.mango.MangoContextListener.contextDestroyed:101) - Mango context terminating 
 2009-sep-09 13:56:20 org.apache.catalina.core.StandardContext listenerStop
 ALLVARLIG: Exception sending context destroyed event to listener instance of class com.serotonin.mango.MangoContextListener
 org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [insert into events (typeId, typeRef1, typeRef2, activeTs, rtnApplicable, rtnTs, rtnCause, alarmLevel, message) values (?,?,?,?,?,?,?,?,?)]; nested exception is java.sql.SQLSyntaxErrorException: 'RTNTS' is not a column in table or VTI 'APP.EVENTS'.
 	at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.translate(SQLExceptionSubclassTranslator.java:78)
 	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:237)
 	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:606)
 	at com.serotonin.db.spring.ExtendedJdbcTemplate.update(ExtendedJdbcTemplate.java:164)
 	at com.serotonin.db.spring.ExtendedJdbcTemplate.update(ExtendedJdbcTemplate.java:134)
 	at com.serotonin.db.spring.ExtendedJdbcTemplate.update(ExtendedJdbcTemplate.java:130)
 	at com.serotonin.db.DaoUtils.doInsert(DaoUtils.java:150)
 	at com.serotonin.mango.db.dao.EventDao.insertEvent(EventDao.java:92)
 	at com.serotonin.mango.db.dao.EventDao.saveEvent(EventDao.java:63)
 	at com.serotonin.mango.rt.EventManager.raiseEvent(EventManager.java:96)
 	at com.serotonin.mango.rt.event.type.SystemEventType.raiseEvent(SystemEventType.java:91)
 	at com.serotonin.mango.MangoContextListener.contextDestroyed(MangoContextListener.java:105)
 	at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:3869)
 	at org.apache.catalina.core.StandardContext.stop(StandardContext.java:4503)
 	at org.apache.catalina.core.StandardContext.start(StandardContext.java:4367)
 	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:525)
 	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)
 	at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883)
 	at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
 	at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
 	at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
 	at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
 	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
 	at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
 	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:566)
 	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: 'RTNTS' is not a column in table or VTI 'APP.EVENTS'.
 	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.EmbedPreparedStatement.<init>(Unknown Source)
 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source)
 	at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source)
 	at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
 	at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
 	at com.serotonin.db.spring.KeyGeneratingPreparedStatementCreator.createPreparedStatement(KeyGeneratingPreparedStatementCreator.java:21)
 	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:584)
 	... 34 more
 Caused by: java.sql.SQLException: 'RTNTS' is not a column in table or VTI 'APP.EVENTS'.
 	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
 	... 49 more
 Caused by: ERROR 42X14: 'RTNTS' is not a column in table or VTI 'APP.EVENTS'.
 	at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
 	at org.apache.derby.impl.sql.compile.ResultColumn.bindResultColumnByName(Unknown Source)
 	at org.apache.derby.impl.sql.compile.ResultColumnList.bindResultColumnsByName(Unknown Source)
 	at org.apache.derby.impl.sql.compile.InsertNode.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)
 	... 43 more
 2009-sep-09 13:56:20 org.apache.catalina.core.ApplicationContext log
 INFO: Closing Spring root WebApplicationContext
 INFO  2009-09-09 13:56:20,140 (org.springframework.context.support.AbstractApplicationContext.doClose:816) - Closing org.springframework.web.context.support.XmlWebApplicationContext@18f1d7e: display name [Root WebApplicationContext]; startup date [Wed Sep 09 13:56:09 CEST 2009]; root of context hierarchy 
 INFO  2009-09-09 13:56:20,140 (org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroySingletons:392) - Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@161dfb5: defining beans [CompoundEventsDwr,DataPointDetailsDwr,DataPointEditDwr,DataSourceEditDwr,DataSourceListDwr,EmportDwr,EventHandlersDwr,EventsDwr,MailingListsDwr,MiscDwr,PointHierarchyDwr,PublisherEditDwr,PublisherListDwr,ReportsDwr,ScheduledEventsDwr,SystemSettingsDwr,UsersDwr,ViewDwr,WatchListDwr,localeResolver,messageSource]; root of factory hierarchy 
 2009-sep-09 13:56:20 org.apache.coyote.http11.Http11AprProtocol start
 INFO: Starting Coyote HTTP/1.1 on http-8080
 2009-sep-09 13:56:20 org.apache.coyote.ajp.AjpAprProtocol start
 INFO: Starting Coyote AJP/1.3 on ajp-8009
 2009-sep-09 13:56:20 org.apache.catalina.startup.Catalina start
 INFO: Server startup in 12378 ms


Bot
[Post New]09/09/2009 13:49:26
    Subject: Re:Version upgrade
[Up]
mlohbihler


[Avatar]

Joined: 01/03/2007 22:48:52
Messages: 974
Offline
Very strange. The error says that the field "RTNTS" is missing from you Events table in your database. But, this field was added in version 1.5.0, so if it's not there your 1.6.0 installation couldn't have worked.
Best regards,
Matthew Lohbihler
[Post New]09/09/2009 15:34:43
    Subject: Re:Version upgrade
[Up]
Bot

Initiate
[Avatar]

Joined: 08/07/2007 17:33:52
Messages: 5
Location: Sweden
Offline
Now I have tray to upgrade version to version , and when I upgrade from
version 1.60 to version 1.61 a get the errors that I write about before.
Version 1.60 works any idea?






Bot
[Post New]09/09/2009 17:28:29
    Subject: Re:Version upgrade
[Up]
mlohbihler


[Avatar]

Joined: 01/03/2007 22:48:52
Messages: 974
Offline
If 1.6.1 doesn't work for that reason, 1.6.0 shouldn't work either. Check a few things:

1) That your 1.6.0 instance really is that version by looking on the system settings page.
2) That your database has that field by going to the sql page and running "select * from events" and finding the RTNTS field.
3) That the respective versions are in fact pointing to the same database instance. The value is in the WEB-INF/classes/env.properties file, called "db.url".
Best regards,
Matthew Lohbihler
[Post New]10/09/2009 09:57:05
    Subject: Re:Version upgrade
[Up]
Bot

Initiate
[Avatar]

Joined: 08/07/2007 17:33:52
Messages: 5
Location: Sweden
Offline
Answer:

1) The data instance version is 1.6.0.

2) The database has no RTNTS field.

3) The env.properties file db.url=C:/tomcat/apache-tomcat-6.0.14/mangodb.

I have look into the script for create database from scratch, and I find the RTNS field into version 1.6.1?(createTables-derby.sql).

There must be a bug in upgrade funktion or scripts.




Bot
[Post New]10/09/2009 10:10:51
    Subject: Re:Version upgrade
[Up]
mlohbihler


[Avatar]

Joined: 01/03/2007 22:48:52
Messages: 974
Offline
The code that upgrades from version 1.5.0 to 1.6.0 (Upgrade1_5_0.java) contains these lines:

Code:
        "alter table events add rtnTs bigint;",
         "alter table events add rtnCause int;",


(So, the field was introduced in version 1.6.0, not 1.5.0. My mistake, but it doesn't change our situation right now.)

If the instance was properly upgraded to 1.6.0 the field would be there. Also, the 1.6.0 code expects that field to be there, so you should be seeing errors if it's not. The upgrade code creates an output file called Upgrade1_5_0.log. Can you search for this and see if it lists any errors?
Best regards,
Matthew Lohbihler
[Post New]10/09/2009 11:07:59
    Subject: Re:Version upgrade
[Up]
Bot

Initiate
[Avatar]

Joined: 08/07/2007 17:33:52
Messages: 5
Location: Sweden
Offline
Upgrade1_5_0.log


Code:
:ij> alter table pointEventDetectors add alias varchar(255);
 0 rows inserted/updated/deleted
 ij> alter table eventHandlers add alias varchar(255);
 0 rows inserted/updated/deleted
 ij> alter table dataSources add column xid varchar(20);
 0 rows inserted/updated/deleted
 ij> alter table dataPoints add column xid varchar(20);
 0 rows inserted/updated/deleted
 ij> alter table pointEventDetectors add column xid varchar(20);
 0 rows inserted/updated/deleted
 ij> alter table pointEventDetectors add stateLimit double;
 0 rows inserted/updated/deleted
 ij> update pointEventDetectors set stateLimit=limit;
 128 rows inserted/updated/deleted
 ij> alter table pointEventDetectors drop limit;
 0 rows inserted/updated/deleted
 ij> alter table compoundEventDetectors add conditionText varchar(256);
 0 rows inserted/updated/deleted
 ij> update compoundEventDetectors set conditionText=condition;
 1 row inserted/updated/deleted
 ij> alter table compoundEventDetectors drop condition;
 0 rows inserted/updated/deleted
 ij> alter table compoundEventDetectors alter conditionText not null;
 0 rows inserted/updated/deleted
 ij> alter table mangoViewUsers add constraint mangoViewUsersFk1 foreign key (mangoViewId) references mangoViews(id) on delete cascade;
 ERROR 42915: Foreign  Key 'MANGOVIEWUSERSFK1' is invalid because 'the delete rule of foreign key  must be NO ACTION. (The relationship would cause the table to be delete-connected to the same table through multiple relationships and such relationships must have the same delete rule (NO ACTION, RESTRICT or CASCADE).) '. 
 ij> alter table mangoViewUsers add constraint mangoViewUsersFk2 foreign key (userId) references users(id) on delete cascade;
 0 rows inserted/updated/deleted
 ij> alter table mangoViews add column data blob;
 0 rows inserted/updated/deleted
 ij> alter table events add rtnTs bigint;
 0 rows inserted/updated/deleted
 ij> alter table events add rtnCause int;
 0 rows inserted/updated/deleted
 ij> create table userEvents (
   eventId int not null,
   userId int not null,
   silenced char(1) not null,
   ackTs bigint
 );
 0 rows inserted/updated/deleted
 ij> alter table userEvents add constraint userEventsPk primary key (eventId, userId);
 0 rows inserted/updated/deleted
 ij> alter table userEvents add constraint userEventsFk1 foreign key (eventId) references events(id) on delete cascade;
 0 rows inserted/updated/deleted
 ij> alter table userEvents add constraint userEventsFk2 foreign key (userId) references users(id) on delete cascade;
 0 rows inserted/updated/deleted
 ij> create table reportInstanceEvents (
   eventId int not null,
   reportInstanceId int not null,
   typeId int not null,
   typeRef1 int not null,
   typeRef2 int not null,
   activeTs bigint not null,
   rtnApplicable char(1) not null,
   rtnTs bigint,
   rtnCause int,
   alarmLevel int not null,
   message clob
 );
 0 rows inserted/updated/deleted
 ij> alter table reportInstanceEvents add constraint reportInstanceEventsPk primary key (eventId, reportInstanceId);
 0 rows inserted/updated/deleted
 ij> alter table reportInstanceEvents add constraint reportInstanceEventsFk1 foreign key (reportInstanceId)
   references reportInstances(id) on delete cascade;
 0 rows inserted/updated/deleted
 ij> alter table reportInstances add includeEvents int;
 0 rows inserted/updated/deleted
 ij> update reportInstances set includeEvents=1;
 0 rows inserted/updated/deleted
 WARNING 02000: No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table.
 ij> alter table reportInstances alter includeEvents not null;
 0 rows inserted/updated/deleted
 ij> alter table systemSettings add settingValueOld varchar(255);
 0 rows inserted/updated/deleted
 ij> update systemSettings set settingValueOld=settingValue;
 20 rows inserted/updated/deleted
 ij> alter table systemSettings drop settingValue;
 0 rows inserted/updated/deleted
 ij> alter table systemSettings add settingValue clob;
 0 rows inserted/updated/deleted
 ij> update systemSettings set settingValue=settingValueOld;
 20 rows inserted/updated/deleted
 ij> alter table systemSettings drop settingValueOld;
 0 rows inserted/updated/deleted
 ij> create table watchListUsers (
   watchListId int not null,
   userId int not null,
   accessType int not null
 );
 0 rows inserted/updated/deleted
 ij> alter table watchListUsers add constraint watchListUsersPk primary key (watchListId, userId);
 0 rows inserted/updated/deleted
 ij> alter table watchListUsers add constraint watchListUsersFk1 foreign key (watchListId) references watchLists(id) on delete cascade;
 0 rows inserted/updated/deleted
 ij> alter table watchListUsers add constraint watchListUsersFk2 foreign key (userId) references users(id) on delete cascade;
 0 rows inserted/updated/deleted
 ij> alter table users add homeUrl varchar(255);
 0 rows inserted/updated/deleted
 ij>


Bot
[Post New]10/09/2009 14:05:22
    Subject: Re:Version upgrade
[Up]
mlohbihler


[Avatar]

Joined: 01/03/2007 22:48:52
Messages: 974
Offline
The log says the field was created:

Code:
ij> alter table events add rtnTs bigint;
  0 rows inserted/updated/deleted


But you confirmed that it's not actually there. Can you confirm that other operations (like "alter table events add rtnCause int", and "alter table pointEventDetectors add alias varchar(255)") where also not done, or is the rtnTs field an isolated thing?

I don't think there is a bug in the upgrade anywhere since other users would have had the same problem, and believe me we would have heard about it by now.

If you find that there are other script statements that were apparently not executed, you might consider changing your database version back to 1.5.0 and upgrading to 1.6.0 again.
Best regards,
Matthew Lohbihler
[Post New]10/09/2009 18:49:11
    Subject: Re:Version upgrade
[Up]
Bot

Initiate
[Avatar]

Joined: 08/07/2007 17:33:52
Messages: 5
Location: Sweden
Offline
I delete installation of tomcat and mango, then I make a new installation of both tomcat 6.0.14 and mango version1.6.1.
Now its work, there must be some corrupted files with old installation.
Thanks for your help.


Bot
 
Forum Index -> Mango installation
Go to:   
Powered by JForum 2.1.7 © JForum Team