Msg 9420, Level 16, State 1, Line 6 XML parsing: line 2, character 33, illegal xml character

• yujinagata72

  Ten Centuries

  Points: 1072

  More actions

  August 2, 2016 at 5:55 pm

  #315771

  Hi,

  When I run an SQL query, sometimes I got the error,

  Msg 9420, Level 16, State 1, Line 6

  XML parsing: line 2, character 33, illegal xml character

  and sometimes is okay.

  What would be the potential cause of this error?

  Thanks,

• Phil Parkin

  SSC Guru

  Points: 246964

  More actions

  August 2, 2016 at 7:38 pm

  #1893391

  yujinagata72 (8/2/2016)

  ---

  Hi,

  When I run an SQL query, sometimes I got the error,

  Msg 9420, Level 16, State 1, Line 6

  XML parsing: line 2, character 33, illegal xml character

  and sometimes is okay.

  What would be the potential cause of this error?

  Thanks,

  With no query and no sample data to look at, this is challenging to answer.

  I imagine that you have taken the time to rule out the obvious answer (ie, that there are no illegal XML characters involved)?

  The absence of evidence is not evidence of absence
  - Martin Rees
  The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
  - Phil Parkin

• Eirikur Eiriksson

  SSC Guru

  Points: 182912

  More actions

  August 2, 2016 at 10:59 pm

  #1893400

  yujinagata72 (8/2/2016)

  ---

  Hi,

  When I run an SQL query, sometimes I got the error,

  Msg 9420, Level 16, State 1, Line 6

  XML parsing: line 2, character 33, illegal xml character

  and sometimes is okay.

  What would be the potential cause of this error?

  Thanks,

  Post the DDL (create table), sample data as an insert statement and the query that produces the error. Without the necessary information there is no way anyone can help you on this.

  😎

• durga.palepu

  Hall of Fame

  Points: 3530

  More actions

  August 3, 2016 at 12:22 am

  #1893405

  Yes, please post the DDL and DML associated with this query to help you better.