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 laterInformation in this document applies to any platform.
Symptoms
The following tasks fail:
- Modifying an Application to add years
- Import Application
- Duplicate an Application
- LCM Snap Shot of HFM application
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 |