Differences

This shows you the differences between two versions of the page.

--- support:row [2019/12/23 15:02] – pmurphy
+++ support:row [2021/06/25 10:09] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
+===== ROW missing Cascade/ExteNet ID dropdown value =====
+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.
+==== Customer configuration through loadsheet ====
+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?
+==== Operations Database configuration  ====
+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>);

Internal Errigal Collaboration Wiki