I’m having this same issue.
We are on Avid 2018.12 on shared storage and the search function is not longer working.
The issue started with the Search Error: SQL could not be executed… very long error message. I attempted a few fixes, created a new user, deleted the MCState, and deleted the Search_DB for the user that was having issues.
The error message is gone, but now whatever I search for is “No Results Found.”
Any ideas for how to proceed? Thank you.
MacOS 10.12.6, ISIS storage