[Spacewalk-list] 500 ISE Discovered

[Jan Pazdziora]

On Wed, Jan 23, 2013 at 04:31:43PM +0000, Wojtak, Greg (Superfly) wrote:
> 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

I assume this is on the PostgreSQL database. I just tried on
Spacewalk 1.9 that updating page on

	/rhn/users/UserDetails.do?uid=...

with empty prefix passes just fine. How do you update the user
information -- on WebUI or otherwise?

-- 
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat