OSM:om_cartridge_pkg.drop_cartridge Not Completing
Last updated on JUNE 30, 2017
Applies to:Oracle Communications Order and Service Management - Version 7.2.0 to 126.96.36.199.0 [Release 7.2 to 7.3.0]
Information in this document applies to any platform.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms