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)


On : 8.0.3 version, Install and Upgrade Issues

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

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

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(
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(
at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(
at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(
at com.ModelUpload.Update.Update.main(
Exited with 4
Error while creating alter table scripts
Refer nohup.out...

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.


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