SQL Search not showing results anymore

mrnth

I have been using SQL search for the past 2 days and it suddenly stopped returning any results. It did work before it stopped. Any assistance is appreciated, thank you!

Below is the error found in the log file:

2022-07-13 12:56:08.393 -05:00 [Information]  [RedGate.SQLSearch.Addin.Connect]: Checking for updates to SQL Search

2022-07-13 12:56:08.551 -05:00 [Information]  [RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper]: The reporting of usage events to the product stream is enabled

2022-07-13 12:56:08.563 -05:00 [Information]  [RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper]: The reporting of usage events to the feature stream is enabled

2022-07-13 12:56:08.738 -05:00 [Error]  [RedGate.SQLSearch.Addin.LoggingErrorHandler]: Failed to get the object hierarchy

Exception: Exception has been thrown by the target of an invocation.

   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)

   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

   at RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer.RootNode(String connectionString, IErrorHandler errorHandler)
.
.
.

2022-07-13 12:57:00.099 -05:00 [Information]  [DatabaseObjectStorage]: Inserting objects into index

2022-07-13 12:57:00.549 -05:00 [Information]  [DatabaseObjectStorage]: Inserting job steps into index

2022-07-13 12:57:00.613 -05:00 [Error]  [ServerObjectIndexer]: Exception while indexing server: 

2022-07-13 12:57:32.002 -05:00 [Information]  [DatabaseObjectStorage]: Done objects

2022-07-13 12:57:32.003 -05:00 [Information]  [DatabaseObjectStorage]: Inserting columns into index

2022-07-13 12:58:02.056 -05:00 [Error]  [DatabaseObjectIndexer]: Exception while indexing database *databasename*: 

2022-07-13 12:58:02.275 -05:00 [Error]  [RedGate.SQLSearch.Addin.LoggingErrorHandler]: Failed to get the object hierarchy

Exception: Exception has been thrown by the target of an invocation.

dkim1999

Hi there,

Thank you for reaching out and I apologize that you are running into issues with SQL Search.

What version of SSMS and SQL Search are you using? Also, are you attempting to connect to an Azure database?  Are you using SQL or Windows Authentication?

Thank you!

David Kim

Prod

mrnth

Hi David,
Thank you for responding. Here is the info:-

SQL Server Management Studio: 15.0.18390.0

SQL Search version: 3.5.5.2703
Yes, I'm connecting to an Azure database using SQL server authentication.

mrnth

Hi David,
Just following up to see if you have any solution, thank you!

mrnth

Hi David,
Just following up to see if you have any solution, thank you!

dkim1999

Hi there,

I apologize for the delay in response.

Usually this error occurs if you are using Azure AD authentication, however, since you are using Azure SQL Server authentication, I am not too sure.

Can you try reinstalling the program to see if that helps? Something may have gone corrupted.

Kind Regards,

David Kim

Product Support Engineer

mrnth

Hi David,
Thank you for getting back to me. I reinstalled the program but the issue persists. Tried various solutions online but in vain. I updated my SQL version to 18.12. I'm not sure what I can do to get it to work.

ATurner

Hi mrnth

Could you open SSMS, not connected to any database, wait a moment and then connect to it?