Quesnelia SP#9 - "MARC bib" record cannot be opened after update of (>1) linked "MARC authority" records via "Data import" (add $t/remove $t/change field number)

Description

Overview: "MARC bib" record cannot be opened after update of more than 1 linked "MARC authority" records via "Data import" (MARC authority records should become not eligible for control linked field).
Preconditions:

  1. The job profile should be created: "Update MARC authority records by matching 999 ff $s subfield value".

  2. Links to create between imported "MARC Authority" ( and ) and "MARC Bibliographic" ( ) records, description:
    The "100" MARC field with "$a" value "Beethoven, Ludwig van," of imported "Instance" record must be linked to the "100" field of imported "MARC Authority" record ("Robertson, Peter, 1950-2022 Inspector Banks series ;")
    The "240" MARC field with "$a" value "Variations," of imported "Instance" record must be linked to the "100" field of imported "MARC Authority" record ("Beethoven, Ludwig van, 1770-1827. Variations, piano, violin, cello, op. 44, E♭ major")

Steps to Reproduce:

  1. Log into Snapshot FOLIO environment as User with following permissions:
    Data import: Can upload files, import, and view logs
    Inventory: All permissions
    MARC Authority: View MARC authority record
    quickMARC: View, edit MARC bibliographic record
    UI: Data export module is enabled

  2. Go to "MARC authority" app in the new browser tab.

  3. Export both "MARC authority" records which are linked with imported "MARC bib" record

  4. Go to "Data export" app and download exported ".mrc" file.

  5. Open exported ".mrc" file via "MarcEdit" (or similar app).

  6. In a record without "$t" in "100" field, add "$t" to this field.
    For example, update field to:
    "=100  1\$aRobertson, Peter,$d1950-2022$cInspector Banks series$tTest"

  7. In a record with "$t" in "100" field, remove "$t" from this field.
    For example, update field to:
    "=100  1\$aBeethoven, Ludwig van,$d1770-1827.$mpiano, violin, cello,$nop. 44,$rE♭ major"

  8. Save the edited ".mrc" file

  9. Go to the "Data import" app and upload saved ".mrc" file using created "Update MARC authority records by matching 999 ff $s subfield value" job profile.

  10. Once import is complete, go to "Inventory" app and open imported "MARC bib" with linked fields, ex.:
    "Variations / Ludwig Van Beethoven."

  11. Click on the "Actions" >> "Edit MARC bibliographic record.

Expected Results:

  • Editing view of "MARC Bib" record is opened

  • Fields linked in Preconditions are unlinked ("100", "240" - because "MARC authority" records are no longer eligible to control that fields)

Actual Results: 
On UI: "Record cannot be found or loaded." error is displayed
On Back-end: "240" field has "linkDetails"

Additional Information:
Following updates in "MARC authority" record could make this record not eligible to control linked fields of "MARC bib":
1) Authority 1XX number change:
2) Authority 1XX has removed or added a "$t" (only for 100 and 240 MARC bibs fields).

See attached screencast:

Dev notes: check logs of mod-entities-links, mod-source-record-storage, mod-inventory

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

21

blocks

Checklist

hide

TestRail: Results

Activity

Show:

Natalia ZaitsevaJanuary 31, 2025 at 1:13 PM

no release is needed for mod-entities-links

Khalilah GambrellJanuary 30, 2025 at 5:27 PM

Looks good and . Only issue is the length of time to see these records in the Find Authority plug-in once you import the records.

Khalilah GambrellJanuary 30, 2025 at 5:15 PM

and - there is definitely a delay with indexing because records that should display in the Find authority plug-in take several minutes to display.

Valery_PilkoJanuary 23, 2025 at 1:38 PM
Edited

Tested on Sprint testing environment (all cases) - described issue is fixed, linked fields updated properly after MARC authority records update.
See attached screencast:

Number of titles also updated:



Khalilah GambrellJanuary 22, 2025 at 2:15 PM

This issue is a verification ticket and can only be tested once the linked issues are deployed to Q Bugfest environment.

Done

Details

Assignee

Reporter

Priority

Story Points

Sprint

Development Team

Spitfire

RCA Group

Data related (ex. Can be detected with large dataset only)

CSP Approved

Yes

Affected releases

Poppy (R2 2023)

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created July 19, 2023 at 12:24 PM
Updated January 31, 2025 at 1:58 PM
Resolved December 27, 2024 at 3:16 PM
TestRail: Cases
TestRail: Runs