Uploaded image for project: 'FishEye'
  1. FishEye
  2. FE-6189

Some AO tables are not created when migrating to Oracle database

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Low
    • Resolution: Answered
    • 3.9.0, 3.9.1, 3.10.2
    • N/A
    • None

    Description

      Summary

      FishEye/Crucible sends notification email reporting that the smart commits cannot be performed with the following content:

      FishEye could not execute the smart commit because of an unexpected error: Active Objects failed to initalize for bundle com.atlassian.fecru.plugin.commithook.fecru-webhooks-plugin
      Please manually perform the required action within Crucible.
      

      This problem is caused by the web hook related tables not being available in the database.

      The tables in question are:

      • AO_8219D4_COMMIT_HOOK_CONFIG
      • AO_A0B856_WEB_HOOK_LISTENER_AO
      • AO_B434B9_WEB_HOOK

      These tables have not been created as part of the migration to an Oracle database.
      The following sequences are present - notice the latest two being related to these tables - which seems to be preventing the tables from being created:

      SEQUENCE NUMBER INFO
      --------------------------------------------------------------------------------
      Owner: CRUCIBLE   Sequence Name: AO_2913F5_COMMENT_ISSUE_ID_SEQ
      Calculated Last Number: 21
      Increment by: 1
      Min Value:    1
      Max Value:    9999999999999999999999999999
      Cycle Flag:   NO CYCLE
      Cache Size:   CACHE 20
      Order Flag:   NO ORDER
      
      Owner: CRUCIBLE   Sequence Name: AO_38321B_CUSTOM_CO518521787
      Calculated Last Number: 21
      Increment by: 1
      Min Value:    1
      Max Value:    9999999999999999999999999999
      Cycle Flag:   NO CYCLE
      Cache Size:   CACHE 20
      Order Flag:   NO ORDER
      
      Owner: CRUCIBLE   Sequence Name: AO_A0B856_WEB_HOOK_625253910
      Calculated Last Number: 21
      Increment by: 1
      Min Value:    1
      Max Value:    9999999999999999999999999999
      Cycle Flag:   NO CYCLE
      Cache Size:   CACHE 20
      Order Flag:   NO ORDER
      
      Owner: CRUCIBLE   Sequence Name: AO_B434B9_WEB_HOOK_ID_SEQ
      Calculated Last Number: 21
      Increment by: 1
      Min Value:    1
      Max Value:    9999999999999999999999999999
      Cycle Flag:   NO CYCLE
      Cache Size:   CACHE 20
      Order Flag:   NO ORDER
      

      Environment

      • Oracle database.

      Steps to Reproduce

      1. The problem has not been reproduced yet. The causes mentioned in the summay may be leading to this condition.

      Expected Results

      The smart commit feature works as expected, and no error message is reported in the log files.

      Actual Results

      The below exception is thrown in the atlassian-fisheye-YYYY-MM-DD.log file:

      ERROR [CommitNotifier1 ] com.atlassian.fecru.plugin.commithook.internal.DefaultCommitHookManager DefaultCommitHookManager-handleCommit - Error processing commit hook Web Hooks Processor
      com.atlassian.activeobjects.internal.ActiveObjectsInitException: Active Objects failed to initalize for bundle com.atlassian.fecru.plugin.commithook.fecru-webhooks-plugin
      	at com.atlassian.activeobjects.osgi.ActiveObjectsServiceFactory$5.apply(ActiveObjectsServiceFactory.java:207)
      ...
      Caused by: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
      Database:
      	- name:Oracle
      ...
      java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
      
      	at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:52)
      Caused by: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
      

      Notes

      The smart commit feature does not need to be enabled for this problem to occur.

      Workaround

      Always back up your database before performing any modification to the database. If possible, try your modifications on a test server.

      1. Stop FishEye/Crucible
      2. Drop the AO_A0B856_WEB_HOOK_625253910 and AO_B434B9_WEB_HOOK_ID_SEQ sequences
      3. Start FishEye/Crucible

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              grefosco Gustavo Refosco (Inactive)
              Votes:
              3 Vote for this issue
              Watchers:
              12 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: