How can we help you today? How can we help you today?
Dingbat
Activity overview Badges (0) Posts (1) Comments (7)

Comments

Sort by recent activity
That post only tells you how to restore the layout of SSMS Nevertheless, I'm up for trying anything at this point. I uninstalled, did a layout reset, reinstalled (with latest version of SQL Search), then tried a new search. Got the same error: 2022-01-27 11:51:40.169 +01:00 [Error]  [RedGate.SQLSearch.Addin.LoggingErrorHandler]: Failed to get the object hierarchyException: Exception has been thrown by the target of an invocation. / comments
  1. Community
  2. SQL Search
  3. SQL Search not jumping / scrolling down to selected table
That post only tells you how to restore the layout of SSMSNevertheless, I'm up for trying anything at this point. I uninstalled, did a layout reset, reinstalled (with latest version of SQL Search),...
0 votes
Hi, I closed SQL Manager and removed the folder. Then I started SQL Manager again, and the folder re-appeared with these files: [image] Search behaviour was the same, e.g. nothing happens on double click -- so unfortunately the problem persists The the log says: 2022-01-20 21:08:20.239 +01:00 [Error]  [RedGate.SQLSearch.Addin.LoggingErrorHandler]: Failed to get the object hierarchy / comments
  1. Community
  2. SQL Search
  3. SQL Search not jumping / scrolling down to selected table
Hi,I closed SQL Manager and removed the folder. Then I started SQL Manager again, and the folder re-appeared with these files:Search behaviour was the same, e.g. nothing happens on double click -- ...
0 votes
Database is running on one of our own servers, MS SQL Server 15.04138.2 SQL Server Authentication No cross domain / comments
  1. Community
  2. SQL Search
  3. SQL Search not jumping / scrolling down to selected table
Database is running on one of our own servers, MS SQL Server 15.04138.2SQL Server AuthenticationNo cross domain
0 votes
Downgraded then tried search. Same result, i.e. nothing happens Got this log: 2022-01-12 08:20:44.876 +01:00 [Information]  [RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper]: Usage reporting request made to https://featureusage.red-gate.com/v1/usageevents   Number of submitted usage events = 5   HTTP status code = 200 OK   Response body = 2022-01-12 08:20:46.941 +01:00 [Information]  [RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper]: Sending 1 event: [   {     "eventType": "search",     "headers": {       "productId": "sql-search",       "productVersion": "3.5.5.2703",       "eventUuid": "1d66936f-04ee-4cb9-badc-249abcd7dbb8",       "usageUserId": "70365320-15a3-44ab-971a-3e697f142674",       "sessionUuid": "d1cddd6b-cb10-4420-9b4e-9b9ef868af04",       "createdTimeUtc": "2022-01-12T07:20:43Z"     },     "payload": null   } ] 2022-01-12 08:20:47.020 +01:00 [Information]  [RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper]: Usage reporting request made to https://productusage.red-gate.com/v1/usageevents   Number of submitted usage events = 1   HTTP status code = 200 OK   Response body = 2022-01-12 08:20:48.710 +01: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-01-12 08:20:49.750 +01: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) / comments
  1. Community
  2. SQL Search
  3. SQL Search not jumping / scrolling down to selected table
Downgraded then tried search. Same result, i.e. nothing happensGot this log: 2022-01-12 08:20:44.876 +01:00 [Information]  [RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper]: Usage reporting...
0 votes
Right, here we might have something, this is in the log after I search for a table and double click it: --------------- 2021-12-15 10:44:38.836 +01:00 [Information]  [RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper]: Usage reporting request made to https://productusage.red-gate.com/v1/usageevents   Number of submitted usage events = 1   HTTP status code = 200 OK   Response body = 2021-12-15 10:44:40.456 +01: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) 2021-12-15 10:44:40.655 +01: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) 2021-12-15 10:44:43.667 +01:00 [Information]  [RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper]: Sending 1 event: [   {     "eventType": "objectexplorer.select",     "headers": {       "productId": "sql-search",       "productVersion": "3.5.5.2703",       "eventUuid": "6976af97-b541-4a22-896e-b8e05be671b9",       "usageUserId": "f2e45e47-ca9b-447f-bd66-8d9af283ecb2",       "sessionUuid": "9d841025-86c3-43d1-a1ac-8c8f8e88c116",       "createdTimeUtc": "2021-12-15T09:44:40Z"     },     "payload": {       "action": "DoubleClick"     }   } ] 2021-12-15 10:44:43.748 +01:00 [Information]  [RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper]: Usage reporting request made to https://featureusage.red-gate.com/v1/usageevents   Number of submitted usage events = 1   HTTP status code = 200 OK   Response body = --------------- Is that helpful? Also: I am running the English version of Enterprise Manager, english username for folders / comments
  1. Community
  2. SQL Search
  3. SQL Search not jumping / scrolling down to selected table
Right, here we might have something, this is in the log after I search for a table and double click it:---------------2021-12-15 10:44:38.836 +01:00 [Information]  [RedGate.SQLSearch.UsageReporting...
0 votes
No matter what is open in the object explorer -- nothing happens. E.g. I can expand the tables and go down and select "Table A". I then do a search for "Table B" and double click or use "select in object explorer", but nothing happens except the object explorer being highlighted. The selection will still be "Table A" and no scrolling / movement of the object explorer. I am connecting with SQL Server Authentication with username and password. This has been unchanged / my method of connecting in all the years I've used SQL Search -- the only change is the forementioned deletion of databases / comments
  1. Community
  2. SQL Search
  3. SQL Search not jumping / scrolling down to selected table
No matter what is open in the object explorer -- nothing happens. E.g. I can expand the tables and go down and select "Table A". I then do a search for "Table B" and double click or use "select in ...
0 votes
Unfortunately that does nothing The explorer pane is highlighted (i.e. the top row with "Object Explorer" goes from blue to yellow), but nothing is expanded or highlighted/scrolled to I'm on SQL Server Mangement Studio v18.6 by the way / comments
  1. Community
  2. SQL Search
  3. SQL Search not jumping / scrolling down to selected table
Unfortunately that does nothingThe explorer pane is highlighted (i.e. the top row with "Object Explorer" goes from blue to yellow), but nothing is expanded or highlighted/scrolled toI'm on SQL Serv...
0 votes
Total activity
9
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1