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.
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.
Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
