My Oracle Support Banner

Running the upgradeFoldersILS Script Fails to Upgrade Folders due to DB Errors: "snapshot too old: rollback segment number with name "" too small and ORA-22924: snapshot too old" (Doc ID 2355978.1)

Last updated on JULY 03, 2023

Applies to:

Oracle WebCenter Portal - Version 12.2.1.2.0 and later
Information in this document applies to any platform.

Symptoms

After upgrading from WCP 11g to 12c, running the upgradeFoldersILS Script as part of post-install steps for ILS (Item Level Security) fails with the following errors:

ERROR

 

UpgradeFoldersILSSummary.log:

 

Number of folders not updated : 6

 

UpgradeFoldersILSDetails.log:

 

The log shows errors like this for each failed folder ILS upgrade:

[ERROR]: fFolderGUID : <FOLDER_GUID>, status : FAIL



UCM_server1-diagnostic.log:

 

[2017-12-16T10:23:11.126-05:00] [UCM_server1] [ERROR] [UCM-CS-000001] [oracle.ucm.idccs] [tid: SubjectManager] [ecid: <ECID>] [APP: Oracle Universal Content Management - Content Server] [partition-name: DOMAIN] [tenant-name: GLOBAL] general exception[[
java.io.IOException: ORA-01555: snapshot too old: rollback segment number with name "" too small
ORA-22924: snapshot too old 

    at oracle.jdbc.driver.OracleBlobInputStream.needBytes(OracleBlobInputStream.java:242)
    at oracle.jdbc.driver.OracleBufferedStream.readInternal(OracleBufferedStream.java:182)
    at oracle.jdbc.driver.OracleBufferedStream.read(OracleBufferedStream.java:155)
    at java.io.ObjectInputStream$PeekInputStream.read(ObjectInputStream.java:2620)

...

Caused by: java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number with name "" too small
ORA-22924: snapshot too old 

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:391)
    at oracle.jdbc.driver.T4C8TTILob.processError(T4C8TTILob.java:819)

...

 

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
References


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