OSM Purge Orders Takes Long Time - Sometimes With Error

(Doc ID 1921472.1)

Last updated on SEPTEMBER 18, 2017

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:

C:\OSM703_P13_SIT\SDK\XMLImportExport>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

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