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