XML parsing Error..

• Chowdary's

  SSCrazy

  Points: 2978

  More actions

  August 5, 2014 at 11:09 pm

  #289582

  Hi All,

  we are using SQL 2008 server...

  We have a job like xyz while we are trying to execute the job it is throwing some error message like the following

  "XML parsing: line 16, character 7, end tag does not match start tag [SQLSTATE 42000] (Error 9436)."

  Actually previously we got some error like " SQL Server blocked access to procedure 'sys.sp_OACreate' of component 'Ole Automation Procedures' ....." So for this i enabled the Ole Automation Proc successfully but after that i got the above error(XML parsing)

  Kindly give me some suggestions to overcome from this prob...

  Regards

  Chowdary....

  Regards
  Chowdary...

• LutzM

  SSC Guru

  Points: 107049

  More actions

  August 6, 2014 at 2:11 am

  #1735519

  without seeing the code or at least the xml (obfuscated if needed) and a description how the xml is generated, any answer would be just guessing...

  My guess: either the XML is not generated properly or it is stored in a variable with a length shorter than the XML is leading to a truncation.

  ---

  
  Lutz
  A pessimist is an optimist with experience.

  How to get fast answers to your question[/url]
  How to post performance related questions[/url]
  Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]