Internal Errigal Collaboration Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== Troubleshooting - Node Monitor Not Loading Issues ======

Author: Michelle McCausland

===== Example Customer Request =====
<code>Support, The SNMP Node Monitor is currently not loading. 
Agents which started the application earlier today appear to be operational, but if they attempt to restart application, it stays hung in “Loading application, please wait…</code>
 

----

===== Solution =====

The logs revealed this was caused by bad lat/long data being inserted into the database.

**Query to find bad lat/long data**

<code>select h.id as hubId, h.name as hubName, n.id as nodeId, n.name as nodeName, m.latitude, m.longitude 
from network_element h, network_element n, map_details m 
where n.map_details_id=m.id and n.parent_id=h.id and h.ne_type='Controller'
and (m.latitude like "%'%" or m.longitude like "%'%");</code>

If no rows are returned, then the issue is somewhere else. These are the sites that had the issue:

^  Hub Id  ^  Hub Name                  ^  Node Id  ^  Node Name        ^  Latitude       ^  Longitude     ^ 
|  88567   | ATT_MS_UnivMississippi_40  |  94316    |  REMOTE           |  34?21'42.78    |  89?32'7.70    |
|  88568   | ATT_MS_UnivMississippi_41  |  94474    |  REMOTE           |  34?21'45.93"N  |  89?32'5.36"W  |
|  111778  | VRZ_MS_UnivMississippi_06  |  111780   |  SouthWest Prism  |  34?21'43.60"N  |  89?32'7.39"W  |
|  111778  | VRZ_MS_UnivMississippi_06  |  111781   |  NorthWest Prism  |  34?21'45.75"N  |  89?32'5.71"W  |


To fix it, first find the relevant map_details_id entries:

<code>select map_details_id from network_element where id in (94316,94474,111780,111781);</code>

Then, null out the map_details_id in network_element for each node:

<code>update network_element set map_details_id=null where id in (94316,94474,111780,111781);</code>

Then, delete the map_details_ids:

<code>delete from map_details where id in (30196,30198,34776,34777);</code>

Reload the node monitor to ensure the issue is resolved.

Sidebar

Internal Errigal Collaboration Wiki

User Tools

Site Tools

Page Tools