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)
Conflict in the QP5 parser.
WORKAROUND:
None
STATUS:
Waiting for fix in a future version of Toad for SQL Server.
This is also an issue with other edit/alter function in Toad, i.e. Create like stored proc... or Generate SQL |...| Creation Script, etc.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center