Options

SQL Search not showing results anymore

mrnthmrnth Posts: 5 New member
in SQL Search
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.
Tagged:
· Share on Twitter

Answers

  • Options
    dkim1999dkim1999 Posts: 85 Bronze 2
    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

    · Share on Twitter
  • Options
    mrnthmrnth Posts: 5 New member
    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.
    · Share on Twitter
  • Options
    mrnthmrnth Posts: 5 New member
    Hi David,
    Just following up to see if you have any solution, thank you!
    · Share on Twitter
  • Options
    mrnthmrnth Posts: 5 New member
    Hi David,
    Just following up to see if you have any solution, thank you!
    · Share on Twitter
  • Options
    dkim1999dkim1999 Posts: 85 Bronze 2
    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
    · Share on Twitter
  • Options
    mrnthmrnth Posts: 5 New member
    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.
    · Share on Twitter
  • Options
    ATurnerATurner Posts: 188 Silver 2
    Hi mrnth

    Could you open SSMS, not connected to any database, wait a moment and then connect to it? 
    · Share on Twitter
Sign In or Register to comment.