My Oracle Support Banner

Error 'ORA-01555: snapshot too old: rollback segment number with name "" too small' and the P6 EPPM 'Publish Security' Job Fails (Doc ID 2049935.1)

Last updated on MARCH 21, 2024

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.2 1.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to run the Publish Security Global Scheduled Service job in P6 EPPM, the following error appears in the Publication Services logs.

SEVERE: 2015-08-13 02:50:35:[TASK]:[User]: [3] CORE(SQL): Errors occurred when executing following statement:
declare
DIRTY_USERS_CONTEXT_NAME varchar2(12) := 'DIRTY_USERS';
<SQL code of procedure>
SEVERE: 2015-08-13 02:50:35:[TASK]:[User]: [3] CORE(SQL): ORA-01555: snapshot too old: rollback segment number  with name "" too small
ORA-06512: at line 94
java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number  with name "" too small
ORA-06512: at line 94
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3488)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
at com.primavera.infr.db.PPreparedStatement.execute(Unknown Source)
at com.primavera.px.common.PxServiceSqlTaskImpl.a(Unknown Source)
at com.primavera.px.common.PxServiceSqlTaskImpl.a(Unknown Source)
at com.primavera.px.common.PxServiceSqlTaskImpl.executeTask(Unknown Source)
at com.primavera.px.common.PxAbstractServiceTask.execute(Unknown Source)
at com.primavera.px.common.PxAbstractServiceTask.execute(Unknown Source)
at com.primavera.infr.threadpool.ThreadPoolImpl.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Changes

 

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!

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