Import Application Attempts Abort With The Error "ORA-01555: snapshot too old: rollback segment number x with name "x" too small" (Doc ID 2231210.1)

Last updated on FEBRUARY 10, 2017

Applies to:

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

Symptoms

The HFM 'Import Application' feature fails.  In the BRC_<appName>_Import.log for the attempt, the following error will be recorded:  (Note: The BRC log is located in the directory <EPM_ORACLE_INSTANCE>\diagnostics\logs\hfm where Financial Management Server is configured)


ERROR
-----------------------
Search of records was unsuccessful: ORA-01555: snapshot too old: rollback segment number 3 with name "_SYSSMU3_2073614673$" too small[[
ORA-06512: at "HYPHFM.HFMUTIL_PKG", line 843
ORA-06512: at line 1
. java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number 3 with name "_SYSSMU3_2073614673$" too small
ORA-06512: at "HYPHFM.HFMUTIL_PKG", line 843
ORA-06512: at line 1

 

You may also see the following EPMHFM errors contained within the logs, however, they will all make reference back to the same "ORA-01555: snapshot too old:" error.

EPMHFM-66031
EPMHFM-65925
EPMHFM-66054

Changes

 The issue could be seen in a new installation, or upgraded deployment to the release 11.1.2.4.000+

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