My Oracle Support Banner

Product_update_customers.sql Failing With 'ORA-00904: "CSP"."DEATH": invalid identifier' After Migrating To (Doc ID 2296964.1)

Last updated on NOVEMBER 14, 2019

Applies to:

Oracle Utilities Network Management System - Version to [Release 2.3]
Oracle Network Management for Utilities - DMS - Version to [Release 2.3]
Information in this document applies to any platform.


On : 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 to
2. Run ces_setup.ces.
3. Run the update-customers process
4. The error will appear.


System was updated to NMS


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.