Kash Patel has alarmed colleagues with episodes of excessive drinking and unexplained absences.