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
-
-
- Closed
-
- relates to
-
-
- Gathering Impact
-
- is caused by
-
AO-214 Loading...