Failed to Delete Error

[apatter1]

Hello, 

I'm getting the "Failed to Delete" error when I try to delete any of my Assets. I'm signed in as an Admin with all of the correct privileges. Given that I have recently migrated our content to DITA, I have recently uploaded a significant amount of DITA topics, maps, and associated graphics, we think this could be some kind of indexing error ...?

We are in AEM6.5. 

The error logs show the following:

(A) 

19.10.2023 18:10:48.666 *WARN* [65.121.242.8 [1697739047670] POST /bin/wcmcommand HTTP/1.1] org.apache.jackrabbit.oak.plugins.index.Cursors$TraversingCursor Traversed 100000 nodes with filter Filter(query=select [jcr:path], [jcr:score], * from [dam:Asset] as a where [jcr:content/contentFragment] = 'true' and contains(*, '/content/dam/common-to-all-product-families/graphics/ref-guide-cover-pages/brand/english/product.ai') and isdescendantnode(a, '/content/dam') order by [jcr:created] desc option(index tag [visualSimilaritySearch]) /* xpath: /jcr:root/content/dam//element(*, dam:Asset)[(jcr:content/@contentFragment = 'true' and jcr:contains(., '/content/dam/common-to-all-product-families/graphics/ref-guide-cover-pages/brand/english/product.ai'))] order by @jcr:created descending option (index tag visualSimilaritySearch) */ fullText="/content/dam/common-to-all-product-families/graphics/ref-guide-cover-pages/brand/english/product.ai", path=/content/dam//*, property=[:indexTag=[visualSimilaritySearch], jcr:content/contentFragment=[true]]); consider creating an index or changing the query

19.10.2023 18:10:48.674 *WARN* [65.121.242.8 [1697739047670] POST /bin/wcmcommand HTTP/1.1] org.apache.jackrabbit.oak.query.FilterIterators The query read or traversed more than 100000 nodes.

org.apache.jackrabbit.oak.query.RuntimeNodeTraversalException: The query read or traversed more than 100000 nodes. To avoid affecting other tasks, processing was stopped.

(B)

19.10.2023 18:35:01.177 *INFO* [65.121.242.8 [1697740501176] POST /bin/fmdita/query/references HTTP/1.1] com.adobe.fmdita.query.controller.ReferenceQueryController Received request to get safe delete report

19.10.2023 18:35:01.233 *WARN* [65.121.242.8 [1697740501230] POST /bin/wcmcommand HTTP/1.1] org.apache.jackrabbit.oak.plugins.index.lucene.LucenePropertyIndex This index is deprecated: /oak:index/lucene; it is used for query Filter(query=select [jcr:path], [jcr:score], * from [nt:base] as a where contains(*, '"/content/dam/common-to-all-product-families/graphics/ref-guide-cover-pages/brand/english/product.ai"') /* xpath: //*[jcr:contains(., '"/content/dam/common-to-all-product-families/graphics/ref-guide-cover-pages/brand/english/product.ai"')] */ fullText="/content/dam/common-to-all-product-families/graphics/ref-guide-cover-pages/brand/english/product.ai", path=*). Please change the query or the index definitions.

19.10.2023 18:35:01.252 *WARN* [65.121.242.8 [1697740501230] POST /bin/wcmcommand HTTP/1.1] org.apache.jackrabbit.oak.query.QueryImpl Traversal query (query without index): select [jcr:path], [jcr:score], * from [dam:Asset] as a where [jcr:content/contentFragment] = 'true' and contains(*, '/content/dam/common-to-all-product-families/graphics/ref-guide-cover-pages/brand/english/product.ai') and isdescendantnode(a, '/content/dam') order by [jcr:created] desc option(index tag [visualSimilaritySearch]) /* xpath: /jcr:root/content/dam//element(*, dam:Asset)[(jcr:content/@contentFragment = 'true' and jcr:contains(., '/content/dam/common-to-all-product-families/graphics/ref-guide-cover-pages/brand/english/product.ai'))] order by @jcr:created descending option (index tag visualSimilaritySearch) */; consider creating an index

19.10.2023 18:35:01.262 *WARN* [65.121.242.8 [1697740501230] POST /bin/wcmcommand HTTP/1.1] org.apache.jackrabbit.oak.plugins.index.Cursors$TraversingCursor Traversed 1000 nodes with filter Filter(query=select [jcr:path], [jcr:score], * from [dam:Asset] as a where [jcr:content/contentFragment] = 'true' and contains(*, '/content/dam/common-to-all-product-families/graphics/ref-guide-cover-pages/brand/english/product.ai') and isdescendantnode(a, '/content/dam') order by [jcr:created] desc option(index tag [visualSimilaritySearch]) /* xpath: /jcr:root/content/dam//element(*, dam:Asset)[(jcr:content/@contentFragment = 'true' and jcr:contains(., '/content/dam/common-to-all-product-families/graphics/ref-guide-cover-pages/brand/english/product.ai'))] order by @jcr:created descending option (index tag visualSimilaritySearch) */ fullText="/content/dam/common-to-all-product-families/graphics/ref-guide-cover-pages/brand/english/product.ai", path=/content/dam//*, property=[:indexTag=[visualSimilaritySearch], jcr:content/contentFragment=[true]]); consider creating an index or changing the query

[Saravanan_Dharmaraj · Accepted solution]

@apatter1 Its doing the traversal for the below query when you tried to delete 

select [jcr:path], [jcr:score], * from [dam:Asset] as a where [jcr:content/contentFragment] = 'true' and contains(*, '/content/dam/common-to-all-product-families/graphics/ref-guide-cover-pages/brand/english/product.ai') and isdescendantnode(a, '/content/dam') order by [jcr:created] desc option(index tag [visualSimilaritySearch]) 

Try to see the below oak:index is there already.. it should be there.. if not please update it like below and reindex it and see

I have created the above index using https://oakutils.appspot.com/generate/index 

[EstebanBustamante]

The issue seems to be that, prior to deletion, the asset is attempting to access all the "related assets." As a result, the query mentioned as (A) is being executed. However, due to the index problem, this query fails, preventing you from safely deleting the assets and leading to the error.

Most likely, resolving the query issue with the appropriate index definition will also resolve your deletion problem. Please be aware that there were some known issues related to the tag "visualSimilaritySearch" in some service packs, and a manual fix was provided. I don't know your service pack version, but this might be relevant in your case as well: https://docs.mktossl.com/docs/experience-manager-65/release-notes/service-pack/6.5.11.html?lang=en 

[kautuk_sahni]

@apatter1 Did you find the suggestions from users helpful? Please let us know if more information is required. Otherwise, please mark the answer as correct for posterity. If you have found out solution yourself, please share it with the community.