CTO Load Procedure Fails Intermittently (Doc ID 1136705.1)

Last updated on MARCH 08, 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.

Goal


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?


Solution

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