Model Upload Fails with Unexpected Error or Failed While Handling SuperType-SubType Relations (Doc ID 1407920.1)

Last updated on AUGUST 07, 2017

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)

Symptoms

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
ERWINUPLOAD ERROR..null


This is preventing you from uploading changes to your data model into the OFSAA database.

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