My Oracle Support Banner

Data Source Save Fails With 'Column <COLUMN> is part of an existing Extract/Definition but is not present in the new SourceModel' (Doc ID 2816558.1)

Last updated on OCTOBER 27, 2021

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.1.0.0.0 and later
Oracle Financial Services Data Foundation - Version 8.1.0.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)

Symptoms

In Data Management Tools > Data Source, when you edit and save an existing T2T Source, the save fails with the following message displayed:

[665530] Edit failed
[311502] Error validating source model with the previous version
[665536] Check /<FTPSHARE>///<INFODOM>/dmt/source/<DATA SOURCE>/log/<DATA SOURCE>_SMG.log file for more details
 

The following error exists in the <DATA SOURCE>_SMG.log from the directory /<LOCAL PATH>/<Infodom>/dmt/source/<DATA SOURCE>/log:

[24-09-21 14:38:26,190 GMT PM] [DEBUG] [<USER>] [DMT] [SMGHandler]~[writeLog]~CHECKING VALIDITY OF EXTRACT -->T2T_CASA
[24-09-21 14:38:26,283 GMT PM] [DEBUG] [<USER>] [DMT] [SMGHandler]~[writeLog]~Column STG_CASA.N_EOP_BALANCE_SAVINGS is part of an existing Extract/Definition but is not present in the new SourceModel.
[24-09-21 14:38:26,283 GMT PM] [DEBUG] [<USER>] [DMT] [SMGHandler]~[writeLog]~So please delete or remove the column from the EXTRACT/ DEFINITION
[24-09-21 14:38:26,284 GMT PM] [DEBUG] [<USER>] [DMT] [SMGHandler]~[writeLog]~----------------SOURCE MODEL GENERATION COMPLETED AT Fri Sep 24 09:38:26 CDT 2021---------------------


Note: The "Local Path" directory is listed in WEB_SERVER_INFO.  It is usually defaulted to the ftpshare 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.