Failed to Delete Error | Community
Skip to main content
A
apatter1
October 19, 2023
Solved

Failed to Delete Error

  • October 19, 2023
  • 3 replies
  • 1174 views

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 @6655266: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 @6655266: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 @6655266: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
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Saravanan_Dharmaraj

@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 

 

3 replies

Saravanan_Dharmaraj
Community Advisor
Saravanan_DharmarajCommunity AdvisorAccepted solution
Community Advisor
October 19, 2023

@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
    Community Advisor and Adobe Champion
    EstebanBustamanteCommunity Advisor and Adobe Champion
    Community Advisor and Adobe Champion
    October 24, 2023

    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 

     

    Esteban Bustamante
      kautuk_sahni
      Community Manager
      kautuk_sahniCommunity Manager
      Community Manager
      October 26, 2023

      @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.

      Kautuk Sahni
      Terms & ConditionsAccessibility statement

      Loading footer...