My Oracle Support Banner

OHF 7.3 Install Fails While Creating Seed Data Entries (Doc ID 2716029.1)

Last updated on OCTOBER 01, 2020

Applies to:

Oracle Healthcare Foundation - Version 7.1.1 and later
Information in this document applies to any platform.

Symptoms

Oracle Healthcare Foundation - Version 7.1.1 and later

When upgrading OHF 7.1.1 to 7.3, the installer failed while creating "Seed Data Entries" with the following error messages.


ERROR
-----------------------
 
****************************************************************************
Line 855586: FAIL 10979: 'ORA-06512: at', Rule 'pragma err forever ^ORA-.*'
****************************************************************************
old 2: hdm_seed_data_extract_proc('&&hdm_seed_data_overwrite');
new 2: hdm_seed_data_extract_proc('N');
Processing table:HDM_USER
Processing table:HDM_CD_TYP
Processing table:HDM_CD_SYS
Processing table:HDM_CD_REPOSITORY
Processing table:HDM_CD_REPOSITORY_CD_TYP
Trace info: Sqlcode:-1; sqlerrmORA-00001: unique constraint
(HDM.HDM_CD_REPOSITORY_CD_TYP_UK) violated;backtrace:ORA-06512: at
"HDM.HDM_SEED_DATA_VALIDATION_PROC", line 167
ORA-06512: at
"HDM.HDM_SEED_DATA_VALIDATION_PROC", line 167
PL/SQL_ERROR: Error code
PRSNT_ON_ADMSN_CNRN_CD_Y~EHA_CUSTOM_CD_SYS~1.0~PRSNT_ON_ADMSN_CNRN_CD-1:

**************************************************************************************************************************************
Line 855591: FAIL 10984: 'ORA-00001: unique constraint (HDM.HDM_CD_REPOSITORY_CD_TYP_UK) violated', Rule 'pragma err forever ^ORA-.*'
**************************************************************************************************************************************
Processing table:HDM_CD_REPOSITORY
Processing table:HDM_CD_REPOSITORY_CD_TYP
Trace info: Sqlcode:-1; sqlerrmORA-00001: unique constraint
(HDM.HDM_CD_REPOSITORY_CD_TYP_UK) violated;backtrace:ORA-06512: at
"HDM.HDM_SEED_DATA_VALIDATION_PROC", line 167
ORA-06512: at
"HDM.HDM_SEED_DATA_VALIDATION_PROC", line 167
PL/SQL_ERROR: Error code
PRSNT_ON_ADMSN_CNRN_CD_Y~EHA_CUSTOM_CD_SYS~1.0~PRSNT_ON_ADMSN_CNRN_CD-1:
ORA-00001: unique constraint (HDM.HDM_CD_REPOSITORY_CD_TYP_UK) violated
Processing table:HDM_ATRB_CD_TYP_LKUP_G
Processing table:HDM_MAP_TYP
Processing table:HDM_ATRB_CD_SYS_LKUP_G
Refer to hdm_x_seed_data_err_log temp table for seed data related errors.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Start OHF 7.3 upgrade,
2. The installer failed with the above errors

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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