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

johnnythebadger

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?

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!

cfuller

We are also having this issue with multiple users across multiple machines.

JKJ

I have same issue 

saber_dad

I'm experiencing this issue as well. has anyone found a solution?

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

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 :-)

JKJ

johnnythebadger said:

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.

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

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

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.

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. 

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

end-user

Would it be possible to reset and redeploy 0.2.14 until the next version is available so we can keep working?

IFCU_JJ

ADS is asking me to download 0.2.15 but the file cannot be found.

rodrigoreissm

@IFCU_JJ

The same problem here

@Robyn

Any solution?

Thanks for all

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

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.

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?

EricvS

Hi, just like many others, we are waiting on the new release. Please keep us posted on any updates on the ETA, Thanks.

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?

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. 

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?

johnnythebadger

@Robyn Thank you for keeping us in the loop 
Looks good now 

JKJ

Ahh, what a relief  Thanks

BeardedFen

Hi there. Any update on this?

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 

BeardedFen

Thanks. Does this work for Azure Data Studio

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