[Evergreen-acq] Linking to bib records

[Tiffany Little]

Hi Samantha,

The fact that the error was "attempt to query the database failed" makes me
think there was something going on server-side. So maybe partway through
the upload something happened on the server and the queue wasn't able to
finish processing.

This doesn't help in this particular situation, but here's some of the
common errors that we've seen and how to fix them:
https://pines.georgialibraries.org/dokuwiki/doku.php?id=acq:purchaseorders_howto#fixes_for_errors

Tiffany

Tiffany Little, PINES Services Specialist: Acquisitions

------------------------------

Georgia Public Library Service | University System of Georgia

2872 Woodcock Blvd, Suite 250 l Atlanta, GA 30341

(404) 235-7161 | tlittle at georgialibraries.org

Join our email list <http://georgialibraries.org/> for stories of Georgia
libraries making an impact in our communities.


On Tue, Jan 17, 2023 at 9:44 AM Mary Llewellyn via Evergreen-acq <
evergreen-acq at list.evergreen-ils.org> wrote:

> Hi Samantha,
>
> Did she enter a new queue name during the first upload? Not having a queue
> is usually the reason for being prompted with a screen that looks like the
> upload screen. That's a second chance to enter a new queue name.
>
> Another thing to look at is to Expand all the line items and check each
> copy to be certain a branch is filled in. If you find some lines without
> branches, go to the copy level to fill in a branch, then click Save
> Changes, then Return to go back to the purchase order. Repeat as needed.
>
> Those are the most frequent causes in our system. I hope this helps.
>
> Mary
>
>
> On Tue, Jan 17, 2023 at 8:38 AM O'Connor, Samantha via Evergreen-acq <
> evergreen-acq at list.evergreen-ils.org> wrote:
>
>> Good morning,
>>
>> A staff member from one of our member libraries ran into an issue with a
>> purchase order last week and I'm trying to understand some of the
>> mechanisms behind what happened. She created the Purchase Order via the
>> Load MARC Order Records option. She did not choose to activate the Purchase
>> Order upon creation. When she went to activate the PO, she was prompted to
>> upload the records again. She then discovered that several of the line
>> items in the PO had not linked with the correct bib record. Upon inspecting
>> the queue, it appears that for some of the items, the attempt to query the
>> database failed. There were no problems I could find within the records
>> themselves. She was able to manually link them, at which point she was
>> able to activate the PO without uploading the records a second time.
>>
>> Is there any reason why some of the records would have failed to query
>> the database, but not all of them?
>>
>> *Samantha O’Connor*
>>
>> NC Cardinal Training Specialist
>>
>> NC Dept. of Natural and Cultural Resources
>>
>> *samantha.oconnor at ncdcr.gov <samantha.oconnor at ncdcr.gov> *
>>
>> https://statelibrary.ncdcr.gov/ld/nc-cardinal
>>
>>
>> 109 East Jones Street | 4640 Mail Service Center
>> Raleigh, North Carolina 27699-4600
>>
>> Facebook <https://www.facebook.com/StateLibraryNC/>  Twitter
>> <https://twitter.com/StateLibraryNC>  Instagram
>> <http://www.instagram.com/ncculture>  YouTube
>> <https://www.youtube.com/user/statelibrarync/>  Website
>> <https://statelibrary.ncdcr.gov/>
>>
>> _______________________________________________
>> Evergreen-acq mailing list
>> Evergreen-acq at list.evergreen-ils.org
>> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-acq
>>
>
>
> --
> Mary Llewellyn
> Database Manager
> Bibliomation, Inc.
> 24 Wooster Ave.
> Waterbury, CT 06708
> mllewell at biblio.org
> _______________________________________________
> Evergreen-acq mailing list
> Evergreen-acq at list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-acq
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-acq/attachments/20230117/94873d2d/attachment.htm>