Uploaded image for project: 'mod-source-record-storage'
  1. mod-source-record-storage
  2. MODSOURCE-492

Records that are overlaid multiple times via Inventory Single Record Import can't be overlaid after the second time - Morning Glory

    XMLWordPrintable

Details

    • 0
    • Folijet Support
    • Morning Glory (R2 2022)
    • Cornell
    • Legitimate regression

    Description

      Overview:

      Records that I loaded with a profile that involved MARC modifications return an error when I try to overlay them with Inventory Single Record Import. The error returned has been:
       
      io.vertx.pgclient.PgException: ERROR: current transaction is aborted, commands ignored until end of transaction block (25P02)

      Steps to Reproduce: (4 different ways)
      Option 1

      1. Log into Lotus bugfest
      2. Go to Inventory
      3. Go to Actions/Import
      4. Change the source in the Import pop-up to OCLC WorldCat and paste one of the OCLC numbers listed below.
      5. Once the Instance is created, and you get the green success toast, then In the Instance detail view Action menu, select Actions/Overlay source bibliographic record
      6. Change the source in the Import pop-up to OCLC WorldCat and paste a different (second) OCLC number from the list below.
      7. Check whether the green success toast displays
      8. Scroll down the Instance details to the Identifier section and see if the OCLC number matches the one you used for Overlay or for the original Create. It should be the one for Overlay, not the one for Create
      9. In the Instance detail view Action menu, select Actions/Overlay source bibliographic record again
      10. Change the source in the Import pop-up to OCLC WorldCat and paste a different (third) OCLC number from the list below.
      11. Check whether the green success toast displays
      12. Scroll down the Instance details to the Identifier section and see if the OCLC number matches the one you used for the second Overlay or for the first Overlay. It should be the one for the second Overlay, not the one for the first Overlay
      13. Click Actions/View source, and look at the 035 field with prefix (OCoLC) to see if it matches the number used for the second Overlay or for the First overlay
      14. Go to Data Import and click on View all
      15. Check whether the most recent import with job profile Inventory Single Record - Default Update Instance shows Completed or Completed with errors
      16. If it completed with errors, click on "No file name" and check whether the log displays an error message or not.

      Option 2

      1. Log into Lotus bugfest
      2. Go to Inventory
      3. Press Reset all to ensure you're starting with a clear screen
      4. In the filters in the first pane, select Source = MARC
      5. Select any instance from the search results
      6. In the Instance detail view Action menu, select Actions/Overlay source bibliographic record
      7. Change the source in the Import pop-up to OCLC WorldCat and paste an OCLC number from the list below.
      8. Check whether the green success toast displays
      9. In the Instance detail view Action menu, select Actions/Overlay source bibliographic record again
      10. Change the source in the Import pop-up to OCLC WorldCat and paste a different (second) OCLC number from the list below.
      11. Check whether the green success toast displays
      12. Scroll down the Instance details to the Identifier section and see if the OCLC number matches the one you used for the second Overlay or for the first Overlay. It should be the one for the second Overlay, not the one for the first Overlay
      13. Click Actions/View source, and look at the 035 field with prefix (OCoLC) to see if it matches the number used for the second Overlay or for the First overlay
      14. Go to Data Import and click on View all
      15. Check whether the most recent import with job profile Inventory Single Record - Default Update Instance shows Completed or Completed with errors
      16. If it completed with errors, click on "No file name" and check whether the log displays an error message or not.

      Option 3

      1. Log into Lotus bugfest
      2. Go to Inventory
      3. Press Reset all to ensure you're starting with a clear screen
      4. In the filters in the first pane, select Source = MARC
      5. Select any instance from the search results
      6. In the Instance detail view Action menu, select Actions/Overlay source bibliographic record
      7. Change the source in the Import pop-up to OCLC WorldCat and paste an OCLC number from the list below.
      8. Check whether the green success toast displays
      9. In the Instance detail view Action menu, select Actions/Edit MARC Bibliographic record
      10. Add or change something in the MARC 245 $a (the title field)
      11. Press Save and close
      12. Check that the title in the Instance was updated
      13. In the Instance detail view Action menu, select Actions/Overlay source bibliographic record again
      14. Change the source in the Import pop-up to OCLC WorldCat and paste a different (second) OCLC number from the list below.
      15. Check whether the green success toast displays
      16. Scroll down the Instance details to the Identifier section and see if the OCLC number matches the one you used for the second Overlay or for the first Overlay. It should be the one for the second Overlay, not the one for the first Overlay
      17. Click Actions/View source, and look at the 035 field with prefix (OCoLC) to see if it matches the number used for the second Overlay or for the First overlay
      18. Go to Data Import and click on View all
      19. Check whether the most recent import with job profile Inventory Single Record - Default Update Instance shows Completed or Completed with errors
      20. If it completed with errors, click on "No file name" and check whether the log displays an error message or not.

      Option 4

      1. Log into Lotus bugfest
      2. Import a small file of MARC records using a profile that has MARC modifications like: https://bugfest-lotus.int.aws.folio.org/settings/data-import/job-profiles/view/e188991b-caff-4bfd-a39a-6f54274c53de?sort=name
      3. Go to one of your newly created instance records in Inventory and overlay it with single record import from OCLC.
      4. Check whether the Instance was updated or not
      5. Check whether the Data Import log says Completed or Completed with errors

      Expected Results:

      • The SRS record is successfully overlaid
      • and the Instance is successfully updated to match the updated SRS record
      • and there is a green success toast in Inventory
      • and there is a "Completed" job in the Data Import Log (View all) that shows a job using job profile Inventory Single Record - Default Update Instance, with status of Completed,
      • and showing the title of the record when the No file name hotlink is clicked.

      Actual Results:

      • There SRS record is not successfully overlaid
      • And the Instance is not updated
      • But there is a green success toast in Inventory
      • And there is a "Completed with errors" job in the Data Import Log (View all) that shows a job using job profile Inventory Single Record - Default Update Instance
      • And when the user clicks No file name, they see
        • This list contains no items
        • Or an error message of:
          io.vertx.pgclient.PgException: ERROR: current transaction is aborted, commands ignored until end of transaction block (25P02)

      OCLC numbers that can be used for testing (and more can be easily supplied if needed):
      21525386
      31975777
      832928074
      944474006
      3252644
      899261268
      20827155
      664378873
      38111210
      958396277
      912958093
      29565288

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                ruslan_lavrov Ruslan Lavrov
                jenncolt Jenn Colt
                Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases