My Oracle Support Banner

HFM: Hyperion Financial Management Modify Application, Snap Shot, Import Application and Duplication Application fail, Error "EPMHFM-66084: An error occurred during application backup" "EPMHFM-69449: An error occurred while importing the application." (Doc ID 3015662.1)

Last updated on APRIL 09, 2024

Applies to:

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

Symptoms

The following tasks fail:

Errors in HFM oracle-epm-fm-hsx-server.log will show: 

[FM] [ERROR] [EPMHFM-66006] [oracle.FM.HSXDATAACCESS.oracle.epm.fm.dal.dao.HFMPropertiesDAOImpl] [tid: 29] [ecid: ] [SRC_CLASS: oracle.epm.fm.dal.dao.AdminTasksDAOImpl] [SRC_METHOD: insert] Record was not created: ORA-02289: sequence does not exist[[
. java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not exist

Caused by: Error : 2289, Position : 136, Sql = INSERT INTO HSX_ADMIN_TASKS (TASKID, APPNAME, TASKTYPE, TASKPROGRESS, TASKSTATUS, LASTUPDATETIME, STARTTIME, USERID, SERVERNAME) VALUES(HSX_ADMIN_TASKS_SEQ.nextval, :1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 ) RETURNING TASKID, APPNAME, TASKTYPE, TASKPROGRESS, TASKSTATUS, LASTUPDATETIME, STARTTIME, USERID, SERVERNAME INTO :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , OriginalSql = INSERT INTO HSX_ADMIN_TASKS (TASKID, APPNAME, TASKTYPE, TASKPROGRESS, TASKSTATUS, LASTUPDATETIME, STARTTIME, USERID, SERVERNAME) VALUES(HSX_ADMIN_TASKS_SEQ.nextval, ?, ?, ?, ?, ?, ?, ?, ? ) RETURNING TASKID, APPNAME, TASKTYPE, TASKPROGRESS, TASKSTATUS, LASTUPDATETIME, STARTTIME, USERID, SERVERNAME INTO ?, ?, ?, ?, ?, ?, ?, ?, ?, Error Msg = ORA-02289: sequence does not exist

 

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.