topic Re: Postgres Cdc data missing Jsonb in Qlik Replicate

Postgres Cdc data missing Jsonb

gseckin — Tue, 21 Jul 2026 09:40:01 GMT

We use Postgres database as source, we have jsonb column, when we update a column except that jsonb let's say updated_at column, jsonb column comes as null. but we need to see data even we don't change it. How we can enable this in qlik replicate.

Thanks
version : 2024.5.9.508

Re: Postgres Cdc data missing Jsonb

john_wang — Tue, 21 Jul 2026 10:00:09 GMT

Hello @gseckin ,

Thanks for reaching out to the Qlik Community!

1. Qlik Replicate 2024.5 has reached End of Support (EOS). I recommend upgrading to a supported release, preferably Qlik Replicate 2025.11 SP05.

2. The JSONB data type is treated as a LOB in Replicate. As a result, the source table must have a Primary Key (PK) or Unique Index. Please verify that the table meets this requirement.

3. Since JSONB columns are handled as LOBs, transformations cannot be applied to them. If a transformation is defined on a JSONB column, the replicated value will be NULL.

If you need further assistance, please set SOURCE_CAPTURE/TARGET_APPLY logging to Verbose, reproduce the issue, and review the task log to help identify the root cause. Alternatively, you can open a support ticket and attach the decrypted task log files for further investigation.

Hope this helps.
John.

Re: Postgres Cdc data missing Jsonb

gseckin — Tue, 21 Jul 2026 10:31:11 GMT

Yes we set replicate identity, where can I find this config \CDC/LOB settings to ensure unchanged jsonb values are included in update events. \