...
[18:12:59 CDT(-0500)] <GregElliott> many of the coaches in external_person had empty string for coach_school_id, and that was causing it to break.
[18:13:51 CDT(-0500)] <GregElliott> we set those coach external_person rec's to have null instead '' in coach_school_id, and that seems to have remedied that issue.
[18:14:49 CDT(-0500)] <GregElliott> we will advise IRSC about the data fix, talk about the short term from their side (put null instead of '' in that field), long term open a ticket to that '' in that field gets treated same as null.