Model Upload Fails with Unexpected Error or Failed While Handling SuperType-SubType Relations
(Doc ID 1407920.1)
Last updated on FEBRUARY 20, 2019
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 7.2.10 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)
Oracle Financial Services Enterprise Performance Management (EPM)
In Oracle Financial Services Analytical Applications (OFSAA), when you run an Import Model process, the model upload fails. The following error is listed in the model upload log in /<ftpshare>/<infodom>/logs:
strLastProcessedDate....2012-02-01 15:00:42STARTED TRANSFORMING THE XML FILE TO DATABASE MODEL FILE AT Fri Feb 03 16:00:29 GMT 2012
STARTED SUPER CATEGORY - SUB CATEGORY HANDLING AT Fri Feb 03 16:01:53 GMT 2012
Unexpected Error while handling super type - sub type relationsFAILED WHILE SUPER CATEGORY - SUB CATEGORY RELATIONS HANDLINGDELETING THE DATABASE MODEL
Renaming the Database Model file
You did save the data model in the correct XML Repository Format.
Additionally, you have the correct version of the Erwin.xsl installed in the $FIC_APP_HOME/common/FICServer/conf directory as described in <Document 1284859.1> "Does OFSAA 7.2 Require an Erwin Version Compatibility Patch?".
Different versions of OFSAA Infrastructure may have different errors.
If you are using OFSAA Infrastructure 7.3.5, you may get the following error in the model upload log:
ERWINUPLOAD ERROR..Model Upload Failed while handling SuperType-SubType Relations
In another case, the Super Category - Sub Category Handling may complete but the log ends with the following:
STARTED SUPER CATEGORY - SUB CATEGORY HANDLING AT Thu Apr 09 21:41:31 EDT 2015
SUCCESSFULLY COMPLETED SUPER CATEGORY - SUB CATEGORY RELATIONS HANDLING AT Thu Apr 09 21:41:54 EDT 2015
Key :@@system Value:system----------------------------------------------
Inside AlterModify Component
DbType is ORACLE
This is preventing you from uploading changes to your data model into the OFSAA database.
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