com.atlassian.activeobjects.spi.ActiveObjectsImportExportException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • h3. Current Problem When installing JIRA Software with Oracle while using the driver version 12.1.0.2.0, the following error message is thrown during JIRA's start up: {noformat} 2016-02-26 17:28:26,706 active-objects-init-JiraTenantImpl{id='system'}-0 ERROR anonymous 1047x3x1 1wpfrxf 127.0.0.1 /secure/SetupDatabase!default.jspa [n.java.ao.sql] Exception executing SQL update <CREATE SEQUENCE "AO_550953_SHORTCUT_ID_SEQ" INCREMENT BY 1 START WITH 1 NOMAXVALUE MINVALUE 1> java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)   at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)   at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)   at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)   at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)   at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)   at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:30)   at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:931) {noformat} {noformat} 2016-01-19 09:55:58,586 http-bio-7800-exec-8 ERROR anonymous 595x3x1 18rs8ap 129.6.84.31 /secure/SetupDatabase!default.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Error importing data: com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: 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"' com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: 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"' at com.atlassian.activeobjects.backup.ImportExportErrorServiceImpl.newImportExportSqlException(ImportExportErrorServiceImpl.java:26) at com.atlassian.activeobjects.backup.SqlUtils.onSqlException(SqlUtils.java:46) at com.atlassian.activeobjects.backup.SqlUtils.executeUpdate(SqlUtils.java:37) at com.atlassian.activeobjects.backup.ActiveObjectsDatabaseCleaner.doCleanup(ActiveObjectsDatabaseCleaner.java:67) at com.atlassian.activeobjects.backup.ActiveObjectsDatabaseCleaner.cleanup(ActiveObjectsDatabaseCleaner.java:45) at com.atlassian.activeobjects.backup.ActiveObjectsBackup.clear(ActiveObjectsBackup.java:160) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.removeActiveObjects(DefaultDataImportService.java:958) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:679) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:312) at com.atlassian.jira.startup.DatabaseInitialImporter.importInitialData(DatabaseInitialImporter.java:56) at com.atlassian.jira.startup.DatabaseInitialImporter.importInitialData(DatabaseInitialImporter.java:48) at com.atlassian.jira.web.action.setup.SetupDatabase.doDefault(SetupDatabase.java:141) ... 3 filtered at java.lang.reflect.Method.invoke(Method.java:497) at webwork.util.InjectionUtils$DefaultInjectionImpl.invoke(InjectionUtils.java:70) at webwork.util.InjectionUtils.invoke(InjectionUtils.java:56) ... 2 filtered at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:63) ... 7 filtered at javax.servlet.http.HttpServlet.service(HttpServlet.java:725) ... 50 filtered at com.atlassian.greenhopper.jira.filters.ClassicBoardRouter.doFilter(ClassicBoardRouter.java:59) ... 151 filtered at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLException: ORA-02443: Cannot drop constraint - nonexistent constraint {noformat} h3. Workaround Install the 12.1.0.1.0 Oracle driver instead (it can be downloaded from [here|http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html]). To install it, copy the driver to your {{JIRA_INSTALL/lib/}} folder and remove the current 12.1.0.2.0 driver.
    via by Benito Picarelli [Atlassian],
  • h3. Current Problem When installing JIRA Software with Oracle while using the driver version 12.1.0.2.0, the following error message is thrown during JIRA's start up: {noformat} 2016-02-26 17:28:26,706 active-objects-init-JiraTenantImpl{id='system'}-0 ERROR anonymous 1047x3x1 1wpfrxf 127.0.0.1 /secure/SetupDatabase!default.jspa [n.java.ao.sql] Exception executing SQL update <CREATE SEQUENCE "AO_550953_SHORTCUT_ID_SEQ" INCREMENT BY 1 START WITH 1 NOMAXVALUE MINVALUE 1> java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)   at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)   at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)   at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)   at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)   at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)   at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:30)   at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:931) {noformat} {noformat} 2016-01-19 09:55:58,586 http-bio-7800-exec-8 ERROR anonymous 595x3x1 18rs8ap 129.6.84.31 /secure/SetupDatabase!default.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Error importing data: com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: 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"' com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: 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"' at com.atlassian.activeobjects.backup.ImportExportErrorServiceImpl.newImportExportSqlException(ImportExportErrorServiceImpl.java:26) at com.atlassian.activeobjects.backup.SqlUtils.onSqlException(SqlUtils.java:46) at com.atlassian.activeobjects.backup.SqlUtils.executeUpdate(SqlUtils.java:37) at com.atlassian.activeobjects.backup.ActiveObjectsDatabaseCleaner.doCleanup(ActiveObjectsDatabaseCleaner.java:67) at com.atlassian.activeobjects.backup.ActiveObjectsDatabaseCleaner.cleanup(ActiveObjectsDatabaseCleaner.java:45) at com.atlassian.activeobjects.backup.ActiveObjectsBackup.clear(ActiveObjectsBackup.java:160) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.removeActiveObjects(DefaultDataImportService.java:958) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:679) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:312) at com.atlassian.jira.startup.DatabaseInitialImporter.importInitialData(DatabaseInitialImporter.java:56) at com.atlassian.jira.startup.DatabaseInitialImporter.importInitialData(DatabaseInitialImporter.java:48) at com.atlassian.jira.web.action.setup.SetupDatabase.doDefault(SetupDatabase.java:141) ... 3 filtered at java.lang.reflect.Method.invoke(Method.java:497) at webwork.util.InjectionUtils$DefaultInjectionImpl.invoke(InjectionUtils.java:70) at webwork.util.InjectionUtils.invoke(InjectionUtils.java:56) ... 2 filtered at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:63) ... 7 filtered at javax.servlet.http.HttpServlet.service(HttpServlet.java:725) ... 50 filtered at com.atlassian.greenhopper.jira.filters.ClassicBoardRouter.doFilter(ClassicBoardRouter.java:59) ... 151 filtered at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLException: ORA-02443: Cannot drop constraint - nonexistent constraint {noformat} h3. Workaround Install the 12.1.0.1.0 Oracle driver instead (it can be downloaded from [here|http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html]). To install it, copy the driver to your {{JIRA_INSTALL/lib/}} folder and remove the current 12.1.0.2.0 driver.
    via by Benito Picarelli,
  • h3. Summary After restoring a FishEye backup to an Oracle database, the ORA-00955 error may be presented when trying to create AO tables. h3. Environment * Oracle database, configured according to [https://confluence.atlassian.com/fisheye/migrating-to-oracle-298976836.html] h3. Steps to Reproduce # Have a FishEye backup. # Restore it pointing to an Oracle database. h3. Expected Results * Migration completes succesfully and the application runs fine. h3. Actual Results FishEye may fail after some time, with the following showing up in the logs: {noformat} ** Creating table 'AO_2913F5_COMMENT_ISSUE' ERROR: problem running command java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at com.cenqua.fisheye.FishEyeCtl.mainImpl(FishEyeCtl.java:101) at com.cenqua.fisheye.FishEyeCtl.main(FishEyeCtl.java:44) Caused by: com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin Inline Issue Creation Plugin for Crucible(com.atlassian.crucible.plugins.jira-ril) #3.5.5-raabb646 (table AO_2913F5_COMMENT_ISSUE):Error executing update for SQL statement 'CREATE SEQUENCE "AO_2913F5_COMMENT_ISSUE_ID_SEQ" INCREMENT BY 1 START WITH 1 NOMAXVALUE MINVALUE 1' at com.atlassian.activeobjects.backup.ImportExportErrorServiceImpl.newImportExportSqlException(ImportExportErrorServiceImpl.java:30) at com.atlassian.activeobjects.backup.SqlUtils.onSqlException(SqlUtils.java:53) at com.atlassian.activeobjects.backup.SqlUtils.executeUpdate(SqlUtils.java:42) at com.atlassian.activeobjects.backup.ActiveObjectsTableCreator.create(ActiveObjectsTableCreator.java:84) at com.atlassian.activeobjects.backup.ActiveObjectsTableCreator.create(ActiveObjectsTableCreator.java:62) at com.atlassian.dbexporter.importer.TableDefinitionImporter.doImportNode(TableDefinitionImporter.java:50) at com.atlassian.dbexporter.importer.AbstractImporter.importNode(AbstractImporter.java:49) at com.atlassian.dbexporter.DbImporter.importData(DbImporter.java:73) at com.atlassian.activeobjects.backup.ActiveObjectsBackup.restore(ActiveObjectsBackup.java:158) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at com.atlassian.applinks.host.OsgiServiceProxyFactory$DynamicServiceInvocationHandler.invoke(OsgiServiceProxyFactory.java:111) at com.sun.proxy.$Proxy27.restore(Unknown Source) at com.atlassian.crucible.migration.item.ActiveObjectsBackup$ActiveObjectsRestorer.restore(ActiveObjectsBackup.java:122) at com.cenqua.fisheye.ctl.Restore.run(Restore.java:197) at com.cenqua.fisheye.ctl.Restore.main(Restore.java:273) ... 6 more Caused by: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object {noformat} h3.Workaround # Identify the sequence that is causing the error - this can be done by reviewing the error in the logs. You may find the problematic sequence as follows: {noformat} <CREATE SEQUENCE "AO_60DB71_ISSUERANKING_ID_SEQ" INCREMENT BY 1 START WITH 1 NOMAXVALUE MINVALUE 1> {noformat} # Stop FishEye/Crucible. # Have your Oracle DBA deleting the existing sequence. # Start FishEye/Crucible. *Note*: the process above may need to be repeated further times if FishEye presents errors for other sequences. It should seize failing again after all the problematic sequences have been deleted.
    via by Gustavo Refosco [Atlassian],
  • h3. Summary After restoring a FishEye backup to an Oracle database, the ORA-00955 error may be presented when trying to create AO tables. h3. Environment * Oracle database, configured according to [https://confluence.atlassian.com/fisheye/migrating-to-oracle-298976836.html] h3. Steps to Reproduce # Have a FishEye backup. # Restore it pointing to an Oracle database. h3. Expected Results * Migration completes succesfully and the application runs fine. h3. Actual Results FishEye may fail after some time, with the following showing up in the logs: {noformat} ** Creating table 'AO_2913F5_COMMENT_ISSUE' ERROR: problem running command java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at com.cenqua.fisheye.FishEyeCtl.mainImpl(FishEyeCtl.java:101) at com.cenqua.fisheye.FishEyeCtl.main(FishEyeCtl.java:44) Caused by: com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin Inline Issue Creation Plugin for Crucible(com.atlassian.crucible.plugins.jira-ril) #3.5.5-raabb646 (table AO_2913F5_COMMENT_ISSUE):Error executing update for SQL statement 'CREATE SEQUENCE "AO_2913F5_COMMENT_ISSUE_ID_SEQ" INCREMENT BY 1 START WITH 1 NOMAXVALUE MINVALUE 1' at com.atlassian.activeobjects.backup.ImportExportErrorServiceImpl.newImportExportSqlException(ImportExportErrorServiceImpl.java:30) at com.atlassian.activeobjects.backup.SqlUtils.onSqlException(SqlUtils.java:53) at com.atlassian.activeobjects.backup.SqlUtils.executeUpdate(SqlUtils.java:42) at com.atlassian.activeobjects.backup.ActiveObjectsTableCreator.create(ActiveObjectsTableCreator.java:84) at com.atlassian.activeobjects.backup.ActiveObjectsTableCreator.create(ActiveObjectsTableCreator.java:62) at com.atlassian.dbexporter.importer.TableDefinitionImporter.doImportNode(TableDefinitionImporter.java:50) at com.atlassian.dbexporter.importer.AbstractImporter.importNode(AbstractImporter.java:49) at com.atlassian.dbexporter.DbImporter.importData(DbImporter.java:73) at com.atlassian.activeobjects.backup.ActiveObjectsBackup.restore(ActiveObjectsBackup.java:158) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at com.atlassian.applinks.host.OsgiServiceProxyFactory$DynamicServiceInvocationHandler.invoke(OsgiServiceProxyFactory.java:111) at com.sun.proxy.$Proxy27.restore(Unknown Source) at com.atlassian.crucible.migration.item.ActiveObjectsBackup$ActiveObjectsRestorer.restore(ActiveObjectsBackup.java:122) at com.cenqua.fisheye.ctl.Restore.run(Restore.java:197) at com.cenqua.fisheye.ctl.Restore.main(Restore.java:273) ... 6 more Caused by: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object {noformat} h3.Workaround # Identify the sequence that is causing the error - this can be done by reviewing the error in the logs. You may find the problematic sequence as follows: {noformat} <CREATE SEQUENCE "AO_60DB71_ISSUERANKING_ID_SEQ" INCREMENT BY 1 START WITH 1 NOMAXVALUE MINVALUE 1> {noformat} # Stop FishEye/Crucible. # Have your Oracle DBA deleting the existing sequence. # Start FishEye/Crucible. *Note*: the process above may need to be repeated further times if FishEye presents errors for other sequences. It should seize failing again after all the problematic sequences have been deleted.
    via by Gustavo Refosco [Atlassian],
    • com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: 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"' at com.atlassian.activeobjects.backup.ImportExportErrorServiceImpl.newImportExportSqlException(ImportExportErrorServiceImpl.java:26) at com.atlassian.activeobjects.backup.SqlUtils.onSqlException(SqlUtils.java:46) at com.atlassian.activeobjects.backup.SqlUtils.executeUpdate(SqlUtils.java:37) at com.atlassian.activeobjects.backup.ActiveObjectsDatabaseCleaner.doCleanup(ActiveObjectsDatabaseCleaner.java:67) at com.atlassian.activeobjects.backup.ActiveObjectsDatabaseCleaner.cleanup(ActiveObjectsDatabaseCleaner.java:45) at com.atlassian.activeobjects.backup.ActiveObjectsBackup.clear(ActiveObjectsBackup.java:160) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.removeActiveObjects(DefaultDataImportService.java:958) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:679) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:312) at com.atlassian.jira.startup.DatabaseInitialImporter.importInitialData(DatabaseInitialImporter.java:56) at com.atlassian.jira.startup.DatabaseInitialImporter.importInitialData(DatabaseInitialImporter.java:48) at com.atlassian.jira.web.action.setup.SetupDatabase.doDefault(SetupDatabase.java:141)
    No Bugmate found.