Email in activity log shows "No such parent record"
Most possible is that sent email is not associated to the Target record
1) Check the sent email to make sure it is associated with the right target table.
2) If the target record is not associated , most probably there is a custom business rule on the sys_email which changes the target table associated to the record. The email should be associated to the same table on which the notification is configured .