Details
-
Bug
-
Status: Closed (View Workflow)
-
P1
-
Resolution: Done
-
None
-
Prokopovych - Sprint 120
-
3
-
Prokopovych
-
R1 2021 Hot FIx #4
-
Yes
-
Cornell
Description
Overview:
In an Iris Hotfix-2 environment (with loan history per attached image) we
observe that the process for anonymizing loans is running (image below) and that SOME loans are getting anonymized but not ALL of the loans which should be anonymized.
There are approximately 8K loans that are closed and have a userId
SELECT * FROM <tenant>_mod_circulation_storage.loan where jsonb->'status'->>'name' = 'Closed' and jsonb->>'userId' is not null
Of the 8K loans, approximately 6K have associated fee fines and should NOT be anonymized
with closed_loans_with_users as ( SELECT * FROM tenantid_mod_circulation_storage.loan where jsonb->'status'->>'name' = 'Closed' and jsonb->>'userId' is not null ) select * from closed_loans_with_users cu where EXISTS ( select ac.jsonb->>'loanId' FROM tenantid_mod_feesfines.accounts ac, closed_loans_with_users cl where ac.jsonb->>'loanId' = cu.id::text)
One possible reason for this is due to fetching of 5K loans by the anonymize process
https://github.com/folio-org/mod-circulation/blob/c27229437f5029b8afe9ba8eecd2c58e67c3bf01/src/main/java/org/folio/circulation/domain/anonymization/service/LoansForBorrowerFinder.java#L27
Possible reason for this is:
When the system fetches the first 5000 loans to anonymize, those are made up of loans that have open fees and fines, which means they won’t be anonymized.
This stops other loans which don’t have open fees / fines and are older than the threshold for anonymization from being picked up.
Request is for additional logging to help confirm this is the reason for failure of loans being anonymized (and to resolve issue if confirmed)
Steps to Reproduce:
- Set up loan history (so that loans are anonymized - per image)
- Environment contains >5K loans that are not anonymized (due to fee/fines associated with the loans)
Expected Results:
Closed loans without fees and fines are anonymized based on systems return date
Closed loans with fees and fines (and all fees / fines are closed) are anonymized based on systems return date
Actual Results:
Only some of Closed loans that should be anonymized are
Additional Information:
URL:
Interested parties:
marcjohnson Anya N. Arnold dhowell hollyolepm