Uploaded image for project: 'data-import-processing-core'
  1. data-import-processing-core
  2. MODDICORE-215

When HRID Handling is reset, Data Import cannot create instances - DRAFT

    XMLWordPrintable

    Details

    • Template:
      Standard Bug Write-Up Format
    • Development Team:
      Folijet Support
    • Release:
      Lotus R1 2022

      Description

      Overview: When the instance number in HRID Handling is reset, and the number is lower than the last number in Inventory, Data Import "create instance" actions fail with the error "value already exists in table instance". Expected behavior of Data Import "create" actions is to begin from the next number available in the table. This occurs often in bugfest environments where settings tests are ongoing.

      1. Decide if additional warning modal or UI text is needed. 2. If library resets to a previous start number, use the next unassigned number

      Steps to Reproduce:

      1. In Settings, Inventory, HRID Handling, change the "start with" number for Inventory Instances to a number lower than the current highest number in the table instance.
      2. Click Save and Close.
      3. Have a MARC file prepared to load into FOLIO.
      4. Find a job profile with the action of "create instance" in Settings, Data Import, Job Profiles.
      5. In Data Import, select "choose files" (or drag and drop MARC file into the square), and select the job profile with the "create instance" action. 
      6. Click Run, and Run.

      Expected Results: SRS MARC and Instance records are created.
      Actual Results: SRS MARC is created, but Instance is discarded. Error message reads "io.vertx.core.impl.NoStackTraceThrowable: lower(f_unaccent(jsonb ->> 'hrid'::text)) value already exists in table instance: in20000030"
      Additional Information:
      URL:
      Interested parties: Cornell, Duke

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                abreaux Ann-Marie Breaux
                Reporter:
                Leeda Leeda Adkins
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                  Dates

                  Created:
                  Updated:

                    TestRail: Runs

                      TestRail: Cases