What Should I Do If Error Message "Supplement logging not properly configured" Is Displayed During Incremental Synchronization from Oracle?

Symptom

During incremental synchronization from Oracle, the JobManager or TaskManager log contains error message "Supplement logging not properly configured".

Possible Causes

During data synchronization from Oracle through a real-time link, supplementary logging must be enabled for the tables to be synchronized, so that all data can be read from logs.

Solution

Enable supplementary logging for the Oracle table to be synchronized:

ALTER TABLE "schema_name"."table_name" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;

After the preceding step, KEY ALL_COLUMN_LOGGING can be found, indicating that supplementary logging is enabled for the table.

SELECT LOG_GROUP_TYPE FROM ALL_LOG_GROUPS WHERE OWNER = 'schema_name' AND TABLE_NAME = 'table_name';  KEY ALL_COLUMN_LOGGING