Unable to Access Confluence Pages Containing Gliffy Diagrams
Problem
Unable to access Confluence Pages which contain Gliffy Diagrams. The page generates a Stack Trace Dump similar to:
Diagnosis
Diagnostic Steps
- 'SysAdmin' is able to access the pages without issues and sees a broken image
- 'SysAdmin' can edit the page and replace the broken Gliffy Diagram
- Site administrators can access the 'Edit Page' by using the URL: https://Confluence_URL/wiki/pages/editpage.action?pageId=#######, substitute ####### with the Page ID of the broken page
Cause
Identified in the database that the broken Gliffy Diagram attempts to reference an incorrect Page ID:
<ac:parameter ac:name=""pageid"">393240</ac:parameter>
Workaround
Replacing the Gliffy Diagram Macro resolves the issue
Use the URL: https://Confluence_URL/wiki/pages/editpage.action?pageId=####### to manually access 'Edit Page' for the broken page
Substitute ####### with the Page ID of the broken page
Replace the Broken Gliffy Macro
The following query will show you all Confluence Pages and their PageID (contentid) containing a Gliffy Macro:
select c.contentid, c.title, c.lastmoddate from content c, bodycontent b where c.contentid = b.contentid and c.prevver is null and b.body like '%ac:name="gliffy"%' order by lastmoddate desc;