Uploaded image for project: 'FishEye'
  1. FishEye
  2. FE-3809

Upgrade of instances using Oracle fail when upgrade_75.sql is run

    XMLWordPrintable

Details

    Description

      Pattern logged:

      INFO   | jvm 1    | 2011/10/31 20:34:19 | org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dbControlFactory' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.cenqua.crucible.hibernate.DBControlFactoryImpl]: Constructor threw exception; nested exception is com.cenqua.crucible.hibernate.CruDBException: Problem upgrading with script D:\fecrucible\sql\ORACLE\upgrade\upgrade_75.sql: SQL script error on line 3: "alter table cru_revision add cru_oversize number(1,0) UPDATE cru_version SET cru_version = 76 WHERE cru_version_id = 1;" 
      INFO   | jvm 1    | 2011/10/31 20:34:19 | (ORA-01735: Ungültige Option ALTER TABLE
      INFO   | jvm 1    | 2011/10/31 20:34:19 | ), please contact http://www.atlassian.com/support/
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:288)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1003)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:907)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:580)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at org.mortbay.jetty.handler.ContextHandler.startContext(ContextHandler.java:549)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at org.mortbay.jetty.servlet.Context.startContext(Context.java:136)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at org.mortbay.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1282)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at org.mortbay.jetty.handler.ContextHandler.doStart(ContextHandler.java:518)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at org.mortbay.jetty.webapp.WebAppContext.doStart(WebAppContext.java:499)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at com.cenqua.fisheye.web.jetty.FishEyeWebApplicationContext.doStart(FishEyeWebApplicationContext.java:27)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:152)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at org.mortbay.jetty.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java:156)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:152)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at org.mortbay.jetty.handler.HandlerWrapper.doStart(HandlerWrapper.java:130)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at org.mortbay.jetty.Server.doStart(Server.java:224)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at com.cenqua.fisheye.web.WebServer.start(WebServer.java:275)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at com.cenqua.fisheye.ctl.Run.mainImpl(Run.java:228)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at com.cenqua.fisheye.ctl.Run.main(Run.java:77)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at java.lang.reflect.Method.invoke(Method.java:597)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at com.cenqua.fisheye.FishEyeCtl.mainImpl(FishEyeCtl.java:98)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at com.cenqua.fisheye.FishEyeCtl.main(FishEyeCtl.java:41)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at java.lang.reflect.Method.invoke(Method.java:597)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at org.tanukisoftware.wrapper.WrapperStartStopApp.run(WrapperStartStopApp.java:159)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | 	at java.lang.Thread.run(Thread.java:619)
      INFO   | jvm 1    | 2011/10/31 20:34:19 | Caused by: org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.cenqua.crucible.hibernate.DBControlFactoryImpl]: Constructor threw exception; nested exception is com.cenqua.crucible.hibernate.CruDBException: Problem upgrading with script D:\fecrucible\sql\ORACLE\upgrade\upgrade_75.sql: SQL script error on line 3: "alter table cru_revision add cru_oversize number(1,0) UPDATE cru_version SET cru_version = 76 WHERE cru_version_id = 1;" 
      

      Workaround: Add a semicolon to the end of the first line in the update script.

      Attachments

        Activity

          People

            abuttfield Anna Buttfield [Atlassian]
            rbattaglin Renan Battaglin
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: