-
Bug
-
Resolution: Unresolved
-
Low
-
None
-
7.0.5, 7.0.10
-
7
-
93
-
Severity 3 - Minor
-
3
-
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.
- is related to
-
JRASERVER-61007 AO sequences are missing in XML backups created using the Oracle JDBC driver 12.1.0.2
- Closed
-
SIN-355 Loading...
- relates to
-
JRASERVER-60604 Jira throws protocol violation error when reindexing due to outdated Oracle driver
- Closed
-
AO-707 Loading...