Web client: cannot edit item or call number after mono part assigned
Bug #1739271 reported by
Elaine Hardy
This bug affects 15 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
Fix Released
|
High
|
Unassigned | ||
3.0 |
Fix Released
|
High
|
Unassigned |
Bug Description
After an item/copy has an assigned monographic parts label, whether at time of cataloging or later, you cannot make changes to item attributes or the call number. You have to remove the label, make the changes, and reaasign the label.
Changed in evergreen: | |
status: | New → Confirmed |
Changed in evergreen: | |
importance: | Undecided → High |
Changed in evergreen: | |
assignee: | nobody → Dan Pearl (dpearl) |
tags: | added: signedoff |
Changed in evergreen: | |
milestone: | none → 3.1.3 |
no longer affects: | evergreen/3.1 |
Changed in evergreen: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
I filed a new bug and found this one later. Here is more information to lead us to a solution:
When editing an existing copy that is already assigned a part using the web based staff client, we are seeing errors in the logs:
open-ils.cstore 2017-12-29 15:02:35 [ERR :734:oils_ sql.c:2522: 151455963470971 582] open-ils.cstore ERROR inserting biblio: :monograph_ part object using query [INSERT INTO biblio. monograph_ part (id,record, label,label_ sortkey, deleted) VALUES (DEFAULT, 1039176, '2017/11& /12',DEFAULT, DEFAULT) ;]: 3505685 3505685: ERROR: duplicate key value violates unique constraint "record_ label_unique_ idx"
DETAIL: Key (record, label)=(1039176, 2017/11&/12) already exists.
[2017-12-29 15:02:35] open-ils.cat [ERR :29061: CStoreEditor. pm:139: 151455963470971 582] editor[1|10497] request error open-ils. cstore. direct. biblio. monograph_ part.create : <new object> : Exception: OpenSRF: :DomainObject: :oilsMethodExce ption 2017-12-29T15:02:35 OpenILS: :Utils: :CStoreEditor /usr/local/ share/perl/ 5.22.1/ OpenILS/ Utils/CStoreEdi tor.pm: 465 <500> INSERT error -- please see the error log for more details
[2017-12-29 15:02:35] open-ils.cat [ERR :29061: EX.pm:66: 151455963470971 582] Exception: OpenSRF: :DomainObject: :oilsMethodExce ption 2017-12-29T15:02:35 OpenILS: :Utils: :CStoreEditor /usr/local/ share/perl/ 5.22.1/ OpenILS/ Utils/CStoreEdi tor.pm: 478 <500> INSERT error -- please see the error log for more details
[2017-12-29 15:02:35] open-ils.cat [INFO:29061: CStoreEditor. pm:139: 151455963470971 582] editor[1|10497] request returned no data : open-ils. cstore. direct. biblio. monograph_ part.create
It's attempting to create a new part when it needs to just use the one that it already has.