When Hex A0 (non-breaking space) is embedded in stored procedure code,Toad can't open the stored procedure (4310920)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

When Hex A0 (non-breaking space) is embedded in stored procedure code,Toad can't open the stored procedure
Description

The following error occurs when trying to load a stored procedure that includes a Hex A0 (non- breaking or fixed space):
System.Xml.XmlException
The 'ERROR_TOKEN' start tag on line 30 position 2 does not match the end tag of 'MESSAGE'. Line 103, position 3.
Stack Trace:
at System.Xml.XmlTextReaderImpl.Throw(Exception e)
at System.Xml.XmlTextReaderImpl.ThrowTagMismatch(NodeData startTag)
at System.Xml.XmlTextReaderImpl.ParseEndElement()
at System.Xml.XmlTextReaderImpl.ParseElementContent()
at System.Xml.XmlLoader.LoadNode(Boolean skipOverWhitespace)
at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
at System.Xml.XmlDocument.Load(XmlReader reader)
at System.Xml.XmlDocument.LoadXml(String xml)
at Quest.QP5.Chunk.ParseInfo(ParseInfoFlag flags)
at Quest.Toad.SqlServer.Doe.Common.QP5Parser.QP5Parser.GetFirstChunkXmlDocument(String body, ParseInfoFlag parseInfoFlag)
This issue also affects Schema Compare (when comparing schemas containing the object in question) and when you try to edit the code in the 'Alter' window in Object Explorer, the following message may show:
Quest.Toad.SqlServer.Doe.Common.QP5Parser.QP5ParserWrappingException
QP5 parsing error in 'GetFirstChunkXmlDocument'
Resolution

WORKAROUND
Changing the character to a 'space' character works around the Schema Compare and “Alter” menu.
STATUS
Waiting for fix in a future release of Toad for SQL Server
Defect ID

TSS-1656 and QP-2900
Additional Information

The Schema Compare error is fixed from v7

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Request a KB Article

When Hex A0 (non-breaking space) is embedded in stored procedure code,Toad can't open the stored procedure (4310920)

Title

Description

Resolution

Defect ID

Additional Information

Leave a Comment