[Evergreen-acq] Linking to bib records

[Mary Llewellyn]

We get the Attempt to Query the Database failed message if no provider has
been selected on the upload screen.

On Tue, Jan 17, 2023 at 9:51 AM Tiffany Little <tlittle at georgialibraries.org>
wrote:

> 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
>>
>

-- 
Mary Llewellyn
Database Manager
Bibliomation, Inc.
24 Wooster Ave.
Waterbury, CT 06708
mllewell at biblio.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-acq/attachments/20230117/d7e1fcf0/attachment-0001.htm>