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 MAY 19, 2017

Applies to:

Siebel Sales - Version 8.2.2 SIA[22320] 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

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

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