Node traversal issue while running Netcentric tool

[prajwalreddi]

Hi, we've been using Netcentric ACTool for quite some time without issues. However, we've recently started encountering a node traversal error. Upon reviewing the logs, it appears that the issue arises when the dump.yaml is triggered.

Our repository contains a significant amount of content and a large number of ACL entries, as it's used by hundreds of regions. The error we're seeing is:

GET /mnt/overlay/netcentric/actool/content/overview/content/items/actoolpanel.html/dump.yaml HTTP/1.1] org.apache.sling.engine.impl.SlingRequestProcessorImpl service: Uncaught Throwable
org.apache.jackrabbit.oak.query.RuntimeNodeTraversalException: The query read or traversed more than 100000 nodes. To avoid affecting other tasks, processing was stopped.

Following this error, custom YAML files are no longer being triggered.

Has anyone else come across a similar issue, or is there a recommended approach to address or mitigate this problem?

Thanks in advance for any guidance.

[Abhishekrajbit]

@kwin could you please help on this?

[kwin]

Please help to identify the underlying query, there is some pointers in https://experienceleague.adobe.com/en/docs/experience-manager-65/content/implementing/developing/bestpractices/troubleshooting-slow-queries. This is a community project with no support so in order to get a timely fix you would need to debug a bit on your side.