Apply the latest Oak Cumulative Fix Pack for AEM 6.3.
Last updated on
16 May 2021
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
-
-
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:
-
Log in to http://aem-host:port/crx/de/index.jsp as admin.
-
Set /oak:index/ntBaseLucene/indexRules/nt:base/properties/cqLastReplicationAction/propertyIndex=false.
-
Set /oak:index/ntBaseLucene/refresh=true.
-
Click Save All.
-
If propertyIndex was already set to true, then set /oak:index/ntBaseLucene/indexRules/nt:base/properties/cqLastReplicationAction/index=false.
-
Click Save All again.
Note: There is no need to reindex after setting this property.
Adobe MAX
The Creativity Conference
Oct 14–16 Miami Beach and online
Adobe MAX
The Creativity Conference
Oct 14–16 Miami Beach and online