Unable To Undeploy Cartridge Using CMT/ Purge Or Undeploy Using XMLIE In Oracle RAC With Partitioning
(Doc ID 1914960.1)
Last updated on MARCH 31, 2023
Applies to:
Oracle Communications Order and Service Management - Version 7.2.0 and laterInformation 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 partitioning 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 XMLIE.
The following error was received:
-----------------------
<USERNAME> XMLImportExport]$ ant purge
Buildfile: <DIR>/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=<IP ADD>)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=<SERVICE NAME>)(INSTANCE_NAME=<INSTANCE NAME>)))]
[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 "_<USERNAME>_936390225$" too small
[java] ORA-06512: at "<OSMSCHEMAUSER>.ERROR_MSG", line 8
[java] ORA-06512: at "<OSMSCHEMAUSER>.OM_CARTRIDGE_PKG", line 464
[java] ORA-06512: at "<OSMSCHEMAUSER>.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 "_<USERNAME>_936390225$" too small
[java] ORA-06512: at "<OSMSCHEMAUSER>.ERROR_MSG", line 8
[java] ORA-06512: at "<OSMSCHEMAUSER>.OM_CARTRIDGE_PKG", line 464
[java] ORA-06512: at "<OSMSCHEMAUSER>.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 "_<USERNAME>_936390225$" too small
[java] ORA-06512: at "<OSMSCHEMAUSER>.ERROR_MSG", line 8
[java] ORA-06512: at "<OSMSCHEMAUSER>.OM_CARTRIDGE_PKG", line 464
[java] ORA-06512: at "<OSMSCHEMAUSER>.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 "<OSMSCHEMAUSER>.ERROR_MSG", line 8
[java] ORA-06512: at "<OSMSCHEMAUSER>.OM_CARTRIDGE_PKG", line 464
[java] ORA-06512: at "<OSMSCHEMAUSER>.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 "_<USERNAME>_936390225$" too small
[java] ORA-06512: at "<OSMSCHEMAUSER>.ERROR_MSG", line 8
[java] ORA-06512: at "<OSMSCHEMAUSER>.OM_CARTRIDGE_PKG", line 464
[java] ORA-06512: at "<OSMSCHEMAUSER>.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 "_<USERNAME>_936390225$" too small
[java] ORA-06512: at "<OSMSCHEMAUSER>.ERROR_MSG", line 8
[java] ORA-06512: at "<OSMSCHEMAUSER>.OM_CARTRIDGE_PKG", line 464
[java] ORA-06512: at "<OSMSCHEMAUSER>.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 "_<USERNAME>_936390225$" too small
[java] ORA-06512: at "<OSMSCHEMAUSER>.ERROR_MSG", line 8
[java] ORA-06512: at "<OSMSCHEMAUSER>.OM_CARTRIDGE_PKG", line 464
[java] ORA-06512: at "<OSMSCHEMAUSER>.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!
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |