Database upgrade failed at Repository data upgrade step
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
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
0