Request from DJ - Date: Thu, Mar 9, 2017 at 2:22

“Like I mentioned, NC-MI-MIDTOWN-VZW-Host4 _remote address is loaded incorrectly, I tried to change the remote address from 1290 W. Elizabeth to 3100 Vinewood St, but failed to do so. Can you please take a look at it .Attached is the loadsheet.”

Issue was due to multiple network elements sharing the same address details id in the database. This was likely caused by a manual load of address detail data into the database. To rectify this the ids were made to be unique. The same was true of the map_details table though not to the same extent - these were also corrected.

SELECT ne.address_details_id, ad.street_address, ad.jurisdiction, COUNT(ne.id) as neCount from network_element ne JOIN address_details ad ON ad.id = ne.address_details_id GROUP BY ne.address_details_id HAVING neCount > 1;

SELECT ne.id, ne.name, ne.ip_address, ne.address_details_id, ad.street_address, ad.jurisdiction from network_element ne JOIN address_details ad on ad.id = ne.address_details_id WHERE address_details_id IN(38171,67996,67997,67998,67999);