Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.
SOLVED

Not able to Delete DAM Asset

Avatar

Level 3

We are recently migrating from AEM 6.1 to AEM 6.3.

In Production we have large DAM assets content and post migration we identified that in AEM 6.3 if you delete any single DAM assets itself it gives the exception as

The query read more than 500000 nodes in memory. To avoid running out of memory, processing was stopped.

Cannot serve request to /bin/wcmcommand in com.day.cq.wcm.core.impl.commands.WCMCommandServlet

I believe the warning / exception message is expected in case the query return more than specified thresh limit.

Is anyone encounter this issue with large DAM content  in AEM 6.3 or 6.2 ? If yes then can you please advise how it was resolved.

1 Accepted Solution

Avatar

Correct answer by
Level 3

Update on the above solution.

The deleted out of box index reappear on restart of the instance and we started noticing the issue again. After further working with Adobe support team, here is the updated solution.

Step1: open the object in crx/de : "/oak:index/ntBaseLucene/indexRules/nt:base/properties/cqLastReplicationAction"

Step2: add property "index" and set the value " {Boolean} false".

Step3: go to http://[author]:4502/libs/granite/operations/content/diagnosis/tool.html/granite_oakindexmanager

Step4: search "ntBaseLucene" and click "re-index" in the column.

Step5: wait until the re-indexing to be completed.

View solution in original post

2 Replies

Avatar

Level 3

Issue is resolved by Adobe Support Team. It is bug in AEM 6.3+ SP1 + CFP2 , instance having more DAM assets will face this issue due to wrong index value.

Problem : Asset delete causing slowness

Root cause : Cannot be efficiently handled by the ntBaseLucene index because it is (intentionally) not configured to evaluate paths constraints

Solution : Remove the 'cq:lastReplicationAction' from the Oak Index at /oak:index/ntBaseLucene (and reindex)

Avatar

Correct answer by
Level 3

Update on the above solution.

The deleted out of box index reappear on restart of the instance and we started noticing the issue again. After further working with Adobe support team, here is the updated solution.

Step1: open the object in crx/de : "/oak:index/ntBaseLucene/indexRules/nt:base/properties/cqLastReplicationAction"

Step2: add property "index" and set the value " {Boolean} false".

Step3: go to http://[author]:4502/libs/granite/operations/content/diagnosis/tool.html/granite_oakindexmanager

Step4: search "ntBaseLucene" and click "re-index" in the column.

Step5: wait until the re-indexing to be completed.