"ORA-00913: too many values" error when running ces_control_zones.ces after updating to 22.214.171.124.2
Last updated on APRIL 11, 2017
Applies to:Oracle Utilities Network Management System - Version 126.96.36.199.0 to 188.8.131.52.0 [Release 2.3]
Oracle Network Management for Utilities - DMS - Version 184.108.40.206.0 to 220.127.116.11.0 [Release 2.3]
Information in this document applies to any platform.
On NMS 18.104.22.168.0
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 22.214.171.124.1 to 126.96.36.199.2 nor when running "ces_setup.ces -clean -reset"
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 188.8.131.52.2
2. Run ces_setup.ces -clean -reset
3. Review the setup log and the control_zones_structures table
Updated from NMS 184.108.40.206.1 to 220.127.116.11.2
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