-
Bug
-
Resolution: Fixed
-
High
-
6.0, 1000.15.0, 5.10.8
-
17
-
Severity 1 - Critical
-
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
- Be on a instance with duplicate entry in AO_187CCC_SIDEBAR_LINK table (unknown how to reproduce this step)
- Access a Space
- 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
- 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}';
- 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};
- Flush cache
Note: Don't forget to backup the database
- causes
-
-
- Closed
-
- duplicates
-
-
- Closed
-
- relates to
-
-
- Closed
-
| Form Name | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
[CONFSERVER-41425] Confluence Sidebar is blank and Space Tools is missing on some instances
Glad it worked for you. I totally forgot about this until your comment came in and curiosity overtook me.
Cheers,
Jon
itpartners@samsonpost.ru
added a comment - Thank you , Jon, for sharing your solution.
Just solved similar issue with "sidebar disappearance"
itpartners@samsonpost.ru
added a comment - Thank you , Jon, for sharing your solution.
Just solved similar issue with "sidebar disappearance" To answer my own comment, I just deleted the two duplicate keys directly on a wild hunch and the sidebar is all fixed.
I chose randomly (assumed the newer ones were wrong) and got lucky.
Going to wait for the official fix as it would appear this bug has a fix under review currently for the production environment.
I just used the below to remove the duplicates:
delete from AO_187CCC_SIDEBAR_LINK where ID=112
delete from AO_187CCC_SIDEBAR_LINK where ID=113
Cheers,
Jon
Is there any chance this is the issue I am experiencing?
https://answers.atlassian.com/questions/39145492/default-theme-issue-in-confluence-5.10.0-from-confluence-5.4.0-on-one-space.-missing-sidebar
A fix for this issue is now available for Confluence Server customers.
Upgrade now or check out the Release Notes to see what other issues are resolved.