FindPaginated Search Error: Multi Domain Searches

We tried to make OpenKM as intuitive as possible, but an advice is always welcome.
Forum rules
Please, before asking something see the documentation wiki or use the search feature of the forum. And remember we don't have a crystal ball or mental readers, so if you post about an issue tell us which OpenKM are you using and also the browser and operating system version. For more info read How to Report Bugs Effectively.
Post Reply
ofstab
Junior Boarder
Junior Boarder
Posts: 37
Joined: Tue Jan 05, 2016 9:21 am

FindPaginated Search Error: Multi Domain Searches

Post by ofstab » Fri Sep 22, 2017 8:12 am

I have having problems using the findpaginated search function, either through the UI, or through the Rest service. The errors are the same.

I am doing a wildcard search on name (i.e. return all objects found) in a particular folder. I am using community 6.3.1, so recursive search is on by default.

If I search individually for documents/mails/folders, it works as expected.

If I search for all three - documents/folders/emails in one, I get the following error:

Code: Select all

2017-09-22 08:59:45,700 [http-nio-0.0.0.0-8080-exec-1] ERROR com.openkm.servlet.frontend.SearchServlet- No row with the given identifier exists: [com.openkm.dao.bean.NodeMail#f238f070-620f-4f77-9ff6-1ff4491c6c6d]
The UUID is always of a folder. I can manually delete the folder with that UUID, but then another folder in the tree produces the same error.

If I search for document/mails only (no folders), I get this error:

Code: Select all

2017-09-22 09:00:01,129 [http-nio-0.0.0.0-8080-exec-7] ERROR com.openkm.servlet.frontend.SearchServlet- maxClauseCount is set to 1024
If I search for folder/mail I get the same error as above - but only if I search for more than 10 results, or try to search for the second page of 10 results.

Very strange. I can work around this by doing three individual searches, and then combining the results, but I would like to do this in one go if possible.

jllort
Moderator
Moderator
Posts: 9692
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: FindPaginated Search Error: Multi Domain Searches

Post by jllort » Sat Sep 23, 2017 6:14 pm

maxClauseCount error comes because the query what is build based in your search contains more than 1024 clausules, that is caused because the number of subfolders into the root folder you have choosen for recursive search have more htan 1024 subfolders nodes. Take a look if exist in your configuration parameters one named "max.search.clauses" ( increase the value ). Also I suggest upgrade to 6.3.4, althought will not solve the issue always is good idea upgrade to latest OpenKM version ( follow the steps described at https://docs.openkm.com/kcenter/view/ok ... guide.html )

ofstab
Junior Boarder
Junior Boarder
Posts: 37
Joined: Tue Jan 05, 2016 9:21 am

Re: FindPaginated Search Error: Multi Domain Searches

Post by ofstab » Tue Sep 26, 2017 9:42 am

Thank you for your reply. I have an upgrade to the latest version on my to-do list!

I was trying to do something clever with my application to speed up the time it takes to load all files from a folder in OpenKM. I can have a delay of several seconds while both documents and folders were loaded. My idea was to speed up this process by searching for all files in a folder, and returning the search results paginated into sensibly sized chunks. The total time taken would be around the same, but the user would not be staring at a blank screen while the process completes.

However, I see that is not going to work due to the maxclausecount issue, unless I make that ridiculously large, which is going to cause its own problems.

I was also thinking about enforcing a max 100 files per folder rule, managed underneath the UI and invisible to the user. The problem is that if the user then logs in through the web interface rather than my app, then they will be faced with loads of auto generated folders with no idea where their stuff is.

Back to the drawing board, I think.

jllort
Moderator
Moderator
Posts: 9692
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: FindPaginated Search Error: Multi Domain Searches

Post by jllort » Wed Sep 27, 2017 2:41 pm

Your users are using OpenKM UI or are accessing with your own application and you are working with remote API access ?

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest