[RRT] Call number types in mappings mismatch tenant data

RCA Group

Not a bug

Description

DI completes with following error:

"io.vertx.core.impl.NoStackTraceThrowable: [{"id":"fa6070f7-99a7-4ea2-b48d-831ab2c21345","error":"{\n \"errors\" : [ {\n \"message\" : \"Cannot set holdings_record.callnumbertypeid = 82bd9278-c212-4fde-b5bf-c5f4139bbadd because it does not exist in call_number_type.id.\",\n \"type\" : \"1\",\n \"code\" : \"-1\",\n \"parameters\" : [ {\n \"key\" : \"holdings_record.callnumbertypeid\",\n \"value\" : \"82bd9278-c212-4fde-b5bf-c5f4139bbadd\"\n } ]\n } ]\n}","holdingId":null}] 

org.folio.processing.exceptions.EventProcessingException: [{"id":"fed54d1e-4e96-4207-a5de-212e9088cb8d","error":"insert or update on table \"holdings_record\" violates foreign key constraint \"callnumbertypeid_call_number_type_fkey\": Key (callnumbertypeid)=(aced0bd0-4b3f-41ea-a97c-0e70563c5c09) is not present in table \"call_number_type\".","holdingId":null}]"

 IDs for call number type used in the mapping profiles mismatch those existing in the Inventory settings

Environment

None

Potential Workaround

None

Checklist

hide

Activity

Show:

Kateryna SenchenkoMarch 25, 2024 at 1:08 PM

Call number type ids in mapping profiles should reflect those actually existing on the tenant. Mismatch could have happened if profiles were copied from other tenants, or reference data changed at some point. 

To resolve the issue - mapping profile can be edited, needed callNumberType selected from the dropdown list. The edit should pull in the current values from the tenant ref data.

Done

Details

Assignee

Reporter

Priority

Story Points

Sprint

Development Team

Folijet

Release

Quesnelia (R1 2024)

Affected releases

Poppy (R2 2023)

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created March 25, 2024 at 1:06 PM
Updated March 26, 2024 at 1:33 PM
Resolved March 26, 2024 at 1:32 PM
TestRail: Cases
TestRail: Runs