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


{{:support:extenet_prod_on_air_status_values.png|}}