>I have found 159743 out of 2 millions records which are orphans. As a test, I need to remove those records and execute the application again to see if that was really the factor.

Yes, sounds like a plan. Good luck!