Qlik Replicate: data copy is failing with metadata errors

[narendersarva]

After copying data from MSSQL to Azure SQL tables, the copy fails with the error:

The metadata for source table 'tabel_name' is different than the corresponding MS-CDC Change Table. The table will be suspended.

Resolution

Verify if the tables you are replicating are temporal or system tables. Temporal or system tables are not supported by Qlik Replicate. See Limitations and considerations for details.

Possible workarounds

If you want to capture changes to these tables with MS-CDC and Qlik Replicate, then you have to unhide the system-generated columns:

ALTER TABLE <the table name> ALTER COLUMN [SysStartTime] drop HIDDEN;
ALTER TABLE <the table name> ALTER COLUMN [SysEndTime] drop HIDDEN;

Depending on how the table was created, the hidden column names may be different, such as ValidFrom, ValidTo.

If you don't want to make the above change, you can use the ODBC with CDC endpoint and capture both the base table and the history table using SysStartTime as the context column.

See Qlik Replicate: W: The metadata for source table 'dbo.table' is different than the corresponding MS-... for details. 

Environment

• Qlik Replicate