8.0 To 8.1 Upgrade Exception: ORA-02291: Integrity Constraint (ARGUS_APP.FK2_CODE_LIST_DETAIL_DISCRE (Doc ID 2484018.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

While performing the upgrade from 8.0 to 8.1, the following error occurred during execution of file \SQL81\Argus_81_flex_bucket_CODE_LIST_DETAIL_DISCRETE_data_change1.sql\SQL81\Argus_81_flex_bucket_CODE_LIST_DETAIL_DISCRETE_data_change1.sql

ERROR
=====
ORA-02291: integrity constraint (ARGUS_APP.FK2_CODE_LIST_DETAIL_DISCRE

The statement which was running when the error is thrown is as follows:

INSERT INTO ARGUS_APP.code_list_detail_discrete
  (code_list_id, decode_context, code, display_value, preferred,
  sort, last_update_time, enterprise_id)
  SELECT clca.code_list_id, 'ja' decode_context, clca.code,
  (CASE clca.code
  WHEN '1'
  THEN 'ヒスパニックまたはラテン系'
  WHEN '2'
  THEN '非ヒスパニックまたは非ラテン系'
  WHEN '3'
  THEN '不明'
  WHEN '4'
  THEN '情報なし'
  END
  ) display_value,
  0, NULL, NULL, clca.enterprise_id
  FROM code_list_code_attributes clca
  WHERE UPPER (clca.code_list_id) = 'ETHNIC_GROUP' AND clca.deleted IS NULL

Both tables do not contain data when performing the following selects:

select count(1) from argus_app.code_list_code_attributes
and
select count(1) from code_list_detail_discrete.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.