Difference in column types between replicated table and it's change table

[JensAegon]

Hi,

We are replicating a table from an SQL to a Aurora database. However, we are seeing a difference in column types between the replicated table and it's change table. The column in question has the following types:

• Source table: xml
• Replicated table: text
• Change table: mediumtext

Going by the Qlik replication docs we should expect the XML column to get replicated as a CLOB(text) column, however I would expect the CT and the replicated table to have the same CLOB type.

We suspect this is the cause of data corruption in the replicated table (The first byte from the data is missing, causing the text in the column to render as Chinese characters).

Are we correct in this assumption and if so, how do we correct this issue?

Kind regards,
Jens

[SwathiPulagam]

Hi @JensAegon ,

In Replicate Data Types there is no TEXT data type. 

As per the user guide, Here is the datatype conversion for a CLOB column:

SQL Server- XML

Replicate-CLOB

Target- TEXT

For data corruption please raise a support case as we need to do more analysis.

Thanks,

Swathi

[lyka]

Hi Jens,

What is the Replicate version? Did Replicate create the change table? To troubleshoot, you can start by setting TRACE logging on source_unload, target_load and metadata_manager and verify how the columns are mapped and created. 

Thanks

Lyka