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"'

Atlassian JIRA | Benito Picarelli | 1 year ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    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.

    Atlassian JIRA | 1 year ago | Benito Picarelli [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"'
  2. 0

    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.

    Atlassian JIRA | 1 year ago | Benito Picarelli
    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"'

    Root Cause Analysis

    1. 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()
    2. com.atlassian.activeobjects
      ActiveObjectsBackup.clear
      1. com.atlassian.activeobjects.backup.ImportExportErrorServiceImpl.newImportExportSqlException(ImportExportErrorServiceImpl.java:26)
      2. com.atlassian.activeobjects.backup.SqlUtils.onSqlException(SqlUtils.java:46)
      3. com.atlassian.activeobjects.backup.SqlUtils.executeUpdate(SqlUtils.java:37)
      4. com.atlassian.activeobjects.backup.ActiveObjectsDatabaseCleaner.doCleanup(ActiveObjectsDatabaseCleaner.java:67)
      5. com.atlassian.activeobjects.backup.ActiveObjectsDatabaseCleaner.cleanup(ActiveObjectsDatabaseCleaner.java:45)
      6. com.atlassian.activeobjects.backup.ActiveObjectsBackup.clear(ActiveObjectsBackup.java:160)
      6 frames
    3. com.atlassian.jira
      SetupDatabase.doDefault
      1. com.atlassian.jira.bc.dataimport.DefaultDataImportService.removeActiveObjects(DefaultDataImportService.java:958)
      2. com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:679)
      3. com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:312)
      4. com.atlassian.jira.startup.DatabaseInitialImporter.importInitialData(DatabaseInitialImporter.java:56)
      5. com.atlassian.jira.startup.DatabaseInitialImporter.importInitialData(DatabaseInitialImporter.java:48)
      6. com.atlassian.jira.web.action.setup.SetupDatabase.doDefault(SetupDatabase.java:141)
      6 frames