SQL Prompt 10.5.x not loading in Visual Studio 2017/2019

• 
  I can confirm that if I revert to version 10.4.7, the problem goes away.

  TheoL January 06, 2021 18:43

  - 0 +
• 
  Hi Theo,
  
  The issue could be due to a different version of a dll being needed by Visual Studio and the latest SQL Prompt version.
  Could you try the following steps:
  1. Upgrade from 10.4.7 to SQL Prompt 10.5.3
  2. In Visual Studio select the option to "Disable local Application Insights for Asp .Net Core web projects"
  This can be done from : 
  “TOOLS –> Options –> Projects and Solutions –> Web Projects” and check “Disable local Application Insights for Asp.Net Core web projects.”
  
  
  
  3. Try the Format SQL
  
  Please do let us know if this does work for you.
  
  Regards,
  Sujay

  Sujay January 08, 2021 09:36

  - 0 +
• 
  Thanks for the update. I tried this, but no change. Not noted before, the SQL Prompt main menu item fails to show when opening any SQL file.  I tested on Visual Studio 2017 Enterprise 15.9.30.
  
  The full error message from ActivityLog.xml:
  
  

  Begin package load [SQLPromptPackage]
  
  SetSite failed for package [SQLPromptPackage]Source: 'RedGate.SQLPrompt.UsageReporting' Description: The type initializer for 'Microsoft.ApplicationInsights.Extensibility.TelemetryConfiguration' threw an exception. System.TypeInitializationException: The type initializer for 'Microsoft.ApplicationInsights.Extensibility.TelemetryConfiguration' threw an exception. ---> System.TypeLoadException: Could not load type 'System.Diagnostics.Activity' from assembly 'System.Diagnostics.DiagnosticSource, Version=4.0.1.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51'. at Microsoft.ApplicationInsights.Extensibility.TelemetryConfiguration.<>c.<.cctor>b__13_0() at Microsoft.ApplicationInsights.ActivityExtensions.TryRun(Action action) at Microsoft.ApplicationInsights.Extensibility.TelemetryConfiguration..cctor() --- End of inner exception stack trace --- at RedGate.SQLPrompt.UsageReporting.AppInsightsClient.GetClient() at RedGate.SQLPrompt.UsageReporting.AppInsightsClient.get_Client() at RedGate.SQLPrompt.UsageReporting.ErrorReporting.ErrorReporter.CreateExceptionReporterController(Exception e, Boolean doRateLimit, Boolean shownToUser, Boolean includeUsersEmailAddress) at RedGate.SQLPrompt.UsageReporting.ErrorReporting.ErrorReporter.ShowError(Exception exception) at RedGate.SQLPrompt.VsPackage.SQLPromptPackage.<InitializeAsync>d__2.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.VisualStudio.Shell.AsyncPackage.<>c__DisplayClass16_0.<<Microsoft-VisualStudio-Shell-Interop-IAsyncLoadablePackageInitialize-Initialize>b__1>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.VisualStudio.Threading.JoinableTask.<JoinAsync>d__78.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.VisualStudio.Services.VsTask.RethrowException(AggregateException e) at Microsoft.VisualStudio.Services.VsTask.InternalGetResult(Boolean ignoreUIThreadCheck) at Microsoft.VisualStudio.Services.VsTask.GetResult()System.TypeLoadException: Could not load type 'System.Diagnostics.Activity' from assembly 'System.Diagnostics.DiagnosticSource, Version=4.0.1.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51'. at Microsoft.ApplicationInsights.Extensibility.TelemetryConfiguration.<>c.<.cctor>b__13_0() at Microsoft.ApplicationInsights.ActivityExtensions.TryRun(Action action) at Microsoft.ApplicationInsights.Extensibility.TelemetryConfiguration..cctor()
  
  End package load [SQLPromptPackage]
  

  I have "Application Insights Tools for Visual Studio Package - 8.14.20131.1" extension installed - part of the "Developer Analytics Tools" extension from Microsoft.

  I tested both disabling and uninstalling the "Developer Analytics Tools" (and restarting), but neither of these changed the outcome.  
  

  TheoL January 08, 2021 13:33

  - 0 +
