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

The DB type MARC did not get updated to MARC_BIB

    XMLWordPrintable

    Details

    • Template:
      Standard Bug Write-Up Format
    • Sprint:
      eHoldings Sprint 122
    • Story Points:
      2
    • Development Team:
      Spitfire
    • Release:
      R2 2021 Hot Fix #2
    • Hot Fix Approved by Cap Planning?:
      Yes

      Description

      Overview:

      After updating mod-srs to version 5.1.4, data import failed with the errors:
       
      WARN RecordDaoImpl [376802223eqId] Error occurred on batch execution: ERROR: invalid input value for enum record_type: "MARC_BIB"
       
      ERROR: insert or update on table “raw_records_lb” violates foreign key constraint “fk_raw_records_records” Detail: Key (id)=(9c0fab3f-a1ab-4a2e-b07f-eb8b9a0f82e7) is not present in table “records_lb”.
       
      After investigation It turns out that this is due to the DB type MARC was changed to MARC_BIB but it was not updated in the database.  Normally metadata like these needs to be updated by a DB migration script to change the value of the row. Perhaps there was a script for it but either it did not run or errored out, or there might have been no script at all. This issue needs to be investigated and fixed.

      Steps to Reproduce:

      1. Run any DI CREATE job after upgrading mod-srs to version 5.1.4

      Expected Results:

      • The DI job completes successfully
        Actual Results:
      • The DI job completed with errors.
        Additional Information:
      • Found in FSE and PTF environments

      • Interested parties:

      Ann-Marie Breaux Kateryna Senchenko

        TestRail: Results

          Attachments

          1. image-2021-08-31-08-55-05-994.png
            191 kB
            Martin Tran
          2. image-2021-09-17-14-57-54-787.png
            16 kB
            Ilya Silkov
          3. screenshot-1.png
            50 kB
            Pavlo Smahin

            Issue Links

              Activity

                People

                Assignee:
                Daos Serhii Zdorenko
                Reporter:
                mtraneis Martin Tran
                Votes:
                0 Vote for this issue
                Watchers:
                13 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases