How can we help you today? How can we help you today?
dbabler
Activity overview Badges (0) Posts (0) Comments (2)

Comments

Sort by recent activity
TomW said: Hi @RajivYanamandra Sorry you're having trouble with our ADS extension. This issue isn't something we've seen before. Could you try moving the snippets to a different location and seeing if the extension can access them there? This should tell us whether it's a general issue or specific to the location you're trying to use. Thanks, Tom Hey Tom I just wanted to make sure you saw that others are having this issue.  I posted screenshots above.  Is there any update on this? / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt cannot access SSMS snippets folder in Azure Data studio
TomW said: Hi @RajivYanamandra Sorry you're having trouble with our ADS extension. This issue isn't something we've seen before. Could you try moving the snippets to a different location and ...
0 votes
I am having the same issue it happens mostly, but not always, when I have to run Azure Data Studio in Administrative Mode (which I usually have to).  Failed to import snippets from SSMS: Error: Unhandled exception: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Text.Json.JsonException: The JSON value could not be converted to System.String. Path: $.CheckComments.body | LineNumber: 3 | BytePositionInLine: 65. at System.Text.Json.ThrowHelper.ThrowJsonException_DeserializeUnableToConvertValue(Type propertyType) at System.Text.Json.JsonPropertyInfo.Read(JsonTokenType tokenType, ReadStack& state, Utf8JsonReader& reader) at System.Text.Json.JsonSerializer.ReadCore(JsonSerializerOptions options, Utf8JsonReader& reader, ReadStack& readStack) at System.Text.Json.JsonSerializer.ReadCore(Type returnType, JsonSerializerOptions options, Utf8JsonReader& reader) at System.Text.Json.JsonSerializer.Deserialize(String json, Type returnType, JsonSerializerOptions options) at System.Text.Json.JsonSerializer.Deserialize[TValue](String json, JsonSerializerOptions options) at RedGate.SqlPrompt.SnippetConverter.Ads.AdsSnippetSerializer.Deserialize(Stream stream) in [image] \BuildAgentB\work\dc5fefc0dc183d00\SnippetConverter\Ads\AdsSnippetSerializer.cs:line 47 at RedGate.SqlPrompt.SnippetConverter.Ads.AdsSnippets.Load(String snippetsFile) in [image] \BuildAgentB\work\dc5fefc0dc183d00\SnippetConverter\Ads\AdsSnippets.cs:line 17 at RedGate.SqlPrompt.SnippetConverter.SsmsToAdsSnippetConverter.Convert(String ssmsSnippetsFolder, String adsSnippetsFile) in [image] \BuildAgentB\work\dc5fefc0dc183d00\SnippetConverter\SsmsToAdsSnippetConverter.cs:line 25 at RedGate.SqlPrompt.SnippetConverter.Program.Run(Logger logger, Options options) in [image] \BuildAgentB\work\dc5fefc0dc183d00\SnippetConverter\Program.cs:line 79 at RedGate.SqlPrompt.SnippetConverter.Program.<>c__DisplayClass1_0.<Main>b__0(Options options) in [image] \BuildAgentB\work\dc5fefc0dc183d00\SnippetConverter\Program.cs:line 34 --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor, Boolean wrapExceptions) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.Delegate.DynamicInvokeImpl(Object[] args) at System.Delegate.DynamicInvoke(Object[] args) at System.CommandLine.Invocation.ModelBindingCommandHandler.InvokeAsync(InvocationContext context) at System.CommandLine.Invocation.InvocationPipeline.<>c__DisplayClass4_0.<<BuildInvocationChain>b__0>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.CommandLine.Builder.CommandLineBuilderExtensions.<>c__DisplayClass23_0.<<UseParseErrorReporting>b__0>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.CommandLine.Builder.CommandLineBuilderExtensions.<>c__DisplayClass16_0.<<UseHelp>b__0>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.CommandLine.Builder.CommandLineBuilderExtensions.<>c__DisplayClass27_0.<<UseVersionOption>b__1>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.CommandLine.Builder.CommandLineBuilderExtensions.<>c__DisplayClass25_0.<<UseTypoCorrections>b__0>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.CommandLine.Builder.CommandLineBuilderExtensions.<>c.<<UseSuggestDirective>b__24_0>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.CommandLine.Builder.CommandLineBuilderExtensions.<>c__DisplayClass22_0.<<UseParseDirective>b__0>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.CommandLine.Builder.CommandLineBuilderExtensions.<>c__DisplayClass11_0.<<UseDebugDirective>b__0>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.CommandLine.Builder.CommandLineBuilderExtensions.<>c.<<RegisterWithDotnetSuggest>b__10_0>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.CommandLine.Builder.CommandLineBuilderExtensions.<>c__DisplayClass14_0.<<UseExceptionHandler>b__0>d.MoveNext() [image] / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt cannot access SSMS snippets folder in Azure Data studio
I am having the same issue it happens mostly, but not always, when I have to run Azure Data Studio in Administrative Mode (which I usually have to).  Failed to import snippets from SSMS: Error: Unh...
0 votes
Total activity
3
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1