Table of Contents
Troubleshooting - Contact is receiving data error message
Author: Michelle McCausland
Example Customer Request
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).
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:
select * from contact_responsibility where element_id not in (select id from network_element);
| 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 |
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: IDMS-1231 (RESOLVED)