[Spacewalk-list] 500 ISE Discovered

[Wojtak, Greg (Superfly)]

I found that when a user is created with an empty Prefix (ie, Mr.), any attempt to modify the account afterwards generates a 500 ISE.

Not necessarily a big deal, but I spent a day trying to track down why I couldn't change a user's password or set him to use PAM authentication, when it was because of this error.

>From catalina.out:

2013-01-23 11:25:10,538 [ajp-127.0.0.1-8009-18] WARN  com.redhat.rhn.common.hibernate.EmptyVarcharInterceptor - Object com.redhat.rhn.domain.user.legacy.PersonalInfo is setting empty string prefix
2013-01-23 11:25:10,539 [ajp-127.0.0.1-8009-18] WARN  com.redhat.rhn.common.hibernate.EmptyVarcharInterceptor - Object com.redhat.rhn.domain.user.legacy.PersonalInfo is setting empty string title
2013-01-23 11:25:10,544 [ajp-127.0.0.1-8009-18] WARN  org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 23502
2013-01-23 11:25:10,545 [ajp-127.0.0.1-8009-18] ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: null value in column "prefix" violates not-null constraint
2013-01-23 11:25:10,545 [ajp-127.0.0.1-8009-18] ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: could not update: [com.redhat.rhn.domain.user.legacy.PersonalInfo#147]