Title: Relationship diagram not adding relationship 

Author: Jason Ritz

Date: August 23, 2023

Audience: Customers, and/or Agents and Admins

Environmental details: On-Prem 8.79.x

Problem/Summary:

The user is unable to add a new relationship to the Relationship Diagram. When selecting Save, the relationship is not added, and no error message or notification is displayed, just a thin red line below the UI. 

The logs show the error message

"status":"Bad Request","message":"Duplicate item type rules are not allowed: 87 -> 87"}}

Solution:

1.  FInd the duplicate relationship rules in the database using the following query (updating the to and from doc using the data from the log. 87 in this example) 
   
   

   SELECT * FROM relationshiprule WHERE fromDocTypeId = 87 AND toDocTypeId = 87;

2. Stop the application 
3. Remove the duplicate relationship rules from the database using the following query (replacing the IDs with the IDs returned from step 1. 10199 and 10200 in this example)
   

   DELETE FROM relationshiprule WHERE id in (10199, 10200);

4. Restart the application 

Related Articles, Work orders, Zendesk tickets, Defects, etc. 

• Zendesk Ticket 48363
• Zendesk Ticket 72000

Feedback: Did this article help you resolve your slow internet connection? Please leave feedback in the comments below.