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 laterInformation 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
********************************************************************************
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 |