'The destination table cannot be dropped' Errors During Model Upload for Merged Model for Version Upgrade (Doc ID 2069945.1)

Last updated on MARCH 23, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Oracle Financial Services Profitability Management - Version 6.0 and later
Oracle Financial Services Asset Liability Management - Version 6.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 6.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)

Symptoms

On OFSAA 7.3, when attempting to run model upload prior to running the upgrade from PFT 6.1.0.3 to PFT, 6.1.1, the incremental model upload fails:

ERROR

Error obtained in the ETLService log:
[ETLLOG] Oct 7,15 11:52:23 : [MODELUPLOADHELPER]Log Message::::Number of Tables in Existing Model...725
[ETLLOG] Oct 7,15 11:52:23 : [MODELUPLOADHELPER]Log Message::::Started Validating Deleted Tables and Creating Drop Table Scripts
[ETLLOG] Oct 7,15 13:23:42 : [MODELUPLOADHELPER]Log Message::::Error - Metadata Mapping is Present for Tables, so cannot Drop
[ETLLOG] Oct 7,15 13:23:42 : [CLSUCNTUPLOADHANDLER]logFileName:/opt/rpf/ofs/ftpshare/INFODOM/logs/INFODOM_LOG_121_10.07.2015-11.47.32.log
[ETLLOG] Oct 7,15 13:23:42 : [MODELUPLOADHELPER]Query IS::::UPDATE REV_MODEL_UPLOAD SET LOG='/opt/rpf/ofs/ftpshare/INFODOM/logs/INFODOM_LOG_121_10.07.2015-11.47.32.log' WHERE MODEL_ID=221340
[ETLLOG] Oct 7,15 13:23:42 : [MODELUPLOADHELPER]Output..[SC:10][ST:2][SST:0][Oper:0][Version:0][EF:false][D:INFODOM][S:null][U:null][PT:2][P:null1]
[ETLLOG] Oct 7,15 13:23:42 : [CLSUCNTUPLOADHANDLER][ETL Upload Model]String returned by Model Upload Model Upload Failed
[ETLLOG] Oct 7,15 13:23:42 : [MODELUPLOADHELPER]Log Message::::Error in Model Upload.
[ETLLOG] Oct 7,15 13:23:42 : [CLSUCNTUPLOADHANDLER]
com.iflex.fic.etl.UploadModel.cnt.ModelUploadException
  at com.iflex.fic.etl.UploadModel.cnt.ClsUCntUploadHandler.handleUpload(ClsUCntUploadHandler.java:351)
  at com.iflex.fic.etl.util.ClsUUtlETLServiceProvider.handleRequest(ClsUUtlETLServiceProvider.java:133)

From the model upload log:

Log file name is-- :/opt/rpf/ofs/ftpshare/INFODOM/logs/INFODOM_LOG_121_10.07.2015-11.47.32.log----------------------------------------------
MODEL UPLOAD STARTED AT Wed Oct 07 11:47:41 EDT 2015
Source Erwin XML File :: /opt/rpf/ofs/ftpshare/INFODOM/erwin/erwinXML/PFT_Datamodel_Merged.xml
Model Upload Mode :: Incremental Model upload (Incremental changes)
Using Erwin.xsl File at :: /opt/rpf/ofs/ofsaai/ficapp/common/FICServer/conf/Erwin95/Erwin.xsl
Target XML File :: /opt/rpf/ofs/ftpshare/INFODOM/erwin/fipxml/INFODOM_DATABASE.XML
----------------------------------------------
Information Domain : INFODOM
CURRENT VERSION IS 120
strLastProcessedDate....2015-09-05 11:17:04STARTED TRANSFORMING THE XML FILE TO DATABASE MODEL FILE AT Wed Oct 07 11:47:42 EDT 2015
COMPLETED TRANSFORMING THE XML FILE TO DATABASE MODEL FILE AT Wed Oct 07 11:51:30 EDT 2015
----------------------------------------------
STARTED SUPER CATEGORY - SUB CATEGORY HANDLING AT Wed Oct 07 11:51:42 EDT 2015
SUCCESSFULLY COMPLETED SUPER CATEGORY - SUB CATEGORY RELATIONS HANDLING AT Wed Oct 07 11:52:11 EDT 2015

Key :@@system Value:system----------------------------------------------
Inside AlterModify Component
DbType is ORACLE
NUMBER OF TABLES IN THE NEW MODEL :: 441
NUMBER OF TABLES IN THE EXISTING MODEL :: 725
----------------------------------------------
Successfully executed
Successfully executed

Inside Delete Tables.
----------------------------------------------
STARTED CHECKING FOR DELETED ITEMS
----------------------------------------------
FSI_EXCHANGE_RATE_HIST.
----------------------------------------------
FSI_RATE_DATA_SOURCE_CD.
----------------------------------------------
DIM_PRODUCT.

This table DIM_PRODUCT has been deleted in the new database model.

The destination table DIM_PRODUCT cannot be dropped as it is mapped under the Source ETLSRC in the Definition T2T_STG_LEASES_CONTRACTS_CAS.

...
Dim_Prod_Rpt_Type_Kb.

This table DIM_PROD_RPT_TYPE_KB has been deleted in the new database model.

This table DIM_PROD_RPT_TYPE_KB has data in it and hence cannot be dropped.
----------------------------------------------
MODEL UPLOAD FAILED.
----------------------------------------------
Modelupload status..Altering the Model Failed.ERWINUPLOAD ERROR..Modelupload Failed

The issue can be reproduced at will with the following steps:
1. Merge existing 6.1.0.3 data model with PFT 6.1.1 seeded data model
2. Run model upload

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms