Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

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
Labels (2)
3 Replies
Anonymous
Not applicable

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
Anonymous
Not applicable

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 :
0683p000009MBly.png
Anonymous
Not applicable

another image..
0683p000009MBVD.png