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 MAY 06, 2024
Applies to:
Oracle Financial Services Analytical Applications Infrastructure - Version 8.1.0.0.0 and laterOracle 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 |