My Oracle Support Banner

ERWINUPLOAD ERROR..Model Upload Failed While Handling Sliced Merge ORA-02264: name already used by an existing constraint Errors (Doc ID 2618903.1)

Last updated on DECEMBER 09, 2019

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
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)
CA Erwin Data Model Upload

Symptoms

On OFSAA 8.0.7.2, restored a previous backup and patched FSDF 807 with one off patches, ran DMT migration and are attempting to upload PFT 8.0.7 data model using slice mode.  The following error is thrown:

ERROR
ERWINUPLOAD ERROR..Model Upload Failed while handling Sliced Merge.

In addition, the model upload log shows the following error:

fsi_account_index_hist.sql---------ORA-02264: name already used by an existing constraint

In the Oracle Database, the table FCT_PLAN_REPORT_MAP already has a primary key with that name.

Checking data in AAI_TABLE_UID_MAP, the values in N_TABLE_ID do not match the Primary Keys in user_constraints.

For example:

select * from all_constraints
where owner = 'ATOMIC'
and table_name in ('FCT_PLAN_REPORT_MAP', 'FSI_ACCOUNT_INDEX_HIST', 'FCT_RR_CTL_MAP', 'FCT_PLAN_TASK_EXECUTION')
and constraint_name like 'PK%' order by 2;

PK_3623 - FCT_PLAN_TASK_EXECUTION
PK_3625 - FCT_PLAN_REPORT_MAP
PK_3624 - FCT_RR_CTL_MAP

select * from AAI_TABLE_UID_MAP
where v_table_name in ('FCT_PLAN_REPORT_MAP', 'FSI_ACCOUNT_INDEX_HIST', 'FCT_RR_CTL_MAP', 'FCT_PLAN_TASK_EXECUTION');

3622 - FCT_PLAN_TASK_EXECUTION
3623 - FCT_RR_CTL_MAP
3624 - FCT_PLAN_REPORT_MAP
3625 - FSI_ACCOUNT_INDX_HIST

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