Author: Michelle McCausland

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…

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

Query to find bad lat/long data

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 "%'%");

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

To fix it, first find the relevant map_details_id entries:

select map_details_id from network_element where id in (94316,94474,111780,111781);

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

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

Then, delete the map_details_ids:

delete from map_details where id in (30196,30198,34776,34777);

Reload the node monitor to ensure the issue is resolved.