Application Installation is Stuck Due to Update Constraint Utility and File Permission (Doc ID 2249001.1)

Last updated on APRIL 14, 2017

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On : 8.0.3 version, Install and Upgrade Issues

The installation of OFS_PFT 8.0.3 is stuck in "Starting OFS_PFT-8.0.3.0.0 Patch"

Error
The issue stopped at update constraint utility as per update.log:

Reached
Step 3: Gathering information about previous constraint names
Step 4: Alter constraints
java.sql.BatchUpdateException: error occurred during batching: ORA-01418: specified index does not exist - need to know which index does not exist.
at oracle.jdbc.driver.OracleStatement.executeBatch(OracleStatement.java:5031)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:246)
at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:345)
at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:345)
at com.ModelUpload.Update.Update.main(Update.java:198)
Status:4
Exited with 4
Error while creating alter table scripts
Refer nohup.out...


Steps
1. Run OFS_PFT 8.0.3 and it shows failed on constraints.
2. Fixed the constraints, OFS_PFT 8.0.3 is stuck again.



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