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'

Atlassian JIRA | Peter Obara [Atlassian] | 5 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    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>

    Atlassian JIRA | 5 years ago | Peter Obara [Atlassian]
    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'
  2. 0

    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>

    Atlassian JIRA | 5 years ago | Peter Obara [Atlassian]
    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'
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Ask Tom "inserting multiple rows: ORA-00918"

    oracle.com | 10 months ago
    java.sql.SQLException: ORA-00918: column ambiguously defined
  5. 0

    Ask Tom "inserting multiple rows: ORA-00918"

    oracle.com | 1 year ago
    java.sql.SQLException: ORA-00918: column ambiguously defined

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      ORA-00972: identifier is too long

      at oracle.jdbc.driver.T4CTTIoer.processError()
    2. Oracle jdbc
      OracleStatementWrapper.executeUpdate
      1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
      3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
      4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
      5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
      6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
      7. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:194)
      8. oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1000)
      9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
      10. oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1814)
      11. oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1779)
      12. oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:277)
      12 frames
    3. Commons DBCP
      DelegatingStatement.executeUpdate
      1. org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196)
      1 frame
    4. com.atlassian.activeobjects
      OracleSequencesAroundImporter.before
      1. com.atlassian.activeobjects.backup.SequenceUtils.executeUpdate(SequenceUtils.java:29)
      2. com.atlassian.activeobjects.backup.SequenceUtils.executeUpdate(SequenceUtils.java:43)
      3. com.atlassian.activeobjects.backup.OracleSequencesAroundImporter.dropSequence(OracleSequencesAroundImporter.java:115)
      4. com.atlassian.activeobjects.backup.OracleSequencesAroundImporter.dropAllSequences(OracleSequencesAroundImporter.java:100)
      5. com.atlassian.activeobjects.backup.OracleSequencesAroundImporter.doBefore(OracleSequencesAroundImporter.java:61)
      6. com.atlassian.activeobjects.backup.OracleSequencesAroundImporter.before(OracleSequencesAroundImporter.java:39)
      6 frames
    5. com.atlassian.dbexporter
      DbImporter.importData
      1. com.atlassian.dbexporter.importer.AbstractImporter.importNode(AbstractImporter.java:46)
      2. com.atlassian.dbexporter.DbImporter.importData(DbImporter.java:73)
      2 frames
    6. com.atlassian.activeobjects
      ActiveObjectsBackup.restore
      1. com.atlassian.activeobjects.backup.ActiveObjectsBackup.restore(ActiveObjectsBackup.java:155)
      1 frame
    7. com.atlassian.jira
      ImportTaskManagerImpl$TaskCallableDecorator.call
      1. com.atlassian.jira.bc.dataimport.DefaultDataImportService.restoreActiveObjects(DefaultDataImportService.java:347)
      2. com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:479)
      3. com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:209)
      4. com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:65)
      5. com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:28)
      6. com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:147)
      6 frames
    8. Java RT
      FutureTask.run
      1. java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      2. java.util.concurrent.FutureTask.run(FutureTask.java:138)
      3. java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
      4. java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      5. java.util.concurrent.FutureTask.run(FutureTask.java:138)
      5 frames
    9. com.atlassian.multitenant
      MultiTenantExecutors$WrappedRunnable.run
      1. com.atlassian.multitenant.impl.DefaultMultiTenantManager.runForTenant(DefaultMultiTenantManager.java:61)
      2. com.atlassian.multitenant.juc.MultiTenantExecutors$WrappedRunnable.run(MultiTenantExecutors.java:160)
      2 frames
    10. Java RT
      Thread.run
      1. java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
      2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
      3. java.lang.Thread.run(Thread.java:662)
      3 frames