AEM OOTB Sitemap Scheduler is not generating Sitemaps
Hello,
We’re upgrading AEM Service Pack to use Sitemap feature and trying to setup a scheduler for Sitemap Generation (org.apache.sling.sitemap.impl.SitemapScheduler) but It’s not able to execute and in error.log, getting this:

org.apache.jackrabbit.oak.plugins.index.Cursors$TraversingCursor Traversed 3000 nodes with filter Filter(query=select [jcr:path], [jcr:score], * from [nt:base] as a where [sling:sitemapRoot] = true and isdescendantnode(a, '/content/we-retail/us') option(index tag [slingSitemaps]) /* xpath: /jcr:root/content/we-retail/us//*[@sling:sitemapRoot=true] option(index tag slingSitemaps) */, path=/content/we-retail/us//*, property=[:indexTag=[slingSitemaps], sling:sitemapRoot=[true]]); consider creating an index or changing the query
Since this query get's generated based on what we enter in scheduler So, not sure if we can change the query here somehow?
So, I tried indexing but still it doesn't seem to work.

Can anyone suggest what's wrong here?
Regards,
Radha