A report found what Mayor Lori Lightfoot called a “series of ethical lapses”, including over an incident where he was found asleep in a parked car asleep at the wheel.