Hyperion Financial Management (HFM) 11.1.2.4.000 Application Startup Fails


Generally we copy the database via application backup from 11.1.2.2 and restored in brand new 11.1.2.4 installation and then upgraded using in place upgrade option.

1. It initially failed with errors below:

<Apr 29, 2015 12:49:51 PM PDT> <Error>
<oracle.FM.HSXDATAACCESS.oracle.epm.fm.dal.manager.DALSession> <BEA-000000> <An error occurred in Data Access Layer. Message: Could not rollback as there is no open transaction.>
<Apr 29, 2015 12:49:51 PM PDT> <Error> <oracle.FM.HSX.SERVER.oracle.epm.fm.common.HsxServerConfig> <BEA-000000> <An unexpected error has occurred. Message: An error occurred in Data Access Layer. Message: Could not rollback as there is no open transaction. oracle.epm.fm.dal.exception.DALException: An error occurred in Data Access Layer. Message: Could not rollback as there is no open transaction.

2. After running the Schema upgrade utility again, user was able to open the application and load data, metadata without any problems. The application is running fine. The below error occurs in the HFM application logs frequently.

<Apr 29, 2015 12:49:51 PM PDT> <Warning>
<oracle.FM.HSXDATAACCESS.oracle.epm.fm.dal.dao.BaseDAOImpl> <BEA-000000>
<SELECT MAX(UPDATEDON) LAST_UPDATED FROM XFM_PARAMETERS>
<Apr 29, 2015 12:49:51 PM PDT> <Error>
<oracle.FM.HSXDATAACCESS.oracle.epm.fm.dal.dao.UserOnSystemDAOImpl>
<BEA-000000> <An error occurred while reading settings from the table : [  ][SQLServer JDBC Driver][SQLServer]Invalid column name ‘UPDATEDON’..
java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid column name ‘UPDATEDON’.
at weblogic.jdbc.sqlserverbase.ddb_.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb_.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)

3. In addition, the following occurs:

  • Application is in Admin mode and user receives the following error:

EPMHFM-66122: An unexpected error occurred while stopping the admin task for Logistics application.

 

  • Unknown Error will occur when accessing Settings and Admin tasks menu under Admin tasks.

The root Cause for this issue is XFM_PARAMETERS and XFM_PARAMETERS_DEFAULTS tables are not created as part of inplace upgrade process.

 

First check whether the XFM_PARAMETERS and XFM_PARAMETERS_DEFAULTS are created in the HFM database.

If not, user needs to execute the below two scripts:

1. <EOH>\products\FinancialManagement\Server\conf\<DBVENDOR>_from_11.1.2.1.000_to_11.1.2.2.000_SchemaUpgrade.sql

2. <EOH>\products\FinancialManagement\Server\conf\<DBVENDOR>_from_11.1.2.3.000_to_11.1.2.4.000_SchemaUpgrade.sql

 

Note: This issue occurs when upgrading to 11.1.2.4.000 using in-place upgrade option.

NOTE : – Make sure you have a FULL backup before making any changes to the system.

 

Thanks,

~KKT~

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s