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'

Samebug tips1

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


rafaelrafael

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web516

  • via Unknown by Peter Obara [Atlassian],
  • via Unknown by Peter Obara [Atlassian],
  • Stack trace

    • 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' at com.atlassian.activeobjects.backup.ImportExportErrorServiceImpl.newImportExportSqlException(ImportExportErrorServiceImpl.java:32) at com.atlassian.activeobjects.backup.SequenceUtils.executeUpdate(SequenceUtils.java:33) at com.atlassian.activeobjects.backup.SequenceUtils.executeUpdate(SequenceUtils.java:43) at com.atlassian.activeobjects.backup.OracleSequencesAroundImporter.dropSequence(OracleSequencesAroundImporter.java:115) at com.atlassian.activeobjects.backup.OracleSequencesAroundImporter.dropAllSequences(OracleSequencesAroundImporter.java:100) at com.atlassian.activeobjects.backup.OracleSequencesAroundImporter.doBefore(OracleSequencesAroundImporter.java:61) at com.atlassian.activeobjects.backup.OracleSequencesAroundImporter.before(OracleSequencesAroundImporter.java:39) at com.atlassian.dbexporter.importer.AbstractImporter.importNode(AbstractImporter.java:46) at com.atlassian.dbexporter.DbImporter.importData(DbImporter.java:73) at com.atlassian.activeobjects.backup.ActiveObjectsBackup.restore(ActiveObjectsBackup.java:155) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.restoreActiveObjects(DefaultDataImportService.java:347) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:479) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:209) at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:65) at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:28) at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:147) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at com.atlassian.multitenant.impl.DefaultMultiTenantManager.runForTenant(DefaultMultiTenantManager.java:61) at com.atlassian.multitenant.juc.MultiTenantExecutors$WrappedRunnable.run(MultiTenantExecutors.java:160) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) Caused by: java.sql.SQLException: ORA-00972: identifier is too long 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.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196) at com.atlassian.activeobjects.backup.SequenceUtils.executeUpdate(SequenceUtils.java:29) ... 24 more

    Write tip

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

    Users with the same issue

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