My Oracle Support Banner

Cannot Save Or Re-generate Source Model For LRM-STAGING Data Source In LRS 8.0.7 (Doc ID 2642470.1)

Last updated on MAY 26, 2020

Applies to:

Oracle Financial Services Liquidity Risk Management - Version 8.0.0 and later
Information in this document applies to any platform.

Symptoms

Customer is trying to do source model generation and the the model generation is failing throwing exception.

Error Seen in SMG.log: for issue a)
[19-02-20 05:23:40,648 GMT AM] [DEBUG] [SYSADMN] [DMT] [SMGHandler]~[writeLog]~[SMG-MODEL-VALIDITY] Exception whie checking validity status- null
[19-02-20 05:23:40,650 GMT AM] [DEBUG] [SYSADMN] [DMT] [SMGHandler]~[writeLog]~ EXCEPTION WHILE GENERATING SOURCE MODEL


Error Seen in OFSAA.log from the deployed area:
[19-02-20 05:23:40,640 GMT AM]  [DEBUG] [WEB]  [NA] [DMT] [DefinitionModelToDefinitionBean]~[logThis]~[DefinitionModelToDefinitionBean] Could not find expression for Derived Column with name F_HELD_BY_CLIENT Returning null expression

For issue b) SMG.log entry:

[20-02-20 08:24:35,837 GMT AM]  [DEBUG]   [SYSADMN] [DMT] [SMGHandler]~[writeLog]~Table FFSI_DEPOSIT_INSURANCE  is part of an existing Extract/Definition but doesnot exist in the new SourceModel.
[20-02-20 08:24:35,838 GMT AM]  [DEBUG]   [SYSADMN] [DMT] [SMGHandler]~[writeLog]~So please delete or remove the table from the EXTRACTS DEFINITION
[20-02-20 08:24:35,839 GMT AM]  [DEBUG]   [SYSADMN] [DMT] [SMGHandler]~[writeLog]~----------------SOURCE MODEL GENERATION COMPLETED AT Thu Feb 20 09:24:35 WAT 2020---------------------

OFSAA.log of deployed area error message:
[20-02-20 08:24:35,835 GMT AM]  [DEBUG] [WEB]  [NA] [NA] Query -> INSERT INTO AAI_AUDIT_TRAIL (V_USER_ID, V_ACTION_CODE, V_ACTION_SUBTYPE, V_STATUS, V_ACTION_DETAILS, OPERATION_TIME, V_WORKSTATION) VALUES (?, ?, ?, ?, ?, sysdate,?)
Query Parmeters as provided -> OFSAUSER, VIEW, , AAIAUDIT.AUDIT_MSG_STAT_SUC, [AAIAUDIT.AUDIT_MSG_VIEW_TOI][DMT_DM^T2T_FCT_DEPOSIT_INSURANCE_DETAILS_POP_2^OFSINFODOM], UNDEFINED
[20-02-20 08:24:35,837 GMT AM]  [INFO ] [WEB]  [OFSAUSER] [DMT] [SMGHandler]~[writeLog]~[SMGHandler] [SMGLog for Source LRM_STAGING ] Table FFSI_DEPOSIT_INSURANCE  is part of an existing Extract/Definition but doesnot exist in the new SourceModel.
[20-02-20 08:24:35,838 GMT AM]  [INFO ] [WEB]  [OFSAUSER] [DMT] [SMGHandler]~[writeLog]~[SMGHandler] [SMGLog for Source LRM_STAGING ] So please delete or remove the table from the EXTRACTS DEFINITION
[20-02-20 08:24:35,838 GMT AM]  [ERROR] [WEB]  [OFSAUSER] [DMT] [SMGHandler]~[checkModelValidity]~[SMGHandler] SOURCE MODEL GENERATION FAILED WHILE COMPARING WITH PREVIOUS MODEL
[20-02-20 08:24:35,838 GMT AM]  [ERROR] [WEB]  [OFSAUSER] [DMT] [SMGHandler]~[generateSourceModelCatalog]~[SMGHandler] SOURCE MODEL VALIDATION FAILED WHILE COMPARING WITH PREVIOUS MODEL
[20-02-20 08:24:35,839 GMT AM]  [INFO ] [WEB]  [OFSAUSER] [DMT] [SMGHandler]~[writeLog]~[SMGHandler] [SMGLog for Source LRM_STAGING ] ----------------SOURCE MODEL GENERATION COMPLETED AT Thu Feb 20 09:24:35 WAT 2020---------------------
[20-02-20 08:24:35,839 GMT AM]  [ERROR] [WEB]  [OFSAUSER] [DMT] [SourceService]~[saveObjectAdd]~Validator Exception Occured
com.ofs.aai.exception.OFSAAValidatorException: null

Changes

 LRS 807 and 80720 installed.

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.