Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-60007

Oracle Driver 12.1.0.2.0 throws errors in the logs

XMLWordPrintable

      Current Problem

      When installing JIRA Software with Oracle while using the driver version 12.1.0.2.0 / 12.2.0.1.0, the following error message is thrown during JIRA's start up:

      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)
      
      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
      

      Workaround

      Install the 12.1.0.1.0 Oracle driver instead (it can be downloaded from here). To install it, copy the driver to your JIRA_INSTALL/lib/ folder and remove the current 12.1.0.2.0 driver.

              Unassigned Unassigned
              bpicarelli Benito Picarelli
              Votes:
              20 Vote for this issue
              Watchers:
              31 Start watching this issue

                Created:
                Updated: