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 - Address details not updating after spreadsheet upload ======

**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.

{{ :onboarding:snmpmanager:codesnipped.png?nolink |}}

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);

Sidebar

Internal Errigal Collaboration Wiki

User Tools

Site Tools

Page Tools