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

Last updated on JUNE 30, 2017

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

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