Overview

The problem is encountered when deleting (purging) content from old migrated spaces with a large number of documents. The end-user receives the following message:
An error occurred during the community deletion. Please check the logs for more information.

Environment

Jive On-Prem version SBS 9.0.1.0.

Visible Issue or Error

The following error message is found in the logs:

2017-07-26 11:31:28,791 [TaskEngineWorker-pool-1] [::]
ERROR com.jivesoftware.community.CommunityDeleteHelper - 
An error occurred while deleting community 2112 
java.lang.Exception: There was a problem deleting communities as user 2004.

Reproduction Steps

1. Select a Space with more than 1000 documents.
2. Navigate to Admin console (Spaces > Management > Summary), select this Space, and click Delete.
3. On the following screen, verify that there are more than 1000 documents in this space, and click Delete.
   
   
   
   
4. Jive begins the purge process and displays an error.

Expected Result

• The Space should be deleted without any issues.

Actual Result

• Error on deletion
  
  

Root Cause

The root of the issue appears to be in the following module:

 com.jivesoftware.community.impl.dao.DbDocumentDAO:
126 private static final String LOAD_DOCS_FULL_PUBLISHED =
127 SELECT_DOCS_FULL +
128 "WHERE d.internalDocID IN (:documentIDs) " +
129 "AND v.state = '" + PUBLISHED.getState() + "' " +
130 "AND NOT EXISTS (SELECT 1 FROM jiveDocVersion lv WHERE lv.internalDocID
= d.internalDocID AND lv.versionID > v.versionID)";>/pre>

Resolution

Fixed in the Jive Hosted and ON-Prem version 9.0.5.0 | 1826.

Workaround

No known workaround. The user must upgrade Jive to a recent version.