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 - Contact is receiving data error message ======

Author: Michelle McCausland

===== Example Customer Request =====

<code>Support, I am encountering errors when attempting to update contact responsibilities. 
Would the contacts being in error cause any adverse effects on dispatches? Do we know how many other contacts are in error?

OR

When I open up a user in the snmp manager gui I get a data error in the network responsibility section (See Screenshot below).
</code>

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


----

===== Solution =====

The issue with this item was that the users in error were assigned to network elements that were no longer in the system for whatever reason.

To find the list of contact responsibilities assigned to missing network elements use the following query:

<code> select * from contact_responsibility where element_id not in (select id from network_element); </code>

^  id    ^ version ^  element_id  ^  rank  ^  responsibility_type  ^  contact_id  ^
| 38012  | 0       |  118337      |  0     |  NULL                 |  1045        |
| 38014  | 0       |  118337      |  0     |  NULL                 |  1           |
| 49797  | 0       |  108742      |  0     |  Carrier Primary      |  1093        |
| 54695  | 0       |  118337      |  0     |  Carrier Primary      |  1123        |
					
These contact responsibility entries can be deleted or reassigned to a different network element accordingly (in most cases deleted).

It is necessary to delete these broken references to fix the issue.

**Note:** As of the time of writing - 17th May 2017, there is a development ticket to resolve this. See: [[https://errigal.atlassian.net/browse/IDMS-1231|IDMS-1231]] (RESOLVED)

Sidebar

Internal Errigal Collaboration Wiki

User Tools

Site Tools

Page Tools