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

    • eHoldings Sprint 122
    • 2
    • Spitfire
    • R2 2021 Hot Fix #2
    • Yes
    • Implementation coding issue

    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:

      abreaux Kateryna Senchenko

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases