How can we help you today? How can we help you today?

Stored procedure parameter auto-completion

After installing version 11.0.1.16766, stored procedure parameter auto-completion stopped working.

luca.cestola
1

Comments

1 comment

  • CR12

    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

    CR12
    0

Add comment

Please sign in to leave a comment.