Details
-
Bug
-
Status: Closed (View Workflow)
-
P3
-
Resolution: Done
-
None
-
-
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:
- Log into any Nolana FOLIO environment
- 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.)
- 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
- blocks
-
MODINV-781 Release v20.0.1
-
- Closed
-
- defines
-
UXPROD-3725 NFR: Data Import Technical, NFR, & Misc work (Orchid R1 2023)
-
- Closed
-
- relates to
-
MODINV-588 Implement deduplication for Instances
-
- Closed
-