Collect Shipment And Booking History Failing With ORA-01555 Error (Doc ID 1466844.1)

Last updated on DECEMBER 18, 2013

Applies to:

Oracle Demantra Demand Management - Version 7.3.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 18-Dec-2013***

Goal

Issue

The following is seen in the logs when running the Collect Shipment and Booking History:

MSDDEMCHD module: Collect Shipment and Booking History

ORA-01555: snapshot too old: rollback segment number 124 with name "_SYSSMU124_2408282003$" too small
...
...
Deleting data from sales staging table - MSDEM.T_SRC_SALES_TMPL
Fetched the schema name as : MSDEM
Begin Delete data from ERR table - MSDEM.T_SRC_SALES_TMPL_err
Exception(1): msd_dem_collect_history_data.collect_series_data - 04-JUN-2012 14:59:40
ORA-01555: snapshot too old: rollback segment number 124 with name "_SYSSMU124_2408282003$" too small
ORA-02063: preceding line from DESTINATION_TO_SOURCE
Error(17): msd_dem_collect_history_data.collect_history_data - 04-JUN-2012 14:59:40
Error while collecting Shipment History - Requested Items - Shipped Date

 

Findings

Through investigation found this error is thrown due to the UNDO_RETENTION database parameter not being set to the correct size.
The following internal bug was found on the subject:

unpublished Bug 9041409 - NOT ENOUGH SPACE IN UNDO TABLESPACE


How can Users figure out the optimal setting for the UNDO_RETENTION parameter in their environment?

 

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