Getting Errors While Migrating From OSM 730 To OSM 741 CNE
(Doc ID 3015440.1)
Last updated on APRIL 08, 2024
Applies to:
Oracle Communications Order and Service Management - Version 7.4.1.0.0 and laterInformation in this document applies to any platform.
Symptoms
On : 7.4.1.0.0 version,
Unable to migrate data from OSM 7.3.0 to OSM 7.4.1 CNE
ERROR
-----------------------
Caused by: Error : 942, Position : 214, Sql = SELECT omn.*, oc.mnemonic, oc.namespace, oc.customization_target_type, oc.customization_owner FROM om_notification_def omn LEFT OUTER JOIN om_cartridge cart ON omn.cartridge_id = cart.cartridge_id LEFT OUTER JOIN om_customization oc ON oc.customization_target_id = omn.notification_id WHERE cart.status = 'VALID' AND (oc.customization_owner IS NULL OR oc.customization_owner = 'SYSTEM'), OriginalSql = SELECT omn.*, oc.mnemonic, oc.namespace, oc.customization_target_type, oc.customization_owner FROM om_notification_def omn LEFT OUTER JOIN om_cartridge cart ON omn.cartridge_id = cart.cartridge_id LEFT OUTER JOIN om_customization oc ON oc.customization_target_id = omn.notification_id WHERE cart.status = 'VALID' AND (oc.customization_owner IS NULL OR oc.customization_owner = 'SYSTEM'), Error Msg = ORA-00942: table or view does not exist
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 |
| Cause |
| Solution |
| References |