Help Center> Data Replication Service> Troubleshooting> Failure Cases> Real-Time Synchronization with Oracle Serving as the Source> Incremental Synchronization Error: Source supplemental log level is PK/UI. Missing column data at delete+insert on ***"
Updated on 2024-05-09 GMT+08:00
View PDF

Incremental Synchronization Error: Source supplemental log level is PK/UI. Missing column data at delete+insert on ***"

Scenarios

During an incremental synchronization from Oracle to PostgreSQL, GaussDB(DWS), or GaussDB, an error is reported, and the log information is as follows: service INCREMENT failed, cause by: Source supplemental log level is PK/UI. Missing column data at delete+insert on ***

Possible Causes

The supplemental log level of the source Oracle database is PK/UI. The update operation of the source database is not hit in the workload replay of the destination database. DRS converts the update operation to delete and insert operations by default. During the insert operation, the log does not contain data of other columns. As a result, an error is reported.

Solution

Change the supplemental log level of the source database to ALL. Then, in the task list, click Reset in the Operation column to submit the task again.