OSM:om_cartridge_pkg.drop_cartridge Not Completing
(Doc ID 2279008.1)
Last updated on APRIL 15, 2024
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 |