Model Upload Fails with 'Error - Metadata Mapping is Present for Tables, so cannot Drop' (Doc ID 2284403.1)

Last updated on AUGUST 25, 2024

Applies to:

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA) 7.3.3.2, you are trying to remove key dimensions columns from the environment.  When you run the Model Upload to remove the columns from the data model, you get the following error in the ETLService.log from $FIC_APP_HOME/common/FICServer/logs:

[ETLLOG] Jun 13,17 18:41:33 : [MODELUPLOADHELPER]Log Message::::Starting ModelUpload Process
[ETLLOG] Jun 13,17 18:41:51 : [MODELUPLOADHELPER]Log Message::::Number of Tables in New Model...641
[ETLLOG] Jun 13,17 18:41:51 : [MODELUPLOADHELPER]Log Message::::Number of Tables in Existing Model...641
[ETLLOG] Jun 13,17 18:41:51 : [MODELUPLOADHELPER]Log Message::::Started Validating Deleted Tables and Creating Drop Table Scripts
[ETLLOG] Jun 13,17 18:42:54 : [MODELUPLOADHELPER]Log Message::::Error - Metadata Mapping is Present for Tables, so cannot Drop

and

[ETLLOG] Jun 13,17 18:42:54 : [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)
       at com.iflex.fic.newservice.ServiceProxy.invokeService(ServiceProxy.java:184)
       at com.iflex.fic.newservice.NewServiceMaster.provideService(NewServiceMaster.java:211)
       at com.iflex.fic.newservice.DynamicServiceManager.provideService(DynamicServiceManager.java:297)
       at com.iflex.fic.ficserver.JavaRequestHandler.handleRequest(JavaRequestHandler.java:546)
       at com.iflex.fic.ficserver.JavaSocketConnection.run(JavaSocketConnection.java:202)

The model upload log from /<ftpshare>/<infodom>/log only contains the following:

Log file name is-- :/ftpshare/<infodom>/log/<infodom>_LOG_26_06.13.2017-06.23.30.log----------------------------------------------
MODEL UPLOAD STARTED AT Tue Jun 13 18:23:48 CDT 2017
Source Erwin XML File :: /ftpshare/<infodom>/erwin/erwinXML/PFT_V240_Datamodel90.xml
Model Upload Mode :: Incremental Model upload (Incremental changes)
Using Erwin.xsl File at :: /oraofsa/product/ofsaai.7.3/ficapp/common/FICServer/conf/Erwin91/Erwin.xsl
Target XML File :: /ftpshare/<infodom>/erwin/fipxml/<infodom>_DATABASE.XML
----------------------------------------------
Information Domain : <infodom>
CURRENT VERSION IS 25
strLastProcessedDate....2017-06-13 11:30:49STARTED TRANSFORMING THE XML FILE TO DATABASE MODEL FILE AT Tue Jun 13 18:23:48 CDT 2017

Finally, the nohup.out contains errors like the following:

java.io.IOException: Stream closed
       at sun.nio.cs.StreamEncoder.ensureOpen(StreamEncoder.java:26)
       at sun.nio.cs.StreamEncoder.write(StreamEncoder.java:99)
       at sun.nio.cs.StreamEncoder.write(StreamEncoder.java:116)
       at java.io.OutputStreamWriter.write(OutputStreamWriter.java:203)
       at java.io.Writer.write(Writer.java:140)
       at com.iflex.fic.etl.UploadModel.cnt.logFile.writeIntoLog(logFile.java:114)
       at com.iflex.fic.etl.UploadModel.cnt.ClsUCntUploadModel.AlterModifyTable(ClsUCntUploadModel.java:2152)
       at com.iflex.fic.etl.UploadModel.cnt.ClsUCntUploadModel.handleRequest(ClsUCntUploadModel.java:276)
       at com.iflex.fic.etl.UploadModel.cnt.ClsUCntErwinUpLoad.uploadErwin(ClsUCntErwinUpLoad.java:183)
       at com.iflex.fic.etl.UploadModel.cnt.ClsUCntUploadHandler.handleUpload(ClsUCntUploadHandler.java:331)
       at com.iflex.fic.etl.util.ClsUUtlETLServiceProvider.handleRequest(ClsUUtlETLServiceProvider.java:133)
       etc.

As a result of the errors, the model upload fails.

Cause

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