Duplicate identifiers are being assigned to beneficiaries

[Gojo-Taqi]

Describe the bug
For the org ctrith_iph, refer to the link to witness the duplicate identifiers being assigned.

https://reporting.avniproject.org/question/2591-duplicate-identifiers-for-ctrith-iph

[vinayvenu]

Analysis

set role ctrith_iph;
select id,
created_by_id,
created_date_time,
last_modified_by_id,
last_modified_date_time,
address_id,
registration_date,
"Individual Id (Not to be used)"
from ctrith_iph.individual
where created_by_id = 7316
and id between 1399939 and 1406654
order by id asc;
-- Notice that 2316 is recorded twice. This looks like something to do with IdentifierAssignmentService.assignPopulatedIdentifiersFromObservations.

The code here can potentially throw an exception.