Details
-
Bug
-
Status: Closed (View Workflow)
-
P2
-
Resolution: Won't Do
-
None
-
None
-
Folijet Sprint 143
-
1
-
Folijet
-
Morning Glory (R2 2022)
-
Not a bug
Description
Overview: Updating "MARC Authority" record by matching using "999 ff $s" or "010 $a" values via "Data import" fails at https://folio-scratch-sprint-testing.ci.folio.org/ environment.
Steps to Reproduce:
- Log into https://folio-scratch-sprint-testing.ci.folio.org/ environment as User with the following permissions:
Data import: Can upload files, import, and view logs
Settings (Data import): Can view, create, edit, and remove
Edit MARC authority record
View MARC authority record
quickMARC: View, edit MARC authorities record
UI: Data export module is enabled - Navigate to "Settings/Data import/Match profiles"
2.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
2.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.
2.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.
2.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.
3. Navigate to "MARC Authority" app.
4. Fill in the input field with search query, which will retrieve records [e.g.: "*"]>> Click on the "Search" button.
5. Check the checkbox next to any record.
6. Click on the "Actions" dropdown button and choose "Export selected records (CSV/MARC)" option from the dropdown.
7. Navigate to "Data export" app and download generated ".mrc" file by clicking on title at the appeared row.
8. Open downloaded ".mrc" file via "MarcEditor".
9. Edit any value of 1XX-998 fields in "MARC Authority" record at the opened file.
10. Save ".mrc" file with changes.
11. Navigate to "Data import" app and trigger the data import by clicking on the "or choose file" button at jobs panel and submitting ".mrc" file with edited "MARC Authority" records.
12. Select update job profile that you created at step 2 (e.g.: "Update MARC authority records by matching 999 ff $s subfield value")
13. Click on the "Actions menu" button > Select "Run" > Click on the "Run" button at displayed modal.
Expected Results: Once import is complete then a new row with "Completed" status will display in Logs details.
Actual Results: Once import is complete then a new row with "Completed with errors" status is displayed in Logs details. The error message: "io.vertx.pgclient.PgException: ERROR: duplicate key value violates unique constraint "idx_records_matched_id_gen" (23505)"
Additional Information: See attached screencast.
This issue reproduced only at https://folio-scratch-sprint-testing.ci.folio.org/ environment.
The same issue is reproducing for update "MARC Authority" record by matching on 010 $a subfield value.
The same issue is reproducing for update "MARC Bibliographic" record by matching on 999 ff $s subfield value
TestRail: Results
Attachments
Issue Links
- defines
-
UXPROD-3446 NFR: Data Import R2 2022 Morning Glory Technical, NFR, & Misc work
-
- Closed
-
- relates to
-
MODDATAIMP-428 Cancelled data import jobs sometimes continue on to completion
-
- Closed
-
-
MODINV-705 Updating "MARC Authority" record by matching "999 ff $s" subfield value, via "Data import", causes errors
-
- Closed
-
-
MODSOURCE-531 Can't update "MARC" record, which was created by stopped import job
-
- Closed
-
-
UXPROD-1383 Ability to roll back a load if problems
-
- Draft
-