Duplicated Unknown housing status on client created date | Voters

Duplicated Unknown housing status on client created date

Ali Ryder

This is another version of https://acreconsulting.canny.io/hifis-4/p/housing-status-duplicated-statuses but it's distinct enough that I'm giving it its own ticket.

I have a total of 36 clients. I found the issue for 7 clients including Anonymous, Anonymous, that's around 20% of clients affected.
I tested the demo site and the issue is present for over 1200 clients. Here are some examples of affected clients: all clients between 2,881 and 2,895 inclusive; 2,723; 800; 259.... there's lots.
It's always duplicated Unknown status. Every time. I haven't found a duplicated status that wasn't Unknown.
It's always the same client becoming unknown a bunch of times at the exact same timestamp.
The timestamp is the same timestamp as the client created date.
There are always 77 copies of the duplicated unknown status. The number 77 probably has to do with something in my database. I tested on demo.hifis.ca and the number was 615. I don't know what I have 77 of and demo.hifis.ca has 615 of, but there's probably something.