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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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