Details
-
Bug
-
Resolution: Not a bug
-
Low
-
3.10.3
-
None
-
None
Description
Summary
After restoring a FishEye backup to an Oracle database, the ORA-00955 error may be presented when trying to create AO tables.
Environment
- Oracle database, configured according to https://confluence.atlassian.com/fisheye/migrating-to-oracle-298976836.html
Steps to Reproduce
- Have a FishEye backup.
- Restore it pointing to an Oracle database.
Expected Results
- Migration completes succesfully and the application runs fine.
Actual Results
FishEye may fail after some time, with the following showing up in the logs:
** 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
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:
<CREATE SEQUENCE "AO_60DB71_ISSUERANKING_ID_SEQ" INCREMENT BY 1 START WITH 1 NOMAXVALUE MINVALUE 1>
- 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.
Attachments
Issue Links
- duplicates
-
FE-6465 Active object race condition in DB migration/restore (potentially to Oracle only)
- Closed
- relates to
-
JRASERVER-29155 Check for pre existing sequences when using Oracle DB
- Gathering Impact
- is caused by
-
AO-214 Loading...