How can we help you today? How can we help you today?

SQL Search not showing results anymore

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.
mrnth
0

Comments

7 comments

Sort by
  • 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

    dkim1999
    0
  • 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
    0
  • mrnth
    Hi David,
    Just following up to see if you have any solution, thank you!
    mrnth
    0
  • mrnth
    Hi David,
    Just following up to see if you have any solution, thank you!
    mrnth
    0
  • 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
    dkim1999
    0
  • 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.
    mrnth
    0
  • ATurner
    Hi mrnth

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

Add comment

Please sign in to leave a comment.