My Oracle Support Banner

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

Last updated on FEBRUARY 15, 2023

Applies to:

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

Goal

The following error appears in the Publication Services logs.

ORA-01555: snapshot too old: rollback segment number with name "" too small

Sample log below:

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)

Solution

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.