Midlevel managers who fail to live up to expectations may need to let go of some of the traits that made them rock stars in their previous positions.