We recently saw that the end date is being populated at both object level and crosswalk level.
- When DeleteDate is set for the crosswalk the Relation End Date is set automatically. This is working as expected. The only other scenario where it does not end Date relation is when we have multiple crosswalks and any of the crosswalks do not have the DeleteDate set.
- The entity has been inactivated but the relation is still active. This appears to be a consistency issue and we should execute the following two jobs and verify the results.
- https://docs.reltio.com/tasksapi/ValidateRelationsTask.html - This task will iterate over the entire collection of relations for a tenant, and for each relation, it checks if valid start and end entities are present.
- https://docs.reltio.com/tasksapi/RelationsConsistencyTask.html - This task will fix any inconsistency between RELATIONS and RELATIONS_ONE_HOP_NEW.