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

Confluence Sidebar is blank and Space Tools is missing on some instances

XMLWordPrintable

      NOTE: This bug report is for Confluence Server. Using Confluence Cloud? See the corresponding bug report.

      Summary

      When you access a Space, the sidebar is blank and Space Tools is missing.

      This message is seen in the logs

      2017-02-01 11:31:42,989 ERROR [ajp-nio-8009-exec-121] [plugin.descriptor.web.ConfluenceWebInterfaceManager] getHtml Failed to render web panel: com.atlassian.plugin.web.descriptors.DefaultWebPanelModuleDescriptor$ContextAwareWebPanel@40857e64
 -- url: /display/KEY/Page | page: 4260294 | traceId: 5589811101dedf7a | userName: username | referer: https://confluence.company.com/spacedirectory/view.action | action: viewpage
java.lang.RuntimeException: Entities can only be used with a single EntityManager instance

      Environment

      Confluence 1000.27.0

      Steps to Reproduce

      1. Be on a instance with duplicate entry in AO_187CCC_SIDEBAR_LINK table (unknown how to reproduce this step)
      2. Access a Space
      3. The sidebar is showing blank and Space Tools is missing

      Expected Results

      • Confluence Sidebar and Space Tools should be visible

      Actual Results

      • Confluence Sidebar is blank and Space Tools is missing

      Resolution

      1. Verify if there is a Duplicate Entry in "AO_187CCC_SIDEBAR_LINK" 
        select * from "AO_187CCC_SIDEBAR_LINK" where "CATEGORY" = 'ADVANCED' AND "SPACE_KEY"='{SPACEKEY}';
        select * from "AO_187CCC_SIDEBAR_LINK" where "CATEGORY" = 'MAIN' AND "SPACE_KEY"='{SPACEKEY}';
      2. Once duplicate entry is identified, delete the duplicate entry by running the command: 
        delete from "AO_187CCC_SIDEBAR_LINK" where "ID" = {ID of the duplicate entry};
      3. Flush cache

      Note: Don't forget to backup the database

        1. AO_187CCC_SIDEBAR_LINK table screenshot.png
          AO_187CCC_SIDEBAR_LINK table screenshot.png
          22 kB
        2. screenshot-1.png
          screenshot-1.png
          22 kB

            [CONFSERVER-41425] Confluence Sidebar is blank and Space Tools is missing on some instances

            Katherine Yabut made changes -
            Workflow Original: JAC Bug Workflow v3 [ 2878945 ] New: CONFSERVER Bug Workflow v4 [ 3002802 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2787776 ] New: JAC Bug Workflow v3 [ 2878945 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow [ 2728856 ] New: JAC Bug Workflow v2 [ 2787776 ]
            Owen made changes -
            Symptom Severity Original: Critical [ 14430 ] New: Severity 1 - Critical [ 15830 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2380457 ] New: JAC Bug Workflow [ 2728856 ]
            Rachel Robins made changes -
            Fix Version/s Original: 1000.139.0 [ 62300 ]
            Fix Version/s Original: 1000.140.0 [ 62301 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 2266255 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2380457 ]
            Michael Andreacchio made changes -
            UIS Original: 10
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2223139 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 2266255 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2173586 ] New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2223139 ]

              cvolzke@atlassian.com Clinton Volzke (Inactive)
              jalor Janice Alor (Inactive)
              Affected customers:
              2 This affects my team
              Watchers:
              21 Start watching this issue

                Created:
                Updated:
                Resolved: