OFSAA Data Model Upload Fails at 'Renaming the Database Model file' (Doc ID 1332786.1)

Last updated on JULY 27, 2016

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.2 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 try to upload a data model XML file for the first time in a new instance, the upload fails.  The following message is in the model upload log in the /<ftp>/<infodom>/erwin/log/ directory:

----------------------------------------------
Information Domain : OFSAA52INFOD
CURRENT VERSION IS 10
strLastProcessedDate....2011-03-21 15:10:57STARTED TRANSFORMING THE XML FILE TO DATABASE MODEL FILE AT Mon May 16 12:10:14 CEST 2011
COMPLETED TRANSFORMING THE XML FILE TO DATABASE MODEL FILE AT Mon May 16 12:11:15 CEST 2011
----------------------------------------------
STARTED SUPER CATEGORY - SUB CATEGORY HANDLING AT Mon May 16 12:11:15 CEST 2011
Failed while handling super type - sub type relationsFAILED WHILE SUPER CATEGORY - SUB CATEGORY RELATIONS HANDLINGDELETING THE DATABASE MODEL
Renaming the Database Model file
----------------------------------------------
MODEL UPLOAD COMPLETED AT Mon May 16 12:11:37 CEST 2011
----------------------------------------------

You cannot find any more specific error messages anywhere.  The Java Console contains the following generic message:

Upload Model status='[S][ETL.MODELUPLOAD.UPLOAD_ERR]'

As a result of the error, the Data Model cannot be uploaded 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