Comments
1 comment
-
The log files is catching the issue:
2025-06-05 15:55:37.180 -03:00 [Warning] Database population step failed for database Allied.Live.Database - step parameters
System.IndexOutOfRangeException: Index was outside the bounds of the array.
at RedGate.SqlPrompt.Cache.ParameterDefaultValueExtractor.ProcessSingleLineComment(String body, Int32& index, ContextTypes& currentContext)
at RedGate.SqlPrompt.Cache.ParameterDefaultValueExtractor.GetFilteredBody(String body)
at RedGate.SqlPrompt.Cache.ParameterDefaultValueExtractor.GetFromObjectDefinition(IEnumerable`1 procedureParameters, String body)
at RedGate.SqlPrompt.Cache.ParameterDefaultValueUpdater.UpdateFromObjectDefinition(Dictionary`2 objectDefinitions, List`1 parameters)
at RedGate.SqlPrompt.Cache.Population.Steps.Queries.Filtered.ParameterQuery.Execute(IDbCommand command)
at RedGate.SqlPrompt.Cache.Population.Steps.ParameterPopulationStep.Populate(IDbCommand command)
at RedGate.SqlPrompt.Cache.Population.DatabasePopulator.PopulateStep(DebugLogger logger, DbCommand command, IDatabasePopulationStep populationStep, String databaseName, Single overallPercentageComplete)
2025-06-05 15:55:44.255 -03:00 [Information] [KATDB16].[Allied.Live.Database] Cache finished with no warnings
Add comment
Please sign in to leave a comment.
After installing version 11.0.1.16766, stored procedure parameter auto-completion stopped working.