com.atlassian.confluence.upgrade.UpgradeException

If you like a tip written by other Samebug users, mark is as helpful! Marks help our algorithm provide you better solutions and also help other users.
tip

This is a bug in version 4.1.9 and it's fixed from version 4.3.0beta and beyond.

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • following error cwd_membership java.sql.SQLException: ORA-00942 {code} 2012-06-13 12:30:31,314 INFO [main] [com.atlassian.confluence.lifecycle] contextInitialized Starting Confluence 3.5 (build #2148) 2012-06-13 12:30:33,088 INFO [main] [atlassian.plugin.manager.DefaultPluginManager] init Initialising the plugin system 2012-06-13 12:30:33,215 INFO [main] [atlassian.plugin.manager.DefaultPluginManager] init Plugin system started in 0:00:00.126 2012-06-13 12:30:33,944 INFO [main] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization started 2012-06-13 12:30:35,219 INFO [main] [com.atlassian.confluence.lifecycle] <init> Loading EhCache cache manager 2012-06-13 12:30:45,857 ERROR [main] [confluence.search.lucene.ConfluenceSearcherInitialisation] initialise Error encountered while warming up searcher - The index has not been upgraded. Please reindex. 2012-06-13 12:30:49,267 INFO [main] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization completed in 15323 ms 2012-06-13 12:30:50,876 ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute Unsuccessful: alter table cwd_membership add child_group_id number(19,0) 2012-06-13 12:30:50,877 ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute ORA-00942: 테이블 또는 뷰가 존재하지 않습니다 2012-06-13 12:30:50,878 ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute could not complete schema update java.sql.SQLException: ORA-00942: 테이블 또는 뷰가 존재하지 않습니다 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:194) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1000) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307) at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1814) at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1779) at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:277) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) at net.sf.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:167) at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:147) at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:134) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgradeSchema(AbstractUpgradeManager.java:158) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:62) at com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager.upgrade(DefaultUpgradeManager.java:139) at com.atlassian.confluence.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:28) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4205) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4704) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) at org.apache.catalina.core.StandardHost.start(StandardHost.java:840) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) 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: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:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) 2012-06-13 12:30:50,896 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized Upgrade failed, application will not start: com.atlassian.config.ConfigurationException: Cannot update schema com.atlassian.confluence.upgrade.UpgradeException: com.atlassian.config.ConfigurationException: Cannot update schema at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:84) at com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager.upgrade(DefaultUpgradeManager.java:139) at com.atlassian.confluence.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:28) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4205) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4704) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) at org.apache.catalina.core.StandardHost.start(StandardHost.java:840) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) 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: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:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) Caused by: com.atlassian.config.ConfigurationException: Cannot update schema at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:151) at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:134) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgradeSchema(AbstractUpgradeManager.java:158) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:62) ... 17 more Caused by: java.sql.SQLException: ORA-00942: 테이블 또는 뷰가 존재하지 않습니다 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:194) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1000) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307) at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1814) at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1779) at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:277) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) at net.sf.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:167) at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:147) ... 20 more 2012-06-13 12:30:50,901 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized 1 errors were encountered during upgrade: 2012-06-13 12:30:50,902 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized 1: Cannot update schema 2012-06-13 12:30:51,937 INFO [main] [com.atlassian.confluence.lifecycle] init Confluence is ready to serve ^[[D {code}
    via by Inno Song,
  • following error cwd_membership java.sql.SQLException: ORA-00942 {code} 2012-06-13 12:30:31,314 INFO [main] [com.atlassian.confluence.lifecycle] contextInitialized Starting Confluence 3.5 (build #2148) 2012-06-13 12:30:33,088 INFO [main] [atlassian.plugin.manager.DefaultPluginManager] init Initialising the plugin system 2012-06-13 12:30:33,215 INFO [main] [atlassian.plugin.manager.DefaultPluginManager] init Plugin system started in 0:00:00.126 2012-06-13 12:30:33,944 INFO [main] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization started 2012-06-13 12:30:35,219 INFO [main] [com.atlassian.confluence.lifecycle] <init> Loading EhCache cache manager 2012-06-13 12:30:45,857 ERROR [main] [confluence.search.lucene.ConfluenceSearcherInitialisation] initialise Error encountered while warming up searcher - The index has not been upgraded. Please reindex. 2012-06-13 12:30:49,267 INFO [main] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization completed in 15323 ms 2012-06-13 12:30:50,876 ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute Unsuccessful: alter table cwd_membership add child_group_id number(19,0) 2012-06-13 12:30:50,877 ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute ORA-00942: 테이블 또는 뷰가 존재하지 않습니다 2012-06-13 12:30:50,878 ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute could not complete schema update java.sql.SQLException: ORA-00942: 테이블 또는 뷰가 존재하지 않습니다 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:194) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1000) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307) at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1814) at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1779) at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:277) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) at net.sf.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:167) at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:147) at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:134) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgradeSchema(AbstractUpgradeManager.java:158) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:62) at com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager.upgrade(DefaultUpgradeManager.java:139) at com.atlassian.confluence.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:28) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4205) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4704) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) at org.apache.catalina.core.StandardHost.start(StandardHost.java:840) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) 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: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:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) 2012-06-13 12:30:50,896 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized Upgrade failed, application will not start: com.atlassian.config.ConfigurationException: Cannot update schema com.atlassian.confluence.upgrade.UpgradeException: com.atlassian.config.ConfigurationException: Cannot update schema at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:84) at com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager.upgrade(DefaultUpgradeManager.java:139) at com.atlassian.confluence.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:28) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4205) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4704) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) at org.apache.catalina.core.StandardHost.start(StandardHost.java:840) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) 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: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:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) Caused by: com.atlassian.config.ConfigurationException: Cannot update schema at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:151) at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:134) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgradeSchema(AbstractUpgradeManager.java:158) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:62) ... 17 more Caused by: java.sql.SQLException: ORA-00942: 테이블 또는 뷰가 존재하지 않습니다 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:194) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1000) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307) at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1814) at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1779) at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:277) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) at net.sf.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:167) at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:147) ... 20 more 2012-06-13 12:30:50,901 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized 1 errors were encountered during upgrade: 2012-06-13 12:30:50,902 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized 1: Cannot update schema 2012-06-13 12:30:51,937 INFO [main] [com.atlassian.confluence.lifecycle] init Confluence is ready to serve ^[[D {code}
    via by Inno Song,
  • Exception suggests the upgrade failed because the column already exists. Given that the table has been there for a number of version - or at least seems to be based on the data in the table, and the column being added is the primary key for this table, I find the exception, and what appears to be the inability to handle the concept of needing to "creating something that already exists" a little more gracefully perplexing. The good news is that reverting back to 2.10.4 went without a hitch. 2009-10-10 12:21:42,101 INFO [Thread-1] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization completed in 12812 ms 2009-10-10 12:21:43,586 ERROR [Thread-1] [hibernate.tool.hbm2ddl.SchemaUpdate] execute Unsuccessful: alter table LABEL add LABELID number(19,0) 2009-10-10 12:21:43,586 ERROR [Thread-1] [hibernate.tool.hbm2ddl.SchemaUpdate] execute ORA-01430: column being added already exists in table 2009-10-10 12:21:43,586 ERROR [Thread-1] [hibernate.tool.hbm2ddl.SchemaUpdate] execute could not complete schema update java.sql.SQLException: ORA-01430: column being added already exists in table at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:942) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222) at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1706) at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1674) at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:275) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) at net.sf.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:167) at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:147) at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:134) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgradeSchema(AbstractUpgradeManager.java:146) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:47) at com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager.upgrade(DefaultUpgradeManager.java:70) at com.atlassian.confluence.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:26) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardHost.start(StandardHost.java:722) 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:583) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) 2009-10-10 12:21:43,586 ERROR [Thread-1] [atlassian.confluence.upgrade.AbstractUpgradeManager] upgrade Exception thrown during upgrade: Cannot update schema com.atlassian.config.ConfigurationException: Cannot update schema at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:151) at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:134) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgradeSchema(AbstractUpgradeManager.java:146) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:47) at com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager.upgrade(DefaultUpgradeManager.java:70) at com.atlassian.confluence.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:26) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardHost.start(StandardHost.java:722) 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:583) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) Caused by: java.sql.SQLException: ORA-01430: column being added already exists in table at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:942) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222) at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1706) at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1674) at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:275) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) at net.sf.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:167) at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:147) ... 20 more 2009-10-10 12:21:43,601 FATAL [Thread-1] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized Upgrade failed, application will not start: com.atlassian.config.ConfigurationException: Cannot update schema com.atlassian.confluence.upgrade.UpgradeException: com.atlassian.config.ConfigurationException: Cannot update schema at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:80) at com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager.upgrade(DefaultUpgradeManager.java:70) at com.atlassian.confluence.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:26) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardHost.start(StandardHost.java:722) 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:583) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) Caused by: com.atlassian.config.ConfigurationException: Cannot update schema at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:151) at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:134) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgradeSchema(AbstractUpgradeManager.java:146) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:47) ... 17 more Caused by: java.sql.SQLException: ORA-01430: column being added already exists in table
    via by Arvid Jedlicka,
  • Exception suggests the upgrade failed because the column already exists. Given that the table has been there for a number of version - or at least seems to be based on the data in the table, and the column being added is the primary key for this table, I find the exception, and what appears to be the inability to handle the concept of needing to "creating something that already exists" a little more gracefully perplexing. The good news is that reverting back to 2.10.4 went without a hitch. 2009-10-10 12:21:42,101 INFO [Thread-1] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization completed in 12812 ms 2009-10-10 12:21:43,586 ERROR [Thread-1] [hibernate.tool.hbm2ddl.SchemaUpdate] execute Unsuccessful: alter table LABEL add LABELID number(19,0) 2009-10-10 12:21:43,586 ERROR [Thread-1] [hibernate.tool.hbm2ddl.SchemaUpdate] execute ORA-01430: column being added already exists in table 2009-10-10 12:21:43,586 ERROR [Thread-1] [hibernate.tool.hbm2ddl.SchemaUpdate] execute could not complete schema update java.sql.SQLException: ORA-01430: column being added already exists in table at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:942) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222) at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1706) at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1674) at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:275) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) at net.sf.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:167) at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:147) at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:134) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgradeSchema(AbstractUpgradeManager.java:146) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:47) at com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager.upgrade(DefaultUpgradeManager.java:70) at com.atlassian.confluence.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:26) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardHost.start(StandardHost.java:722) 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:583) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) 2009-10-10 12:21:43,586 ERROR [Thread-1] [atlassian.confluence.upgrade.AbstractUpgradeManager] upgrade Exception thrown during upgrade: Cannot update schema com.atlassian.config.ConfigurationException: Cannot update schema at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:151) at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:134) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgradeSchema(AbstractUpgradeManager.java:146) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:47) at com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager.upgrade(DefaultUpgradeManager.java:70) at com.atlassian.confluence.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:26) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardHost.start(StandardHost.java:722) 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:583) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) Caused by: java.sql.SQLException: ORA-01430: column being added already exists in table at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:942) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222) at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1706) at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1674) at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:275) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) at net.sf.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:167) at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:147) ... 20 more 2009-10-10 12:21:43,601 FATAL [Thread-1] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized Upgrade failed, application will not start: com.atlassian.config.ConfigurationException: Cannot update schema com.atlassian.confluence.upgrade.UpgradeException: com.atlassian.config.ConfigurationException: Cannot update schema at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:80) at com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager.upgrade(DefaultUpgradeManager.java:70) at com.atlassian.confluence.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:26) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardHost.start(StandardHost.java:722) 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:583) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) Caused by: com.atlassian.config.ConfigurationException: Cannot update schema at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:151) at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:134) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgradeSchema(AbstractUpgradeManager.java:146) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:47) ... 17 more Caused by: java.sql.SQLException: ORA-01430: column being added already exists in table
    via by Arvid Jedlicka,
  • GitHub comment 12#126733654
    via GitHub by straav
    ,
  • Many users find themselves encountering ORA-00972 when attempting to access a table that has a large column length. ... ORA-00972 in which trying to get data from DBMS tables with 31 or more characters in the column name, throws ORA-00972. This can happen even if the ORA_OBJECT_NAME domain is defined as VARCHAR(30) as opposed to VARCHAR(31) AO_60DB71_ISSUERANKINGLOG_ID_SEQ is longer than 30 characters at 32 characters. build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] 2011-11-11 21:37:37,632 JiraImportTaskExecutionThread-1 ERROR admin 1297x22x1 ti27su 127.0.0.1 /secure/admin/XmlRestore.jspa [jira.bc.dataimport.DefaultDataImportService] Error importing data: com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin GreenHopper(com.pyxis.greenhopper.jira) #5.8.4-SNAPSHOT:Error executing update for SQL statement 'DROP SEQUENCE AO_60DB71_ISSUERANKINGLOG_ID_SEQ' build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin GreenHopper(com.pyxis.greenhopper.jira) #5.8.4-SNAPSHOT:Error executing update for SQL statement 'DROP SEQUENCE AO_60DB71_ISSUERANKINGLOG_ID_SEQ' build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.activeobjects.backup.ImportExportErrorServiceImpl.newImportExportSqlException(ImportExportErrorServiceImpl.java:32) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.activeobjects.backup.SequenceUtils.executeUpdate(SequenceUtils.java:33) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.activeobjects.backup.SequenceUtils.executeUpdate(SequenceUtils.java:43) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.activeobjects.backup.OracleSequencesAroundImporter.dropSequence(OracleSequencesAroundImporter.java:115) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.activeobjects.backup.OracleSequencesAroundImporter.dropAllSequences(OracleSequencesAroundImporter.java:100) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.activeobjects.backup.OracleSequencesAroundImporter.doBefore(OracleSequencesAroundImporter.java:61) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.activeobjects.backup.OracleSequencesAroundImporter.before(OracleSequencesAroundImporter.java:39) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.dbexporter.importer.AbstractImporter.importNode(AbstractImporter.java:46) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.dbexporter.DbImporter.importData(DbImporter.java:73) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.activeobjects.backup.ActiveObjectsBackup.restore(ActiveObjectsBackup.java:155) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.jira.bc.dataimport.DefaultDataImportService.restoreActiveObjects(DefaultDataImportService.java:347) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:479) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:209) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:65) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:28) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:147) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at java.util.concurrent.FutureTask.run(FutureTask.java:138) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at java.util.concurrent.FutureTask.run(FutureTask.java:138) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.multitenant.impl.DefaultMultiTenantManager.runForTenant(DefaultMultiTenantManager.java:61) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.multitenant.juc.MultiTenantExecutors$WrappedRunnable.run(MultiTenantExecutors.java:160) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at java.lang.Thread.run(Thread.java:662) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] Caused by: java.sql.SQLException: ORA-00972: identifier is too long build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:194) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1000) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1814) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1779) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:277) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.activeobjects.backup.SequenceUtils.executeUpdate(SequenceUtils.java:29) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] ... 24 more build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] 2011-11-11 21:37:37,636 JiraImportTaskExecutionThread-1 INFO admin 1297x22x1 ti27su 127.0.0.1 /secure/admin/XmlRestore.jspa [jira.bc.dataimport.DefaultDataImportService] Importing data is 100% complete... build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] 2011-11-11 21:37:37,636 JiraImportTaskExecutionThread-1 INFO admin 1297x22x1 ti27su 127.0.0.1 /secure/admin/XmlRestore.jspa [jira.bc.dataimport.DefaultDataImportService] JIRA Data Import has finished. build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . ______ TEST FAILURE ______ build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . java.lang.AssertionError: Failed to restore JIRA data from [/opt/bamboo-agent/xml-data/build-dir/GH-TPM58-TPMORACLE/greenhopper-integration-test/target/jira/home/import/test-data.zip]. See logs for details. build 11-Nov-2011 21:37:37 . at com.atlassian.jira.functest.framework.AdministrationImpl.restoreData(AdministrationImpl.java:423) build 11-Nov-2011 21:37:37 . at com.atlassian.jira.functest.framework.AdministrationImpl.restoreData(AdministrationImpl.java:368) build 11-Nov-2011 21:37:37 . at com.atlassian.jira.functest.framework.AdministrationImpl.restoreData(AdministrationImpl.java:352) build 11-Nov-2011 21:37:37 . at com.atlassian.jira.functest.framework.AdministrationImpl.restoreData(AdministrationImpl.java:296) build 11-Nov-2011 21:37:37 . at com.atlassian.jira.functest.framework.AdministrationImpl.restoreData(AdministrationImpl.java:290) build 11-Nov-2011 21:37:37 . at it.com.atlassian.greenhopper.api.RankResourceTest.setUpTest(RankResourceTest.java:44) build 11-Nov-2011 21:37:37 . at com.atlassian.jira.functest.framework.FuncTestCase.setUp(FuncTestCase.java:168) build 11-Nov-2011 21:37:37 . at junit.framework.TestCase.runBare(TestCase.java:132) build 11-Nov-2011 21:37:37 . at com.atlassian.jira.functest.framework.FuncTestCase.runBare(FuncTestCase.java:300) build 11-Nov-2011 21:37:37 . at junit.framework.TestResult$1.protect(TestResult.java:110) build 11-Nov-2011 21:37:37 . at junit.framework.TestResult.runProtected(TestResult.java:128) build 11-Nov-2011 21:37:37 . at junit.framework.TestResult.run(TestResult.java:113) build 11-Nov-2011 21:37:37 . at junit.framework.TestCase.run(TestCase.java:124) build 11-Nov-2011 21:37:37 . at junit.framework.TestSuite.runTest(TestSuite.java:243) build 11-Nov-2011 21:37:37 . at junit.framework.TestSuite.run(TestSuite.java:238) build 11-Nov-2011 21:37:37 . at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:83) build 11-Nov-2011 21:37:37 . at org.apache.maven.surefire.junit4.JUnit4TestSet.execute(JUnit4TestSet.java:62) build 11-Nov-2011 21:37:37 . at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.executeTestSet(AbstractDirectoryTestSuite.java:140) build 11-Nov-2011 21:37:37 . at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.execute(AbstractDirectoryTestSuite.java:127) build 11-Nov-2011 21:37:37 . at org.apache.maven.surefire.Surefire.run(Surefire.java:177) build 11-Nov-2011 21:37:37 . at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) build 11-Nov-2011 21:37:37 . at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) build 11-Nov-2011 21:37:37 . at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) build 11-Nov-2011 21:37:37 . at java.lang.reflect.Method.invoke(Method.java:597) build 11-Nov-2011 21:37:37 . at org.apache.maven.surefire.booter.SurefireBooter.runSuitesInProcess(SurefireBooter.java:345) build 11-Nov-2011 21:37:37 . at org.apache.maven.surefire.booter.SurefireBooter.main(SurefireBooter.java:1009) build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . ______________________________ Starting HTML dump build 11-Nov-2011 21:37:37 . URL : http://localhost:2990/jira/secure/admin/XmlRestore!finish.jspa build 11-Nov-2011 21:37:37 . HTTP METHOD : GET build 11-Nov-2011 21:37:37 . HTTP SC : 200 build 11-Nov-2011 21:37:37 . HTTP MSG : OK build 11-Nov-2011 21:37:37 . Request Headers : build 11-Nov-2011 21:37:37 . ________________ build 11-Nov-2011 21:37:37 . Cookie : JSESSIONID=AFC8AEF9B215D62635E33AB8135073EF;atlassian.xsrf.token=B81K-KFOU-I9XI-SF5D|5695b6165f239c625fb471e35f384ffe9da49036|lin build 11-Nov-2011 21:37:37 . Accept-Encoding : gzip build 11-Nov-2011 21:37:37 . User-Agent : httpunit/1.5.4-atlassian-patched build 11-Nov-2011 21:37:37 . Response Headers : build 11-Nov-2011 21:37:37 . ________________ build 11-Nov-2011 21:37:37 . EXPIRES : Thu, 01 Jan 1970 00:00:00 GMT build 11-Nov-2011 21:37:37 . X-ASESSIONID : ti27su build 11-Nov-2011 21:37:37 . DATE : Sat, 12 Nov 2011 03:37:37 GMT build 11-Nov-2011 21:37:37 . CONTENT-TYPE : text/html;charset=UTF-8 build 11-Nov-2011 21:37:37 . CACHE-CONTROL : no-cache, no-store, must-revalidate build 11-Nov-2011 21:37:37 . TRANSFER-ENCODING : chunked build 11-Nov-2011 21:37:37 . X-AUSERNAME : admin build 11-Nov-2011 21:37:37 . SERVER : Apache-Coyote/1.1 build 11-Nov-2011 21:37:37 . X-AREQUESTID : 1297x23x1 build 11-Nov-2011 21:37:37 . X-SERAPH-LOGINREASON : OK build 11-Nov-2011 21:37:37 . PRAGMA : no-cache build 11-Nov-2011 21:37:37 . Last Successful Response Body : build 11-Nov-2011 21:37:37 . ________________ build 11-Nov-2011 21:37:37 . <!DOCTYPE html> build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . <html>
    via by Peter Obara [Atlassian],
  • Many users find themselves encountering ORA-00972 when attempting to access a table that has a large column length. ... ORA-00972 in which trying to get data from DBMS tables with 31 or more characters in the column name, throws ORA-00972. This can happen even if the ORA_OBJECT_NAME domain is defined as VARCHAR(30) as opposed to VARCHAR(31) AO_60DB71_ISSUERANKINGLOG_ID_SEQ is longer than 30 characters at 32 characters. build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] 2011-11-11 21:37:37,632 JiraImportTaskExecutionThread-1 ERROR admin 1297x22x1 ti27su 127.0.0.1 /secure/admin/XmlRestore.jspa [jira.bc.dataimport.DefaultDataImportService] Error importing data: com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin GreenHopper(com.pyxis.greenhopper.jira) #5.8.4-SNAPSHOT:Error executing update for SQL statement 'DROP SEQUENCE AO_60DB71_ISSUERANKINGLOG_ID_SEQ' build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin GreenHopper(com.pyxis.greenhopper.jira) #5.8.4-SNAPSHOT:Error executing update for SQL statement 'DROP SEQUENCE AO_60DB71_ISSUERANKINGLOG_ID_SEQ' build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.activeobjects.backup.ImportExportErrorServiceImpl.newImportExportSqlException(ImportExportErrorServiceImpl.java:32) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.activeobjects.backup.SequenceUtils.executeUpdate(SequenceUtils.java:33) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.activeobjects.backup.SequenceUtils.executeUpdate(SequenceUtils.java:43) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.activeobjects.backup.OracleSequencesAroundImporter.dropSequence(OracleSequencesAroundImporter.java:115) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.activeobjects.backup.OracleSequencesAroundImporter.dropAllSequences(OracleSequencesAroundImporter.java:100) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.activeobjects.backup.OracleSequencesAroundImporter.doBefore(OracleSequencesAroundImporter.java:61) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.activeobjects.backup.OracleSequencesAroundImporter.before(OracleSequencesAroundImporter.java:39) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.dbexporter.importer.AbstractImporter.importNode(AbstractImporter.java:46) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.dbexporter.DbImporter.importData(DbImporter.java:73) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.activeobjects.backup.ActiveObjectsBackup.restore(ActiveObjectsBackup.java:155) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.jira.bc.dataimport.DefaultDataImportService.restoreActiveObjects(DefaultDataImportService.java:347) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:479) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:209) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:65) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:28) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:147) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at java.util.concurrent.FutureTask.run(FutureTask.java:138) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at java.util.concurrent.FutureTask.run(FutureTask.java:138) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.multitenant.impl.DefaultMultiTenantManager.runForTenant(DefaultMultiTenantManager.java:61) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.multitenant.juc.MultiTenantExecutors$WrappedRunnable.run(MultiTenantExecutors.java:160) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at java.lang.Thread.run(Thread.java:662) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] Caused by: java.sql.SQLException: ORA-00972: identifier is too long build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:194) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1000) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1814) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1779) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:277) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.activeobjects.backup.SequenceUtils.executeUpdate(SequenceUtils.java:29) build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] ... 24 more build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] 2011-11-11 21:37:37,636 JiraImportTaskExecutionThread-1 INFO admin 1297x22x1 ti27su 127.0.0.1 /secure/admin/XmlRestore.jspa [jira.bc.dataimport.DefaultDataImportService] Importing data is 100% complete... build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] 2011-11-11 21:37:37,636 JiraImportTaskExecutionThread-1 INFO admin 1297x22x1 ti27su 127.0.0.1 /secure/admin/XmlRestore.jspa [jira.bc.dataimport.DefaultDataImportService] JIRA Data Import has finished. build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . ______ TEST FAILURE ______ build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . java.lang.AssertionError: Failed to restore JIRA data from [/opt/bamboo-agent/xml-data/build-dir/GH-TPM58-TPMORACLE/greenhopper-integration-test/target/jira/home/import/test-data.zip]. See logs for details. build 11-Nov-2011 21:37:37 . at com.atlassian.jira.functest.framework.AdministrationImpl.restoreData(AdministrationImpl.java:423) build 11-Nov-2011 21:37:37 . at com.atlassian.jira.functest.framework.AdministrationImpl.restoreData(AdministrationImpl.java:368) build 11-Nov-2011 21:37:37 . at com.atlassian.jira.functest.framework.AdministrationImpl.restoreData(AdministrationImpl.java:352) build 11-Nov-2011 21:37:37 . at com.atlassian.jira.functest.framework.AdministrationImpl.restoreData(AdministrationImpl.java:296) build 11-Nov-2011 21:37:37 . at com.atlassian.jira.functest.framework.AdministrationImpl.restoreData(AdministrationImpl.java:290) build 11-Nov-2011 21:37:37 . at it.com.atlassian.greenhopper.api.RankResourceTest.setUpTest(RankResourceTest.java:44) build 11-Nov-2011 21:37:37 . at com.atlassian.jira.functest.framework.FuncTestCase.setUp(FuncTestCase.java:168) build 11-Nov-2011 21:37:37 . at junit.framework.TestCase.runBare(TestCase.java:132) build 11-Nov-2011 21:37:37 . at com.atlassian.jira.functest.framework.FuncTestCase.runBare(FuncTestCase.java:300) build 11-Nov-2011 21:37:37 . at junit.framework.TestResult$1.protect(TestResult.java:110) build 11-Nov-2011 21:37:37 . at junit.framework.TestResult.runProtected(TestResult.java:128) build 11-Nov-2011 21:37:37 . at junit.framework.TestResult.run(TestResult.java:113) build 11-Nov-2011 21:37:37 . at junit.framework.TestCase.run(TestCase.java:124) build 11-Nov-2011 21:37:37 . at junit.framework.TestSuite.runTest(TestSuite.java:243) build 11-Nov-2011 21:37:37 . at junit.framework.TestSuite.run(TestSuite.java:238) build 11-Nov-2011 21:37:37 . at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:83) build 11-Nov-2011 21:37:37 . at org.apache.maven.surefire.junit4.JUnit4TestSet.execute(JUnit4TestSet.java:62) build 11-Nov-2011 21:37:37 . at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.executeTestSet(AbstractDirectoryTestSuite.java:140) build 11-Nov-2011 21:37:37 . at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.execute(AbstractDirectoryTestSuite.java:127) build 11-Nov-2011 21:37:37 . at org.apache.maven.surefire.Surefire.run(Surefire.java:177) build 11-Nov-2011 21:37:37 . at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) build 11-Nov-2011 21:37:37 . at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) build 11-Nov-2011 21:37:37 . at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) build 11-Nov-2011 21:37:37 . at java.lang.reflect.Method.invoke(Method.java:597) build 11-Nov-2011 21:37:37 . at org.apache.maven.surefire.booter.SurefireBooter.runSuitesInProcess(SurefireBooter.java:345) build 11-Nov-2011 21:37:37 . at org.apache.maven.surefire.booter.SurefireBooter.main(SurefireBooter.java:1009) build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . ______________________________ Starting HTML dump build 11-Nov-2011 21:37:37 . URL : http://localhost:2990/jira/secure/admin/XmlRestore!finish.jspa build 11-Nov-2011 21:37:37 . HTTP METHOD : GET build 11-Nov-2011 21:37:37 . HTTP SC : 200 build 11-Nov-2011 21:37:37 . HTTP MSG : OK build 11-Nov-2011 21:37:37 . Request Headers : build 11-Nov-2011 21:37:37 . ________________ build 11-Nov-2011 21:37:37 . Cookie : JSESSIONID=AFC8AEF9B215D62635E33AB8135073EF;atlassian.xsrf.token=B81K-KFOU-I9XI-SF5D|5695b6165f239c625fb471e35f384ffe9da49036|lin build 11-Nov-2011 21:37:37 . Accept-Encoding : gzip build 11-Nov-2011 21:37:37 . User-Agent : httpunit/1.5.4-atlassian-patched build 11-Nov-2011 21:37:37 . Response Headers : build 11-Nov-2011 21:37:37 . ________________ build 11-Nov-2011 21:37:37 . EXPIRES : Thu, 01 Jan 1970 00:00:00 GMT build 11-Nov-2011 21:37:37 . X-ASESSIONID : ti27su build 11-Nov-2011 21:37:37 . DATE : Sat, 12 Nov 2011 03:37:37 GMT build 11-Nov-2011 21:37:37 . CONTENT-TYPE : text/html;charset=UTF-8 build 11-Nov-2011 21:37:37 . CACHE-CONTROL : no-cache, no-store, must-revalidate build 11-Nov-2011 21:37:37 . TRANSFER-ENCODING : chunked build 11-Nov-2011 21:37:37 . X-AUSERNAME : admin build 11-Nov-2011 21:37:37 . SERVER : Apache-Coyote/1.1 build 11-Nov-2011 21:37:37 . X-AREQUESTID : 1297x23x1 build 11-Nov-2011 21:37:37 . X-SERAPH-LOGINREASON : OK build 11-Nov-2011 21:37:37 . PRAGMA : no-cache build 11-Nov-2011 21:37:37 . Last Successful Response Body : build 11-Nov-2011 21:37:37 . ________________ build 11-Nov-2011 21:37:37 . <!DOCTYPE html> build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . build 11-Nov-2011 21:37:37 . <html>
    via by Peter Obara [Atlassian],
    • com.atlassian.confluence.upgrade.UpgradeException: com.atlassian.config.ConfigurationException: Cannot update schema at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:84) at com.atlassian.confluence.upgrade.impl.DefaultUpgradeManager.upgrade(DefaultUpgradeManager.java:139) at com.atlassian.confluence.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:28) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4205) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4704) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) at org.apache.catalina.core.StandardHost.start(StandardHost.java:840) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) 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: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:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) Caused by: com.atlassian.config.ConfigurationException: Cannot update schema at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:151) at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:134) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgradeSchema(AbstractUpgradeManager.java:158) at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:62) ... 17 more Caused by: java.sql.SQLException: ORA-00942: 테이블 또는 뷰가 존재하지 않습니다 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:194) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1000) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307) at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1814) at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1779) at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:277) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) at net.sf.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:167) at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:147) ... 20 more

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,
    tomthomastomthomas
    1 times, last one,
    tzrlktzrlk
    10 times, last one,
    treefolktreefolk
    6 times, last one,
    CafecanudoCafecanudo
    2 times, last one,
    45 more bugmates