Bug 118511

Summary:	cms upgrade from 6.0.0 to 6.0.1 : bug in sql script update-bundle-type-id.sql
Product:	[Retired] Red Hat Enterprise CMS	Reporter:	durnez <vdurnez>
Component:	other	Assignee:	ccm-bugs-list
Status:	CLOSED RAWHIDE	QA Contact:	Jon Orris <jorris>
Severity:	medium	Docs Contact:
Priority:	medium
Version:	6.0
Target Milestone:	---
Target Release:	---
Hardware:	All
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2004-03-17 19:05:45 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:	108447

Description durnez 2004-03-17 08:42:28 UTC

Description of problem:

when running :
cms/sql/default/upgrade/6.0.0-6.0.1/update-bundle-type-id.sql

and with a database having a content item with several pending instances, 
the following error occurs :
ERROR at line 1:
ORA-01427: single-row subquery returns more than one row

The reason why this exception occurs is because the inner query
retrieves several values when the content item has several pending
instances.

The solution is to replace in file
cms/sql/default/upgrade/6.0.0-6.0.1/update-bundle-type-id.sql
 :
> set type_id = (select i.type_id
by
> set type_id = (select distinct i.type_id

Version-Release number of selected component (if applicable):
CMS 6.0.0 (for upgrade to 6.0.1)

How reproducible:
always

Comment 1 Dennis Gregorovic 2004-03-17 19:05:45 UTC

Thanks for catching this.  The changes have been checked in.