topic Re: [Talend 6.1.1] Problem toracleouput insert or update in Talend Studio

[Talend 6.1.1] Problem toracleouput insert or update

Anonymous — Wed, 22 Mar 2017 16:53:50 GMT

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.

Re: [Talend 6.1.1] Problem toracleouput insert or update

Anonymous — Thu, 23 Mar 2017 02:44:07 GMT

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

Re: [Talend 6.1.1] Problem toracleouput insert or update

Anonymous — Thu, 23 Mar 2017 08:25:07 GMT

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.

Re: [Talend 6.1.1] Problem toracleouput insert or update

Anonymous — Thu, 23 Mar 2017 08:34:15 GMT

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

Re: [Talend 6.1.1] Problem toracleouput insert or update

Anonymous — Thu, 23 Mar 2017 10:49:55 GMT

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 ?

Re: [Talend 6.1.1] Problem toracleouput insert or update

Anonymous — Fri, 24 Mar 2017 08:00:56 GMT

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