Replicate - Oracle source: ALL COLUMN supplemental logging is required

[john_wang]

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

Related Content 

1. Internal support case ID: # 00047346.

2. Michael_Litz Oracle ALL Column Supplemental Logging 

3. Michael_Litz Qlik Replicate: Implementing UPSERT and MERGE modes by applying a Conflicts Handling Policy 

Qlik Replicate