Receiving an error when selecting Alter Procedure in Editor for a certain stored procedure.
Select a stored procedure, right click and select alter procedure in editor. Toad gives the following error. All other procedures are fine.
Quest.Toad.SqlServer.Doe.Common.QP5Parser.QP5ParserWrappingException
QP5 parsing error in GetFirstChunkXmlDocument
Stack Trace:
at Quest.Toad.SqlServer.Doe.Common.QP5Parser.QP5Parser.GetSQLObjectBodyOffsets(QP5ParserDocument qp5ParserDocument, ToadObjectType toadObjectType)
at Quest.Toad.SqlServer.Doe.StoredProcs.StoredProcProperties.get_Body()
at Quest.Toad.SqlServer.Doe.StoredProcs.StoredProcProperties.IsChanged()
at Quest.Toad.SqlServer.Doe.StoredProcs.StoredProcProperties.GetScript(StoredProcProperties storedProcProperties, StringBuilder sbScript, ScriptOptions scriptOptions)
at Quest.Toad.SqlServer.Doe.StoredProcs.StoredProcProperties.GetScript(StringBuilder sbScript, ScriptOptions scriptOptions)
at Quest.Toad.SqlServer.Doe.StoredProcs.StoredProcEditForm.Properties_LoadDoneHandler(Object sender, RoutedEventArgs e, StringBuilder sb, ScriptOptions scriptOptions, ITrl itrl)
at Quest.Toad.SqlServer.Doe.StoredProcs.StoredProcEditForm.AlterInEditor(Object sender, ItemClickEventArgs e)
System.InvalidOperationException
Sequence contains no elements
Stack Trace:
at System.Linq.Enumerable.First[TSource](IEnumerable`1 source)
at Quest.Toad.SqlServer.Doe.Common.QP5Parser.QP5Parser.GetSQLObjectBodyOffsets(QP5ParserDocument qp5ParserDocument, ToadObjectType toadObjectType)
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center