Business Rules / Agent Merging - agent cannot be deleted while associated with a specifyuser

[carlosmbe]

Describe the bug
I tried to merge 5 agents and got the error in the title

#3474 (comment)

To Reproduce
Steps to reproduce the behavior:

1. Go to NHMD -> NHMD AMBER
2. Create a Formatted Query for Agents
3. Reverse the results sorting order so that it's Descending
4. Merge the Agents I've listed below
5. See error

Specify 7 Crash Report - 2023-07-19T20_57_17.921Z.txt

Agents to merge:

• A.v.H.
• AA
• Aa, R
• Aarvik, L
• Aastrup, C.

Beautiful Pictures

So for privacy (and legal) reasons the videos for Agent Merging are in the Vault:

https://drive.google.com/file/d/1kHKugy8ixThS82_PHDg43JZg2MDzULlh/view?usp=share_link

Desktop:

• OS: Mac Os
• Browser: Chrome
• Specify 7 Version: 7.9

[emenslin]

This specific example no longer works however this issue can be replicated by trying to merge two or more agents that are associated with a spuser. This seems like the expected behavior since one agent would not be able to have more than one user however maybe we could add some sort of merge blocker instead of letting the merge go through and fail at the end, but I also don't think this is something most users would run into so I'm not sure if it'd be worth it.

Lzv0Zuc5zb.mp4

Merging 79770e27-ae5a-4c5e-92eb-d28311ab500f Crash Report - 2024-07-09T17_55_58.633Z.txt