Details
-
Bug
-
Resolution: Fixed
-
High
-
5.3, 5.4
-
None
Description
Problem:
Confluence stops working;
These are the messages found on the logs:
2013-12-09 09:20:30,155 ERROR [http-8090-35] [mywork.host.rest.ExceptionLogger] toResponse Exception thrown from resource -- url: /confluence/rest/mywork/latest/status/notification/count | userName: bjaison | referer: http://agile.ironmountain.com/confluence/pages/viewpage.action?spaceKey=rc&title=Calendar com.atlassian.activeobjects.internal.ActiveObjectsInitException: Active Objects failed to initalize for bundle com.atlassian.mywork.confluence-host-plugin
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONFLUENCE53A.U_AO_9412A1_AOUSER_USERNAME) violated
Workaround 1:
Disable the bundled plugin: Workbox - Host Plugin.
Workaround 2:
1. Shutdown Confluence
2. Backup your Confluence database
3. Run the following SQL queries on your Confluence database:
\\ This will remove the oauth dances your users have done with other external applications eg JIRA, and will mean your users will need to re-authenticate with those systems over oauth delete from AO_9412A1_USER_APP_LINK; \\ This will remove task order and whether notifications have been read or not delete from AO_9412A1_AOUSER;
4. Clear the plugin cache
5. Restart Confluence
Deleting the content of these two tables only removes the data mentioned above, and does not remove any actual Workbox entries, so this is a relatively low impact workaround for those who wish to keep the Workbox functionality.
