My Oracle Support Banner

Model upload fails due to Update Constraint utility failure (Doc ID 2690028.1)

Last updated on JULY 19, 2020

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.2 and later
Information in this document applies to any platform.

Symptoms

On : 8.0.2 version, Install and Upgrade Issues_OFSS

When attempting to perform model upload as part of upgrade process,
the following error occurs.

ERROR
-----------------------
Console:
/fccm/Software/Upgradeto804/1/25532735/bin>./install.sh
/fccm/Software/Upgradeto804/1/25532735/bin:/u01/app/oracle/product/12.1.0/client_1/bin:/bin:/home/tomcat/jdk1.7.0_79:/home/tomcat/jdk1.7.0_79/bin:/u01/app/oracle/product/12.1.0/client_1/bin:/usr/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/usr/local/lib:/usr/local/include:.:/fccm/ofsaa_fccm/ficdb/bin:/bin:/fccm/ofsaa_fccm/ficapp/icc/bin:/fccm/ofsaa_fccm/ficweb/bin:/fccm/ofsaa_fccm/ficweb/apache-ant-1.7.1/bin:.
/fccm/Software/Upgradeto804/1/25532735/bin
[Mon 29/6/2020 09:25:29] [OFSAAI] [FATAL] - Error in Model upload. So aborting installation
[Mon 29/6/2020 09:25:29] [OFSAAI] [FATAL] - Data Model Failed...Check ModelUpload log for more details
[Mon 29/6/2020 09:25:29] [OFSAAI] [FATAL] - Error77: Error occured while performing DataModel Upload

ETLService.log
-------------------
[ETLLOG] Jun 30,20 13:13:17 : [CLSUCNTUPLOADHANDLER]Constraints are not updated. UpdateConstraints utility is not run for this infodom. Exiting model Upload.
[ETLLOG] Jun 30,20 13:13:17 : [MODELUPLOADHELPER]Log Message::::Error in Model Upload.UpdateConstraints utility is not executed for this infodom.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Try to perform model upload as part of upgrade process


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot successfully upgrade application.

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.