Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Import is completed with errors when control field that differs from 001 is used for marc-to-marc matching

Description

The issue was spotted during testing MODSOURCE-671.

Steps to Reproduce:

Import marc-bib record using job profile containing marc-to-marc matching and action profile for marc-bib update if a record matches. Marc-to-marc match profile should use a control field that differs from 001 as a match point (e.g. 008).

During investigation  in debug the following exception was found:
"io.vertx.pgclient.PgException: ERROR: syntax error at or near "393893" (42601)"

Due to redundant wrapping of value from incoming field by single quotation marks.
https://github.com/folio-org/mod-source-record-storage/blob/2b7e5b732f7d1a7b51685195aa1797df18feb147/mod-source-record-storage-server/src/main/java/org/folio/dao/RecordDaoImpl.java#L293

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Checklist

hide

TestRail: Results

Activity

Show:

Ann-Marie Breaux November 20, 2023 at 5:07 PM

JenkinsNotifications November 7, 2023 at 6:05 PM

Deployed to the Poppy bf env. Moved status to In bugfix review from status Awaiting deployment. Please proceed with the verification.

Ann-Marie Breaux November 6, 2023 at 8:00 AM

Thank you and and ! Moving this to Awaiting release

Maksym Ishchenko October 30, 2023 at 1:53 PM

Hello

Ticket verified on snapshot env. No errors appears after updating record using 00x match. Moving ticket to in review column

cc:  

Ruslan Lavrov September 12, 2023 at 8:33 AM

Hi , yes, by "control field" term I mean any field from range 001-009. However, this issue is relevant for all control fields except 001 because another query/logic is applied for matching by 001 field.

Done

Details

Assignee

Reporter

Labels

Priority

Story Points

Sprint

Development Team

Folijet

Parent

Fix versions

Release

Poppy (R2 2023) Bug Fix

RCA Group

Legitimate regression

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created August 4, 2023 at 11:43 AM
Updated November 20, 2023 at 5:07 PM
Resolved November 6, 2023 at 8:00 AM
TestRail: Cases
TestRail: Runs

Flag notifications