Uploaded image for project: 'mod-data-import'
  1. mod-data-import
  2. MODDATAIMP-702

Updating "MARC" record by matching profile via "Data import" fails

    XMLWordPrintable

Details

    • 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:

      1. 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
      2. 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

            Activity

              People

                Miami20 Khamidulla Abdulkhakimov
                valpil Valery Pilko
                Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases