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

Data Import job creates duplicate marc records for a few records in the import file

    XMLWordPrintable

Details

    • 5
    • Folijet Support
    • Lotus (R1 2022) Bug Fix
    • Cornell
    • Not a bug

    Description

      Overview: 

      This issue is observed in a Kiwi Hotfix-1 environment

      For a small number of records (duplicate marc records are created) - 3 of 2919 records in the import file where this was observed

      Specifically issue was observed with the very first import of the day

      This message is observed in the logs
      Below message is observed in mod-inventory-storage log file (for each record with issue)
      12:57:44 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='23F09', message='Ignoring optimistic locking conflict while overwriting changed record 22b6f3fc-a008-4c8f-9c69-775db54a16a0: Stored _version is 4, _version of request is 3', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='PL/pgSQL function instance_set_ol_version() line 8 at RAISE', file='pl_exec.c', line='3855', routine='exec_stmt_raise', schema='fs00001034_mod_inventory_storage', table='instance', column='null', dataType='null', constraint='null'

      When looking at these same records in the UI, they can't be edited in quick marc because there are two versions of the marc record.

      Steps to Reproduce:

      1. Log into a Kiwi Hotfix-1 environment
      2. Perform a Data Import of the Attached file with associated Profile

      Attached content of 
      GET change-manager/jobExecutions/ed3a7f7b-bae9-4df4-a26e-90a03607ff8b for job profile information

       

      Expected Results:

      Import is successful and does not create duplicate marc record entries
      Actual Results:
      Data Import creates multiple marc record entries for a small subset of total record.

      Messages regarding optimistic locking observed in log file

      Attempting to edit records in Quick Marc results in errors due to duplicate marc entries

      Additional Information:

      Interested parties:
      cc: jenncolt

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                Aivar Iusupov Aivar Iusupov
                cgodfrey Carole Godfrey
                Votes:
                0 Vote for this issue
                Watchers:
                8 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases