Latest posts for the topic "Version upgrade"

Version upgrade

Bot — GMT

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.:63) - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
INFO 2009-09-09 13:56:19,937 (org.quartz.core.QuartzScheduler.: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.: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.(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.(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.(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.(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
[/code]

Bot

Re:Version upgrade

mlohbihler — GMT

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.

Re:Version upgrade

Bot — GMT

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

Re:Version upgrade

mlohbihler — GMT

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".

Re:Version upgrade

Bot — GMT

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

Re:Version upgrade

mlohbihler — GMT

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;",[/code]

(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?

Re:Version upgrade

Bot — GMT

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>
[/code]

Bot

Re:Version upgrade

mlohbihler — GMT

The log says the field was created:

[code]ij> alter table events add rtnTs bigint;
0 rows inserted/updated/deleted
[/code]

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.

Re:Version upgrade

Bot — GMT

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