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

Last updated on JULY 14, 2017

Applies to:

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

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 :: /herramientas/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

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