Search: Max clauses reached error

[openkm_user]

Hi,

I have my taxonomy in the following way,

Capture.JPG (15.95 KiB) Viewed 5745 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 5744 times

Searching,

search.JPG (17.49 KiB) Viewed 5745 times

I get this error, please help,

error.JPG (43.42 KiB) Viewed 5745 times

Thanks!

[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.

[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!

[pavila]

Which OpenKM version are you using? Can you reproduce this error in a recent night build?

Thanks.

[openkm_user]

Hi,

I am using,

Capture.JPG (24.59 KiB) Viewed 5716 times

I believe this is the latest community version.

Thanks!

[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.

[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 5709 times

Thanks!

[pavila]

I've submitted code today, please try tomorrow because the night build is build at night (as the names means )

[openkm_user]

Hi,

Thank you, I will try tomorrow, we are in different timezone, so I wasn't sure .

[openkm_user]

Hi,

I tried the last night build, it still returns same error.

My current taxonomy is,

Capture.JPG (17.83 KiB) Viewed 5702 times

Capture.JPG (35.97 KiB) Viewed 5702 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?

[pavila]

Have you increased the max.search.clauses parameter?

[openkm_user]

Works when there are less documents inside, currently path set to the folder contains almost 100,000 documents, size 3.7gb.

[openkm_user]

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?

[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.

[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!