Fresh installation of BD 812 failing (Doc ID 2991478.1)

Last updated on DECEMBER 12, 2023

Applies to:

Symptoms

BD installation failing with below errors

Log [2023-11-25 01:04:28.149] [WRAPPERINSTALLER] [ERROR] - Error occurred while executing SQL file. MERGE INTO cssms_usr_group_dsn_map_pack a
USING (SELECT 'IPEADMN' v_group_code, 'FCCMINFO' v_dsnid, 'IPEFLD' v_segment_code, 'OFS_IPE' v_app_id from dual ) b
ON (a.v_group_code = b.v_group_code and a.v_dsnid = b.v_dsnid and a.v_segment_code = b.v_segment_code and a.v_app_id = b.v_app_id)
WHEN NOT MATCHED THEN
INSERT (v_group_code, v_dsnid, v_segment_code, v_app_id)
VALUES (b.v_group_code, b.v_dsnid, b.v_segment_code, b.v_app_id) java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (OFSAACONF.FK_USR_GROUP_DSN_MAP_PACK_2) violated - parent key not found

Log [2023-11-25 01:04:28.149] [WRAPPERINSTALLER] [DEBUG] - Executing insert_cssms_usrgrp_dsn_unauth_pack.sql file ...
Log [2023-11-25 01:04:28.207] [WRAPPERINSTALLER] [ERROR] - Error occurred while executing SQL file. MERGE INTO cssms_usrgrp_dsn_unauth_pack a
USING (SELECT 'IPEADMN' v_group_code, 'FCCMINFO' v_dsnid, 'IPEFLD' v_segment_code, 'OFS_IPE' v_app_id , 'A' recordstat, 'A' operation, 'SYSADMN' modified_by from dual ) b
ON (a.v_group_code = b.v_group_code and a.v_dsnid = b.v_dsnid and a.v_segment_code = b.v_segment_code and a.v_app_id = b.v_app_id)
WHEN NOT MATCHED THEN
INSERT (v_group_code, v_dsnid, v_segment_code, v_app_id, recordstat, operation, modified_by)
VALUES (b.v_group_code, b.v_dsnid, b.v_segment_code, b.v_app_id, b.recordstat , b.operation, b.modified_by) java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (OFSAACONF.FK_CSSMS_USRGRP_DSN_UNAUTH_2) violated - parent key not found

Cause

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