The real cause lies in his personality.

Literal

True [possessive-の] cause [topic-は] his personality [location-に] exists.

~にある ('lies in, is found in') pinpoints a location or source. 性格 ('personality/character') is what the cause is attributed to. A concise analytical statement.