none
Replication issue on xml data in varchar(max) data type RRS feed

  • Question

  • I set up transactional replication and have an issues on xml data which is in  varchar(max) data type. Recently I found some of the xml format got  malformed on subscriber but not on publisher. 

    eg: On publisher side

    <entry 1>

    field1

    filed 2

    <entry 1>

    <entry 2>

    <field 1>

    <field 2>

    <entry 2>

    On subscriber it got written as

    <entry 1>

    <entry 2>

    <field 1>

    <field2>

    <entry 2>

    <field1>

    <field2>

    <entry 1>

    It is happening only on few records randomly. I am not seeing any errors on replication side. no latencies. replication performance is excellent. Not sure what I am missing here.

    Appreciate your inputs.


    S.Prema

    Thursday, August 8, 2019 6:27 PM

All replies

  • What are the properties of your article?

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Friday, August 9, 2019 9:31 AM

  • S.Prema

    Friday, August 9, 2019 4:53 PM
  • Who has an opinion?
    Monday, August 19, 2019 9:09 AM
  • This is an app issue. This is not a transactional replication issue. If you were storing XML in the XML data type it might be a replication issue. IIRC in SQL 2008 there was an issue replicating XML where it would be malformed on the subscriber. This issue was with merge replication.

    Somehow your app is mangling your "xml" stored in the varchar(max) data type.

    Monday, August 19, 2019 3:06 PM
    Moderator