Bug 221354

Summary:	ISE on uploading a null path
Product:	[Retired] Red Hat Network	Reporter:	Partha Aji <paji>
Component:	RHN/Web Site	Assignee:	Partha Aji <paji>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Preethi Thomas <pthomas>
Severity:	medium	Docs Contact:
Priority:	medium
Version:	RHN Stable	CC:	rhn-bugs
Target Milestone:	---
Target Release:	---
Hardware:	All
OS:	Linux
URL:	http://rhn.webdev.redhat.com/rhn/systems/details/configuration/addfiles/UploadFile.do?sid=1007116742
Whiteboard:
Fixed In Version:	rhn500h	Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2007-03-13 03:09:17 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:
Bug Blocks:	192224

Description Partha Aji 2007-01-04 00:27:09 UTC

Description of problem:
1) Register a system to hosted
2) Provide provisioning to that system
3) Navigate to the SDC Configuration page of that system
4) Click on add files
5) Leave the "File to Upload:" & "Filename/Path:" blank and Select "Upload
Configuration File"

Notice the ISE..

Comment 1 Partha Aji 2007-01-04 00:33:41 UTC

com.redhat.rhn.common.db.WrappedSQLException: ORA-01400: cannot insert NULL into
("RHN"."RHNCONFIGFILENAME"."PATH")
ORA-06512: at "RHN.LOOKUP_CONFIG_FILENAME", line 17
ORA-01403: no data found
ORA-06512: at line 1

	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
	at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:215)
	at
oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:954)
	at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
	at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
	at
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3390)
	at
oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4223)
	at
net.rkbloom.logdriver.LogCallableStatement.execute(LogCallableStatement.java:148)
	at
com.mchange.v2.c3p0.impl.NewProxyCallableStatement.execute(NewProxyCallableStatement.java:912)
	at
com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:111)
	at
com.redhat.rhn.common.db.datasource.CachedStatement.executeCallable(CachedStatement.java:415)
	at com.redhat.rhn.common.db.datasource.CallableMode.execute(CallableMode.java:30)
	at
com.redhat.rhn.domain.config.ConfigurationFactory.lookupConfigFileName(ConfigurationFactory.java:610)
	at
com.redhat.rhn.domain.config.ConfigurationFactory.lookupOrInsertConfigFileName(ConfigurationFactory.java:590)
	at
com.redhat.rhn.manager.configuration.ConfigurationManager.lookupConfigFile(ConfigurationManager.java:1657)
	at
com.redhat.rhn.frontend.action.configuration.BaseAddFilesAction.fileExists(BaseAddFilesAction.java:180)
	at
com.redhat.rhn.frontend.action.configuration.BaseAddFilesAction.execute(BaseAddFilesAction.java:67)
	at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
	... 51 more
Caused by: 
java.sql.SQLException: ORA-01400: cannot insert NULL into
("RHN"."RHNCONFIGFILENAME"."PATH")
ORA-06512: at "RHN.LOOKUP_CONFIG_FILENAME", line 17
ORA-01403: no data found
ORA-06512: at line 1

Comment 2 Grant Gainey 2007-01-17 17:34:18 UTC

Retest - BaseAddFiles shouldn't even get as far as fileExists() if there's no
upload specified.  Possibly fixed as of 10-JAN

Comment 3 Partha Aji 2007-02-13 01:43:09 UTC

This has now been resolved.. QA - Please make sure you test nulling out other
fields on this page...

Comment 4 Partha Aji 2007-02-15 22:15:46 UTC

Moving to ON_QA

Comment 5 Partha Aji 2007-02-15 22:17:31 UTC

Moving to ON_QA

Comment 6 Preethi Thomas 2007-02-16 14:32:21 UTC

verified

Comment 7 Preethi Thomas 2007-03-06 21:46:13 UTC

verified in stage.

Comment 8 Brandon Perkins 2007-03-13 03:09:17 UTC

Closed in the rhn500h Release.