A table with a JSON B (LOB) datatype column did not replicate this field to the target table. The task was run in CDC mode.
Checking in the table create DDL found that there were was no primary key or unique index on the table.
Limitation:
LOB columns are not replicated in CDC mode when the table has no PK or UK.
Resolution:
Add a key to the source table or use the table in a Full Load only task.
Related Content
Replicate - Oracle source: replicating LOB columns via ROWID if the table has no Primary Key or Uniq...
An Introduction to Qlik Replicate Tasks: Full Load vs CDC
Qlik Replicate: Support JSONB datatype for PostgreSQL ODBC data source
