Table of Contents
Remove On Air Status Values
Author: Paddy Murphy
Two ON Air status that were removed from ExteNet by Operations are re-populated every time the Snmp Manager is restarted as the values auto populated from the Bootstrap.groovy file.
List On Air Status Values
select * from network_element_status;
The following ON Air Status values that should be removed if present:
- PENDING ACCEPTANCE - ON-AIR
- PENDING ACCEPTANCE - OFF-AIR
Check for foreign key constraints before deleting states
select * from network_element_status_change_event where current_status_id = <network_element_status ID>; select * from network_element where status_id = <network_element_status ID>;
Update tables with foreign key restraints if required
Table entries that are 'PENDING ACCEPTANCE' - ON-AIR can be updated to 'ON-AIR - PENDING ACCEPTANCE'.
Always backup tables before running the updates below.
update network_element_status_change_event set current_status_id = <network_element_status ID> where current_status_id = <network_element_status ID>; update network_element set status_id = <network_element_status ID> where status_id = <network_element_status ID>;
Delete PENDING ACCEPTANCE states
delete from network_element_status where id = <network_element_status ID>;
Verify that entries have been updated be navigating to any parent network element in EMS:
- Select System - Edit System Info in navigation bar
- Select the 'On Air Status“ dropdown
- Values in dropdown list should match the values in the network_element_status table
- No state with PENDING ACCEPTANCE - O… should be visible in dropdown list
