PFT / FTP 8.1.2: Data Source Resave Fails With "Table STG_CORRESPONDENT_ACCOUNT / STG_INSTRUMENT_CONTRACT_MASTER is part of an existing Extract/Definition but does not exist in the new SourceModel" Error (Doc ID 2914397.1)

Last updated on DECEMBER 16, 2022

Applies to:

Symptoms

In OFSAA 8.1.2 environment with PFT & FTP modules installed, Data Source resave fails with below error.

ERROR

[665530] Edit failed
[311502] Error validating source model with the previous version
[665536] Check <ftpshare>/<INFODOM>/dmt/source/STAGING/log/STAGING_SMG.log file for more details

From OFSAAerr.log:

[03-10-22 11:02:04,889 GMT AM] [ERROR] [WEB] [APPADMIN] [DMT] [SMGHandler]~[checkModelValidity]~[SMGHandler] SOURCE MODEL GENERATION FAILED WHILE COMPARING WITH PREVIOUS MODEL
[03-10-22 11:02:04,889 GMT AM] [ERROR] [WEB] [APPADMIN] [DMT] [SMGHandler]~[generateSourceModelCatalog]~[SMGHandler] SOURCE MODEL VALIDATION FAILED WHILE COMPARING WITH PREVIOUS MODEL
[03-10-22 11:02:04,890 GMT AM] [ERROR] [WEB] [APPADMIN] [DMT] [SourceService]~[saveObjectAdd]~Validator Exception Occured
com.ofs.aai.exception.OFSAAValidatorException: null
at com.ofs.aai.service.dmt.source.SMGHandler.checkModelValidity(SMGHandler.java:1390) ~[aai-dmt-service.jar:?]
at com.ofs.aai.service.dmt.source.SMGHandler.generateSourceModelCatalog(SMGHandler.java:1104) ~[aai-dmt-service.jar:?]
at com.ofs.aai.service.dmt.source.SMGHandler.generateSourceModel(SMGHandler.java:154) ~[aai-dmt-service.jar:?]

As per STAGING_SMG.log from FTPSHARE directory, the Staging Data Source re-save failed sequentially due to below errors:

[13-10-22 11:53:40,389 GMT AM] [DEBUG] [SYSADMN] [DMT] [SMGHandler]~[writeLog]~CHECKING VALIDITY OF EXTRACT -->T2T_ASSET_BACK_SEC
[13-10-22 11:53:40,417 GMT AM] [DEBUG] [SYSADMN] [DMT] [SMGHandler]~[writeLog]~Table STG_INSTRUMENT_CONTRACT_MASTER is part of an existing Extract/Definition but doesnot exist in the new SourceModel.
[13-10-22 11:53:40,417 GMT AM] [DEBUG] [SYSADMN] [DMT] [SMGHandler]~[writeLog]~So please delete or remove the table from the EXTRACTS DEFINITION

[07-10-22 07:32:00,733 GMT AM] [DEBUG] [SYSADMN] [DMT] [SMGHandler]~[writeLog]~CHECKING VALIDITY OF EXTRACT -->T2T_ASSET_BACK_SEC_INCR_LOAD
[07-10-22 07:32:00,788 GMT AM] [DEBUG] [SYSADMN] [DMT] [SMGHandler]~[writeLog]~Table STG_INSTRUMENT_CONTRACT_MASTER is part of an existing Extract/Definition but doesnot exist in the new SourceModel.
[07-10-22 07:32:00,789 GMT AM] [DEBUG] [SYSADMN] [DMT] [SMGHandler]~[writeLog]~So please delete or remove the table from the EXTRACTS DEFINITION

[19-10-22 09:38:38,638 GMT AM] [DEBUG] [SYSADMN] [DMT] [SMGHandler]~[writeLog]~CHECKING VALIDITY OF EXTRACT -->T2T_CORRESPONDENT_CASA
[19-10-22 09:38:38,688 GMT AM] [DEBUG] [SYSADMN] [DMT] [SMGHandler]~[writeLog]~Table STG_CORRESPONDENT_ACCOUNT is part of an existing Extract/Definition but doesnot exist in the new SourceModel.
[19-10-22 09:38:38,688 GMT AM] [DEBUG] [SYSADMN] [DMT] [SMGHandler]~[writeLog]~So please delete or remove the table from the EXTRACTS DEFINITION

[19-10-22 09:38:38,638 GMT AM] [DEBUG] [SYSADMN] [DMT] [SMGHandler]~[writeLog]~CHECKING VALIDITY OF EXTRACT -->T2T_CORRESPONDENT_CASA_INCR_LOAD
[19-10-22 09:38:38,688 GMT AM] [DEBUG] [SYSADMN] [DMT] [SMGHandler]~[writeLog]~Table STG_CORRESPONDENT_ACCOUNT is part of an existing Extract/Definition but doesnot exist in the new SourceModel.
[19-10-22 09:38:38,688 GMT AM] [DEBUG] [SYSADMN] [DMT] [SMGHandler]~[writeLog]~So please delete or remove the table from the EXTRACTS DEFINITION

[19-10-22 09:48:41,474 GMT AM] [DEBUG] [SYSADMN] [DMT] [SMGHandler]~[writeLog]~CHECKING VALIDITY OF EXTRACT -->T2T_CORRESPONDENT_CREDIT_LINE
[19-10-22 09:48:41,512 GMT AM] [DEBUG] [SYSADMN] [DMT] [SMGHandler]~[writeLog]~Table STG_CORRESPONDENT_ACCOUNT is part of an existing Extract/Definition but doesnot exist in the new SourceModel.
[19-10-22 09:48:41,512 GMT AM] [DEBUG] [SYSADMN] [DMT] [SMGHandler]~[writeLog]~So please delete or remove the table from the EXTRACTS DEFINITION

[20-10-22 12:38:32,630 GMT PM] [DEBUG] [SYSADMN] [DMT] [SMGHandler]~[writeLog]~CHECKING VALIDITY OF EXTRACT -->T2T_CORRESPONDENT_CREDIT_LINE_INCR_LOAD
[20-10-22 12:38:32,830 GMT PM] [DEBUG] [SYSADMN] [DMT] [SMGHandler]~[writeLog]~Table STG_CORRESPONDENT_ACCOUNT is part of an existing Extract/Definition but doesnot exist in the new SourceModel.
[20-10-22 12:38:32,830 GMT PM] [DEBUG] [SYSADMN] [DMT] [SMGHandler]~[writeLog]~So please delete or remove the table from the EXTRACTS DEFINITION

Issue which is similar to Document 2882833.1.

Cause

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