I am having the same issue here is my scenario
i put empty('') where value is NULL
now this '' value does not match with the parent table's id
here is things need to check , all value with presented in parent table
otherwise remove data from parent table then try