"Master failed to load" error

rrhodes_lsmrrhodes_lsm Posts: 1 New member
in SQL Prompt
I have a problem using SQL prompt on one of my company's SQL servers (seems to be fine on other servers). Auto complete doesn't work at all, and if I refresh suggestions it goes through the motions but then shows a "master failed to load" error. If I look further into it I get "Index was outside the bounds of the array". Our IT team don't know where to start, so if anyone can help me to nudge them in the right direction I would appreciate it! Log below:

19 Jan 2023 11:22:28,538 [1] INFO  RedGate.SqlPrompt.Metadata.Logging.LogService - Starting new SQL Prompt 9.3.1.6690 editor session
19 Jan 2023 11:22:28,583 [1] INFO  RedGate.SQLPrompt.CommonVS.BaseConnect.1 - BaseConnect(RedGate.SQLPrompt.SsmsPackage.ConnectAdapter) constructed successfully
19 Jan 2023 11:22:28,633 [1] INFO  RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Initialising DTE and AddIn connections.
***
DTE.FullName = C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Ssms.exe, DTE.Version = 2017.0140,
DTE.CommandLine = ,
***
AddIn.Name = SQL Prompt, AddIn.ProgID = RedGate.SQLPrompt.SsmsPackage.ConnectAdapter,
AddIn.Description = SQL Prompt
19 Jan 2023 11:22:28,634 [1] INFO  RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Current culture en-US
19 Jan 2023 11:22:28,634 [1] INFO  RedGate.SQLPrompt.CommonVS.BaseConnect.1 - AddIn.SatelliteDllPath = 
19 Jan 2023 11:22:28,945 [1] INFO  RedGate.SQLPrompt.CommonUI.Options.LicensingWrapper - Licensing client created
19 Jan 2023 11:22:31,144 [1] INFO  RedGate.SQLPrompt.CommonUI.Options.LicensingWrapper - License edition initially Full
19 Jan 2023 11:22:31,179 [1] INFO  RedGate.SqlPrompt.Metadata.Options.OptionsBase - Loading UIOptions from C:\Users\n1594741\AppData\Local\Red Gate\SQL Prompt 9\RedGate_SQLPrompt_CommonUI_Options_UIOptions.xml (attempt 0 of 10)...
19 Jan 2023 11:22:31,191 [1] INFO  RedGate.SqlPrompt.Metadata.Options.OptionsBase - Successfully loaded UIOptions
19 Jan 2023 11:22:31,208 [1] INFO  RedGate.SqlPrompt.Metadata.Options.OptionsBase - Loading EngineOptions from C:\Users\n1594741\AppData\Local\Red Gate\SQL Prompt 9\RedGate_SqlPrompt_Engine_EngineOptions.xml (attempt 0 of 10)...
19 Jan 2023 11:22:31,213 [1] INFO  RedGate.SqlPrompt.Metadata.Options.OptionsBase - Successfully loaded EngineOptions
19 Jan 2023 11:22:31,224 [1] INFO  RedGate.SqlPrompt.Metadata.Options.OptionsBase - Loading LayoutOptions from C:\Users\n1594741\AppData\Local\Red Gate\SQL Prompt 9\RedGate_SqlPrompt_Format_Layout_LayoutOptions.xml (attempt 0 of 10)...
19 Jan 2023 11:22:31,228 [1] INFO  RedGate.SqlPrompt.Metadata.Options.OptionsBase - Successfully loaded LayoutOptions
19 Jan 2023 11:22:31,233 [1] INFO  RedGate.SqlPrompt.Metadata.Options.OptionsBase - Loading TabMagicOptions from C:\Users\n1594741\AppData\Local\Red Gate\SQL Prompt 9\RedGate_SQLPrompt_CommonUI_Options_TabMagicOptions.xml (attempt 0 of 10)...
19 Jan 2023 11:22:31,233 [1] INFO  RedGate.SqlPrompt.Metadata.Options.OptionsBase - Successfully loaded TabMagicOptions
19 Jan 2023 11:22:31,704 [1] INFO  RedGate.SQLQueryKeeper.TabMagicConnect2017 - ctor started
19 Jan 2023 11:22:31,705 [1] INFO  RedGate.SQLQueryKeeper.TabMagicConnect2017 - ctor complete
19 Jan 2023 11:22:31,793 [1] INFO  RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Initialisation successful.
19 Jan 2023 11:22:31,822 [1] INFO  RedGate.SQLQueryKeeper.TabMagicConnect2017 - Initialize started
19 Jan 2023 11:22:31,823 [1] INFO  RedGate.SQLQueryKeeper.Initialization - Connecting
19 Jan 2023 11:22:31,873 [1] INFO  RedGate.SQLQueryKeeper.MutexWrapper - Taking mutex for DocumentStore ctor1ff474fc-bd01-42d7-a4ec-a16356dacf51
19 Jan 2023 11:22:31,885 [1] INFO  RedGate.SQLQueryKeeper.MutexWrapper - Releasing mutex for DocumentStore ctor1ff474fc-bd01-42d7-a4ec-a16356dacf51
19 Jan 2023 11:22:31,888 [1] INFO  RedGate.SQLQueryKeeper.TabMagicConnect2017 - Initialize complete
19 Jan 2023 11:22:31,888 [1] INFO  RedGate.SQLPrompt.CommonVS.BaseConnect.1 - OnConnection(ext_cm_AfterStartup)
19 Jan 2023 11:22:31,889 [1] INFO  RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Handling OnStartupComplete()
19 Jan 2023 11:22:31,900 [1] INFO  RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Entering Startup()
19 Jan 2023 11:22:31,900 [1] INFO  RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Loading plugins...
19 Jan 2023 11:22:31,902 [1] INFO  RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Starting EditorManager...
19 Jan 2023 11:22:31,937 [1] INFO  RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Creating menus for SQL Prompt edition Full
19 Jan 2023 11:22:32,130 [1] INFO  RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Calling SqlPromptApplication.Initialise()
19 Jan 2023 11:22:32,133 [1] INFO  RedGate.SQLPrompt.CommonVS.BaseConnect.1 - Startup() completed successfully.
19 Jan 2023 11:22:32,134 [1] INFO  RedGate.SQLPrompt.CommonVS.BaseConnect.1 - SqlPromptApplication initialised. (startup took 0:00:03.656)
19 Jan 2023 11:22:32,135 [1] INFO  RedGate.SQLQueryKeeper.TabMagicConnect2017 - OnStartupComplete started
19 Jan 2023 11:22:32,136 [1] INFO  RedGate.SQLQueryKeeper.Initialization - OnShellInitialized
19 Jan 2023 11:22:32,138 [1] INFO  RedGate.SQLQueryKeeper.MutexWrapper - Taking mutex for Reload open tabs57ad1280-67d2-4dcd-8cbf-b1327ce071c0
19 Jan 2023 11:22:32,156 [1] INFO  RedGate.SQLQueryKeeper.MutexWrapper - Releasing mutex for Reload open tabs57ad1280-67d2-4dcd-8cbf-b1327ce071c0
19 Jan 2023 11:22:32,306 [1] INFO  RedGate.SQLQueryKeeper.TabWatcher - Trying to open document: Extract_AAL_Gridded_Data.sql
19 Jan 2023 11:22:34,485 [1] INFO  RedGate.SQLQueryKeeper.TabWatcher - Document opened
19 Jan 2023 11:22:34,617 [1] INFO  RedGate.SQLQueryKeeper.TabWatcher - Trying to open document: SQLQuery1.sql
19 Jan 2023 11:22:35,028 [1] INFO  RedGate.SQLQueryKeeper.TabWatcher - Document opened
19 Jan 2023 11:22:35,168 [1] INFO  RedGate.SQLQueryKeeper.TabWatcher - Trying to open document: SQLQuery2.sql
19 Jan 2023 11:22:35,443 [1] INFO  RedGate.SQLQueryKeeper.TabWatcher - Document opened
19 Jan 2023 11:22:35,541 [1] INFO  RedGate.SQLQueryKeeper.TabWatcher - Trying to open document: SQLQuery3.sql
19 Jan 2023 11:22:35,829 [1] INFO  RedGate.SQLQueryKeeper.TabWatcher - Document opened
19 Jan 2023 11:22:35,924 [1] INFO  RedGate.SQLQueryKeeper.TabMagicConnect2017 - OnStartupComplete complete
19 Jan 2023 11:22:40,524 [1] INFO  RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Created new ServerCandidate for server: D16TS1DB01\SQL2017,14001
19 Jan 2023 11:22:40,953 [16] ERROR RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Cannot load server capabilities: unsupported server Unknown
19 Jan 2023 11:22:40,962 [16] INFO  RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Chosen server capabilities Sql2017
19 Jan 2023 11:22:41,870 [10] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[master] progress: Connecting...
19 Jan 2023 11:22:41,870 [16] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[LSM_RESEARCH] progress: Waiting for master database
19 Jan 2023 11:22:42,074 [10] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - Populating [D16TS1DB01\SQL2017,14001].[master] as Unknown
19 Jan 2023 11:22:42,154 [10] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[master] progress: Processing schemas...
19 Jan 2023 11:22:42,156 [10] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[master] progress: Processing objects...
19 Jan 2023 11:22:42,365 [10] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[master] progress: Processing master objects...
19 Jan 2023 11:22:42,373 [10] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[master] progress: Processing triggers...
19 Jan 2023 11:22:42,374 [10] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[master] progress: Processing datatypes...
19 Jan 2023 11:22:43,035 [10] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[master] progress: Processing datatypes...
19 Jan 2023 11:22:43,036 [10] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[master] progress: Processing columns...
19 Jan 2023 11:22:43,059 [10] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[master] progress: Processing parameters...
19 Jan 2023 11:22:43,107 [10] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[master] progress: Processing indexes...
19 Jan 2023 11:22:43,109 [10] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[master] progress: Processing foreign keys...
19 Jan 2023 11:22:43,111 [10] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[master] progress: Processing primary keys...
19 Jan 2023 11:22:43,112 [10] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[master] progress: Processing services...
19 Jan 2023 11:22:43,153 [10] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[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()
19 Jan 2023 11:22:43,188 [16] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[LSM_RESEARCH] Cache finished with warnings:
RedGate.SqlPrompt.Metadata.CandidateInterfaces.MasterNotLoadedException: The master database could not be loaded
   at RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate.LoadDatabase()
19 Jan 2023 11:22:56,741 [12] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[LSM_RESEARCH] loading skipped
19 Jan 2023 11:22:56,748 [12] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[LSM_RESEARCH] loading skipped
19 Jan 2023 11:22:57,210 [45] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[LSM_RESEARCH] loading skipped
19 Jan 2023 11:22:58,575 [17] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[LSM_RESEARCH] loading skipped
19 Jan 2023 11:23:01,732 [12] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[LSM_RESEARCH] progress: Waiting for master database
19 Jan 2023 11:23:01,776 [12] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[LSM_RESEARCH] Cache finished with warnings:
RedGate.SqlPrompt.Metadata.CandidateInterfaces.MasterNotLoadedException: The master database could not be loaded
   at RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate.LoadDatabase()
19 Jan 2023 11:23:01,793 [1] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[LSM_RESEARCH] loading skipped
19 Jan 2023 11:23:01,794 [1] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[LSM_RESEARCH] loading skipped
19 Jan 2023 11:23:01,946 [7] ERROR RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Cannot load server capabilities: unsupported server Unknown
19 Jan 2023 11:23:01,950 [7] INFO  RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Chosen server capabilities Sql2017
19 Jan 2023 11:23:02,197 [42] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[LSM_RESEARCH] loading skipped
19 Jan 2023 11:23:02,683 [13] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[master] progress: Connecting...
19 Jan 2023 11:23:02,893 [13] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - Populating [D16TS1DB01\SQL2017,14001].[master] as Unknown
19 Jan 2023 11:23:02,959 [13] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[master] progress: Processing schemas...
19 Jan 2023 11:23:02,961 [13] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[master] progress: Processing objects...
19 Jan 2023 11:23:03,124 [13] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[master] progress: Processing master objects...
19 Jan 2023 11:23:03,128 [13] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[master] progress: Processing triggers...
19 Jan 2023 11:23:03,128 [13] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[master] progress: Processing datatypes...
19 Jan 2023 11:23:03,129 [13] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[master] progress: Processing datatypes...
19 Jan 2023 11:23:03,130 [13] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[master] progress: Processing columns...
19 Jan 2023 11:23:03,575 [13] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[master] progress: Processing parameters...
19 Jan 2023 11:23:03,789 [13] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[master] progress: Processing indexes...
19 Jan 2023 11:23:03,800 [13] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[master] progress: Processing foreign keys...
19 Jan 2023 11:23:03,801 [13] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[master] progress: Processing primary keys...
19 Jan 2023 11:23:03,802 [13] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[master] progress: Processing services...
19 Jan 2023 11:23:03,844 [13] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[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()
19 Jan 2023 11:23:03,867 [1] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[LSM_RESEARCH] loading skipped
19 Jan 2023 11:23:03,868 [1] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[LSM_RESEARCH] loading skipped
19 Jan 2023 11:23:04,281 [43] INFO  RedGate.SqlPrompt.Cache.Candidates.DatabaseCandidate - [D16TS1DB01\SQL2017,14001].[LSM_RESEARCH] loading skipped

Tagged:
· Share on Twitter

Answers

Sign In or Register to comment.