topic Re: Supplemental Logging issue for logstream in Qlik Replicate

Supplemental Logging issue for logstream

Abhimannyu_19 — Mon, 12 May 2025 11:31:27 GMT

We're able to get cdc data for the tables, but in logstream task we see suplemental logging configuration error. So the question is that for logstream task do we need additional supplemental logging configuration ?

Below is the attached error screenshot.

Re: Supplemental Logging issue for logstream

john_wang — Mon, 12 May 2025 13:19:42 GMT

Hello @Abhimannyu_19 ,

Welcome to Qlik Community forum and thanks for reaching out here!

In general Qlik Replicate requires minimal supplemental loggings. However in some cases the ALL COLUMN supplemental logging is required for the table. You may manually enable the ALL COLUMN supplemental logging, please check my article:

Oracle source: ALL COLUMN supplemental logging is required

Hope it helps.

John.

Re: Supplemental Logging issue for logstream

Abhimannyu_19 — Mon, 12 May 2025 13:30:13 GMT

Hello @john_wang ,

Thanks for your reply.
Supplemental logging for the tables that we want are already enabled in our oracle database because in other tasks, we have the same config and it's working fine.

But somehow in Logstream task despite having the same config as other tasks, it's not working.
Do we need to do some additional Supplemental logging settings/config for logstream ?

Re: Supplemental Logging issue for logstream

john_wang — Mon, 12 May 2025 14:32:49 GMT

Hello @Abhimannyu_19 ,

Qlik Replicate will verify whether a table’s supplemental logging is sufficient based on the task settings. Different task configurations may require different levels of supplemental logging.

For example, if the "Retrieve all source columns on UPDATE" option is enabled in a LogStream staging task, you must increase the supplemental logging level to ALL COLUMNS. For instance:

Regards,

John.