Unable To Undeploy Cartridge Using CMT/ Purge Or Undeploy Using XMLIE In Oracle RAC With Partioning (Doc ID 1914960.1)

Last updated on NOVEMBER 01, 2016

Applies to:

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

Symptoms

On  OSM version 7.2.0.4 with Clustering

We are Unable to undeploy a cartridge using CMT/ Purge or undeploy using XMLIE in Oracle RAC with partitioning

This is a 2 node cluster with RAC DB and partioning enabled.

When the user is trying  to undeploy all the cartridges from DB, they are facing different issues while undeploying and purging using CMT and XMIE.


The following error was received:
-----------------------


osmuser@saltwin1 XMLImportExport]$ ant purge
Buildfile: /osmprod/OSM/SDK/XMLImportExport/build.xml
    [echo] -Xbootclasspath/p:
    [echo] -Xbootclasspath/a:
    [echo]

purge:
    [echo] Purging the entire database including orders.
    [java] The use of the -p option is deprecated and not recommended. You will be prompted for passwords if omitted.
    [java] ********************************************************************************
    [java] Order and Service Management XML Import/Export Tool - ver. 7.2.0.4.0.1518
    [java] Copyright (C) 1998, 2007, Oracle.
    [java] All Rights Reserved.
    [java] www.oracle.com
    [java] ********************************************************************************
    [java]
    [java] Error decrypting the password of xmlAPIConnection from the config file. Encrypt it again by running the EncryptPasswords utility.
    [java] Error decrypting the password of j2eeAdminConnection from the config file. Encrypt it again by running the EncryptPasswords utility.
    [java] This command will remove all cartridges and orders from the OMS schema version 7.2.0.0.372 in database [jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.128.6.56)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=nosmdb)(INSTANCE_NAME=nosmdb1)))]
    [java] Are you sure you want to purge the entire database (Y/N)?
Y
    [java] Purging all cartridges from database...

   [java] Operation processing failed.
    [java] com.mslv.oms.metadatahandler.operation.CleanupException: com.mslv.oms.metadatahandler.dataaccesslayer.ProxyException: ORA-20114: Oracle runtime error. ORA-01555: snapshot too old: rollback segment number 85 with name "_SYSSMU85_936390225$" too small
    [java] ORA-06512: at "ORDERMGMT1.ERROR_MSG", line 8
    [java] ORA-06512: at "ORDERMGMT1.OM_CARTRIDGE_PKG", line 464
    [java] ORA-06512: at "ORDERMGMT1.OM_CARTRIDGE_PKG", line 477
    [java] ORA-06512: at line 1
    [java] Nested Exception: ORA-20114: Oracle runtime error. ORA-01555: snapshot too old: rollback segment number 85 with name "_SYSSMU85_936390225$" too small
    [java] ORA-06512: at "ORDERMGMT1.ERROR_MSG", line 8
    [java] ORA-06512: at "ORDERMGMT1.OM_CARTRIDGE_PKG", line 464
    [java] ORA-06512: at "ORDERMGMT1.OM_CARTRIDGE_PKG", line 477
    [java] ORA-06512: at line 1
    [java] Nested Exception: java.sql.SQLException: ORA-20114: Oracle runtime error. ORA-01555: snapshot too old: rollback segment number 85 with name "_SYSSMU85_936390225$" too small
    [java] ORA-06512: at "ORDERMGMT1.ERROR_MSG", line 8
    [java] ORA-06512: at "ORDERMGMT1.OM_CARTRIDGE_PKG", line 464
    [java] ORA-06512: at "ORDERMGMT1.OM_CARTRIDGE_PKG", line 477
    [java] ORA-06512: at line 1
    [java]
    [java]     at com.mslv.oms.metadatahandler.operation.CleanupOperation.purgeCartridges(Unknown Source)
    [java]     at com.mslv.oms.metadatahandler.operation.CleanupOperation.cleanup(Unknown Source)
    [java]     at com.mslv.oms.metadatahandler.operation.CleanupOperation.doProcess(Unknown Source)
    [java]     at com.mslv.oms.metadatahandler.operation.Operation.processOperation(Unknown Source)
    [java]     at com.mslv.oms.metadatahandler.MetadataProcessor.process(Unknown Source)
    [java]     at com.mslv.oms.metadatahandler.MetadataHandlerMain.main(Unknown Source)
    [java] Caused by: com.mslv.oms.metadatahandler.dataaccesslayer.ProxyException: ORA-20114: Oracle runtime error. ORA-01555: snapshot too old: rollback segment number 85 with name "_SYSSMU85_936390225$" too small
    [java] ORA-06512: at "ORDERMGMT1.ERROR_MSG", line 8
    [java] ORA-06512: at "ORDERMGMT1.OM_CARTRIDGE_PKG", line 464
    [java] ORA-06512: at "ORDERMGMT1.OM_CARTRIDGE_PKG", line 477
    [java] ORA-06512: at line 1
    [java] Nested Exception: ORA-20114: Oracle runtime error. ORA-01555: snapshot too old: rollback segment number 85 with name "_SYSSMU85_936390225$" too small
    [java] ORA-06512: at "ORDERMGMT1.ERROR_MSG", line 8
    [java] ORA-06512: at "ORDERMGMT1.OM_CARTRIDGE_PKG", line 464
    [java] ORA-06512: at "ORDERMGMT1.OM_CARTRIDGE_PKG", line 477
    [java] ORA-06512: at line 1
    [java] Nested Exception: java.sql.SQLException: ORA-20114: Oracle runtime error. ORA-01555: snapshot too old: rollback segment number 85 with name "_SYSSMU85_936390225$" too small
    [java] ORA-06512: at "ORDERMGMT1.ERROR_MSG", line 8
    [java] ORA-06512: at "ORDERMGMT1.OM_CARTRIDGE_PKG", line 464
    [java] ORA-06512: at "ORDERMGMT1.OM_CARTRIDGE_PKG", line 477
    [java] ORA-06512: at line 1
    [java]
    [java]     at com.mslv.oms.metadatahandler.dataaccesslayer.AbstractProxy.execute(Unknown Source)
    [java]     ... 6 more
    [java] Caused by: java.sql.SQLException: ORA-20114: Oracle runtime error. ORA-01555: snapshot too old: rollback segment number 85 with name "_SYSSMU85_936390225$" too small
    [java] ORA-06512: at "ORDERMGMT1.ERROR_MSG", line 8
    [java] ORA-06512: at "ORDERMGMT1.OM_CARTRIDGE_PKG", line 464
    [java] ORA-06512: at "ORDERMGMT1.OM_CARTRIDGE_PKG", line 477
    [java] ORA-06512: at line 1
    [java]
    [java]     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
    [java]     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
    [java]     at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
    [java]     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
    [java]     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
    [java]     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
    [java]     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
    [java]     at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1008)
    [java]     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
    [java]     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
    [java]     at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
    [java]     at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1086)
    [java]     at com.mslv.oms.metadatahandler.dataaccesslayer.PreparedProxy.executeStatement(Unknown Source)
    [java]     ... 7 more
    [java] Purge failed!

 

Cause

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