Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
muralam
Creator

ORA-00001: unique constraint violated

Hi ,

 

I am trying to insert an existing record into target table, where there is a primary key, even though when i try to insert a record which is already present, is there any way in talend to ignore the below erro in run console and process the other records. i have unchecked die on error option still i am getting the below error at each row in run console

ORA-00001: unique constraint (project.SYS_C005268) violated

 

Regards,

Meena

Labels (2)
3 Replies
Anonymous
Not applicable

There are a couple of ways to avoid this. You can use the "insert or update" option for "Action on data" of your db component. To do this you will also need to switch on "Field options" on the Advanced Settings tab. This will update any records that already exist.

 

If you do not want to update any records you can use a tMap and the table you are writing to as a lookup for the tMap. When your data comes into the tMap you can check to see if it can be joined on the primary key. If it can't then it can be loaded. If it can be joined, it means the data is already there and should be filtered out.

 

Both of those ways are better than just ignoring error messages.

Ganshyam
Creator II

 Basic Setting --> Uncheck the Die on Error.

 Advanced Setting --> Uncheck the Batch Size.

Anonymous
Not applicable


@Ganshyam wrote:

 Basic Setting --> Uncheck the Die on Error.

 Advanced Setting --> Uncheck the Batch Size.


Actually, that doesn't suppress the warnings (on the contrary, the will be many more), but it enables TOS to proceed with the following records. Thus, it is probably the easiest workaround. Thanks!