[Talend 6.1.1] Problem toracleouput insert or update

[Anonymous]

Hello,

I have a problem when I use toracleoutput with "insert or update" parameter.

I have this error : ORA-00001: unique constraint (string.string) violated

But when I use the parameter "Update", it works well.

I don't understand, because i have the key in my schema.

[Anonymous]

Hi,
Did you use only one key in your schema? Could you please post the screenshot of your tOracleOutput component setting? Does this isssue repro when you use "Update or Insert"?
Best regards
Sabrina

[Anonymous]

Hi Sabrina,

I have the same problem with "update or insert"
here the screenshot:



it works well with "update".
Thanks in advance for your feedback.

[Anonymous]

Hi,
ORA-00001: unique constraint (string.string) violated
This issue is caused by An UPDATE or INSERT statement attempted to insert a duplicate key. For Trusted Oracle configured in DBMS MAC mode, you may see this message if a duplicate entry exists at a different level.
Is there any unique restriction for you? Have you tried to remove it to see if it works?
Best regards
Sabrina

[Anonymous]

If I delete the line it works.

But I do not understand why it works on "update" 
If the line already exist, it does not use update of the 'insert or update" parameter ? 

[Anonymous]

Hi,
What's the line you are referring to? It seems that you cannot use any "INSERT" operation(insert, update or insert, insert or update) for your current scenario.
Best regards
Sabrina