Hyperion Financial Management (HFM) 11.1.2.4.000 Application Startup Fails (Doc ID 2030593.1)

Last updated on AUGUST 01, 2016

Applies to:

Hyperion Financial Management - Version 11.1.2.4.000 and later
Information in this document applies to any platform.

Symptoms

User copied 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:


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

 

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