Description of Problem: If the user sets Address1 to one of more spaces, then it does not get populated with the default of "." and therefore when we attempt to insert into the web_user_site_info record, we get a traceback. The error is: Traceback (innermost last): File "/var/www/rhns/server/apacheServer.py", line 37, in __call__ ret = f(req) File "/var/www/rhns/server/rhnServer.py", line 163, in handler ret = self.__xmlrpcCall(server, methodName, params, req) File "/var/www/rhns/server/rhnServer.py", line 507, in __xmlrpcCall raise rhns_oracle.OracleError(e) OracleError: (1407, 'ORA-01407: cannot update +("WEB"."WEB_USER_SITE_INFO"."ADDRESS1") to NULL\012', {'SQL': 'update +web_user_site_info set alt_first_names = :p_alt_first_names, state = +:p_state, country = :p_country, alt_last_name = :p_alt_last_name, address1 = +:p_address1 where id = :p0', 'Params': [(':p0', 2049647), (':p_address1', +''), (':p_alt_first_names', 'C'), (':p_alt_last_name', 'Bailey'), +(':p_country', 'CA'), (':p_state', 'British Columbia')]}) Version-Release number of selected component (if applicable): How Reproducible: Always Steps to Reproduce: 1. 2. 3. Actual Results: Expected Results: Need to make sure that spaces count as null and therefore those mandatory fields get populated with "." Additional Information:
Bret McMillian taking a look at this - but holding off on assigning it for now.
This need to be fixed in the rhn_register itself. Assigning to alikins
The error looks like a oracle server side error to me, but either way, I cant seem to duplicate this with the client. jay/joe: Mind showing me how to trigger it?
ping, can duplicate this... gonna close if no other info
Seems to work fine. Closing.