id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
1208	dettool -revertresidexp fails on foreign key constraint	eugene	eugene	"this revert fails because other steps (detreject) have already moved ahead.  this suggests a problem with the constraints

ipp004: dettool -dbname gpc1 -revertresidexp -det_id 100
 p_psDBRunQuery (psDB.c:812) : Failed to execute SQL query.  Error: Cannot delete or update a parent row: a foreign key constraint fails (`gpc1/detRunSummary`, CONSTRAINT `detRunSummary_ibfk_2` FOREIGN KEY (`det_id`, `iteration`) REFERENCES `detResidExp` (`det_id`, `iteration`))
 revertresidexpMode (dettool_residexp.c:291) : database error


 -> p_psDBRunQuery (psDB.c:812): Database error generated by the server
     Failed to execute SQL query.  Error: Cannot delete or update a parent row: a foreign key constraint fails (`gpc1/detRunSummary`, CONSTRAINT `detRunSummary_ibfk_2` FOREIGN KEY (`det_id`, `iteration`) REFERENCES `detResidExp` (`det_id`, `iteration`))
 -> revertresidexpMode (dettool_residexp.c:291): unknown psLib error
     database error
"	defect	assigned	low		ippTools		minor