Oak Indexing : Traversal Warning : AEM 6.5.10

Question

We have below mentioned TRAVERSAL warn in logs, due to OOB query which generates whenever we open the DAM folder. :-

Traversed 1000 nodes with filter Filter(query=select [jcr:path], [jcr:score], * from [nt:base] as a where ischildnode(a, '/content/dam/abcFolder') and [hidden] = 'false' union select [jcr:path], [jcr:score], * from [nt:base] as a where ischildnode(a, '/content/dam/abcFolder') and [hidden] is null /* xpath: /jcr:root/content/dam/abcFolder/*[((@hidden = 'false' or not(@hidden)))] */, path=/content/dam/abcFolder/*, property=[hidden=[false]]); consider creating an index or changing the query

Also, I tried to run a simplified version of this query on Explain Query:-

select [jcr:path], [jcr:score] from [nt:base] as a where ischildnode(a, '/content/dam/abcFolder')

Result :-

No indexes were used.

This is a traversal query.

Re-indexing wont help because the query is fired on [nt:base], and not [dam:Asset], due to which OOB /oak:index/damAssetLucene, is not getting used.

Any suggestions to resolve the issue (except keeping less than 1000 files in each dam folder)

Results on Vanilla Instance :-

Query :- select [jcr:path], [jcr:score] from [nt:base] as a where ischildnode(a, '/content/dam')

Explain Query Results :-

No indexes were used.

This is a traversal query.

Raja-Karuppsamy · Accepted Answer

Hi @parakhma - We have faced the same issue in our platform when we upgraded to SP 12 from SP10 package. As this is known bug from the AEM SP12 (mentioned in the release notes).

To resolve the issue :

Option#1 - Recommended by Adobe, update the property the below under oak:index/damAssetLucene:

tag -> string -> visualSimilaritySearch (multivalue)
refresh ->boolean ->true & save the changes.

Option#2 - Increase the memory limit in the OSGi configuration (Temporary fix):

Aapche Jackrabbit Query Engine Setting service -> Add one more "0" in Memory read limit field.

Regards,

Raja

kautuk_sahni · Answer

I would recommend creating a Support Ticket for this one.

Sign up

Login with SSO

Login to the community

Login with SSO