• 
  Hi Theo,
  
  Thank you for the update. I have escalated the issue to the development team along with the latest logs and that disabling the Local Application Insights did not solve the problme. I will let you know as soon as I get an update from the development team.
  
  Regards,
  Sujay

  Sujay January 12, 2021 07:12

  - 0 +
• 
  SQL Prompt 10.5.6.17542 still has not resolved the issue 

  TheoL January 26, 2021 21:14

  - 0 +
• 
  Hi Theo,
  
  The issue is not yet fixed in 10.5.6.17542. I have once again escalated this to the development team and will let you know once there is an update
  
  Regards,
  Sujay

  Sujay January 27, 2021 03:47

  - 0 +
• 
  Hi!
  Any update on this - the error still remains...
  Thanks!

  torsten.strauss February 04, 2021 19:52

  - 0 +
• 
  Hi Torsten,
  
  The issue is still being looked into by the development team. We will post here as soon as there is any update available.
  We appreciate your patience while we look into this.
  
  Regards,
  Sujay
  
  

  Sujay February 05, 2021 08:45

  - 0 +
• 
  Just tested SQL Prompt 10.6.2.
  Result:
  Visual Studio 2017: Error still present 
  Visual Studio 2019: Appears to load OK - at least enough to appear in the menu. Did not test further before reverting back  to version 10.4.7
  
  These tests are done on the same computer.

  TheoL February 16, 2021 15:09

  - 0 +
• 
  I'm also getting this issue. 
  
  Edit: More details:
  
  SQL Prompt 10.6.2.18034
  Visual Studio 2019, 16.8.5
  
  

  albert_gouws February 21, 2021 20:40

  - 0 +
• 
  Just installed the latest update and again SQL Prompt is uninstalled from VS2019 but not updated. I have to reinstall SQL Prompt then with the toolbelt
  It would be great if you can fix this - thanks!

  torsten.strauss February 23, 2021 12:07

  - 0 +
• 
  The problem is that the latest release of SQL Pormpt is not part of the SQL Toolbelt yet.
  Therefore I am back to the former version by updating and reinstalling ...
  It would be very helpful to ensure that the latest release is immediatly pushed to the SQL Toolbelt download- many thanks!

  torsten.strauss February 23, 2021 12:12

  - 0 +
• 
  @Sujay For those still affected by this issue, could you please include the link to download SQL Prompt version 10.4.7.

  TheoL February 24, 2021 22:32

  - 0 +
• 

  torsten.strauss said:

  Just installed the latest update and again SQL Prompt is uninstalled from VS2019 but not updated. I have to reinstall SQL Prompt then with the toolbelt
  It would be great if you can fix this - thanks!

  Hi Torsten,
  
  The SQL Toolbelt at https://download.red-gate.com/installers/SQLToolbelt/2021-02-23/SQLToolbelt.exe has the updated version of SQL Prompt. 
  
  Regards,
  Sujay

  Sujay February 25, 2021 01:35

  - 0 +
• 

  TheoL said:

  @Sujay For those still affected by this issue, could you please include the link to download SQL Prompt version 10.4.7.

  Hi Theo,
  
  That is a good suggestion. The 10.4.7 build is available at https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.4.7.16599.exe 
  
  Regards,
  Sujay

  Sujay February 25, 2021 01:38

  - 0 +
• 
  The issue has been fixed in SQL Prompt version 10.6.2 and later for Visual Studio 2019.
  
  For Visual Studio 2017, the development team has reviewed the issue.
  Unfortunately, on this occasion, they are unable to work on a fix for this bug.
  However, they have advised that a workaround can be used to overcome the issue.
  In Visual Studio 2017, there is a conflict with Xamarian tools, and uninstalling these helps to stop the error.
  
  Regards,
  Sujay
  

  Sujay March 05, 2021 05:21

  - 0 +
• 
  I uninstalled xamarin (which thankfully I'm not using at the moment) and SQL prompt seems to work ok for me now.

  AndyR April 09, 2021 15:02

  - 0 +

Add comment

Please sign in to leave a comment.