While using ACS Audit log search getting java.lang.UnsupportedOperationException: The query read or traversed more than 300000 ... processing was stopped.

Avatar

Avatar
Validate 1
MVP
Umesh_Thakur
MVP

Likes

147 likes

Total Posts

161 posts

Correct reply

53 solutions
Top badges earned
Validate 1
Applaud 25
Ignite 3
Ignite 1
Give Back 5
View profile

Avatar
Validate 1
MVP
Umesh_Thakur
MVP

Likes

147 likes

Total Posts

161 posts

Correct reply

53 solutions
Top badges earned
Validate 1
Applaud 25
Ignite 3
Ignite 1
Give Back 5
View profile
Umesh_Thakur
MVP

30-09-2020

Dear Members,

I am using audit log search in on of my environment but due to "

java.lang.UnsupportedOperationException: The query read or traversed more than 300000 nodes. To avoid affecting other tasks, processing was stopped.

" it is not working even with the path where, there in no activation or any kind of modification has had happened.

To Resolve the issue I have purged the page audit log several time with the Minimum age at 1 and I also checked with In Memory Read Limit of Oak Query Engine config with maximum(600000) but nothing worked for me.

I was referring below guide 

https://helpx.adobe.com/experience-manager/6-3/sites/developing/using/troubleshooting-slow-queries.h...

Is anyone is having any idea what can be causing the issue and what can be the solution for it.

Please revert.

Thanks

Umesh Thakur

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Coach
Employee
Jörg_Hoh
Employee

Likes

1,135 likes

Total Posts

3,167 posts

Correct reply

1,080 solutions
Top badges earned
Coach
Give back 600
Ignite 5
Ignite 3
Ignite 1
View profile

Avatar
Coach
Employee
Jörg_Hoh
Employee

Likes

1,135 likes

Total Posts

3,167 posts

Correct reply

1,080 solutions
Top badges earned
Coach
Give back 600
Ignite 5
Ignite 3
Ignite 1
View profile
Jörg_Hoh
Employee

01-10-2020

Are you using the Audit Log functionality of ACS AEM Commons? In that case you should raise a ticket there.

It seems that the query you are doing is not covered by any index, and to preserve the performance of the instance, the query is terminated after 300k nodes have been traversed.

Answers (0)