Last week we were using SQL prompt without issue on Azure Synapse DW. Then messages began popping up with URI issues and IT stated prompt was trying to hit an update url. They said update the app. I updated from SSM 19 to SSMS 20 and also updated sql prompt. It is no longer operational due to “Waiting for master database” when the sql pool db is selected.
logs below
2025-05-30 09:13:18.481 -07:00 [Information] Logging level set to 'Information'
2025-05-30 09:13:19.144 -07:00 [Information] Launching package entry point Ssms19 (version 19.3.4.0) for SQL Prompt 11.0.0.16715.
2025-05-30 09:13:19.161 -07:00 [Information] Initialising DTE and AddIn connections.
DTE.FullName: C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Ssms.exe
DTE.Version: 19.3
DTE.CommandLine:
Current culture: en-US
Current UI culture: en-US
2025-05-30 09:13:21.550 -07:00 [Information] SqlPromptApplication initialised (startup took 0:00:00.000)
2025-05-30 09:13:21.957 -07:00 [Error] Check for updates: Failure whilst attempting check for updates
System.Net.WebException: The request failed with HTTP status 403: Forbidden.
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at RedGate.Update.Client.SoapUpdateServer.Check.CheckForUpdates(String xmlArgument, String& xmlResponse, String& errorMessage)
at RedGate.Update.Client.UpdateServer.UpdateServer.CheckForUpdates(String serialNumber, Boolean automatic)
2025-05-30 09:13:21.959 -07:00 [Error] Check for updates: Facade failure
System.Net.WebException: The request failed with HTTP status 403: Forbidden.
Server stack trace:
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at RedGate.Update.Client.SoapUpdateServer.Check.CheckForUpdates(String xmlArgument, String& xmlResponse, String& errorMessage)
at RedGate.Update.Client.UpdateServer.UpdateServer.CheckForUpdates(String serialNumber, Boolean automatic)
at RedGate.Update.Client.UpdateService.CheckForUpdatesStatic(IUpdateServer updateServer, IDownloadManager downloadManager, String serialNumber, Boolean automatic, DownloadProgress progress)
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message reqMsg, Boolean bProxyCase)
at System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed, MessageData& msgData)
at RedGate.Update.Client.UpdateService.Callback.EndInvoke(IAsyncResult result)
at RedGate.Update.Client.UpdateService.EndCheckForUpdates(IAsyncResult asyncResult)
at RedGate.Update.Client.UpdateFacade.CheckFinished(IAsyncResult ar)
2025-05-30 09:13:27.577 -07:00 [Information] Current license: Enabled = True, Activated = True, Features = [None]
2025-05-30 09:13:38.888 -07:00 [Information] Sql History initialized successfully
2025-05-30 09:14:22.392 -07:00 [Information] Created new ServerCandidate for server: ahdw-synapse-prod2.sql.azuresynapse.net
2025-05-30 09:14:23.170 -07:00 [Information] Chosen server capabilities "AzureSqlDedicatedPool"
2025-05-30 09:14:24.476 -07:00 [Information] [ahdw-synapse-prod2.sql.azuresynapse.net].[master] Caching was cancelled
2025-05-30 09:14:24.476 -07:00 [Information] [ahdw-synapse-prod2.sql.azuresynapse.net].[master] loading skipped
2025-05-30 09:14:24.476 -07:00 [Information] [ahdw-synapse-prod2.sql.azuresynapse.net].[master] loading skipped
2025-05-30 09:14:24.644 -07:00 [Information] Populating [ahdw-synapse-prod2.sql.azuresynapse.net].[master] as "AzureSqlDedicatedPool"
2025-05-30 09:14:25.066 -07:00 [Information] Populating [ahdw-synapse-prod2.sql.azuresynapse.net].[master] as "AzureSqlDedicatedPool"
2025-05-30 09:14:25.066 -07:00 [Information] Chosen server capabilities "AzureSqlDedicatedPool"
2025-05-30 09:14:26.452 -07:00 [Warning] Could not find table 1349579846 for PK column 1 - perhaps it's on a table type
2025-05-30 09:14:28.425 -07:00 [Information] [ahdw-synapse-prod2.sql.azuresynapse.net].[master] Cache finished with warnings:
RedGate.SqlPrompt.Metadata.Metadata_Interfaces.DecryptionException: No permissions to decrypt objects ---> RedGate.SqlPrompt.Cache.PageReader.PromptDecryptorException: GetAllocUnitID : SQL Server exception thrown ---> Microsoft.Data.SqlClient.SqlException: Invalid object name 'sys.system_internals_allocation_units'.
at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData()
at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at Microsoft.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at RedGate.SqlPrompt.Cache.PageReader.DatabaseFramework.GetRowsetId(DbConnection conn, Int32 objId)
--- End of inner exception stack trace ---
at RedGate.SqlPrompt.Cache.PageReader.DatabaseFramework.GetRowsetId(DbConnection conn, Int32 objId)
at RedGate.SqlPrompt.Cache.PageReader.PromptPageReader..ctor(IShellDedicatedConnectionFactory connectionFactory, ConnectionProperties connectionProperties, String useLine)
at RedGate.SqlPrompt.Cache.ScriptRetrieval.ScriptRetrieverWithDecryption.SetPageReader()
--- End of inner exception stack trace ---
2025-05-30 09:14:32.921 -07:00 [Information] Created new ServerCandidate for server: ahdw-synapse-prod2.sql.azuresynapse.net
2025-05-30 09:14:34.418 -07:00 [Information] Chosen server capabilities "PDW"
2025-05-30 09:14:34.418 -07:00 [Information] Server does not support getting list of collations
2025-05-30 09:14:34.705 -07:00 [Information] Server does not support linking to other servers
2025-05-30 09:14:34.705 -07:00 [Information] Login suggestions are not supported for "PDW" servers
2025-05-30 09:14:34.800 -07:00 [Warning] Couldn't populate resource pools.
Microsoft.Data.SqlClient.SqlException (0x80131904): Catalog view 'resource_governor_resource_pools' is not supported in this version.
at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData()
at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at Microsoft.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at RedGate.SqlPrompt.Cache.Candidates.ServerCandidate.PopulateResourcePools(DbConnection serverLevelConnection)
ClientConnectionId:9f060be6-8c83-4d65-9567-d6681a812712
Error Number:104385,State:1,Class:16
ClientConnectionId before routing:d3a175ce-02b1-41ff-9c75-9da6e6b1aef6
Routing Destination:e37a6a6ca572-0.tr10751.westus1-a.worker.database.windows.net,11048
2025-05-30 09:14:34.976 -07:00 [Warning] Failed to load server ahdw-synapse-prod2.sql.azuresynapse.net
Microsoft.Data.SqlClient.SqlException (0x80131904): Catalog view 'dm_xe_object_columns' is not supported in this version.
at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData()
at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at Microsoft.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at RedGate.SqlPrompt.Cache.Candidates.ServerCandidate.GetPackageFromDatabase(DbConnection serverLevelConnection)
at RedGate.SqlPrompt.Cache.Candidates.ServerCandidate.LoadServer()
ClientConnectionId:9f060be6-8c83-4d65-9567-d6681a812712
Error Number:104385,State:1,Class:16
ClientConnectionId before routing:d3a175ce-02b1-41ff-9c75-9da6e6b1aef6
Routing Destination:e37a6a6ca572-0.tr10751.westus1-a.worker.database.windows.net,11048
2025-05-30 09:15:09.684 -07:00 [Error] Error checking for platform availability
System.Threading.Tasks.TaskCanceledException: A task was canceled.
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at RedGate.SqlPrompt.Platform.Client.KillSwitchChecker.<GetEnabled>d__5.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 RedGate.SqlPrompt.Platform.Client.KillSwitchChecker.<RunOperation>d__4.MoveNext()
Official comment
Last week we were using SQL prompt without issue on Azure Synapse DW. Then messages began popping up with URI issues and IT stated prompt was trying to hit an update url. They said update the app. I updated from SSM 19 to SSMS 20 and also updated sql prompt. It is no longer operational due to “Waiting for master database” when the sql pool db is selected.
logs below