My Oracle Support Banner

OSM Purge Orders Takes Long Time - Sometimes With Error (Doc ID 1921472.1)

Last updated on MARCH 30, 2023

Applies to:

Oracle Communications Order and Service Management - Version 7.0.3 and later
Information in this document applies to any platform.

Goal

What causes the following error when trying to purge orders issues when trying to purge orders.

OSM 7.0.3 Patch 13
OSM 7.0.3.1020



 It is taking a long time and is failing with the following exception:

orderpurge config\config-SIT.xml dopurge "order_states=OPEN" "namespace=ALL"
********************************************************************************
Order and Service Management XML Import/Export Tool - ver. 7.0.3.1020
Copyright (C) 1998, 2007, Oracle.
All Rights Reserved.
www.oracle.com
********************************************************************************

Param [3] is [order_states=OPEN]
Param [4] is [namespace=ALL]
Starting to purge orders from database...

Order purge is failed.
Operation processing failed.
com.mslv.oms.metadatahandler.handler.HandlerException: OrderPurge Operation failed.
  at com.mslv.oms.metadatahandler.operation.OrderPurgeOperation.doProcess(Unknown Source)
  at com.mslv.oms.metadatahandler.operation.Operation.processOperation(Unknown Source)
  at com.mslv.oms.metadatahandler.MetadataProcessor.process(Unknown Source)
  at com.mslv.oms.metadatahandler.MetadataHandlerMain.main(Unknown Source)
Caused by: com.mslv.oms.metadatahandler.operation.OrderPurgeException: com.mslv.oms.metadatahandler.dataaccesslayer.ProxyException: ORA-0
1555: snapshot too old: rollback segment number 2 with name "_SYSSMU2_1130899406$" too small
ORA-06512: at "ORDERMGMT.OM_NEW_PURGE_PKG", line 1591
ORA-06512: at line 1
Nested Exception: ORA-01555: snapshot too old: rollback segment number 2 with name "_SYSSMU2_1130899406$" too small
ORA-06512: at "ORDERMGMT.OM_NEW_PURGE_PKG", line 1591
ORA-06512: at line 1
Nested Exception: java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number 2 with name "_SYSSMU2_1130899406$" too smal
l
ORA-06512: at "ORDERMGMT.OM_NEW_PURGE_PKG", line 1591
ORA-06512: at line 1

  at com.mslv.oms.metadatahandler

 

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!


In this Document
Goal
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.