topic Re: CDC error in Qlik Compose

CDC error

Tool_Tip — Tue, 12 Aug 2025 05:38:50 GMT

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

Re: CDC error

rose42snowden — Thu, 14 Aug 2025 03:54:37 GMT

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.

Re: CDC error

Tool_Tip — Thu, 14 Aug 2025 03:42:15 GMT

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.