PFT, FTP, or ALM 6.0 Installer Hangs When Executing the Script Dm_common_ddl_6_0.sql (Doc ID 1605554.1)

Last updated on MARCH 29, 2015

Applies to:

Oracle Financial Services Profitability Management - Version 5.6 to 6.0 [Release 5 to 6]
Oracle Financial Services Funds Transfer Pricing - Version 5.6 to 6.0 [Release 5 to 6]
Oracle Financial Services Asset Liability Management - Version 5.6 to 6.0 [Release 5 to 6]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

When upgrading Oracle Financial Services Profitability Management (PFT), Funds Transfer Pricing (FTP) or Asset Liability Management (ALM) from version 5.6 to 6.0, the installer has been stuck at the same place for hours.  When you check the install log specified in the log4j.xml, the last line of the log shows that it is executing the script dm_common_ddl_6_0.sql:

[Wed 20/11/2013 11:37:42] [OFSPFT] [DEBUG] - ===>Number of lines Read: 39
[Wed 20/11/2013 11:37:42] [OFSPFT] [DEBUG] - ===>Executing file:/app/reveleusofs2/scripts/atomic/create/dm_common_ddl_6_0.sql


The installer is stuck at this point.  However, it is not hanging because you can see that it is actively executing SQL in the database.

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