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.

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

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>;

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 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:

1. Select System - Edit System Info in navigation bar
2. Select the 'On Air Status“ dropdown
3. Values in dropdown list should match the values in the network_element_status table
4. No state with PENDING ACCEPTANCE - O… should be visible in dropdown list