java.lang.reflect.InvocationTargetException

Atlassian JIRA | Gustavo Refosco [Atlassian] | 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. Summary After restoring a FishEye backup to an Oracle database, the ORA-00955 error may be presented when trying to create AO tables. h3. Environment * Oracle database, configured according to [https://confluence.atlassian.com/fisheye/migrating-to-oracle-298976836.html] h3. Steps to Reproduce # Have a FishEye backup. # Restore it pointing to an Oracle database. h3. Expected Results * Migration completes succesfully and the application runs fine. h3. Actual Results FishEye may fail after some time, with the following showing up in the logs: {noformat} ** 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 {noformat} h3.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: {noformat} <CREATE SEQUENCE "AO_60DB71_ISSUERANKING_ID_SEQ" INCREMENT BY 1 START WITH 1 NOMAXVALUE MINVALUE 1> {noformat} # 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.

    Atlassian JIRA | 1 year ago | Gustavo Refosco [Atlassian]
    java.lang.reflect.InvocationTargetException
  2. 0

    h3. Summary After restoring a FishEye backup to an Oracle database, the ORA-00955 error may be presented when trying to create AO tables. h3. Environment * Oracle database, configured according to [https://confluence.atlassian.com/fisheye/migrating-to-oracle-298976836.html] h3. Steps to Reproduce # Have a FishEye backup. # Restore it pointing to an Oracle database. h3. Expected Results * Migration completes succesfully and the application runs fine. h3. Actual Results FishEye may fail after some time, with the following showing up in the logs: {noformat} ** 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 {noformat} h3.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: {noformat} <CREATE SEQUENCE "AO_60DB71_ISSUERANKING_ID_SEQ" INCREMENT BY 1 START WITH 1 NOMAXVALUE MINVALUE 1> {noformat} # 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.

    Atlassian JIRA | 1 year ago | Gustavo Refosco [Atlassian]
    java.lang.reflect.InvocationTargetException

    Root Cause Analysis

    1. 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()
    2. com.atlassian.activeobjects
      ActiveObjectsTableCreator.create
      1. com.atlassian.activeobjects.backup.ImportExportErrorServiceImpl.newImportExportSqlException(ImportExportErrorServiceImpl.java:30)
      2. com.atlassian.activeobjects.backup.SqlUtils.onSqlException(SqlUtils.java:53)
      3. com.atlassian.activeobjects.backup.SqlUtils.executeUpdate(SqlUtils.java:42)
      4. com.atlassian.activeobjects.backup.ActiveObjectsTableCreator.create(ActiveObjectsTableCreator.java:84)
      5. com.atlassian.activeobjects.backup.ActiveObjectsTableCreator.create(ActiveObjectsTableCreator.java:62)
      5 frames
    3. com.atlassian.dbexporter
      DbImporter.importData
      1. com.atlassian.dbexporter.importer.TableDefinitionImporter.doImportNode(TableDefinitionImporter.java:50)
      2. com.atlassian.dbexporter.importer.AbstractImporter.importNode(AbstractImporter.java:49)
      3. com.atlassian.dbexporter.DbImporter.importData(DbImporter.java:73)
      3 frames
    4. com.atlassian.activeobjects
      ActiveObjectsBackup.restore
      1. com.atlassian.activeobjects.backup.ActiveObjectsBackup.restore(ActiveObjectsBackup.java:158)
      1 frame
    5. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:497)
      4 frames
    6. com.atlassian.applinks
      OsgiServiceProxyFactory$DynamicServiceInvocationHandler.invoke
      1. com.atlassian.applinks.host.OsgiServiceProxyFactory$DynamicServiceInvocationHandler.invoke(OsgiServiceProxyFactory.java:111)
      1 frame
    7. com.sun.proxy
      $Proxy27.restore
      1. com.sun.proxy.$Proxy27.restore(Unknown Source)
      1 frame
    8. com.atlassian.crucible
      ActiveObjectsBackup$ActiveObjectsRestorer.restore
      1. com.atlassian.crucible.migration.item.ActiveObjectsBackup$ActiveObjectsRestorer.restore(ActiveObjectsBackup.java:122)
      1 frame
    9. com.cenqua.fisheye
      Restore.main
      1. com.cenqua.fisheye.ctl.Restore.run(Restore.java:197)
      2. com.cenqua.fisheye.ctl.Restore.main(Restore.java:273)
      2 frames
    10. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:497)
      4 frames
    11. com.cenqua.fisheye
      FishEyeCtl.main
      1. com.cenqua.fisheye.FishEyeCtl.mainImpl(FishEyeCtl.java:101)
      2. com.cenqua.fisheye.FishEyeCtl.main(FishEyeCtl.java:44)
      2 frames