Query does not return newly added pages in results

Avatar

Avatar
Validate 1
Level 2
sundarig9086821
Level 2

Likes

10 likes

Total Posts

28 posts

Correct reply

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

Avatar
Validate 1
Level 2
sundarig9086821
Level 2

Likes

10 likes

Total Posts

28 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
sundarig9086821
Level 2

25-01-2020

Hi,

 

In one of the AEM instance, we face an issue with query results.

Forex: 

if my query is ---- select * from nt:unstructured where cq:template = '/apps/projectname/templatepath' and jcr:path like '/content/projectname/%'

it returns a set of pages which matching template.

However, newly added pages of that template are not returned as part of the query result.

NOTE: This occurs only in one instance, not in other (which is exact clone of -- not working AEM instance).

What might be the cause of missing new pages in query results?

arunpatidar26, Ratna Kumar, smacdonald2008

JaideepBrar

Thanks,
Sundari.

View Entire Topic

Avatar

Avatar
Validate 1
Level 2
sundarig9086821
Level 2

Likes

10 likes

Total Posts

28 posts

Correct reply

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

Avatar
Validate 1
Level 2
sundarig9086821
Level 2

Likes

10 likes

Total Posts

28 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
sundarig9086821
Level 2

27-01-2020

Hi,

The issue resolved when we checked ntbaselucene index(which showed in execution plan while executing query), which had a property "corrupt".

Hence we removed ntbaselucene and installed the correct one from other instance.

Then the query result worked fine as expected.