My Oracle Support Banner

Model Upload "UPLOAD ERROR..Exception while fetching tables info from AAI_DMM_METADATA table" Errors During 8.1 Application Pack Installation (Doc ID 2779753.1)

Last updated on MAY 27, 2021

Applies to:

Oracle Financial Services Data Foundation - Version 8.1.0.0.0 to 8.1.1 [Release 8.1]
Oracle Financial Services Analytical Applications Infrastructure - Version 8.1.0.0.0 to 8.1.1 [Release 8.1]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI / AAI)
Oracle Financial Services Data Foundation (FSDF)

Symptoms

Have started the OFSAA 8.1.0.0.0 Upgrade. OFSAAI Platform - 8.1.0.0.0 installed successfully. While running FSDF-8.1.0.0.0 the data model upload is failing.

Iteration1 : Datamodel failed with the following error "Exception occured while Copy File to fipxml table.java.nio.file.NoSuchFileException: /ftpshare/FSDFINFO/json/dbXML/OFS_BFND_Datamodel_DB.XML". It seems the mentioned directory file is missing. Before this error the folder structure creation log message was displayed but the physical folder structure was missing under ftpshare.  Have manually created this folder structure "/ftpshare/FSDFINFO/json/dbXML" and rerun the installer again. This time it went through by copying the file "OFS_BFND_Datamodel_DB.XML" to this location "/ftpshare/FSDFINFO/json/dbXML".

Iteration 2: After fixing the above (iteration 1 error) data model again fails again with new errors:

ERROR

Started Model Upload using JSON :Tue May 11 18:04:48 CDT 2021

----------------------------------------------
JSON MODEL UPLOAD STARTED AT Tue May 11 18:04:48 CDT 2021
----------------------------------------------
 UPLOAD ERROR..Exception while fetching tables info from AAI_DMM_METADATA table. java.lang.ClassCastException: java.lang.String cannot be cast to com.iflex.fic.global.DACRecordSet
Ended Model Upload using JSON :Tue May 11 18:04:48 CDT 2021
Modelupload status..Model Upload FailedERWINUPLOAD ERROR..Modelupload Failed


It is not clear why JSON MODEL UPLOAD is being triggered here.  Currently using only FSDF application and no other apps are installed in this environment. Attempting to launch the model upload manually gives the same errors.

The issue can be reproduced at will with the following steps:
1. Use the 8.1 FSDF V998311-01.zip installer to upgrade AAI and FSDF to 8.1
2. Find that the installer is trying to trigger JSON model upload

Changes

New OFSAA 8.1 installation.

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
Changes
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.