Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-10-24 : 08:34:50
|
| Ben writes "I have a XML - based job using namespaces, and I got an interesting error message now that we're in unit testing <o joy>. Here it is:End tag 'c:Unique' does not match the start tag 'c:UniqueID'. Error processing resource 'file:///C:/Documents and Settings/XXXX/Desktop/test.xml'. Line 1, Position 2026 <c:Unique></c:Unique> holds CustomerID's, which is a primary key. This particular result has around 15 customerID's, and the last bit of the string for which the error message occurs looks like this:<c:UniqueID type="EXTERNAL">201776</c:UniqueID><c:UniqueID type="EXTERNAL">201777</c:UniqueAs you can see, the tag works fine until it gets to position 2026 in the string, at which point the string terminates.The XML Message parses and works correctly for smaller-sized messages. Hypothesis: I've hit the max size of an unidentified buffer.My result set string length (think EM > options > tools) is set to 5000 characters. NO problem there. Also, I don't see any limitations based on datatype anywhere (think VARCHAR(8000) or NTEXT).Have any of you folks run into this problem before? I haven't found anything on Google or MSDN.Sincerely,Ben" |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2003-10-24 : 20:27:31
|
| How are you importing the doc?How are you processing in SQL Server (ie OPENXML,etc..)?Need more info to examine... |
 |
|
|
|
|
|
My Error: XML parsing error