Investigation: Juniper: automatic block 'Maximum fee/fine balance" not removed after item renewed for patron with a large volume of loans

Description

Overview: Patron automatic blocks are aged to lost, then the patron renews them- but the block is not removed 
Steps to Reproduce:

  1. Patron checks out item 

  2. a trigger to automatic block happens

  3. the item ages to lost 

  4. patron ties to renew - but can't so it is overriden to renew 

  5. the automatic block is not removed

Expected Results: the block is removed
Actual Results: the block remains
Additional Information:
URL:
Interested parties:

CSP Request Details

Approved via release_bug_triage Slack channel.

CSP Rejection Details

None

Potential Workaround

Original issue reported by Cornell (this ticket, MODPATBLK-109) - 'Max fee/fine balance' block is SOMETIMES not cleared despite the fact that fees/fines are closed after renewal. MODPATBLK-112 - the same as MODPATBLK-109, only for check-in. 'Max fee/fine balance' block is SOMETIMES not cleared despite the fact that fess/fines are closed, but they were closed as a result of a check-in rather than renewal. 1 and 2 seem to have the same root cause - some of the FEE_FINE_BALANCE_CHANGE messages are not delivered from mod-feesfines to mod-patron-blocks for some reason. This would explain why it only happens sometimes and cannot be reproduced on other envs. It can be a pub-sub or Kafka issue and it can possibly affect other blocks. The fact that it happens after renewal in one case and after check-in in another case is, most probably, insignificant. Please check comment & workaround field in MODPATBLK-112 where there is a workaround for such cases - how to sync data when some of the messages are lost.

Attachments

13

Checklist

hide

TestRail: Results

Activity

Show:

Stephanie Buck February 28, 2022 at 6:03 PM

Please see workaround. 

Stephanie Buck February 28, 2022 at 6:02 PM

Thank you, . 

 

Thomas Trutt February 28, 2022 at 3:59 PM

 So I just tried to do a re-sync in Kiwi and the blocks are not clearing. I will contact our host about doing the extra step of clearing the data from the database. I wasn't sure if you would want to re-open this or not.

Stephanie Buck February 25, 2022 at 9:06 PM

That's correct, .

Thomas Trutt February 25, 2022 at 8:25 PM

Thanks .. It is also my understanding that the root cause of this issue has been addressed in Kiwi. If that is the case I have no issue closing the ticket. 

Done

Assignee

Unassigned

Reporter

Priority

Development Team

Vega

Release

R2 2021 Hot Fix #7

RCA Group

TBD

CSP Approved

Yes

Affected Institution

Cornell
Spokane Public Libraries
TAMU
University of Chicago

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs
Created January 7, 2022 at 3:41 AM
Updated March 1, 2022 at 6:01 PM
Resolved February 28, 2022 at 6:03 PM
TestRail: Cases
TestRail: Runs
Loading...