SQL Search gives no results

Don_Adams

I can't get SQL Search to work. I have un-installed, re-installed, downloaded the latest version (3.5.5.2703) and it won't work either.  I'm using SSMS v18.9.1, SQL Server Standard (64bit), SQL version 14.0.2037.1, and Windows Server 2019 Std.(10.0).  The database I am searching is 277,904.38 MB.

I enter text in the search field and it will index for a while and finally return no results.  Can someone help me get this app to work?

Thanks,

Don

Don_Adams

I also get this in the logs:
2021-11-24 09:06:11.924 -05:00 [Error]  [DatabaseObjectIndexer]: Exception while indexing database CSI_EGR:

Ben_P

Hi Don,

What type of objects are you searching for? Does it return 0 results no matter what you try to search?

Do you have any other tools installed into SSMS? If so please update them to the latest versions.

Don_Adams

I get 0 results for all objects.  I can search other databases individually, but as noted in my second post, the indexing fails for that database and I assume that is the problem.  It just does not tell me what the exception is.  SQL Prompt is the only other tool in SSMS.

Ben_P

Hi Don,

Can you check that you are running the latest version of SQL Prompt? The newest version can be downloaded here: 

https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.9.3.25270.exe

If you are still encountering this issue after the update can you check the Windows event viewer for any errors relating to SQL Search? 

Don_Adams

Ben,

I have downloaded and installed the latest SQL Prompt and the problem still exists.  Also, there are no Event Viewer entries for SQL Search.

Ben_P

How are you connecting to the servers in SSMS? And are you working through a VPN on any type of VM environment like Citrix? 

Don_Adams

No VPN, and the server is a virtual machine off site.

Ben_P

In case corrupted indexes are causing this, can you please first close SSMS, delete all content from the folder %LocalAppData%\Red Gate\SQLSearch 3\Indexes, and then open SSMS and try searching the database having the issue?

Don_Adams

OK, that did not help.  All still the same.  Anything else?

Dan_J

Hi @Don_Adams

Just a thought, could this possibly be a permissions issue in relation to that database?

Also to check, have you ever been able to search on the database in question? Or has it only recently stopped working?

Finally, it may be worth uninstalling SQL Search using Revo Uninstaller Free (https://www.revouninstaller.com/revo-uninstaller-free-download/) to ensure all residual files are removed, before then reinstalling SQL Search v.3.5.5 (https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.5.5.2703.exe).