Have you checked for invalid data that may make the foreign key fail (maybe some data has been deleted in the parent table in between data transfers)?