Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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
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
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