SQL Search gives no results

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

  Don_Adams November 24, 2021 14:42

  - 0 +
• 
  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.

  Ben_P November 25, 2021 17:30

  - 0 +
• 
  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.

  Don_Adams November 26, 2021 13:44

  - 0 +
• 
  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?

  Ben_P November 29, 2021 18:45

  - 0 +
• 
  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.

  Don_Adams November 29, 2021 20:28

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

  Ben_P December 02, 2021 17:09

  - 0 +
• 
  No VPN, and the server is a virtual machine off site.

  Don_Adams December 02, 2021 17:13

  - 0 +
• 
  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?
  

  Ben_P December 07, 2021 12:19

  - 0 +
• 
  OK, that did not help.  All still the same.  Anything else?

  Don_Adams December 07, 2021 12:27

  - 0 +
• 
  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).
  

  
  
  

  Dan_J December 13, 2021 12:11

  - 0 +

Add comment

Please sign in to leave a comment.