My Oracle Support Banner

Install of OFS_BD_PACK failing when run in offline mode (Doc ID 2833384.1)

Last updated on JANUARY 12, 2024

Applies to:

Oracle Financial Services Behavior Detection Platform - Version 8.0 and later
Information in this document applies to any platform.

Symptoms

BD 808 installation is failing with the below error :

Error occurred while executing SQL file. insert into CSSMS_SEGMENT_MAST (V_DSNID, V_SEGMENT_CODE, V_SEGMENT_NAME, V_SEGMENT_DESC, V_CREATED_BY, D_CREATED_DATE, V_LAST_MODIFIED_BY, D_LAST_MODIFIED_DATE, V_SEGMENT_TYPE, V_OWNER_CODE)
 values ('', 'IPEFLD', 'IPEFLD', 'Inline Processing Folder', 'SYSADMN', to_char(sysdate, 'MM/DD/YYYY HH24:MM:SS'), 'SYSADMN', to_char(sysdate, 'MM/DD/YYYY HH24:MM:SS'), 'PUBLIC', 'SYSADMN') java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("FCCMCONF"."CSSMS_SEGMENT_MAST"."V_DSNID")

Log [2021-10-06 02:59:45.505] [WRAPPERINSTALLER] [ERROR] - Error occurred while executing SQL file. INSERT INTO INFODOM_PATCHES (V_INFODOM,N_SERIAL_NO,V_PATCH_NAME,V_APP_ID,V_REMARKS,D_APPLIED_DATE) (SELECT '',(select MAX(N_SERIAL_NO) + 1 from INFODOM_PATCHES),'8.0.8.0.0','OFSIPE','Financial Services Inline Processing Engine',SYSDATE from dual where not exists (SELECT V_INFODOM,V_PATCH_NAME,V_APP_ID,V_REMARKS FROM INFODOM_PATCHES WHERE V_INFODOM='' AND V_APP_ID='OFSIPE' AND V_PATCH_NAME='8.0.8.0.0')) java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("FCCMCONF"."INFODOM_PATCHES"."V_INFODOM")

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
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.