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'

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert tip

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

Solutions on the web

via Atlassian JIRA by Peter Obara [Atlassian], 1 year ago
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'
via Atlassian JIRA by Peter Obara [Atlassian], 1 year ago
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'
via Atlassian JIRA by Benito Picarelli [Atlassian], 1 year ago
There was an error during import/export with <unknown plugin>:Error executing update for SQL statement 'ALTER TABLE "AO_60DB71_WORKINGDAYS" DROP CONSTRAINT "fk_ao_60db71_workin146243269"'
via Atlassian JIRA by Benito Picarelli, 1 year ago
There was an error during import/export with <unknown plugin>:Error executing update for SQL statement 'ALTER TABLE "AO_60DB71_WORKINGDAYS" DROP CONSTRAINT "fk_ao_60db71_workin146243269"'
via Atlassian JIRA by Benito Picarelli, 2 months ago
There was an error during import/export with <unknown plugin>:Error executing update for SQL statement 'ALTER TABLE "AO_60DB71_WORKINGDAYS" DROP CONSTRAINT "fk_ao_60db71_workin146243269"'
via Atlassian JIRA by Boris Berenberg, 1 year ago
There was an error during import/export with plugin Atlassian JIRA - Plugins - Invite User(com.atlassian.jira.jira-invite-user-plugin) #1.13 (table AO_97EDAB_USERINVITATION):Error executing update for SQL statement 'CREATE TABLE
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 com.atlassian.activeobjects.backup.SequenceUtils.executeUpdate(SequenceUtils.java:29)
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)

Users with the same issue

Once, 2 months ago
Once, 9 months ago
10 times, 9 months ago
6 times, 1 year ago
2 times, 1 year ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.