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

Last updated on APRIL 20, 2023

Applies to:

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

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