AEM Query not showing correct results after service pack upgrade to 6.5.12

[girishb83316758]

Hi Team,

After upgrading AEM service pack (from 6.5.6 to 6.5.12) we are not get correct search results from Query Builder.

I am running the below query to get all the 'RUNNING' workflows from AEM

http://localhost:4502/bin/querybuilder.json?path=/var/workflow/instances&1_property=modelId&1_proper...

Before(AEM 6.5.6) the upgrade we use to get the results. Post upgrading service pack to 6.5.12 I'm getting results as 0.

Unable to see any errors in com.day.cq.search log file.

Anyone any idea why results might not be coming after upgradation.?

Thanks,

[Saravanan_Dharmaraj]

@girishb83316758 I see typo and camelCase mismatch in the query. I just the ran the below query similar to yours it works fine. Bold ones are wrong in your query. 

path=/var/workflow/instances
1_property=modelId
1_property.value=/var/workflow/models/<MODELID>
2_property=status
2_property.value=RUNNING
3_property=jcr:primaryType
3_property.value=cq:Workflow
orderby=path

[girishb83316758]

Hi,

Thank you for the response.Query is correct. While I'm trying in this post it is typo..

[pulkitvashisth · Accepted solution]

Hi @girishb83316758 
Have you tried reindexing the relevant oak indexes after the service pack upgrade?
https://blogs.perficient.com/2017/04/19/rebuild-indexes-in-aem-with-oak-index-manager/
Also check if the modelId you are using exists now after the upgrade.

[girishb83316758]

Thank you for the response.

After reindexing query works correctly.