Not effective.
Not able to assume active duty.
A member of the military who is unable to assume active duty.
Lacking the power to attract interest.
Not handsome or beautiful or appealing.
An aesthetically unattractive person