User Tools
Writing /app/www/public/data/meta/support/on_air_status.meta failed
support:on_air_status
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| support:on_air_status [2019/10/14 14:17] – pmurphy | support:on_air_status [2021/06/25 10:09] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ===== 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 = < | ||
| + | select * from network_element where status_id = < | ||
| + | | ||
| + | |||
| + | ==== Update tables with foreign key restraints if required ===== | ||
| + | |||
| + | Table entries that are ' | ||
| + | |||
| + | //Always backup tables before running the updates below.// | ||
| + | update network_element_status_change_event set current_status_id = < | ||
| + | update network_element set status_id = < | ||
| + | | ||
| + | |||
| + | ==== Delete PENDING ACCEPTANCE states ==== | ||
| + | delete from network_element_status where 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" | ||
| + | - 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 | ||
| + | |||
| + | |||
| + | {{: | ||
Page Tools
