Hi
We are getting below error in querybuilder Api request.
<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
<html>
<head>
<title>500 The query read or traversed more than 100000 nodes. To avoid affecting other tasks, processing was
stopped.</title>
</head>
<body>
<h1>The query read or traversed more than 100000 nodes. To avoid affecting other tasks, processing was stopped.</h1>
<p>Cannot serve request to /bin/querybuilder.json on this server</p>
<hr>
<address>ApacheSling/2.6 (jetty/9.4.15.v20190215, OpenJDK 64-Bit Server VM 11.0.16, Linux
5.10.135-122.509.amzn2.x86_64 amd64)</address>
</body>
</html>
We have done some analysis and found that this issue is of “In Memory Limit” that can be configured through configMgr.
Please let us know how this limit works and what is the maximum limit we can set.
Solved! Go to Solution.
Views
Replies
Total Likes
Problem is with the query and the index for the query that you are running, before proceeding further as mentioned by @Lokesh_Vajrala try to use the explain query tool and check which part of the query is taking time, try to index those predicate filters and make sure proper types are also used in the query not the generic types like "nt:unstructured"
Hope this helps !!
@akshaybhujbale It will help if you create a new index to match the query or optimize the current query to use existing indexes. Increasing the limits may impact the system's performance negatively.
You can use the Explain Query tool to understand the query performance and Oak Index Definition Generator to generate index definition.
Problem is with the query and the index for the query that you are running, before proceeding further as mentioned by @Lokesh_Vajrala try to use the explain query tool and check which part of the query is taking time, try to index those predicate filters and make sure proper types are also used in the query not the generic types like "nt:unstructured"
Hope this helps !!
Can we setup a call to discuss more so that I will get clear idea.
Let me know if it is possible?
Views
Replies
Total Likes