Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts
We are getting below error on qlik compose cdc task
Terminated: sqlstate 23000, errorcode 1, message ORA-00001: unique constraint (DWH.UN_2660_H) violated Cause:
kindly assist
The error "ORA-00001: unique constraint (DWH.UN_2660_H) violated" in your Qlik Compose CDC task indicates that the task is attempting to insert a duplicate record into a table that has a unique constraint. This usually happens when the source table has duplicate primary keys or unique values, which the CDC process is trying to replicate. To fix this, you need to identify and remove the duplicate records from your source data or modify your Qlik Compose PaybyPlateMa task to handle these duplicates gracefully, possibly by using an update instead of an insert if the record already exists.
Dear Rose,
I have checked and found that there is no duplicate records into source table as well as in RPL table.
All records are unique.