-
Bug
-
Resolution: Answered
-
Low
-
3.9.0, 3.9.1, 3.10.2
-
None
-
Severity 3 - Minor
-
2
-
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
- 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.
- Stop FishEye/Crucible
- Drop the AO_A0B856_WEB_HOOK_625253910 and AO_B434B9_WEB_HOOK_ID_SEQ sequences
- Start FishEye/Crucible
