Asset deletion hangs and takes more than a minute | AEM 6.3

Search
Experience Manager User Guide

On this page

Applies to: Experience Manager

某些 Creative Cloud 应用程序、服务和功能在中国不可用。

When deleting assets in the /assets.html Touch UI, the UI hangs and takes more than a minute to complete the operation.

Environment

AEM 6.3

Cause

This is a known product bug, GRANITE-18998, the cause is that the query limit is hit when executing this query:

SELECT * FROM [nt:base] WHERE (ISSAMENODE('/content/dam/adobe-test/jpg3186.jpg') OR ISDESCENDANTNODE('/content/dam/adobe-test/jpg3186.jpg')) AND [cq:lastReplicationAction] = 'Activate'

Resolution

  1. Apply the latest Oak Cumulative Fix Pack for AEM 6.3.

  2. Add this JVM parameter to the CQ_JVM_OPTS variable in the AEM crx-quickstart/bin/start script:

    -Doak.lucene.useActualEntryCount=true

Or if you are not able to apply the Oak fix, as workaround:

  1. Log in to http://aem-host:port/crx/de/index.jsp as admin.

  2. Set /oak:index/ntBaseLucene/indexRules/nt:base/properties/cqLastReplicationAction/propertyIndex=false.

  3. Set /oak:index/ntBaseLucene/refresh=true.

  4. Click Save All.

  5. If propertyIndex was already set to true, then set /oak:index/ntBaseLucene/indexRules/nt:base/properties/cqLastReplicationAction/index=false.

  6. Click Save All again.

Note:  There is no need to reindex after setting this property.