"ORA-00913: too many values" error when running ces_control_zones.ces after updating to

(Doc ID 2252150.1)

Last updated on APRIL 11, 2017

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.



When running ces_control_zone.ces on a model with a missing field in the
control_zone_structures_backup table, an sql error is generated:

15:36): Saving control_zones into control_zones_backup...
(15:36): Saving control_zone_structures into
DBD::Oracle::st execute failed: ORA-00913: too many values (DBD ERROR: error
possibly near <*> indicator at char 34 in '

pr25469025 migration script was not getting run when updating from to nor when running "ces_setup.ces -clean -reset"

Running "ces_setup.ces -clean -reset" should NEVER be done on live production systems as it erases the entire electrical model and all operational data.

This migration adds the column hierarchy_type to the CONTROL_ZONE_STRUCTURES and CONTROL_ZONE_STRUCTURES_BACKUP tables

The issue can be reproduced with the following steps:
1. Update to
2. Run ces_setup.ces -clean -reset 
3. Review the setup log and the control_zones_structures table


 Updated from NMS to


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms