IRM 8.1.1.9 To 8.1.1.11 - error ORA-00001: unique constraint (SIEBEL.S_ISS_VALDN_MSG_U1) violated in Upgrep (Doc ID 1987223.1)

Last updated on JULY 20, 2016

Applies to:

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

Symptoms

On : 8.1.1.11.11 [IP2013] version, Upgrade

When attempting to run Upgrade,
the following error occurs.

ERROR
-----------------------

UpgradeLog UpgradeInfo 3 00000002543616ec:0 2014-10-09 17:26:38 Executing SQL statement RUN_SQL_30:

insert into S_ISS_VALDN_MSG (

  ROW_ID

  , CREATED

  , CREATED_BY

  , LAST_UPD

  , LAST_UPD_BY

  , MODIFICATION_NUM

  , CONFLICT_ID

  , DB_LAST_UPD

  , DB_LAST_UPD_SRC

  , MSG_SRC_TYPE_CD

  , MSG_TYPE_CD

  , MSG_TEXT

  , MSG_LVL_CD

  )

SELECT

  VALDN_RULE.ROW_ID

  , VALDN_RULE.CREATED

  , VALDN_RULE.CREATED_BY

  , VALDN_RULE.LAST_UPD

  , VALDN_RULE.LAST_UPD_BY

  , VALDN_RULE.MODIFICATION_NUM

  , VALDN_RULE.CONFLICT_ID

  , {fn now ()}

  , 'Data Migration'

  , {fn substring(RULE_SET.NAME, 1, 30)}

  , VALDN_RULE.RETURN_CD

  , VALDN_RULE.ERR_MSG_TXT

  , CASE

  WHEN VALDN_RULE.BUSCOMP_NAME IN ('Quote','Quote Item')

  THEN 'Quote'

  WHEN VALDN_RULE.BUSCOMP_NAME IN ('Order Entry – Orders','Order Line Items')

  THEN 'Order'

  WHEN VALDN_RULE.BUSCOMP_NAME IN ('Service Agreement','FS Agreement Item')

  THEN 'Agreement'

  ELSE 'Other'

  END

FROM

  S_VALDN_RULE VALDN_RULE, S_VALDN_RL_SET RULE_SET

WHERE VALDN_RULE.RULE_SET_ID = RULE_SET.ROW_ID

  AND VALDN_RULE.VALDN_MSG_ID IS NULL

  AND VALDN_RULE.ERR_MSG_TXT IS NOT NULL

  AND NOT EXISTS (

  SELECT 'x'

  FROM S_ISS_VALDN_MSG VALDN_MSG

  WHERE VALDN_MSG.MSG_SRC_TYPE_CD = RULE_SET.NAME

  AND VALDN_MSG.MSG_TYPE_CD = VALDN_RULE.RETURN_CD

  )

  AND VALDN_RULE.ROW_ID =

  (SELECT MIN (VR.ROW_ID)

  FROM S_VALDN_RULE VR, S_VALDN_RL_SET VRS

  WHERE VR.RULE_SET_ID = VRS.ROW_ID

  AND VR.VALDN_MSG_ID IS NULL

  AND VRS.ROW_ID = RULE_SET.ROW_ID

  AND VR.RETURN_CD = VALDN_RULE.RETURN_CD

  )

  AND RULE_SET.ROW_ID = (SELECT MAX (VRS.ROW_ID)

  FROM S_VALDN_RL_SET VRS

  WHERE RULE_SET.NAME = VRS.NAME

  )

SARMLog SARMInformation 3 00000002543616ec:0 2014-10-09 17:26:38 SARM is OFF -change param SARMLevel to enable

SARMLog SARMInformation 3 00000002543616ec:0 2014-10-09 17:26:38 SARM Client is OFF -change param SARMClientLevel to enable

SARMLog SARMInformation 3 00000002543616ec:0 2014-10-09 17:26:38 SARM is OFF -change param SARMLevel to enable

SARMLog SARMInformation 3 00000002543616ec:0 2014-10-09 17:26:38 SARM Client is OFF -change param SARMClientLevel to enable

SARMLog SARMInformation 3 00000002543616ec:0 2014-10-09 17:26:38 SARM is OFF -change param SARMLevel to enable

SARMLog SARMInformation 3 00000002543616ec:0 2014-10-09 17:26:38 SARM Client is OFF -change param SARMClientLevel to enable

SQLError Statement 0 00000002543616ec:0 2014-10-09 17:26:39 SQL Statement:
  insert into S_ISS_VALDN_MSG ( ROW_ID , CREATED , CREATED_BY , LAST_UPD , LAST_UPD_BY , MODIFICATION_NUM , CONFLICT_ID , DB_LAST_UPD , DB_LAST_UPD_SRC , MSG_SRC_TYPE_CD , MSG_TYPE_CD , MSG_TEXT , MSG_LVL_CD ) SELECT VALDN_RULE.ROW_ID , VALDN_RULE.CREATED , VALDN_RULE.CREATED_BY , VALDN_RULE.LAST_UPD , VALDN_RULE.LAST_UPD_BY , VALDN_RULE.MODIFICATION_NUM , VALDN_RULE.CONFLICT_ID , {fn now ()} , 'Data Migration' , {fn substring(RULE_SET.NAME, 1, 30)} , VALDN_RULE.RETURN_CD , VALDN_RULE.ERR_MSG_TXT , CASE WHEN VALDN_RULE.BUSCOMP_NAME IN ('Quote','Quote Item') THEN 'Quote' WHEN VALDN_RULE.BUSCOMP_NAME IN ('Order Entry – Orders','Order Line Items') THEN 'Order' WHEN VALDN_RULE.BUSCOMP_NAME IN ('Service Agreement','FS Agreement Item') THEN 'Agreement' ELSE 'Other' END FROM S_VALDN_RULE VALDN_RULE, S_VALDN_RL_SET RULE_SET WHERE VALDN_RULE.RULE_SET_ID = RULE_SET.ROW_ID AND VALDN_RULE.VALDN_MSG_ID IS NULL AND VALDN_RULE.ERR_MSG_TXT IS NOT NULL AND NOT EXISTS ( SELECT 'x' FROM S_ISS_VALDN_MSG VALDN_MSG WHERE VALDN_MSG.MSG_SRC_TYPE_CD = RULE_SET.NAME AND VALDN_MSG.MSG_TYPE_CD = VALDN_RULE.RETURN_CD ) AND VALDN_RULE.ROW_ID = (SELECT MIN (VR.ROW_ID) FROM S_VALDN_RULE VR, S_VALDN_RL_SET VRS WHERE VR.RULE_SET_ID = VRS.ROW_ID AND VR.VALDN_MSG_ID IS NULL AND VRS.ROW_ID = RULE_SET.ROW_ID AND VR.RETURN_CD = VALDN_RULE.RETURN_CD ) AND RULE_SET.ROW_ID = (SELECT MAX (VRS.ROW_ID) FROM S_VALDN_RL_SET VRS WHERE RULE_SET.NAME = VRS.NAME )

DBCLog DBCLogError 1 00000002543616ec:0 2014-10-09 17:26:39 [DataDirect][ODBC Oracle driver][Oracle]ORA-00001: unique constraint (SIEBEL.S_ISS_VALDN_MSG_U1) violated


UpgradeLog UpgradeError 1 00000002543616ec:0 2014-10-09 17:26:39 [DataDirect][ODBC Oracle driver][Oracle]ORA-00001: unique constraint (SIEBEL.S_ISS_VALDN_MSG_U1) violated



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Upgrep to new version
2. The update on S_ISS_VALDN_MSG gives the error mentioned above.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, upgrade cannot continue.

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