8.1.1.3 SEA to 8.1.1.11 SIA UPGREP error
edited May 29, 2014 2:19AM in Siebel Operators: Administration, Installation, Updates (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)
0