master failed to load.

MichaelPe

Hi,
When accessing a SQL 2019 (v15.0.4198) I get the error "master failed to load.". Connecting to older SQL servers works fine.
This is using SQL Prompt Core 9.4.3.7121 core that is included with Visual Studio 2017.
I downloaded the latest trial version and that works fine with no errors
Below is the log output:

21 Jun 2022 07:58:39,855 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection

21 Jun 2022 07:58:39,893 [24] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [Server1].[master] progress: Processing schemas...

21 Jun 2022 07:58:39,895 [24] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [Server1].[master] progress: Processing objects...

21 Jun 2022 07:58:40,020 [24] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [Server1].[master] progress: Processing master objects...

21 Jun 2022 07:58:40,028 [24] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [Server1].[master] progress: Processing triggers...

21 Jun 2022 07:58:40,029 [24] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [Server1].[master] progress: Processing datatypes...

21 Jun 2022 07:58:40,944 [24] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [Server1].[master] progress: Processing datatypes...

21 Jun 2022 07:58:40,944 [24] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [Server1].[master] progress: Processing columns...

21 Jun 2022 07:58:41,069 [24] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [Server1].[master] progress: Processing parameters...

21 Jun 2022 07:58:41,229 [24] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [Server1].[master] progress: Processing indexes...

21 Jun 2022 07:58:41,230 [24] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [Server1].[master] progress: Processing foreign keys...

21 Jun 2022 07:58:41,231 [24] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [Server1].[master] progress: Processing primary keys...

21 Jun 2022 07:58:41,232 [24] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [Server1].[master] progress: Processing services...

21 Jun 2022 07:58:41,304 [24] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [Server1].[master] Cache finished with warnings:

System.IndexOutOfRangeException: Index was outside the bounds of the array.

   at System.Data.SqlClient.SqlDataReader.CheckDataIsReady(Int32 columnIndex, Boolean allowPartiallyReadColumn, Boolean permitAsync, String methodName)

   at System.Data.SqlClient.SqlDataReader.TryReadColumn(Int32 i, Boolean setTimeout, Boolean allowPartiallyReadColumn)

   at System.Data.SqlClient.SqlDataReader.GetInt32(Int32 i)

   at RedGate.SqlPrompt.Cache.Population.Steps.ServicePopulationStep.Populate(IDataReader reader)

   at RedGate.SqlPrompt.Cache.Population.DatabasePopulator.Populate(SqlConnection sqlConnection, CancellationToken cancellationToken)

   at RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate.LoadDatabase()

21 Jun 2022 07:58:41,340 [1] DEBUG RedGate.SQLPrompt.CommonUI.Forms.TaskExecuter.ViewModels.LoadingProgressPopupViewModel - Closing messages for Database: 'master'

DanC

Hi @MichaelPe it sounds like a potential bug in that version, you mentioned downloading and trialing the latest version which worked, can you upgrade and use the latest?