Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-32046

Active Objects failed to initalize for bundle com.atlassian.mywork.confluence-host-plugin

      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.

            [CONFSERVER-32046] Active Objects failed to initalize for bundle com.atlassian.mywork.confluence-host-plugin

            Katherine Yabut made changes -
            Workflow Original: JAC Bug Workflow v3 [ 2876536 ] New: CONFSERVER Bug Workflow v4 [ 3005343 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2804189 ] New: JAC Bug Workflow v3 [ 2876536 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow [ 2736086 ] New: JAC Bug Workflow v2 [ 2804189 ]
            Mark Hrynczak (Inactive) made changes -
            Remote Link Original: This issue links to "Page (Extranet)" [ 63640 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2395076 ] New: JAC Bug Workflow [ 2736086 ]
            Alex Yakovlev (Inactive) made changes -
            Labels Original: affects-server bugfix engine-room/architecture enterprise loyalty st10 threshold New: affects-server engine-room/architecture enterprise loyalty st10 threshold
            Alex Yakovlev (Inactive) made changes -
            Labels Original: affects-server bugfix engine-room/architecture enterprise st10 threshold New: affects-server bugfix engine-room/architecture enterprise loyalty st10 threshold
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 2290819 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2395076 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2228776 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 2290819 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2185159 ] New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2228776 ]

              ple Phong Quoc Le (Inactive)
              bgriebeler BrunaA
              Affected customers:
              12 This affects my team
              Watchers:
              22 Start watching this issue

                Created:
                Updated:
                Resolved: