My Oracle Support Banner

BD 8.0.8 Language Pack Patch Issue (Doc ID 2767019.1)

Last updated on APRIL 12, 2021

Applies to:

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

Symptoms

BD 8.0.8 Language pack patch 31329982 resulted in 2 errors

[Tue 30/3/2021 11:02:54] [OFS_BD] [ INFO] - Executing file:/home/csecmbd/csecmbd808/csecmbd808/fichome2021.03.30.11.02.24/SQLScripts/ConfigSchema/TAB_LOCALE_MAP_AML.sql
[Tue 30/3/2021 11:02:54] [OFS_BD] [ERROR] - Query:'
MERGE INTO TAB_LOCALE_MAP T USING (
SELECT '1026' TAB_ID, 'CSECMBDINFO' DSN_ID, 'ja_JP' LOCALE_ID, 'アラート' TAB_NAME, 'Alerts' TAB_DESCRIPTION, 'OFS_AML' APP_ID FROM DUAL) S
ON ( T.APP_ID = S.APP_ID AND T.LOCALE_ID = S.LOCALE_ID AND T.DSN_ID = S.DSN_ID AND T.TAB_ID = S.TAB_ID )
WHEN MATCHED THEN UPDATE SET T.TAB_NAME = S.TAB_NAME, T.TAB_DESCRIPTION = S.TAB_DESCRIPTION
WHEN NOT MATCHED THEN INSERT
(TAB_ID,DSN_ID,LOCALE_ID,TAB_NAME,TAB_DESCRIPTION,APP_ID)
VALUES
(S.TAB_ID,S.DSN_ID,S.LOCALE_ID,S.TAB_NAME,S.TAB_DESCRIPTION,S.APP_ID)
'
Error:ORA-02291: integrity constraint (CONFCSECMBD.FK_TAB_LOCALE_MAP) violated - parent key not found

[Tue 30/3/2021 11:02:54] [OFS_BD] [ERROR] - Query:'
MERGE INTO TAB_LOCALE_MAP T USING (
SELECT '1027' TAB_ID, 'CSECMBDINFO' DSN_ID, 'ja_JP' LOCALE_ID, 'ケース' TAB_NAME, 'Cases' TAB_DESCRIPTION, 'OFS_AML' APP_ID FROM DUAL) S
ON ( T.APP_ID = S.APP_ID AND T.LOCALE_ID = S.LOCALE_ID AND T.DSN_ID = S.DSN_ID AND T.TAB_ID = S.TAB_ID )
WHEN MATCHED THEN UPDATE SET T.TAB_NAME = S.TAB_NAME, T.TAB_DESCRIPTION = S.TAB_DESCRIPTION
WHEN NOT MATCHED THEN INSERT
(TAB_ID,DSN_ID,LOCALE_ID,TAB_NAME,TAB_DESCRIPTION,APP_ID)
VALUES
(S.TAB_ID,S.DSN_ID,S.LOCALE_ID,S.TAB_NAME,S.TAB_DESCRIPTION,S.APP_ID)
'
Error:ORA-02291: integrity constraint (CONFCSECMBD.FK_TAB_LOCALE_MAP) violated - parent key not found

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.