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

This version of SQL Prompt in ADS has expired. Please download the latest version to continue using

I use SQL Prompt in Azure Data Studio.

It has been working fine, but today I have started getting this error message:

Error formatting SQL: Error: Unhandled exception: System.Exception: This version of SQL Prompt in ADS has expired. Please download the latest version to continue using it.
   at RedGate.SqlPrompt.Format.Engine.AzureDataStudio.TimeBomb.Check() in D :\BuildAgentA\work\dc5fefc0dc183d00\Engine\Format.Engine\AzureDataStudio\TimeBomb.cs:line 13
   at RedGate.SqlPrompt.Format.Engine.AzureDataStudio.CommandLine.Commands.FormatSqlOptions.Run(String authToken, String adsStylesPath, String styleName, Boolean applyCasing) in D :\BuildAgentA\work\dc5fefc0dc183d00\Engine\Format.Engine\AzureDataStudio\CommandLine\Commands\FormatSqlCommand.cs:line 33
   at System.CommandLine.Handler.<>c__DisplayClass5_0`4.<SetHandler>b__0(InvocationContext context)
   at System.CommandLine.Invocation.AnonymousCommandHandler.Invoke(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.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.CommandLine.Builder.CommandLineBuilderExtensions.<>c__DisplayClass17_0.<<UseParseErrorReporting>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.CommandLine.Builder.CommandLineBuilderExtensions.<>c__DisplayClass12_0.<<UseHelp>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.CommandLine.Builder.CommandLineBuilderExtensions.<>c__DisplayClass22_0.<<UseVersionOption>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.CommandLine.Builder.CommandLineBuilderExtensions.<>c__DisplayClass19_0.<<UseTypoCorrections>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.CommandLine.Builder.CommandLineBuilderExtensions.<>c.<<UseSuggestDirective>b__18_0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.CommandLine.Builder.CommandLineBuilderExtensions.<>c__DisplayClass16_0.<<UseParseDirective>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.CommandLine.Builder.CommandLineBuilderExtensions.<>c.<<RegisterWithDotnetSuggest>b__5_0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.CommandLine.Builder.CommandLineBuilderExtensions.<>c__DisplayClass8_0.<<UseExceptionHandler>b__0>d.MoveNext()

Please ensure you highlighted a valid block of T-SQL.



I have downloaded and installed the latest version of the extension but the problem persists.

Is anyone else having the same problem?  Can someone please suggest a fix?
johnnythebadger
0

Comments

32 comments

Sort by
  • cfuller
    We are also having this issue with multiple users across multiple machines.
    cfuller
    0
  • JKJ
    I have same issue  :'-(



    JKJ
    0
  • saber_dad
    I'm experiencing this issue as well. has anyone found a solution?
    saber_dad
    0
  • johnnythebadger
    From looking at old release notes it looks like maybe they just need to push out the TimeBomb date. @redgate is anyone working on fixing this, please?
    johnnythebadger
    0
  • johnnythebadger
    I'm now getting a notification in ADS to upgrade the extension, but the new version isn't on the downloads page yet...

    Hopefully this means it will be fixed soon :-)
    johnnythebadger
    0
  • JKJ
    I'm now getting a notification in ADS to upgrade the extension, but the new version isn't on the downloads page yet...

    Hopefully this means it will be fixed soon :-)
    I can confirm this experience. I cannot help wondering, wether the issues has been fixed, but the link to the download is incorrect, or the file has not been published in the expected location.
    JKJ
    0
  • DomiScha
    Same Iissue. Still no answer from Redgate?
    Had to transfer from SSMS to Data Studio. Big disappointment when I realised thata sql prompt does not work properly in data studio. Please try to fix this.
    DomiScha
    0
  • DomiScha
    Same Iissue. Still no answer from Redgate?

    Had to transfer from SSMS to Data Studio. Big disappointment when I realised thata sql prompt does not work properly in data studio. Please try to fix this.
    DomiScha
    0
  • DomiScha
    Same Iissue. Still no answer from Redgate?

    Had to transfer from SSMS to Data Studio. Big disappointment when I realised thata sql prompt does not work properly in data studio. Please try to fix this.
    DomiScha
    0
  • Robyn
    Hi All, 

    Apologies for the radio silence on this one. We can see it have evidently had a wider impact in the community that support were initially exposed. 

    The development team are aware and have been working on a fix. Our understanding is this will be deployed in the next release of SQL Prompt, so watch out for this imminently.
    Robyn
    0
  • stanleyvanderstok
    Robyn said:
    Hi All, 

    Apologies for the radio silence on this one. We can see it have evidently had a wider impact in the community that support were initially exposed. 

    The development team are aware and have been working on a fix. Our understanding is this will be deployed in the next release of SQL Prompt, so watch out for this imminently. 
    Hi Robyn,

    Thanks for the update. 

    Could you also give us an estimation on when this release will be deployed? 

    Kind regards
    stanleyvanderstok
    0
  • end-user
    Would it be possible to reset and redeploy 0.2.14 until the next version is available so we can keep working?
    end-user
    0
  • IFCU_JJ
    ADS is asking me to download 0.2.15 but the file cannot be found.
    IFCU_JJ
    0
  • rodrigoreissm
    @IFCU_JJ

    The same problem here

    @Robyn

    Any solution?

    Thanks for all
    rodrigoreissm
    0
  • JamesA
    I'm getting the same experience as @IFCU_JJ

    @Robyn is there any ETA for the solution as this is impacting our ability to work efficiently

    JamesA
    0
  • TomK
    @Robyn, thanks to the team for working to restore SQL Prompt in Azure Data Studio. I'm looking forward to not having to use SSMS so much.

    TomK
    0
  • MikeB_Gordian
    I'm also having this issue with 0.2.14 being expired but 0.2.15 download page does not exist. Thanks for your attention on this matter @Robyn. Are we closer to knowing an ETA on the new release?
    MikeB_Gordian
    0
  • EricvS
    Hi, just like many others, we are waiting on the new release. Please keep us posted on any updates on the ETA, Thanks.
    EricvS
    0
  • rd_matt
    +1 to all the above.  Desperately awaiting a resolution to this, and keen to know when we'll be able to use it again @Robyn?
    rd_matt
    0
  • Robyn
    Hi All, 

    Sorry that there has been no update - we simply haven't had the information to share!

    We now know that a release will not happen before the end of the week. With the UK Bank Holiday on Monday the earliest we anticipate the release is Tuesday 27th. However, we have still not been given a firm ETA. 

    Should we get any further information, it will be shared here.
    Robyn
    0
  • end-user
    Thanks @Robyn! I think all this pressure is simply due to something that we used suddenly stopped working.  Not because it broke with an update, but rather was time-bombed to expire.  Is there a way to remove that "feature" so this doesn't happen again and the users aren't all blind-sided?
    end-user
    0
  • Robyn
    The new update is now available. You should be able to update as normal through ADS but if you cannot here is a link to the VSIX to install it from
     
    https://download.red-gate.com/EAP/SQLPromptADS/SQLPromptADS_0.2.15.0.zip

    Thank you for your patience whilst we have been waiting on this release!
    Robyn
    0
  • johnnythebadger
    @Robyn Thank you for keeping us in the loop  :)
    Looks good now
    johnnythebadger
    0
  • JKJ
    Ahh, what a relief  :D Thanks <|>
    JKJ
    0
  • BeardedFen
    Hi there. Any update on this?

    BeardedFen
    0
  • Robyn
    If you haven't already, updating SQL Prompt using the link below should fix any issues in ADS.

    https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.21.9884.exe 
    Robyn
    0
  • BeardedFen
    Thanks. Does this work for Azure Data Studio
    BeardedFen
    0
  • end-user
    @Robyn I think @BeardedFen is correct - the link you posted is SQL Prompt for SSMS.  This thread was concerned with the SQL Prompt for ADS extension.  I think the latest version is https://download.red-gate.com/EAP/SQLPromptADS/SQLPromptADS_0.2.15.0.zip
    end-user
    0
  • MikeB_Gordian
    I am now getting this same expired message with version 2.15. Is there a 2.16 to download @Robyn? I reinstalled 2.15 from vsix and still get the error.
    MikeB_Gordian
    0
  • Romy
    When using SQL Prompt, an error message is returned that the version has expired (2.15). There is just no new version to be found, so now we cannot use SQL Prompt for ADS. Can this be looked into?
    Romy
    0

Add comment

Please sign in to leave a comment.