OFSAAI 'Unexpected Error while handling super type' or Incorrect Column Has Been Deleted Errors Doing Erwin Data Model Upload (Doc ID 1276185.1)

Last updated on MAY 13, 2013

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA) - Version 5.x / 6.x
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.x

Symptoms

On Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.x, when attempting to data model upload the following errors occur in the model upload log:

ERROR

STARTED SUPER CATEGORY - SUB CATEGORY HANDLING AT Wed Dec 01 19:33:46 GMT+01:00 2010
Unexpected Error while handling super type - sub type relations FAILED WHILE SUPER CATEGORY - SUB CATEGORY RELATIONS HANDLING DELETING THE DATABASE MODEL
Did not go into the rename block
----------------------------------------------
MODEL UPLOAD COMPLETED AT Wed Dec 01 19:33:49 GMT+01:00 2010
----------------------------------------------

OR

Inside Delete Tables.
----------------------------------------------
STARTED CHECKING FOR DELETED ITEMS
----------------------------------------------
DIM_FINANCIAL_ELEMENTS_ATTR.

 This column FINANCIAL_ELEM_ID has been deleted from the table DIM_FINANCIAL_ELEMENTS_ATTR in the new database model

 The Column FINANCIAL_ELEM_ID of table DIM_FINANCIAL_ELEMENTS_ATTR cannot be deleted as the table has data for this column.

 This column ATTRIBUTE_ID has been deleted from the table DIM_FINANCIAL_ELEMENTS_ATTR in the new database model

STEPS
The issue can be reproduced at will with the following steps:

1. Merged data models.
2. Do incremental model upload.

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