5 Replies Latest reply on Dec 12, 2007 7:56 PM by gbobeck

    Upgrade Error - 1.6 to 1.9

      Folks,

       

      I am using the standalone version of Clearspace and tried to upgrade from v. 1.6 to 1.9. All seemingly went well but when I opened the Admin console I see the following error:

       

      PreparedStatementCallback; bad SQL grammar ; nested exception is java.sql.SQLException: Invalid object name 'jivePluginProp'.

       

      And, when I try open the app I get the following Message: System Error - with the following details:

       

           

      • Status Code: 500

           

      • Exception Type:

           

      • Error Message:

           

      • Request URI: /clearspace/index.jspa

           

      • Stack Trace:

                o freemarker.ext.beans.BeanModel.get(BeanModel.java:223)

                o freemarker.core.Dot._getAsTemplateModel(Dot.java:76)

                o freemarker.core.Expression.getAsTemplateModel(Expression.java:89)

                o freemarker.core.Expression.getStringValue(Expression.java:93)

                o freemarker.core.DollarVariable.accept(DollarVariable.java:76)

                o freemarker.core.Environment.visit(Environment.java:196)

                o freemarker.core.MixedContent.accept(MixedContent.java:92)

                o freemarker.core.Environment.visit(Environment.java:196)

                o freemarker.core.IfBlock.accept(IfBlock.java:82)

                o freemarker.core.Environment.visit(Environment.java:196)

                o freemarker.core.MixedContent.accept(MixedContent.java:92)

                o freemarker.core.Environment.visit(Environment.java:196)

                o freemarker.core.IteratorBlock$Context.runLoop(IteratorBlock.java:160)

                o freemarker.core.Environment.visit(Environment.java:351)

                o freemarker.core.IteratorBlock.accept(IteratorBlock.java:95)

                o freemarker.core.Environment.visit(Environment.java:196)

                o freemarker.core.MixedContent.accept(MixedContent.java:92)

                o freemarker.core.Environment.visit(Environment.java:196)

                o freemarker.core.IfBlock.accept(IfBlock.java:82)

                o freemarker.core.Environment.visit(Environment.java:196)

                o freemarker.core.MixedContent.accept(MixedContent.java:92)

                o freemarker.core.Environment.visit(Environment.java:196)

                o freemarker.core.IfBlock.accept(IfBlock.java:82)

                o freemarker.core.Environment.visit(Environment.java:196)

                o freemarker.core.MixedContent.accept(MixedContent.java:92)

                o freemarker.core.Environment.visit(Environment.java:196)

                o freemarker.core.Environment.process(Environment.java:176)

                o freemarker.template.Template.process(Template.java:232)

                o com.opensymphony.webwork.views.freemarker.FreemarkerResult.doExecute(FreemarkerResult.java:153)

                o com.jivesoftware.community.web.webwork.FreemarkerResult.doExecute(FreemarkerResult.java:134)

                o com.opensymphony.webwork.dispatcher.WebWorkResultSupport.execute(WebWorkResultSupport.java:143)

                o com.opensymphony.xwork.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:313)

                o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:208)

                o com.jivesoftware.community.web.webwork.FlashInterceptor.intercept(FlashInterceptor.java:40)

                o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                o com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:175)

                o com.opensymphony.xwork.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)

                o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                o com.opensymphony.xwork.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:115)

                o com.opensymphony.xwork.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)

                o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                o com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)

                o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                o com.jivesoftware.community.web.webwork.JiveObjectLoaderInterceptor.intercept(JiveObjectLoaderInterceptor.java:55)

                o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                o com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)

                o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                o com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)

                o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                o com.opensymphony.webwork.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:171)

                o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                o com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)

                o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                o com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)

                o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                o com.opensymphony.xwork.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:151)

                o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                o com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)

                o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                o com.jivesoftware.community.web.webwork.JiveIOCInterceptor.intercept(JiveIOCInterceptor.java:719)

                o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                o com.jivesoftware.community.action.LocaleInterceptor.intercept(LocaleInterceptor.java:71)

                o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                o com.jivesoftware.community.web.webwork.AuthInterceptor.intercept(AuthInterceptor.java:91)

                o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                o com.jivesoftware.community.web.webwork.JiveLoginInterceptor.intercept(JiveLoginInterceptor.java:42)

                o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                o com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)

                o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                o com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)

                o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                o com.opensymphony.xwork.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:186)

                o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                o com.jivesoftware.community.web.webwork.ModuleCheckInterceptor.intercept(ModuleCheckInterceptor.java:49)

                o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                o com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116)

                o com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:225)

                o com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:202)

                o com.jivesoftware.community.web.webwork.JiveFilterDispatcher.doFilter(JiveFilterDispatcher.java:53)

                o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

                o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

                o com.jivesoftware.community.web.filter.SetResponseCharacterEncodingFilter.doFilter(SetResponseCharacterEncodingFilter.java:62)

                o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

                o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

                o com.jivesoftware.community.web.filter.JiveCacheFilter.doFilter(JiveCacheFilter.java:191)

                o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

                o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

                o com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)

                o com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)

                o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

                o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

                o com.jivesoftware.community.web.JiveActionContextCleanUp.doFilter(JiveActionContextCleanUp.java:46)

                o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

                o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

                o com.jivesoftware.community.web.filter.PresenceFilter.doFilter(PresenceFilter.java:106)

                o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

                o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

                o com.jivesoftware.community.web.filter.JiveCompressionFilter.doFilter(JiveCompressionFilter.java:111)

                o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

                o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

                o com.jivesoftware.community.web.filter.SetRequestCharacterEncodingFilter.doFilter(SetRequestCharacterEncodingFilter.java:76)

                o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

                o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

                o org.directwebremoting.servlet.DwrWebContextFilter.doFilter(DwrWebContextFilter.java:91)

                o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

                o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

                o com.jivesoftware.community.web.filter.MaintenanceFilter.doFilter(MaintenanceFilter.java:81)

                o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

                o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

                o com.jivesoftware.community.upgrade.UpgradeFilter.doFilter(UpgradeFilter.java:43)

                o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

                o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

                o com.jivesoftware.base.plugin.PluginFilter.doFilter(PluginFilter.java:77)

                o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

                o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

                o com.jivesoftware.community.web.filter.ApplicationInitializedFilter.doFilter(ApplicationInitializedFilter.java:95)

                o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

                o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

                o com.jivesoftware.base.database.dao.DAOContextCleanUpFilter.doFilter(DAOContextCleanUpFilter.java:32)

                o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

                o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

                o org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

                o org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)

                o org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)

                o org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)

                o org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)

                o org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)

                o org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)

                o org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)

                o org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)

                o org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)

                o org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)

                o java.lang.Thread.run(Thread.java:595)

           

      • freemarker.template.TemplateModelException: get(subject) failed on instance of com.jivesoftware.community.proxy.DocumentProxy

       

       

      I am no expert with Java - so, please help me with this in mind.

       

      Thanks!

      John