topic Re: Difference in column types between replicated table and it's change table in Qlik Replicate

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

JensAegon — Tue, 26 Jul 2022 13:13:28 GMT

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

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

SwathiPulagam — Tue, 26 Jul 2022 14:07:32 GMT

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

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

lyka — Tue, 26 Jul 2022 14:08:37 GMT

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