Siebel System Admin, Install and Upgrade (MOSC)

MOSC Banner

8.1.1.3 SEA to 8.1.1.11 SIA UPGREP error

edited May 29, 2014 2:19AM in Siebel System Admin, Install and Upgrade (MOSC) 3 commentsAnswered
Hi all,

I'm attempting an upgrade from 8.1.1.3 SEA to 8.1.1.11 SIA. During UPGREP, I'm getting an error during Prepare for Index Creation Step (18)[Item 18]
Status = Error
Item Name = Sql File Entry 17
Title = Prepare for index creation
SQL Statement Prefix = RUN_SQL_
SQL Statement Number = 60
SQL Statement Status = Error

The error in the upgwiz.log is

"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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center