PFT, FTP, or ALM 6.0 Installer Hangs When Executing the Script Dm_common_ddl_6_0.sql
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)
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms