Updating "MARC Authority" record by matching "999 ff $s" subfield value, via "Data import", causes errors

Description

Overview: Updating "MARC Authority" record by matching "999 ff $s" subfield value fail with "Completed with errors" status and MARC record doesn't update.
 Steps to Reproduce:
 # Log into snapshot FOLIO environment as User the at least following permissions:
 -Data import: Can upload files, import, and view logs
 -Settings (Data import): Can view only"
 -Settings (Data import): Can view, create, edit, and remove
 -Edit MARC authority record
 -View MARC authority record
 -quickMARC: View, edit MARC authorities record
 1) Navigate to "Data import" app.
     Trigger the data import by clicking on the "or choose file" button at jobs panel and submitting "uniform_title.mrc" file, using "Default - Create SRS MARC Authority" job profile.
    Wait for import to complete and verify that MARC record successfully imported.

2) Navigate to "MARC Authority" app and open detail view of imported record [e.g.: "Cartoons & Comics"]
    Copy the value of "999 ff" field.
    Open imported file "uniform_title.mrc" via "MarcEditor".
    Edit any of "1XX-998" fields.
    Create "999 ff" field with $s and $i values which exactly matches values from opened record at step 5.
    Save edited ".mrc" file with a new name. [e.g.: "uniform_title _Updated.mrc"]

3) Navigate to "Settings/Data import/Match profiles"
  3.1. Create a new matching profile:
 Existing records = MARC Authority
 Incoming record type = MARC Authority
 Incoming MARC Authority record:
 Field = 999, Ind 1 = f, Ind 2 = f, Subfield = s
 Don't check "Use qualifier" and "Only compare part of this value"
 Match criterion = Exactly matches
 Existing MARC Authority record:
 Field = 999, Ind 1 = f, Ind 2 = f, Subfield = s
 Don't check "Use qualifier" and "Only compare part of this value"
 Save the match profile

  3.2. Go to Field mapping profiles and create a new one:
 Incoming record type = MARC Authority
 FOLIO record type = MARC Authority
 Field mappings for MARC = Updates
 Click on the "Save as profile and close" button.

  3.3. Go to Action profiles and create a new action profile:
 Action = Update (all record types except Orders)
 FOLIO record type = MARC Authority
 Link the mapping profile to this action profile.
 Click on the "Save as profile and close" button.

  3.4. Go to Job profiles and create a new job profile:
 Accepted data type = MARC
 Click on "+" button and select "Match" option
 Choose the match profile created earlier
 In "For matches" tab: Click on "+" button and select "Action" option
 Choose the action profile created earlier
Click on the "Save as profile and close" button.

 4) Navigate to "Data import" app.
 Trigger the data import by clicking on the "or choose file" button at jobs panel and submitting ".mrc" file with updates and "999 ff" field values, from "uniform_title _Updated.mrc".
 Click on created Job profile => Click "Run".
 Wait for import complete and click on title at appeared row.

Expected Results: Import success with "Complete" status. The "MARC Authority" record successfully updated.
 Actual Results: Import finish with "Complete with errors" status. "Authority" column displayed the status "Discarded".
 Additional Information: 
 1) See attached screencast.
 2) You can use attached ".mrc" files for import and update (don't forget to update "999 ff" field value in the "uniform_title _Updated.mrc" file.
 3) This problem is reproduced at [https://folio-snapshot.dev.folio.org/] and [https://sprint-testing.ci.folio.org/]
 But this problem NOT reproduce at [https://bugfest-lotus.int.aws.folio.org/

Link to created job profile at snapshot: [https://folio-snapshot.dev.folio.org/settings/data-import/job-profiles/view/9b71da9b-dbec-4347-a5b1-0497411c245c?sort=name]

Link on created job profile at bugfest: [https://bugfest-lotus.int.aws.folio.org/settings/data-import/job-profiles/view/24c64f97-bc30-4818-9e70-79cecbc0ceb0?query=999&sort=name]

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

8
  • 21 Jun 2022, 06:50 AM
  • 16 Jun 2022, 02:21 PM
  • 16 Jun 2022, 02:21 PM
  • 09 Jun 2022, 07:51 AM
  • 20 May 2022, 10:25 AM
  • 20 May 2022, 07:41 AM
  • 20 May 2022, 07:31 AM
  • 20 May 2022, 07:31 AM

Checklist

hide

TestRail: Results

Activity

Show:

Valery_PilkoJune 21, 2022 at 7:06 AM


I created a new User with the following permissions:

  • Data import: Can upload files, import, and view logs

  • MARC Authority: Delete MARC authority record

  • MARC Authority: Edit MARC authority record

  • MARC Authority: View MARC authority record

  • quickMARC: View, edit MARC authorities record

  • Settings (Data import): Can view, create, edit, and remove

  • UI: Data export module is enabled

Khalilah GambrellJune 21, 2022 at 7:02 AM

Thanks - what login are you using to verify?

Valery_PilkoJune 21, 2022 at 6:47 AM
Edited

 
Ok, let's see this issue closely on Wednesday
Today, I rechecked the following scenarios (all executed successfully):
1) Import "MARC Authority" record >> Export this record >> Edit via "MarcEdit" >>Update by matching 010 $a 
2) Import "MARC Authority" record >> Export this record >> Edit "MARC Authority" record via quickMARC >> Edit via "MarcEdit" >>Update by matching 999 ff $s 
3) Import "MARC Authortiy" record >> Update by matching 010 $a (first time) >> Update by matching 010 $a (second time) + Create new "MARC Authority" record
4) Export 4 record from "MARC Authority" app >>  Edit via "MarcEdit" >> Update 4 records by matching 999 ff $s

See attached screencast:

 

Khalilah GambrellJune 20, 2022 at 4:54 PM
Edited

there maybe an issue with snapshot but I cannot successfully update when matching 010$a or 999ff $s. I can demo the issue at our Wednesday meeting if you are unable to reproduce.

Valery_PilkoJune 16, 2022 at 2:21 PM
Edited

Verified at Snapshot environment - work as expected
See attached screencasts:

Done

Details

Assignee

Reporter

Priority

Story Points

Sprint

Development Team

Spitfire

Fix versions

Release

Morning Glory (R2 2022)

RCA Group

Legitimate regression

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created May 20, 2022 at 7:42 AM
Updated June 29, 2022 at 9:18 PM
Resolved June 23, 2022 at 1:31 PM
TestRail: Cases
TestRail: Runs

Flag notifications