topic Re: tOutput error - ORA-02291: integrity constraint in Talend Studio

tOutput error - ORA-02291: integrity constraint

_AnonymousUser — Tue, 19 Nov 2013 09:22:23 GMT

Hi everyone,
I am having this error after running my job :
ORA-02291: integrity constraint - Parent key not found
I already checked the type of the Foreign Key. It is string(20) in both databases so this shouldn't be the problem.
There was a date column which I assigned to currentDate, not sure if that might be the problem.
Do you have some ideas on where I need do a modification?
thanks in advance

Re: tOutput error - ORA-02291: integrity constraint

Anonymous — Tue, 19 Nov 2013 09:37:31 GMT

Hi,

ORA-02291: integrity constraint - Parent key not found

Here is oracle doc noted this error http://www.dba-oracle.com/t_ora_02291_integrity_constraint_string_string_violated_parent_key_not_found.htm.
Screenshots of job design and component setting will be preferred.
Best regards
Sabrina

Re: tOutput error - ORA-02291: integrity constraint

Anonymous — Tue, 19 Nov 2013 09:45:21 GMT

Hello,
Thanks for your reply, I have seen this duscission already which really didn't help me because I have my FK with the same type in the other DB.
I am attaching some new screenshots :

Re: tOutput error - ORA-02291: integrity constraint

Anonymous — Tue, 19 Nov 2013 09:46:41 GMT

another image..