These things are almost always related to sex outside of marriage; either a subordinate or the spouse of another military member. If it was financial problems or alcoholism, he would have just been reassigned or, more likely, just retired.