Supplemental Logging issue for logstream

[Abhimannyu_19]

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. 

[john_wang]

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.

[Abhimannyu_19]

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 ?

[john_wang · Accepted solution]

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.