Error while running Upgrade to 8.2.2 > Upgrep: ORA-01427: single-row subquery returns more than one row
(Doc ID 1492666.1)
Last updated on JANUARY 30, 2020
Applies to:
Siebel Sales - Version 8.2.2 SIA[22320] and laterSiebel CRM - Version 16.10 [IP2016] to 16.10 [IP2016] [Release V16]
Information in this document applies to any platform.
Check on Currency: 12/09/2014
Symptoms
Error while running Upgrade > Upgrep from Siebel 8.0 SEA to Siebel 8.2.2 SIA.
Failed step: Prepare for index creation - preschm.sql file
LError Statement 0 00000002504e1818:0 2012-09-10 13:53:03 SQL Statement:
UPDATE S_AUDIT_ITEM SET S_AUDIT_ITEM.BC_BASE_TBL = (SELECT BC.TABLE_NAME FROM S_BUSCOMP BC WHERE S_AUDIT_ITEM.BUSCOMP_NAME = BC.NAME ) WHERE S_AUDIT_ITEM.BC_BASE_TBL IS NULL AND EXISTS (SELECT 'FOUND' FROM S_BUSCOMP BC2 WHERE BC2.NAME = S_AUDIT_ITEM.BUSCOMP_NAME)
DBCLog DBCLogError 1 00000002504e1818:0 2012-09-10 13:53:03 [tp][ODBC Oracle driver][Oracle]ORA-01427: single-row subquery returns more than one row
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |