Query does not return newly added pages in results

Question

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.

sundarig9086821 · Accepted Answer

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.

amogh-personal · Answer

Check if there are any spaces after the template path in newly created pages or this could be an issue with indexing. So try re-indexing the cq:template property here /oak:index/cqTemplate

Thanks,
Amogh

Sign up

Login with SSO

Login to the community

Login with SSO