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
  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 | 7 months ago
    java.sql.SQLException: ORA-00918: column ambiguously defined
  5. 0

    Ask Tom "inserting multiple rows: ORA-00918"

    oracle.com | 8 months 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