Serials Batch Receive - unable to search by ISSN or Database ID

Bug #1682296 reported by Christine Burns on 2017-04-12
This bug affects 1 person
Affects Status Importance Assigned to Milestone

Bug Description

New bug discovered in Evergreen version 2.12

In the Serials Batch Receive interface you are supposed to be able to search for receivable issues using either the Database ID or ISSN.

when attempting to search by Database ID or ISSN I get the following error = "Database Query Failed" followed by "No matching records found with any subscriptions attached"

If you access the Serials batch receive interface from a specific record the interface loads as usual.

Example Search -> Retrieve title by database ID -> Actions for this Record -> Serials Batch Receive -> Next -> this works as expected & receivable issues are listed.

But if you click on "Start Over" you are prompted to "Enter an identifier for a bibliographic record" this is where the search fails

Example enter "109242427" results in the 2 errors attached

Desired behavior - If you enter a database ID or ISSN in the "Enter an identifier for a bibliographic record" field the receivable issuances should be displayed

Jeff Davis (jdavis-sitka) wrote :

Working branch user/jeffdavis/lp1682296-db-error-serials-batch-receive has a fix for this:;a=commitdiff;h=655e45f

The branch is several months old but the commit can be cherry-picked to current master without any trouble.

tags: added: pullrequest
Changed in evergreen:
milestone: none → 3.0.2
Changed in evergreen:
milestone: 3.0.2 → 3.0.3
Changed in evergreen:
milestone: 3.0.3 → 3.0.4
Changed in evergreen:
milestone: 3.0.4 → 3.05
Changed in evergreen:
milestone: 3.0.5 → 3.0.6
Cesar V (cesardv) wrote :

Tested this on a local 2.12 EG instance, XUL client no longer gives DB query error when searching by BRE id in Serial Batch Receive. Thanks Jeff!

Here's a fresher signed off branch:;a=shortlog;h=refs/heads/user/cesardv/jeffdavis_lp1682296-db-error-serials-batch-receive

tags: added: signedoff
Changed in evergreen:
milestone: 3.0.6 → 3.0.7
Galen Charlton (gmc) on 2018-03-30
Changed in evergreen:
milestone: 3.0.7 → 3.1.1
status: New → Confirmed
importance: Undecided → Medium
Changed in evergreen:
milestone: 3.1.1 → 3.1.2
Galen Charlton (gmc) on 2018-04-30
Changed in evergreen:
assignee: nobody → Galen Charlton (gmc)
Galen Charlton (gmc) wrote :

Pushed to master, rel_3_1, and rel_3_0. Thanks, Jeff and Cesar!

Changed in evergreen:
assignee: Galen Charlton (gmc) → nobody
status: Confirmed → Fix Committed
Changed in evergreen:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers