Adobe Experience Manager Assets

aemuser2021 · 4/26/23

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

diksha_mishra · 4/26/23

You need to perform this on the authoring instance, something like http://localhost:4502/system/console/slingjsp

http://localhost:4502/libs/granite/ui/content/dumplibs.rebuild.html

Help doc:

https://helpx.adobe.com/experience-manager/kb/How-to-force-a-recompilation-of-all-Sling-scripts-jsps...

If the issue still persists, please raise a support ticket with Adobe, supplying full error logs, screenshots etc.

View solution in original post

diksha_mishra · 4/26/23

@aemuser2021 Can you please share the AEM version along with the Service pack?

In general, you can try the below steps:

1. Recompile Libraries:

http://[host]:[port]/system/console/slingjsp

2. Reindex the lucene index using CRXDE

Go to this path /oak:index/damAssetLucene and Change the reindex property to true by default it will be false only.
Save the changes
Re-indexing will be triggered immediately

3. Restart the instance

Let me know how it goes.

aemuser2021 · 4/26/23

Hi @diksha_mishra ,

1. This URL is not working for me to recompile the libraries: http://localhost:4503/system/console/slingjsp

2. I've tried this to reindex/oak:index/damAssetLucene and also restarted the instance but still facing the same issue.

I'm using AEM 6.5, Service Pack : 6.5.15