Author: Paddy Murphy

If a support request comes to investigate why a value is missing from the Cascade/ExteNet ID drop down list in the ROW(right of way) application check that the values listed below are assigned.

Check the following:

• Is the right_of_way_element value set to true in the network_element table for the child element?
• Is there a value assigned for node_id in the network_element table for child element?

Check that there is an entry in the state_cluster table to join the network element cluster to the relevant state – an element will not appear Cascade/ExteNet ID drop down after a state is selected if this is missing.

Example - check for clusters assigned to Pennsylvania

select * from state where abbreviation = 'PA';
select * from state_cluster where state_clusters_id = 39;

If a new entry is required it has be added to the state_cluster join table via a database insert statement.

• state_clusters_id – State ID
• cluster_id – Cluster ID

Example Insert Query

insert into state_cluster values(<State ID>,<cluster ID>);