The error message "Failed adding supplemental logging for table" indicates that supplemental logging is not enabled on the Oracle source.
Supplemental logging must be enabled to capture the necessary changes for replication.
To fix this error, you should enable supplemental logging on the Oracle database for the specific table or tables.
This can usually be done by executing the following SQL command on the Oracle source:
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
Verify that the logging is enabled and then retry the replication task. This solution aligns with the troubleshooting steps provided in the Qlik Replicate documentation for dealing with supplemental logging errors.
The error message “Failed adding supplemental logging for table ‘Table name’” indicates that supplemental logging has not been enabled for the table in the Oracle source database. Supplemental logging is necessary for Qlik Replicate to capture the changes in the Oracle database accurately, especially for Change Data Capture (CDC) operations.
To resolve this error, you should:
Enable supplemental loggingat the database level by executing the following SQL command in the Oracle database:
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
This command enables minimal supplemental logging, which is required for Qlik Replicate to function correctly1.
If you need to enable supplemental logging for all columns, you can use the following SQL command:
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
This ensures that all necessary column data is logged for replication purposes1.
After enabling supplemental logging, verify that it is active by querying thev$databaseview:
SELECT supplemental_log_data_min FROM v$database;
The correct return value should be ‘YES’, indicating that supplemental logging is enabled1.
The other options provided are not directly related to the issue of supplemental logging:
A. Contact the Oracle DBA: While contacting the DBA might be helpful, the specific action needed is to enable supplemental logging.
B. Check the permission on the target endpoint: Permissions on the target endpoint are not related to the supplemental logging requirement on the source database.
D. Check the permission of the source endpoint: Permissions on the source endpoint are important, but the error message specifically refers to the need for supplemental logging.
Therefore, the verified answer isC. Enable supplemental logging, as it directly addresses the requirement to fix the error related to supplemental logging in Qlik Replicate21.
