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.