Post reply

XML parsing Error..

  • 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...

  • 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]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply