tOutput error - ORA-02291: integrity constraint

One Star

tOutput error - ORA-02291: integrity constraint

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
Moderator

Re: tOutput error - ORA-02291: integrity constraint

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_fou....
Screenshots of job design and component setting will be preferred.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: tOutput error - ORA-02291: integrity constraint

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 :
One Star

Re: tOutput error - ORA-02291: integrity constraint

another image..