Error while running Upgrade to 8.2.2 > Upgrep: ORA-01427: single-row subquery returns more than one row
Last updated on MAY 19, 2017
Applies to:Siebel Sales - Version 8.2.2 SIA and later
Siebel 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
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms