Unexpected error: Name cannot begin with the '<' character,

I could not get the SQL Data Compare command line tool supplied in the cumulative patch (2010-11-04) to work, despite my best efforts. The command line tool worked for me prior to the cumulative patch.

I tried changing all the XML files I could find in the Data Compare directory, but was unable to find one with any offending XML data.

Running on Windows 7 Ultimate x64:

C:\Program Files &#40;x86&#41;\Red Gate\SQL Data Compare 8&gt;SQLDataCompare.exe
Unexpected error: Name cannot begin with the '&lt;' character, hexadecimal value 0x3C. Line 28, position 3.
Name cannot begin with the '&lt;' character, hexadecimal value 0x3C. Line 28, position 3.
System.Xml.XmlException
   at System.Xml.XmlTextReaderImpl.Throw&#40;Exception e&#41;
   at System.Xml.XmlTextReaderImpl.Throw&#40;String res, String&#91;&#93; args&#41;
   at System.Xml.XmlTextReaderImpl.Throw&#40;Int32 pos, String res, String&#91;&#93; args&#41;
   at System.Xml.XmlTextReaderImpl.ParseQName&#40;Boolean isQName, Int32 startOffset, Int32& colonPos&#41;
   at System.Xml.XmlTextReaderImpl.ParseElement&#40;&#41;
   at System.Xml.XmlTextReaderImpl.ParseElementContent&#40;&#41;
   at System.Xml.XmlTextReaderImpl.Read&#40;&#41;
   at System.Xml.XmlTextReader.Read&#40;&#41;
   at System.Xml.XmlCharCheckingReader.Read&#40;&#41;
   at System.Xml.XmlLoader.LoadNode&#40;Boolean skipOverWhitespace&#41;
   at System.Xml.XmlLoader.LoadDocSequence&#40;XmlDocument parentDoc&#41;
   at System.Xml.XmlLoader.Load&#40;XmlDocument doc, XmlReader reader, Boolean preserveWhitespace&#41;
   at System.Xml.XmlDocument.Load&#40;XmlReader reader&#41;
   at g.a&#40;XmlSchema , Stream , Boolean &#41;
   at g..ctor&#40;Stream metaDefinitionIn, Boolean useCommon, Boolean schemaValidate&#41;
   at RedGate.Shared.Utils.CommandLine.CommandLine.ParseCommandLine&#40;Stream metaDefinitionIn, String&#91;&#93; args, Boolean useCommon, Boolean schemaValidate&#41;
   at RedGate.Shared.Utils.CommandLine.CommandLine.ParseCommandLine&#40;Stream metaDefinitionIn, String&#91;&#93; args&#41;
   at RedGate.SQLDataCompare.CommandLine.Startup.a&#40;String&#91;&#93; &#41;

henkli November 12, 2010 03:37

Comments

10 comments

Same problem here. Using Windows 7 Enterprise x64!

Can't start SQLDataCompare in a command prompt, even without any arguments.

DIF1891 November 19, 2010 04:29

0
A bug in using scripts folder made me install the cumulative patch, and now command line doesnt work at all (with the "Name cannot begin with the '<' character" error). Using Windows 7 x64.

Very, very annoying, since I am in the middle of testing Data Compare for the bank I'm working for.

Please advise asap.

claustopholt November 26, 2010 10:50

0
Apologies for the problem with the command line you all encountered.

We've updated the patch to fix this, so please get the latest installer from the cumulative patch thread here

James B November 26, 2010 11:36

0
Still experiencing the same problem with the updated patch: command-line use of sqldatacompare fails with an Exception:

Unexpected error: Name cannot begin with the '<' character, hexadecimal value
0x3C. Line 28, position 3.
Name cannot begin with the '<' character, hexadecimal value 0x3C. Line 28, posit
ion 3.
System.Xml.XmlException
at System.Xml.XmlTextReaderImpl.Throw(Exception e)
at System.Xml.XmlTextReaderImpl.Throw(String res, String[] args)
at System.Xml.XmlTextReaderImpl.Throw(Int32 pos, String res, String[] args)
at System.Xml.XmlTextReaderImpl.ParseQName(Boolean isQName, Int32 startOffset
, Int32& colonPos)
at System.Xml.XmlTextReaderImpl.ParseElement()
at System.Xml.XmlTextReaderImpl.ParseElementContent()
at System.Xml.XmlTextReaderImpl.Read()
at System.Xml.XmlTextReader.Read()
at System.Xml.XmlCharCheckingReader.Read()
at System.Xml.XmlLoader.LoadNode(Boolean skipOverWhitespace)
at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean prese
rveWhitespace)
at System.Xml.XmlDocument.Load(XmlReader reader)
at g.a(XmlSchema , Stream , Boolean )
at g..ctor(Stream metaDefinitionIn, Boolean useCommon, Boolean schemaValidate
)
at RedGate.Shared.Utils.CommandLine.CommandLine.ParseCommandLine(Stream metaD
efinitionIn, String[] args, Boolean useCommon, Boolean schemaValidate)
at RedGate.Shared.Utils.CommandLine.CommandLine.ParseCommandLine(Stream metaD
efinitionIn, String[] args)
at RedGate.SQLDataCompare.CommandLine.Startup.a(String[] )

claustopholt November 27, 2010 09:52

0
Many apologies for this. We're investigating. Internal testing on the patched build has been successful, but the one linked from the forum is confirmed to be still broken.

We should have this fixed by Monday.

David

David Atkinson November 28, 2010 08:20

0
Any news? Sorry to be pushy, but please let me know if I can help in testing.

claustopholt November 29, 2010 05:42

0
Would you be able to download the patch and try again? I've installed it and can confirm that the command line isn't giving the same error.

David

David Atkinson November 29, 2010 06:26

0
I just downloaded now, and it appears to be working for me as well -- great!

I will work through our test today and give final feedback when done, hopefully in a few hours time.

claustopholt November 29, 2010 06:31

0
It all seems to work correctly now, solving both the name < issue and the original issue that made me try the patch. So everything seems fine

claustopholt November 29, 2010 09:02

0
That's great news. I can only apologise again for the issue in the first place. Do let us know if you come across further problems.

David

David Atkinson November 29, 2010 09:04

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Unexpected error: Name cannot begin with the '&lt;' character,

Comments