Details
-
Bug
-
Status: Closed (View Workflow)
-
P2
-
Resolution: Done
-
None
-
-
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
- Log into Lotus bugfest
- Go to Inventory
- Go to Actions/Import
- Change the source in the Import pop-up to OCLC WorldCat and paste one of the OCLC numbers listed below.
- 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
- Change the source in the Import pop-up to OCLC WorldCat and paste a different (second) OCLC number from the list below.
- Check whether the green success toast displays
- 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
- In the Instance detail view Action menu, select Actions/Overlay source bibliographic record again
- Change the source in the Import pop-up to OCLC WorldCat and paste a different (third) OCLC number from the list below.
- Check whether the green success toast displays
- 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
- 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
- Go to Data Import and click on View all
- Check whether the most recent import with job profile Inventory Single Record - Default Update Instance shows Completed or Completed with errors
- If it completed with errors, click on "No file name" and check whether the log displays an error message or not.
Option 2
- Log into Lotus bugfest
- Go to Inventory
- Press Reset all to ensure you're starting with a clear screen
- In the filters in the first pane, select Source = MARC
- Select any instance from the search results
- In the Instance detail view Action menu, select Actions/Overlay source bibliographic record
- Change the source in the Import pop-up to OCLC WorldCat and paste an OCLC number from the list below.
- Check whether the green success toast displays
- In the Instance detail view Action menu, select Actions/Overlay source bibliographic record again
- Change the source in the Import pop-up to OCLC WorldCat and paste a different (second) OCLC number from the list below.
- Check whether the green success toast displays
- 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
- 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
- Go to Data Import and click on View all
- Check whether the most recent import with job profile Inventory Single Record - Default Update Instance shows Completed or Completed with errors
- If it completed with errors, click on "No file name" and check whether the log displays an error message or not.
Option 3
- Log into Lotus bugfest
- Go to Inventory
- Press Reset all to ensure you're starting with a clear screen
- In the filters in the first pane, select Source = MARC
- Select any instance from the search results
- In the Instance detail view Action menu, select Actions/Overlay source bibliographic record
- Change the source in the Import pop-up to OCLC WorldCat and paste an OCLC number from the list below.
- Check whether the green success toast displays
- In the Instance detail view Action menu, select Actions/Edit MARC Bibliographic record
- Add or change something in the MARC 245 $a (the title field)
- Press Save and close
- Check that the title in the Instance was updated
- In the Instance detail view Action menu, select Actions/Overlay source bibliographic record again
- Change the source in the Import pop-up to OCLC WorldCat and paste a different (second) OCLC number from the list below.
- Check whether the green success toast displays
- 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
- 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
- Go to Data Import and click on View all
- Check whether the most recent import with job profile Inventory Single Record - Default Update Instance shows Completed or Completed with errors
- If it completed with errors, click on "No file name" and check whether the log displays an error message or not.
Option 4
- Log into Lotus bugfest
- 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
- Go to one of your newly created instance records in Inventory and overlay it with single record import from OCLC.
- Check whether the Instance was updated or not
- 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
- clones
-
MODSOURCE-489 Records that are overlaid multiple times via Inventory Single Record Import can't be overlaid after the second time - Lotus BF
-
- Closed
-
- defines
-
UXPROD-3463 NFR: Data Import R1 2022 Lotus Support Bug Work
-
- Closed
-
- duplicates
-
MODQM-208 Lotus bugfest: Unable to overlay record after editing in quickMARC
-
- Closed
-