Uploaded image for project: 'mod-inventory'
  1. mod-inventory
  2. MODINV-778

Type Mismatch Error on record_id column

    XMLWordPrintable

Details

    • Folijet Sprint 159
    • 0.5
    • Folijet
    • Orchid (R1 2023) Bug Fix
    • Third party component integration
    • Nolana (R3 2022)

    Description

      Overview:  

      The following error messages show in the database during data import (of MARC BIB or MARC Holdings Creates) 

      2023-02-08 22:17:59 UTC:10.23.10.155(57958):folio@folio:[21227]:ERROR:  column "record_id" is of type uuid but expression is of type text at character 157
      2023-02-08 22:17:59 UTC:10.23.10.155(57958):folio@folio:[21227]:HINT:  You will need to rewrite or cast the expression.
      2023-02-08 22:17:59 UTC:10.23.10.155(57958):folio@folio:[21227]:STATEMENT:  WITH input_rows(record_id, item_id) AS (
             VALUES ($1,$2)
          )
          , ins AS (
             INSERT INTO fs09000000_mod_inventory.records_items(record_id, item_id)
             SELECT * FROM input_rows
             ON CONFLICT (record_id) DO NOTHING
             RETURNING record_id, item_id
             )
          SELECT record_id, item_id
          FROM   ins
          UNION  ALL
          SELECT c.record_id, c.item_id 
          FROM   input_rows
          JOIN   fs09000000_mod_inventory.records_items c USING (record_id); 

      Steps to Reproduce:

      1. Log into any Nolana FOLIO environment
      2. Perform a MARC BIB (or Holdings) Create Import with the attached file using a profile that creates SRS, instances, items, and holdings records. (Or use the Default - Create Holdings and SRS MARC Holdings profile with a MARC Holdings file.)
      3. Observe the errors in the database log

      Expected Results:

      • No errors in the database logs
        Actual Results:
      • Seems like every entry written into the items table results in this error

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                Roman_Chernetskyi Roman Chernetskyi
                mtraneis Martin Tran
                Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases