Page 1 of 2
Search: Max clauses reached error
PostPosted:Tue Feb 23, 2016 11:53 am
by openkm_user
Hi,
I have my taxonomy in the following way,
Capture.JPG (15.95 KiB) Viewed 6580 times
I am trying to search
1018755685 folder inside
Portfolios folder, so used advanced search giving path /okm:root/Portfolios.
advanced.JPG (19.1 KiB) Viewed 6579 times
Searching,
search.JPG (17.49 KiB) Viewed 6580 times
I get this error, please help,
error.JPG (43.42 KiB) Viewed 6580 times
Thanks!
Re: Search: Max clauses reached error
PostPosted:Wed Feb 24, 2016 12:20 pm
by jllort
The problem in this case is filtering by folder. The search internally creates so much clauses. You can increase it from administration with the parameter named max.search.clauses. Anyway I suggest do not filtering by path. And if you are looking for documents do not check folder or reverse.
Re: Search: Max clauses reached error
PostPosted:Thu Feb 25, 2016 11:39 am
by openkm_user
Hi,
Thanks for the reply. I am not sure how should we work with max.search.clauses, tried it in Administration->Configuration->Added new property, doesn't seem to work.
For filtering with path, I am searching for folder (also unchecked documents in advanced search) which should return that folder and documents inside it. Path is necessary because there can be other folder with same name in other path also.
Please help!
Re: Search: Max clauses reached error
PostPosted:Tue Mar 01, 2016 4:03 pm
by pavila
Which OpenKM version are you using? Can you reproduce this error in a recent night build?
Thanks.
Re: Search: Max clauses reached error
PostPosted:Wed Mar 02, 2016 5:47 pm
by openkm_user
Hi,
I am using,
Capture.JPG (24.59 KiB) Viewed 6551 times
I believe this is the latest community version.
Thanks!
Re: Search: Max clauses reached error
PostPosted:Thu Mar 03, 2016 9:49 am
by pavila
Yes, this is the last stable community release but I was asking to the night build from
http://integration.openkm.com/6.3/ because this is the last development version and some issues are already fixed there.
Re: Search: Max clauses reached error
PostPosted:Thu Mar 03, 2016 1:25 pm
by openkm_user
Hi,
Thank you for the response. I tried with latest night build also, it still shows same error. Searches for a long time and returns this error (steps are exactly like I mentioned in my first post).
Capture.JPG (23.6 KiB) Viewed 6544 times
Thanks!
Re: Search: Max clauses reached error
PostPosted:Thu Mar 03, 2016 5:02 pm
by pavila
I've submitted code today, please try tomorrow because the night build is build at night (as the names means

)
Re: Search: Max clauses reached error
PostPosted:Thu Mar 03, 2016 5:36 pm
by openkm_user
Hi,
Thank you, I will try tomorrow, we are in different timezone, so I wasn't sure

.
Re: Search: Max clauses reached error
PostPosted:Fri Mar 04, 2016 9:52 am
by openkm_user
Hi,
I tried the last night build, it still returns same error.
My current taxonomy is,
Capture.JPG (17.83 KiB) Viewed 6537 times
Capture.JPG (35.97 KiB) Viewed 6537 times
In advanced search folder path if I give
/okm:root/Portfolios, it doesn't work, but
/okm:root
/okm:root/Portfolios/CRM039
/okm:root/Portfolios/CRM039/CRM039_1
all these paths works fine.
What could be the problem?
Re: Search: Max clauses reached error
PostPosted:Fri Mar 04, 2016 9:56 am
by pavila
Have you increased the max.search.clauses parameter?
Re: Search: Max clauses reached error
PostPosted:Fri Mar 04, 2016 12:20 pm
by openkm_user
Works when there are less documents inside, currently path set to the folder contains almost 100,000 documents, size 3.7gb.
Re: Search: Max clauses reached error
PostPosted:Fri Mar 04, 2016 2:40 pm
by openkm_user
pavila wrote:Have you increased the max.search.clauses parameter?
Default is 1024, I changed it to 2048, search is slow but it works. Can you please explain more about this parameter?
Re: Search: Max clauses reached error
PostPosted:Fri Mar 04, 2016 3:15 pm
by pavila
Well, it depends on the number of children folders: the more children folder, the higher the number should be. All these folders are used to generate the Lucene query. In short, its better to use medatada to filter results that the folder itself.
Regards.
Re: Search: Max clauses reached error
PostPosted:Fri Mar 04, 2016 3:29 pm
by openkm_user
Thank you very much for the response, can you suggest a best way to automate metadata tagging to folder for my taxonomy?
Thanks in advance!