My Oracle Support Banner

Cannot Save or Re-generate Source Model for STAGING Data Source in 8.0.7 (Doc ID 2518110.1)

Last updated on FEBRUARY 03, 2021

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.7 and later
Oracle Financial Services Profitability Management - Version 8.0.7 and later
Oracle Financial Services Asset Liability Management - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Out of the box (OOTB)

Symptoms

For Oracle Financial Services Profitability Management (PFT) or Asset Liability Management (ALM) 8.0.7, in Data Management Tools > Data Sources, when you edit the seeded OOTB STAGING Data Source and click 'Save' to re-generate the Source Model, the following errors appear:

[665530] Edit failed
[665506] Exception occurred : com.ofs.aai.service.OFSAAServiceException: java.lang.NullPointerException
[665536] Check /u01/ofsaa/ftpshare//<INFODOM>/dmt/source/STAGING/log/STAGING_SMG.log file for more details

 

Additionally, in the STAGING_SMG.log, the following error exists for T2T_CUST_CUST_RELATION:

~CHECKING VALIDITY OF EXTRACT -->T2T_CUST_CUST_RELATION
.
.
.
Could not find expression for Derived Column with name n_cust_skey Returning null expression
~Exception Occured.
java.lang.NullPointerException
       at com.ofs.aai.service.dmt.def.DefinitionModelToDefinitionBean.getBeanFromDMTMappingDetailsObject(DefinitionModelToDefinitionBean.java:232)
       at com.ofs.aai.service.dmt.def.DefinitionService.getObject(DefinitionService.java:2198)
       at com.ofs.aai.service.dmt.client.DMTClient.getMetadataObject(DMTClient.java:339)
       at com.ofs.aai.service.dmt.client.DMTClient.getMetadataObject(DMTClient.java:297)
       at com.ofs.aai.service.dmt.source.SMGHandler.getDefinitionDetails(SMGHandler.java:1188)
       at com.ofs.aai.service.dmt.source.SMGHandler.checkModelValidity(SMGHandler.java:1223)
       at com.ofs.aai.service.dmt.source.SMGHandler.generateSourceModelCatalog(SMGHandler.java:982)
       at com.ofs.aai.service.dmt.source.SMGHandler.generateSourceModel(SMGHandler.java:151)
       at com.ofs.aai.service.dmt.source.SourceService.saveObjectAdd(SourceService.java:1058)
       at com.ofs.aai.service.dmt.source.SourceService.saveAsObjectEdit(SourceService.java:1971)
       at com.ofs.aai.service.dmt.client.DMTClient.saveAsObjectVersion(DMTClient.java:668)
       at com.ofs.aai.service.dmt.client.DMTClient.saveAsObjectVersion(DMTClient.java:588)
       at com.ofs.aai.service.dmt.ojff.DMTSrcDetailed.saveForm(DMTSrcDetailed.java:2519)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
       etc.
.
.
.
~OFSAAServiceException : Object fetch failed for Object Type : DMT_DM
      com.ofs.aai.service.OFSAAServiceException: java.lang.NullPointerException
.
.
.
Caused by: java.lang.NullPointerException
       at com.ofs.aai.service.dmt.def.DefinitionModelToDefinitionBean.getBeanFromDMTMappingDetailsObject(DefinitionModelToDefinitionBean.java:232)
       at com.ofs.aai.service.dmt.def.DefinitionService.getObject(DefinitionService.java:2198)
       ... 57 more
~Unable to fetch details for definition T2T_CUST_CUST_RELATION
Exception whie checking validity status- null
Exception whie checking validity status- null
SOURCE MODEL GENERATION FAILED WHILE COMPARING WITH PREVIOUS MODEL

These errors prevent you from re-generating the Source Model.

Note: Depending on the version of OFSAAI 8.0.7, the detailed error may be output to the OFSAA.log in the web server's OFSAA log directory.

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.