The CIA would have asked him directly about affairs or other blackmailable issues. As long as Petraeus was honest about his activities (within limits) then he would get a pass on the security check.
Was the shirtless FBI whistleblower who contacted Cantor the one to throw a wrench in the deal?