Not able to Delete DAM Asset

Question

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.

Mahamood · Accepted Answer

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_oakindexmanagerStep4: search "ntBaseLucene" and click "re-index" in the column.Step5: wait until the re-indexing to be completed.

Mahamood · Answer

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)

Cadastre-se

Fazer o login com rede social

Bem-vindo

Fazer o login com rede social

Verificando arquivo em busca de vírus

Este arquivo não pode ser baixado