Product_update_customers.sql Failing With 'ORA-00904: "CSP"."DEATH": invalid identifier' After Migrating To 2.3.0.0.5
(Doc ID 2296964.1)
Last updated on NOVEMBER 14, 2019
Applies to:
Oracle Utilities Network Management System - Version 2.3.0.0.0 to 2.3.0.0.0 [Release 2.3]Oracle Network Management for Utilities - DMS - Version 2.3.0.0.0 to 2.3.0.0.0 [Release 2.3]
Information in this document applies to any platform.
Symptoms
On : 2.3.0.0.0 version,
Running the update-customers process results in this error:
"ORA-00904: "CSP"."DEATH": invalid identifier
The product_customers_to_update.sql file is looking for the column cu_service_points_cis.death, but it does not exist.
In the pr22198397_migration.sql there are updates to the cu_service_points that add the death column, but nothing for cu_service_points_cis.
The issue can be reproduced at will with the following steps:
1. Update a model from 1.12.0.3.26 to 2.3.0.0.5
2. Run ces_setup.ces.
3. Run the update-customers process
4. The error will appear.
Changes
System was updated to NMS 2.3.0.0.5
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 |
Changes |
Cause |
Solution |
References |