Qlik Replicate Task Error when using XML Datatype Column in SQL Server

[lyka]

When replicating an XML datatype, the taks fails with the error:

Line 7866: 00006188: 2022-04-15T13:41:25 [TARGET_APPLY ]E: RetCode: SQL_ERROR SqlState: 42000 NativeError: 9412 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]XML parsing: line 1, character 524288, '>' expected Line: 1 Column: -1 [1022502] (ar_odbc_stmt.c:2794)

Environment

Qlik Replicate 

Resolution

If you cannot use unlimited lob support, please increase the limit lob size to accommodate the complete XML value. 

See LOB handling options.

Cause 

Replicate truncates the data in one of the XML columns. This invalidates the XML.