Return
-
Title
Error when trying to edit a function-QP5 parsing error in 'GetFirstChunkXmlDocument' -
Description
In the Object Explorer, right click on function and select Edit, an exception is thrown:
"Exception:
Quest.Toad.SqlServer.Doe.Common.QP5Parser.QP5ParserWrappingException
Message : QP5 parsing error in 'GetFirstChunkXmlDocument'
Stack Trace:
at
Quest.Toad.SqlServer.Doe.Common.QP5Parser.QP5Parser.GetSQLObjectBodyOffs
ets(QP5ParserDocument qp5ParserDocument, ToadObjectType toadObjectType)
at Quest.Toad.SqlServer.Doe.UDF.UDFProperties.get_Body()
at Quest.Toad.SqlServer.Doe.UDF.UDFProperties.IsChanged()
at Quest.Toad.SqlServer.Doe.UDF.UDFProperties.GetScript(StringBuilder sbScript, ScriptOptions scriptOptions)
at
Quest.Toad.SqlServer.Doe.UDF.UDFEditForm.Properties_LoadDoneHandler(Object sender, RoutedEventArgs e, StringBuilder sb, ScriptOptionsscriptOptions, ITrl itrl) at Quest.Toad.SqlServer.Doe.UDF.UDFEditForm.AlterInEditor(Objectsender, ItemClickEventArgs e)
Inner Exception: System.InvalidOperationException
Message : 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)
 -
Cause
Product defect. A specific formatting applied to the function cannot be parsed correctly.
-
Resolution
WORKAROUND:
NoneSTATUS:
Waiting for fix in a future version of Toad for SQL Server. -
Defect ID
ST74118 -
Additional Information
This issue is only reproducible on specific function. The Toad for SQL Server capability to view and edit function is generally available.