Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Tool_Tip
Creator III
Creator III

CDC error

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

Labels (1)
2 Replies
rose42snowden
Contributor
Contributor

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.

 

Tool_Tip
Creator III
Creator III
Author

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.