My Oracle Support Banner

OSM:om_cartridge_pkg.drop_cartridge Not Completing (Doc ID 2279008.1)

Last updated on JULY 05, 2018

Applies to:

Oracle Communications Order and Service Management - Version 7.2.0 to 7.3.1.0.0 [Release 7.2 to 7.3.0]
Information in this document applies to any platform.

Goal

If the drop_cartridge database procedure takes excessively long, the cause might be because foreign key constraints are enabled. The following procedure disables the constraints, allowing the cartridge to be dropped more efficiently.

High Level Action Plan:
1) Shut-down the OSM system
2) Ensure all orders for the cartridge being dropped are purged
3) Disable order data table foreign key constraints referencing cartridge metadata tables
4) Drop the cartridge
5) Enable the FK constraints that were disabled

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.