Customer login  |   Contact us
Home Company Products Support Purchase
Forum Home » Survey software » Opinio

Topic: Upgrading to 7.2.1, table problems...
Replies: 1   Pages: 1   Last Post: Dec 9, 2015 11:44 PM by: Eivind Pedersen


Back to Topic List Back to Topic List Topics: [ Previous | Next ]
Replies: 1   Pages: 1  
molot

Posts: 1
Registered: Dec 1, 2015
Upgrading to 7.2.1, table problems...
Posted: Dec 1, 2015 9:38 PM
  Reply

It has the rights of an owner, but I'm getting this:

01 Dec 2015 13:56:51 -- INFO -- Log4j configure and watch: /[removedByPoster]/opinio/WEB-INF/log4j.properties
01 Dec 2015 13:56:51 -- INFO -- ------------- Initializing Opinio -------------
01 Dec 2015 13:56:51 -- INFO -- Opinio version 7.2 rev11447 (11-Nov-2015 12:47)
01 Dec 2015 13:56:51 -- INFO -- EasyCharts version 4.0.3
01 Dec 2015 13:56:51 -- INFO -- Java vendor: Oracle Corporation
01 Dec 2015 13:56:51 -- INFO -- Java version: 1.7.0_65
01 Dec 2015 13:56:51 -- INFO -- Servlet container: Apache Tomcat/6.0.36
01 Dec 2015 13:56:51 -- INFO -- Operating system: Linux
01 Dec 2015 13:56:51 -- INFO -- Operating system architecture: amd64
01 Dec 2015 13:56:51 -- INFO -- System home: /[removedByPoster]/opinio
01 Dec 2015 13:56:51 -- INFO -- SystemGlobals.setStopAllThreads() stop threads? false
01 Dec 2015 13:56:51 -- INFO -- Load supported languages - language loaded 'sv'
01 Dec 2015 13:56:51 -- INFO -- Load supported languages - language loaded 'es'
01 Dec 2015 13:56:51 -- INFO -- Load supported languages - language loaded 'no'
01 Dec 2015 13:56:51 -- INFO -- Load supported languages - language loaded 'zh'
01 Dec 2015 13:56:51 -- INFO -- Load supported languages - language loaded 'cs'
01 Dec 2015 13:56:51 -- INFO -- Load supported languages - ignore file 'ApplicationResources.properties_prev'
01 Dec 2015 13:56:51 -- INFO -- Load supported languages - language loaded 'fr'
01 Dec 2015 13:56:51 -- INFO -- Load supported languages - language loaded 'da'
01 Dec 2015 13:56:51 -- INFO -- Load supported languages - language loaded 'nl'
01 Dec 2015 13:56:51 -- INFO -- Load supported languages - language loaded 'de'
01 Dec 2015 13:56:51 -- INFO -- Loading /WEB-INF/database.properties file
01 Dec 2015 13:56:51 -- INFO -- Database properties are loaded.
01 Dec 2015 13:56:51 -- INFO -- Loading /WEB-INF/database_conn_pool.properties file
01 Dec 2015 13:56:51 -- INFO -- Database connection pool properties are loaded.
01 Dec 2015 13:56:51 -- INFO -- Loading /WEB-INF/opinio.properties file
01 Dec 2015 13:56:51 -- INFO -- System properties are loaded
01 Dec 2015 13:56:51 -- INFO -- Loading /WEB-INF/cluster.properties file
01 Dec 2015 13:56:51 -- INFO -- Cluster properties are loaded
01 Dec 2015 13:56:51 -- INFO -- Initializing managers
01 Dec 2015 13:56:51 -- INFO -- JDBC driver name: Microsoft JDBC Driver 4.1 for SQL Server
01 Dec 2015 13:56:51 -- INFO -- JDBC Minor version: 1
01 Dec 2015 13:56:51 -- INFO -- JDBC Major version: 4
01 Dec 2015 13:56:51 -- INFO -- JDBC Driver version: 4.1.5504.0
01 Dec 2015 13:56:51 -- INFO -- JDBC URL: jdbc:sqlserver://[removedByPoster];authenticationScheme=nativeAuthentication;xopenStates=false;sendTimeAsDatetime=true;trustServerCertificate=false;sendStringParametersAsUnicode=true;selectMethod=cursor;responseBuffering=adaptive;packetSize=8000;multiSubnetFailover=false;loginTimeout=15;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=true;databaseName=opinio;applicationName=Microsoft JDBC Driver for SQL Server;applicationIntent=readwrite;
01 Dec 2015 13:56:51 -- INFO -- ----------------------------------------
01 Dec 2015 13:56:51 -- INFO -- Database: Microsoft SQL Server, 11.00.5058
01 Dec 2015 13:56:51 -- INFO -- Automatic database upgrade
01 Dec 2015 13:56:51 -- INFO -- UpgradeDatabase.upgrade(): currentDbVersion: 19
01 Dec 2015 13:56:51 -- INFO -- 15) upgrade to version 6.3
01 Dec 2015 13:56:52 -- INFO -- - index ResponseDropdown1 on table OPS_ResponseDropdown was deleted
01 Dec 2015 13:56:52 -- INFO -- - index ResponseDropdown1 was added
01 Dec 2015 13:56:52 -- ERROR -- ConnectionPool: Cannot upgrade database: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'BranchTitle'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1522)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1716)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at M.E.info(KFQA:937)
at M.E.debug(KFQA:527)
at M.E.I(KFQA:229)
at M.H.I(KFQA:96)
at E.C.<clinit>(KFQA:218)
at E.EZ.I(KFQA:85)
at com.objectplanet.survey.business.SystemGlobals.B(KFQA:1449)
at com.objectplanet.survey.business.SystemGlobals.r(KFQA:1346)
at com.objectplanet.survey.business.CC.<init>(KFQA:75)
at com.objectplanet.survey.business.CC.<clinit>(KFQA:1159)
at com.objectplanet.survey.business.R.I(KFQA:56)
at com.objectplanet.survey.view.InitServlet.init(KFQA:252)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1206)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1026)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4421)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4734)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
at org.apache.catalina.core.StandardService.start(StandardService.java:525)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

01 Dec 2015 13:56:52 -- INFO -- DBCP - max connection count = 100
01 Dec 2015 13:56:52 -- INFO -- DBCP - max connection active time = 300000
01 Dec 2015 13:56:52 -- INFO -- Global system info is loaded
01 Dec 2015 13:56:52 -- INFO -- LockManager does not exist. Create LockManager
01 Dec 2015 13:56:52 -- INFO -- Initialize TaskManager
01 Dec 2015 13:56:52 -- INFO -- Timer for scheduled tasks is started
01 Dec 2015 13:56:52 -- INFO -- Start TimerTask that loads all stored tasks
01 Dec 2015 13:56:52 -- INFO -- WorkQueue 'Report Writing queue' has been created with 5 concurrent works
01 Dec 2015 13:56:52 -- INFO -- LuceneMainIndexerThread: next execution - Wed Dec 02 03:17:00 CST 2015, sleep time: 13 hr 20 min 7 sec 256 msec
01 Dec 2015 13:56:53 -- INFO -- ResourceNameManager: resource names are loaded.
01 Dec 2015 13:56:53 -- INFO -- ReportDrilldownCleanerThread: next execution - Sat Dec 05 23:00:00 CST 2015, sleep time: 4 days 9 hr 3 min 6 sec 909 msec
01 Dec 2015 13:56:53 -- INFO -- TrashCleanerThread: next execution - Fri Dec 04 03:00:00 CST 2015, sleep time: 2 days 13 hr 3 min 6 sec 894 msec
01 Dec 2015 13:56:53 -- INFO -- Default content type detection class is used
01 Dec 2015 13:56:53 -- INFO -- PluginJARClassLoader: loading /[removedByPoster]/opinio/WEB-INF/plugins/FreeTextValidatorPlugin.jar
01 Dec 2015 13:56:53 -- INFO -- PluginJARClassLoader: loading /[removedByPoster]/opinio/WEB-INF/plugins/MatrixSumValidatorPlugin.jar
01 Dec 2015 13:56:53 -- INFO -- PluginJARClassLoader: loading /[removedByPoster]/opinio/WEB-INF/plugins/MaxPercentagePlugin.jar
01 Dec 2015 13:56:53 -- INFO -- PluginJARClassLoader.loadPluginClass(): com.objectplanet.plugin.survey.FreeTextValidatorPlugin.FreeTextValidatorPlugin dependencies OK
01 Dec 2015 13:56:53 -- INFO -- Plugin com.objectplanet.plugin.survey.FreeTextValidatorPlugin.FreeTextValidatorPlugin has started.
01 Dec 2015 13:56:53 -- INFO -- PluginJARClassLoader.loadPluginClass(): com.objectplanet.plugin.survey.MatrixSumValidatorPlugin.MatrixSumValidatorPlugin dependencies OK
01 Dec 2015 13:56:53 -- INFO -- Plugin com.objectplanet.plugin.survey.MatrixSumValidatorPlugin.MatrixSumValidatorPlugin has started.
01 Dec 2015 13:56:53 -- INFO -- PluginJARClassLoader.loadPluginClass(): com.objectplanet.plugin.survey.MaxPercentagePlugin.MaxPercentagePlugin dependencies OK
01 Dec 2015 13:56:53 -- INFO -- Plugin com.objectplanet.plugin.survey.MaxPercentagePlugin.MaxPercentagePlugin has started.
01 Dec 2015 13:56:53 -- INFO -- Initializing FileServlet
01 Dec 2015 13:56:54 -- INFO -- SurveyManager: resources are loaded.
01 Dec 2015 13:56:54 -- INFO -- Tiles definition factory loaded for module ''.
01 Dec 2015 13:56:54 -- INFO -- Initializing InterviewerServlet
01 Dec 2015 13:56:54 -- INFO -- LuceneMainIndexer: indexing all users.
01 Dec 2015 13:56:54 -- INFO -- LuceneMainIndexer: indexing done.
01 Dec 2015 13:56:54 -- INFO -- Initializing RespondentUploadServlet
01 Dec 2015 13:56:54 -- INFO -- Global system info is reloaded
01 Dec 2015 13:57:03 -- INFO -- Log4j configure and watch: /[removedByPoster]/opinio/WEB-INF/log4j.properties

Eivind Pedersen

Posts: 466
From: Oslo, Norway
Registered: Jun 11, 2002
Re: Upgrading to 7.2.1, table problems...
Posted: Dec 9, 2015 11:41 PM
  Reply

Can you submit a ticket to our support team at http://support.objectplanet.com/esupport and attach the entire log file? We might need a copy of your database to debug the problem. We can discuss details in the ticket.



© 1998-2017 ObjectPlanet, Inc. Øvre Slottsgate 5, 0157 Oslo, Norway Tel (+47) 2233 3360 | Fax (+47) 2233 3361