All Visits of Contacts of the same Person are deleted when permanent deletion is triggered for one of the Contacts, if there's a distance of >30 days between their Report Dates

[roxanamlendea]

Bug Description

When 2 Contacts are created for the same Person and the distance between their Report Dates exceeds the threshold of 30 days, when the automatic deletion is triggered for one of the Contacts, all their Visits are deleted.

The issue is not reproducible when both Contacts have the same Report Date and Last Contact Date;

Steps to Reproduce

1. Create Contact no. 1 with the Report Date and Last Contact Date for 01 July;
2. Add Visit no. 1 with the date 01 July;
3. Create Contact no. 2 for the same Person with the Report Date and Last Contact Date set to the current date;
4. Add Visit 2 no. 2 for Contact no. 2 with date set to the current date;
5. Trigger automatic deletion for Contact no. 1;

Actual Behavior

Both Visits get deleted;

Expected Behavior

Only Visit no. 1 should get deleted;

Screenshots

System Details

• Device: Windows 10
• SORMAS version: discovered on the current version of Sormas 1.76.0-SNAPSHOT, but it is probably an older issue (I don't have access to the DB and the CronService.java file of the release instances, so I couldn't test there)
• Android version/Browser: Chrome
• Server URL: local instance
• User Role: admin + national user

Additional Information

I found this issue while testing ticket #9666

[roxanamlendea]

Verified ticket on local setup using the latest version of Sormas 1.77.0-SNAPSHOT (53a4a24).