If you use moderation or approval in Clearspace or SBS, every now and then you may run into an issue with a document being inaccessible or a corrupted moderation queue. These types of issues have common causes but can have a variety of symptoms. This document will attempt to capture some of the issues that you may see. Knowing how to identify and fix these issues often involves some knowledge of the Jive database schema and SQL in general, so if you're not DB savvy you should contact your DBA.

Multiple Document versions in a 'Published' State

Symptoms: Unable to edit document because of merge conflicts. Message looks like:

Problem: There are multiple versions of the same document marked in a 'Published' state. You can identify the problem by running this query:

SELECT * FROM jivedocversion WHERE internaldocid = XXXX AND state = 'published';

Resolution: Change the older version of the document to an archived state:

UPDATE jivedocversion SET state = 'archived', status = 8 WHERE internaldocid = <XXXX> AND version = <older>

Then clear your caches.

Document is Half-Published

Symptoms: Normal users see an 'Unauthorized' message when trying to view a document they normally have permission to view. Moderators and Administrators can view the document as expected.

Problem: The document is only partially published. Run this query:

SELECT * FROM jivedocversion WHERE state = 'published' AND status = 2; 

Resolution: Change the status column to align with the state:

UPDATE jivedocversion SET status  = 2 WHERE state = 'published'; 

Then clear your caches.