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



    • 0
    • Folijet Support
    • Lotus R1 2022
    • Data related (ex. Can be detected with large dataset only)


      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:
      Interested parties: Cornell, Duke

      TestRail: Results


          Issue Links



                abreaux Ann-Marie Breaux
                Leeda Leeda Adkins
                0 Vote for this issue
                2 Start watching this issue



                  TestRail: Runs

                    TestRail: Cases