Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Query Index Missing Warning when accessing Assets Folder in AEM 6.3

Avatar

Avatar
Validate 1
Level 2
gauravs23
Level 2

Likes

7 likes

Total Posts

11 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
gauravs23
Level 2

Likes

7 likes

Total Posts

11 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile
gauravs23
Level 2

22-05-2018

We have an images folder for our project in ASSETS section, which has more than 1000 images in it. Whenever the authors access that images folder through Assets section (http://localhost:4502/assets.html/content/dam/abc/content-images), the following warning is printed in the logs, which warns about the missing index for the query that is fired when that images folder is accessed.

    *WARN* GET /assets.html/content/dam/abc/content-images HTTP/1.1] org.apache.jackrabbit.oak.spi.query.Cursors$TraversingCursor Traversed 1000 nodes with filter Filter(query=select [jcr:path], [jcr:score], * from [nt:base] as a where ischildnode(a, '/content/dam/abc/content-images') and [hidden] = 'false' union select [jcr:path], [jcr:score], * from [nt:base] as a where ischildnode(a, '/content/dam/abc/content-images') and [hidden] is null order by [jcr:created] desc /* xpath: /jcr:root/content/dam/abc/content-images/*[((@hidden = 'false' or not(@hidden)))] order by @jcr:created descending */, path=/content/dam/abc/content-images/*, property=[hidden=[false]]); consider creating an index or changing the query

We have not yet created any custom index for damAssets, as the above query is automatically fired by AEM when navigating through the Assets section and as there is no custom implementation done by us, we didn't create any index.

For analysis, I tried to run the above query and a simplified version of the above query - select [jcr:path], [jcr:score] from [nt:base] as a where ischildnode(a, '/content/dam/abc/content-images') through Explain Query tool and it mentions that no indexes were used in the query and it is a traversal query. The results are still returned with this query as well and it prints the same warning.

Has anyone else has found such warnings when navigating through assets? Looking for some help from the community here.

Replies

Avatar

Avatar
Establish
Community Manager
kautuk_sahni
Community Manager

Likes

1,127 likes

Total Posts

6,116 posts

Correct Reply

1,144 solutions
Top badges earned
Establish
Coach
Originator
Contributor 2
Contributor
View profile

Avatar
Establish
Community Manager
kautuk_sahni
Community Manager

Likes

1,127 likes

Total Posts

6,116 posts

Correct Reply

1,144 solutions
Top badges earned
Establish
Coach
Originator
Contributor 2
Contributor
View profile
kautuk_sahni
Community Manager

24-05-2018

Checking this with the team!!

Avatar

Avatar
Validate 25
Level 10
smacdonald2008
Level 10

Likes

1,406 likes

Total Posts

12,671 posts

Correct Reply

2,278 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Give back 900
Give back 600
View profile

Avatar
Validate 25
Level 10
smacdonald2008
Level 10

Likes

1,406 likes

Total Posts

12,671 posts

Correct Reply

2,278 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Give back 900
Give back 600
View profile
smacdonald2008
Level 10

24-05-2018

It certainly appears that the warning is because there is no Index here.

Avatar

Avatar
Validate 1
Level 2
gauravs23
Level 2

Likes

7 likes

Total Posts

11 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
gauravs23
Level 2

Likes

7 likes

Total Posts

11 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile
gauravs23
Level 2

24-05-2018

smacdonald2008 Yes, the warning clearly says consider creating an index. But this warning is appearing only in Author instance when accessing a particular folder in Assets and the query being printed in the warning seems to be internally fired by AEM. Ideally damAssetLucene index should take of all these index requirements where no custom development/customization has been done. What do you think?

Avatar

Avatar
Give Back
Level 1
abera
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Give Back
View profile

Avatar
Give Back
Level 1
abera
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Give Back
View profile
abera
Level 1

05-05-2020

Hi @gauravs23 , I am having the same issue. Can you please tell how you fixed this.