Replicate - Oracle source: ALL COLUMN supplemental logging is required

john_wang — Wed, 03 Aug 2022 12:10:04 GMT

Replicate Oracle source endpoint got errors:

2022-08-03T10:48:53 [SOURCE_UNLOAD ]W: ALL COLUMN supplemental logging is required for table '<schemaName>.<tableName>' (oracle_endpoint_utils.c:600)

2022-08-03T10:48:53 [SOURCE_UNLOAD ]E: Supplemental logging for table '<schemaName>.<tableName>' is not enabled properly [1022310] (oracle_endpoint_unload.c:190).

Cause

When task Apply Conflicts set to use UPSERT, it requires supplemental logging for all columns.

User Guide description: Step 4: When the Insert the missing target record Apply Conflicts option is selected, supplemental logging must be enabled for ALL the source table columns.

Resolution

1- Turn off UPSERT, use other options rather than "INSERT the missing target record"

If UPSERT is necessary then:

2- Add supplemental logging for all columns:

ALTER TABLE <schema>.<table name> ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;

Environment

Oracle source endpoint for Qlik Replicate
Qlik Replicate all supported versions

article Replicate - Oracle source: ALL COLUMN supplemental logging is required in Official Support Articles

Replicate - Oracle source: ALL COLUMN supplemental logging is required

Cause

Resolution

Environment

Related Content