Error In Upgrading From 7.7 SIA To 8.1.1.11 SIA -ISS (Doc ID 1671816.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel System Software - Version 8.0.0.11[20440] and later
Information in this document applies to any platform.

Symptoms

Environment
==========
V8.0.0.11

Description
=========

During the upgrade, the upgrade is failing at the following:

insert into S_VOD (
 ROW_ID
,CREATED
,CREATED_BY
,LAST_UPD
,LAST_UPD_BY
,MODIFICATION_NUM
,CONFLICT_ID
,LOCKED_FLG
,OBJECT_NUM
,VOD_TYPE_CD
,VOD_NAME
,DESC_TEXT)
select
 T.NEW_RLSD_ROW_ID
,P.CREATED
,P.CREATED_BY
,P.LAST_UPD
,P.LAST_UPD_BY
,P.MODIFICATION_NUM
,P.CONFLICT_ID
,'N'
,P.ROW_ID
,'ISS_PROD_DEF'
,{fn concat ({fn rtrim({fn LEFT(P.NAME,85)})}, P.ROW_ID)}
,{fn rtrim({fn LEFT(P.DESC_TEXT,250)})}
from S_PROD_INT P,
  TMPTBL_PRDROWID T
where P.ROW_ID = T.ROW_ID
and exists (select 'x' from TMPTBL_RUNISS77)
UpgradeLog UpgradeInfo 3 00000002528c0f70:0 2013-11-20 17:12:50 Executing SQL statement RUN_SQL_590:
insert into S_VOD (
 ROW_ID
,CREATED
,CREATED_BY
,LAST_UPD
,LAST_UPD_BY
,MODIFICATION_NUM
,CONFLICT_ID
,LOCKED_FLG
,OBJECT_NUM
,VOD_TYPE_CD
,VOD_NAME
,DESC_TEXT)
select
 T.NEW_RLSD_ROW_ID
,P.CREATED
,P.CREATED_BY
,P.LAST_UPD
,P.LAST_UPD_BY
,P.MODIFICATION_NUM
,P.CONFLICT_ID
,'N'
,P.ROW_ID
,'ISS_PROD_DEF'
,{fn concat ({fn rtrim({fn LEFT(P.NAME,85)})}, P.ROW_ID)}
,{fn rtrim({fn LEFT(P.DESC_TEXT,250)})}
from S_PROD_INT P,
  TMPTBL_PRDROWID T
where P.ROW_ID = T.ROW_ID
and exists (select 'x' from TMPTBL_RUNISS77)
SQLError Statement 0 00000002528c0f70:0 2013-11-20 17:13:52 SQL Statement:
  insert into S_VOD ( ROW_ID ,CREATED ,CREATED_BY ,LAST_UPD ,LAST_UPD_BY ,MODIFICATION_NUM ,CONFLICT_ID ,LOCKED_FLG ,OBJECT_NUM ,VOD_TYPE_CD ,VOD_NAME ,DESC_TEXT) select T.NEW_RLSD_ROW_ID ,P.CREATED ,P.CREATED_BY ,P.LAST_UPD ,P.LAST_UPD_BY ,P.MODIFICATION_NUM ,P.CONFLICT_ID ,'N' ,P.ROW_ID ,'ISS_PROD_DEF' ,{fn concat ({fn rtrim({fn LEFT(P.NAME,85)})}, P.ROW_ID)} ,{fn rtrim({fn LEFT(P.DESC_TEXT,250)})} from S_PROD_INT P, TMPTBL_PRDROWID T where P.ROW_ID = T.ROW_ID and exists (select 'x' from TMPTBL_RUNISS77)

DBCLog DBCLogError 1 00000002528c0f70:0 2013-11-20 17:13:52 [tp][ODBC Oracle driver][Oracle]ORA-00001: unique constraint (SIEBEL.S_VOD_U2) violated


UpgradeLog UpgradeError 1 00000002528c0f70:0 2013-11-20 17:13:52 [tp][ODBC Oracle driver][Oracle]ORA-00001: unique constraint (SIEBEL.S_VOD_U2) violated


Impact
=====

Not available.

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