Answers.Body: <p>If you visit the status page of Civi(CiviCRM &gt;&gt; Administer &gt;&gt; Administration Console &gt;&gt; System Status), you should see the option to rebuild the relationship cache table.</p>
  <p>The count of civicrm_relationship_cache table should be twice of civicrm_relationship. If the count is not matching than it means a record is either having missing contact id a or b.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-10-17T10:45:05.337Z
Answers.Text: yes I did a few times from both WEB GUI and by running a corresponded CV command in a terminal, but the message is still back each time I log in.
Answers.UserDisplayName: yurg
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-10-17T10:40:52.803Z
Answers.LastActivityDate: 2024-10-17T10:49:57.517Z
Answers.LastEditDate: 2024-10-17T10:49:57.517Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>Got this &quot;Missing Relationship Cache Data&quot; each time, even after cache rebuilt in Web GUI / API4.
  Could it be because some relationships in the database don't have a start_date but have an end_date?</p>
  <p><a href="https://i.sstatic.net/bZDIddHU.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/bZDIddHU.png" alt=" Missing Relationship Cache Data" /></a>
  <a href="https://i.sstatic.net/WxJNqTDw.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/WxJNqTDw.png" alt="relationships in the database" /></a></p>
  
Tags: <relationships>
Title: "Missing Relationship Cache Data" won't go away
ThreadText: # "Missing Relationship Cache Data" won't go away
  
  (Asked by: username_0 on 2024-10-17)
  
  Got this "Missing Relationship Cache Data" each time, even after cache rebuilt in Web GUI / API4.
  Could it be because some relationships in the database don't have a start\_date but have an end\_date?
  
  [![ Missing Relationship Cache Data](https://i.sstatic.net/bZDIddHU.png)](https://i.sstatic.net/bZDIddHU.png)
  [![relationships in the database](https://i.sstatic.net/WxJNqTDw.png)](https://i.sstatic.net/WxJNqTDw.png)
  
  **Tags:** relationships
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2024-10-17. Score: 1
  
  If you visit the status page of Civi(CiviCRM >> Administer >> Administration Console >> System Status), you should see the option to rebuild the relationship cache table.
  
  The count of civicrm\_relationship\_cache table should be twice of civicrm\_relationship. If the count is not matching than it means a record is either having missing contact id a or b.
  
  > **Comments:**
  > **username_0**: yes I did a few times from both WEB GUI and by running a corresponded CV command in a terminal, but the message is still back each time I log in.  
  
  ---
  
  