nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Draft Page Unavailable and Issues Error

Joseph Schwartz

We've been using Confluence for a month on the Starter Licence, version 6.11 (self-hosted server). I clicked on the link for the Draft page for the first time and got an error instead of the page. The key part of the error states:

The body of this ContentEntityObject ('Redacted Page Name') was 'BodyType:XHTML' but was expected to be 'BodyType:RAW'.

The page referenced does not exist or has been renamed.

Below is the full error, Any assistance in gaining access to our drafts page would be greatly appreciated.

FULL TEXT OF ERROR

org.apache.velocity.exception.MethodInvocationException: Invocation of method 'getBodyAsString' in class com.atlassian.confluence.content.CustomContentEntityObject threw exception java.lang.UnsupportedOperationException: The body of this ContentEntityObject ('Redacted Page Name') was 'BodyType:XHTML' but was expected to be 'BodyType:RAW' at /users/viewmydrafts.vm[line 47, column 29]
at org.apache.velocity.runtime.parser.node.ASTIdentifier.execute(ASTIdentifier.java:223)

caused by: java.lang.UnsupportedOperationException: The body of this ContentEntityObject ('Redacted Page Name') was 'BodyType:XHTML' but was expected to be 'BodyType:RAW'
at com.atlassian.confluence.core.ContentEntityObject.getBodyContent(ContentEntityObject.java:290)

Accepted answers

Joseph Schwartz

The issue with the trial installation of the Questions for Confluence add-in breaking the Drafts functionality was resolved by Atlassian support. This is a back end solution using SQL:

Disable the Questions for Confluence add-in
Shut down Confluence
Backup the database

Update the status to 'deleted' in SQL (this doesn't remove them from the DB):

update content set content_status = 'deleted' where contentid in (select c.contentid from content c where pluginkey='com.atlassian.confluence.plugins.confluence-questions:answer-draft');
update content set content_status = 'deleted' where contentid in (select c.contentid from content c where pluginkey='com.atlassian.confluence.plugins.confluence-questions:question-draft');

Clear the plugin cache
Restart Confluence

Thanks to all who helped me through this!

All comments

Shannon S

Hi Joe,

Did you have Confluence Questions installed at one point? It appears that could cause the issue:

CONFSERVER-56058 Disabling Questions plugin breaks drafts page

Workaround options

First option: Disabling collaborative editing, user should be able to navigate to drafts page normally.
Second option: Re-enabling question plugin then clear drafts.

Let me know if you have any questions!

Regards,

Shannon

Joseph Schwartz

Hi Shannon,

Thanks so much for your reply. We had Questions for Confluence installed under a trial licence, and subsequently uninstalled the add-on. I disabled the Confluence Collaborative Editor Plugin, but the error remained.

We have a SQL database storing the data for Confluence over here and I can see the record in the dbo.CONTENT table that contains the reference to the entry causing the error message. Can I delete this record -- or is there a SQL command I can run -- to fix this issue via the data layer? Barring that, is there a way to obtain a second trial licence (the original expired) so I can re-install Questions for Confluence, delete the drafts, and then remove the plugin? (That way I'd be able to retain both drafts and Collaborative Editing.)

Any further assistance you could provide would be greatly appreciated.

Cheers,

Joe

Shannon S

Hi Joe,

There's a 3rd option we're exploring regarding removing relevant entries in the database. We haven't yet confirmed the exact deletion query but the following will get you a list of entries related to Confluence Questions:

select *
from content
inner join bodycontent on content.contentid = bodycontent.contentid
where content.contenttype = 'CUSTOM' AND content.pluginkey = 'com.atlassian.confluence.plugins.confluence-questions:answer-draft';

In the meantime, you could review this article for information on clearing stale drafts, and perhaps can get it to work for your instance?

Keep an eye on the bug ticket as I've asked for an update there about the query that will help clear CQ drafts.

Regards,

Shannon

Joseph Schwartz

Hi Shannon,

The needed to change the pluginkey for your query to

dbo.CONTENT.PLUGINKEY = 'com.atlassian.confluence.plugins.confluence-questions:question-draft'

as the offending SQL entry is a question-draft, not an answer-draft.

I tried a few things, but was reluctant to run the entire series of deletes you provided without knowing the Confluence data structure better and understanding what the ramifications of running all those deletes might be.

Does Atlassian have a data schema diagram/notes it can provide? If not, I will have to wait for the bug fix.

Thanks.

Joseph Schwartz

The issue with the trial installation of the Questions for Confluence add-in breaking the Drafts functionality was resolved by Atlassian support. This is a back end solution using SQL:

Disable the Questions for Confluence add-in
Shut down Confluence
Backup the database

Update the status to 'deleted' in SQL (this doesn't remove them from the DB):

update content set content_status = 'deleted' where contentid in (select c.contentid from content c where pluginkey='com.atlassian.confluence.plugins.confluence-questions:answer-draft');
update content set content_status = 'deleted' where contentid in (select c.contentid from content c where pluginkey='com.atlassian.confluence.plugins.confluence-questions:question-draft');

Clear the plugin cache
Restart Confluence

Thanks to all who helped me through this!

Hua Soon SIM [Akeles]

One method to fix the issue from the UI is to delete all the questions found at

http://<confluence-base-url>/questions

When the question is being deleted, all the comments and drafts related to that question will also be deleted.

This may be an easier for those who are evaluating and only has a few questions added and also don't need to stop Confluence for database updates.

Can refer to https://jira.atlassian.com/browse/CONFSERVER-55067 for more background.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server