Expand my Community achievements bar.

DAM Index not working

Avatar

Level 1

we're using AEM 6.1 and tyring to query all the properties from the metadata node under dam:Asset.so we created an index using the below link

http://aempodcast.com/2016/aem-resources/indexing-properties-nodes-aem-6-0-6-1/#.Wa6kkFWGPIU 

but we keep on getting a warning message in the log, and query itself takes a long time to run.

Warning Message:*WARN* [JobHandler: /etc/workflow/instances/server0/2017-09-05/report_17:/content/dam/XYZ] org.apache.jackrabbit.oak.spi.query.Cursors$TraversingCursor Traversed 71000 nodes with filter Filter(query=SELECT * FROM [nt:unstructured] AS metadatas WHERE ISDESCENDANTNODE(metadatas,'/content/dam/XYZ') and NAME() like '%metadata%', path=/content/dam/XYZ//*, property=[:localname=[(%metadata%..]]); consider creating an index or changing the query

Is there anything else we need to do?

3 Replies

Avatar

Level 10

Watch this GEMS session - it was done by AEM ENg: Oak Lucene Indexes

Avatar

Level 1

we wanted to index all properties of metadata node

so we've done as per page 16 in the pdf in that link

but we are still seeing the error

Avatar

Level 10

If you are following what was shown in the GEMS session and its not working - could be a bug somewhere - please log a support ticket so Eng can fix it.