CTO Load Procedure Fails Intermittently
Last updated on DECEMBER 18, 2017
Applies to:Oracle Demantra Demand Management - Version: 7.3.0 to 7.3.0 - Release: 7.3.0 to 7.3.0
Information in this document applies to any platform.
Run the workflow IMPORT CTO_LEVEL.
The error seen in the collaborator logs is as follows:
2010-02-12 15:26:02,168 EST [WFProcess_11] FATAL workflow.general: java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number 17 with name "_SYSSMU17_1257869570$" too small
The undo tablespace is defined as 65Gigs. The client also has EBS Suite and the rollback segment is defined as 19 Gigs.
Why does this process need in excess of 65 Gigs as rollback segment?
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