Siebel System Admin, Install and Upgrade (MOSC)

MOSC Banner

Database upgrade failed at Repository data upgrade step

edited May 29, 2014 2:19AM in Siebel System Admin, Install and Upgrade (MOSC) 11 commentsAnswered ✓
Hi,
We are upgrading from Siebel 7.8.2.14 to 8.1.1.7. Right now we're in the Upgrade siebel database stage.

We ran the upgrep and it failed at the Repository data upgrade step. The error I received was cannot update ("SIEBEL"."S_USER_KEY_ATT"."NAME") to NULL. Below is the statement which was failing-

RUN_SQL_220 =
update S_USER_KEY_ATT
set NAME =
(select    C6.NAME || '/'
        || C5.NAME || '/'
        || C4.NAME || '/'
        || C3.NAME || '/'
        || C2.NAME || '/'
        || C1.NAME
from S_UK_ATTJOIN UKAJ_PJ
,    S_COLUMN     C1
,    S_UK_ATTJOIN UKAJ_IJ
,    S_COLUMN     C2

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