Bulk edit of holdings locations cause bad data insertion

Description

Overview:

While staff were working in Poppy they found that some item records could not be moved between holdings, this led us to submit a ticket with FSE who informed us the root cause was this JIRA: https://folio-org.atlassian.net/browse/MODINVSTOR-1094 .

After informing the support group Jeen did some investigation and found that when locations are changed in Bulk edit the permanentLocation location field ie being written to.

beforeBulkEdit.png
afterBulkEdit.png

 

Steps to Reproduce:

  1. Create a list of holding IDs; upload to the Bulk edit, or build a query selecting one or more holding records.

  2. Perform the change permanent location action

Expected Results:

The location is changed, and no extra fields are added to the data set.

Actual Results:

The permanentLocation field is saved to the data set.

Additional Information:
There is a conversation around this issue here: https://folio-project.slack.com/archives/CQ7EK52LB/p1726530355361779 and here: https://folio-project.slack.com/archives/CQ7EK52LB/p1726570597292849

 

Interested parties:

, and

I spoke with Magda about this and she indicated that Bulk edit is just using the APIs available via Inventory to perform these actions, so this issue may be with the Poppy Inventory APIs.

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None at this moment as the script to repair this bad data needs to be run by FSE.

Attachments

7
  • 18 Sep 2024, 09:34 PM
  • 18 Sep 2024, 09:34 PM
  • 18 Sep 2024, 09:34 PM
  • 18 Sep 2024, 09:34 PM
  • 18 Sep 2024, 09:34 PM
  • 18 Sep 2024, 12:22 PM
  • 18 Sep 2024, 12:22 PM

Checklist

hide

Activity

Show:

Magda Zacharska November 21, 2024 at 1:55 PM

The issue has been resolved in Quesnelia release.

Magda Zacharska September 18, 2024 at 9:34 PM

I have confirmed that this is indeed the bulk edit bug in the Poppy release. The change does not occur when the record is edited in Inventory UI.

The holdings record before updates of the permanent location:

image-20240918-211135.png

The holdings record after updates in Inventory UI (no changes in the record structure):

image-20240918-211730.png

The holdings record after Bulk edit updates (the structure of the record changes):

 

image-20240918-212337.png

The issue is not reproducible in the Quesnelia release:

Holdings record before bulk edit:

image-20240918-212849.png

Holdings record after bulk edit (no changes in the record structure)

image-20240918-213309.png
Cannot Reproduce

Details

Assignee

Reporter

Priority

Development Team

Firebird

RCA Group

TBD

Affected Institution

!!!ALL!!!

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created September 17, 2024 at 7:37 PM
Updated November 21, 2024 at 1:55 PM
Resolved November 21, 2024 at 1:55 PM
TestRail: Cases
TestRail: Runs

Flag notifications