<div dir="ltr">We get the Attempt to Query the Database failed message if no provider has been selected on the upload screen. <br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Jan 17, 2023 at 9:51 AM Tiffany Little <<a href="mailto:tlittle@georgialibraries.org">tlittle@georgialibraries.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small">Hi Samantha,</div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small">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.</div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small">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: <a href="https://pines.georgialibraries.org/dokuwiki/doku.php?id=acq:purchaseorders_howto#fixes_for_errors" target="_blank">https://pines.georgialibraries.org/dokuwiki/doku.php?id=acq:purchaseorders_howto#fixes_for_errors</a></div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small">Tiffany</div><div><div dir="ltr"><div dir="ltr"><span><br><div dir="ltr" style="margin-left:0pt" align="left"><table style="border:medium none;border-collapse:collapse"><colgroup><col width="89"><col width="414"></colgroup><tbody><tr style="height:123pt"><td style="vertical-align:top;padding:5pt;overflow:hidden"><p dir="ltr" style="line-height:1.44;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><span style="border:medium none;display:inline-block;overflow:hidden;width:75px;height:75px"><img src="https://lh6.googleusercontent.com/8c2XlzLbIIC6nDoa4yqQ8MzA0npF4WXpUnhhoK_uTqralZtjqVXRwPgmRep3jGYP6q41Sb0ULXqxX-QppYTC8cQyIfBAdqzLBgqvcQwVczkqqiunlj0KIbvy-R3bp-E0mlhF0A4v" style="margin-left: 0px; margin-top: 0px;" width="75" height="75"></span></span></p></td><td style="vertical-align:top;padding:5pt;overflow:hidden"><p dir="ltr" style="line-height:1.44;margin-left:9pt;margin-top:0pt;margin-bottom:0pt"><span style="color:rgb(30,67,155);background-color:transparent;font-weight:700;vertical-align:baseline;white-space:pre-wrap"><font face="tahoma, sans-serif">Tiffany Little, PINES Services Specialist: Acquisitions</font></span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"></p><hr><p></p><p dir="ltr" style="line-height:1.44;margin-left:9pt;margin-top:0pt;margin-bottom:0pt"><span style="font-size:9pt;color:rgb(30,67,155);background-color:transparent;font-weight:700;vertical-align:baseline;white-space:pre-wrap"><font face="tahoma, sans-serif">Georgia Public Library Service | University System of Georgia</font></span></p><p dir="ltr" style="line-height:1.44;margin-left:9pt;margin-top:0pt;margin-bottom:0pt"><span style="font-size:9pt;color:rgb(30,67,155);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><font face="tahoma, sans-serif">2872 Woodcock Blvd, Suite 250 l Atlanta, GA 30341</font></span></p><p dir="ltr" style="line-height:1.44;margin-left:9pt;margin-top:0pt;margin-bottom:0pt"><span style="font-size:9pt;color:rgb(30,67,155);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><font face="tahoma, sans-serif">(404) 235-7161 | <a href="mailto:tlittle@georgialibraries.org" target="_blank">tlittle@georgialibraries.org</a></font></span></p><br><p dir="ltr" style="line-height:1.44;margin-left:9pt;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><span style="border:medium none;display:inline-block;overflow:hidden;width:36px;height:36px"><img src="https://lh6.googleusercontent.com/ql1so1R8csbb2W7DW5vjWe3mTAcApuM7a5CMXbsYnhmF1bDmG62LM_C1BOOyWdkb2PZGKGlaYRIceHjsSvsWPXNw6HPCKqtFLMKCJiPVU0RXu2dAey13WZ02Q6E6FmzNDJ_d9iBf" style="margin-left: 0px; margin-top: 0px;" width="36" height="36"></span></span><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><span style="border:medium none;display:inline-block;overflow:hidden;width:35px;height:35px"><img src="https://lh3.googleusercontent.com/2qSr0-AREIyPSTC1gMsjyXLaBT-yQ7kS6iKvd1L9XrCXxhJDWCRo5eXBHCi7f35AZASOOyiH2Si-wtuXNR8YaA2j-17GWBmmo1mpGxXa7m-JwF4AzUD_5tZZE9n1NVilAJcnGtQs" style="margin-left: 0px; margin-top: 0px;" width="35" height="35"></span></span><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><span style="border:medium none;display:inline-block;overflow:hidden;width:35px;height:35px"><img src="https://lh6.googleusercontent.com/-jM_GEWd7EZGo5MFiR1koKEkiupb_lmwNEMpNiQE3U6k1C2FkyuiNjtGKlWWGfX8zbZ1135yhOHnJSINmMTXgEQuu2RlHIg5hDKxaJ9cmh3Nr6el_vN4ZHlXcAmoCPPWduwXi26m" style="margin-left: 0px; margin-top: 0px;" width="35" height="35"></span></span></p></td></tr><tr style="height:21pt"><td colspan="2" style="vertical-align:top;padding:5pt;overflow:hidden"><p dir="ltr" style="line-height:1.44;text-align:center;margin-top:0pt;margin-bottom:0pt"><a href="http://georgialibraries.org/" target="_blank"><span style="font-size:8pt;font-family:Verdana;color:rgb(17,85,204);background-color:transparent;font-style:italic;vertical-align:baseline;white-space:pre-wrap">Join our email list</span></a><span style="font-size:8pt;font-family:Verdana;color:rgb(0,0,0);background-color:transparent;font-style:italic;vertical-align:baseline;white-space:pre-wrap"> </span><span style="font-size:8pt;font-family:Verdana;color:rgb(67,67,67);background-color:transparent;font-style:italic;vertical-align:baseline;white-space:pre-wrap">for stories of Georgia libraries making an impact in our communities.</span></p></td></tr></tbody></table></div></span></div></div></div><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Jan 17, 2023 at 9:44 AM Mary Llewellyn via Evergreen-acq <<a href="mailto:evergreen-acq@list.evergreen-ils.org" target="_blank">evergreen-acq@list.evergreen-ils.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>Hi Samantha,</div><div><br></div><div>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.<br></div><div><br></div><div>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.</div><div><br></div><div>Those are the most frequent causes in our system. I hope this helps.</div><div><br></div><div>Mary</div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Jan 17, 2023 at 8:38 AM O'Connor, Samantha via Evergreen-acq <<a href="mailto:evergreen-acq@list.evergreen-ils.org" target="_blank">evergreen-acq@list.evergreen-ils.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div>




<div dir="ltr">
<div><span style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">Good morning,</span></div>
<div><span style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)"><br>
</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">
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.
<span style="background-color:rgb(255,255,255);display:inline">
There were no problems I could find within the records themselves.<span> </span></span>She was able to manually link them, at which point she was able to activate the PO without uploading the records a second time. </div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">
Is there any reason why some of the records would have failed to query the database, but not all of them?</div>
<div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div id="m_-5482235765188907885m_6117712352349953314m_4472931198209048030Signature">
<div>
<div><span style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">
<p style="margin:0in;color:rgb(36,36,36);text-align:start;font-size:11pt;font-family:Calibri,sans-serif;background-color:rgb(255,255,255)">
<b><span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px;color:black">Samantha O’Connor</span></b></p>
<p style="margin:0in;color:rgb(36,36,36);text-align:start;font-size:11pt;font-family:Calibri,sans-serif;background-color:rgb(255,255,255)">
<span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px;color:black">NC Cardinal Training Specialist</span></p>
<p style="margin:0in;color:rgb(36,36,36);text-align:start;font-size:11pt;font-family:Calibri,sans-serif;background-color:rgb(255,255,255)">
<span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px;color:black">NC Dept. of Natural and Cultural Resources</span></p>
<p style="margin:0in;color:rgb(36,36,36);text-align:start;font-size:11pt;font-family:Calibri,sans-serif;background-color:rgb(255,255,255)">
<u><span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px;color:rgb(5,99,193)"><a href="mailto:samantha.oconnor@ncdcr.gov" rel="noopener noreferrer" style="margin:0px" target="_blank"><span style="margin:0px;color:blue">samantha.oconnor@ncdcr.gov</span></a><span style="margin:0px"> </span></span></u><span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px;color:black"> </span><span style="font-size:10pt;margin:0px;color:black"></span></p>
<p style="margin:0in;color:rgb(36,36,36);text-align:start;font-size:11pt;font-family:Calibri,sans-serif;background-color:rgb(255,255,255)">
<span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px;color:black"><a href="https://statelibrary.ncdcr.gov/ld/nc-cardinal" rel="noopener noreferrer" style="margin:0px" target="_blank"><span style="margin:0px;color:rgb(5,99,193)">https://statelibrary.ncdcr.gov/ld/nc-cardinal</span></a></span></p>
<p style="margin:0in;color:rgb(36,36,36);text-align:start;font-size:11pt;font-family:Calibri,sans-serif;background-color:rgb(255,255,255)">
<span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px;color:black"><br>
109 East Jones Street | 4640 Mail Service Center </span><span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px"><br>
<span style="margin:0px;color:black">Raleigh, North Carolina 27699-4600</span></span></p>
<p style="margin:6pt 0in 0in;color:rgb(36,36,36);text-align:start;font-size:11pt;font-family:Calibri,sans-serif;background-color:rgb(255,255,255)">
<a href="https://www.facebook.com/StateLibraryNC/" rel="noopener noreferrer" style="margin:0px" target="_blank"><span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px;color:blue">Facebook</span></a><span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px"> <span style="margin:0px"> </span></span><a href="https://twitter.com/StateLibraryNC" rel="noopener noreferrer" style="margin:0px" target="_blank"><span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px;color:blue">Twitter</span></a><span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px"><span style="margin:0px"> </span> </span><a href="http://www.instagram.com/ncculture" rel="noopener noreferrer" style="margin:0px" target="_blank"><span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px;color:blue">Instagram</span></a><span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px"> <span style="margin:0px"> </span></span><a href="https://www.youtube.com/user/statelibrarync/" rel="noopener noreferrer" style="margin:0px" target="_blank"><span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px;color:blue">YouTube</span></a><span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px"><span style="margin:0px"> </span> </span><a href="https://statelibrary.ncdcr.gov/" rel="noopener noreferrer" style="margin:0px" target="_blank"><span style="font-size:10pt;font-family:Arial,sans-serif;margin:0px;color:blue">Website</span></a></p>
<br>
</span></div>
</div>
</div>
</div>
</div>

_______________________________________________<br>
Evergreen-acq mailing list<br>
<a href="mailto:Evergreen-acq@list.evergreen-ils.org" target="_blank">Evergreen-acq@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-acq" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-acq</a><br>
</div></blockquote></div><br clear="all"><br>-- <br><div dir="ltr"><div dir="ltr"><div><div><div><div><div>Mary Llewellyn<br></div>Database Manager<br></div>Bibliomation, Inc.<br></div>24 Wooster Ave.<br></div>Waterbury, CT 06708<br></div><a href="mailto:mllewell@biblio.org" target="_blank">mllewell@biblio.org</a><br></div></div>
_______________________________________________<br>
Evergreen-acq mailing list<br>
<a href="mailto:Evergreen-acq@list.evergreen-ils.org" target="_blank">Evergreen-acq@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-acq" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-acq</a><br>
</blockquote></div>
</blockquote></div><br clear="all"><br>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div><div><div><div>Mary Llewellyn<br></div>Database Manager<br></div>Bibliomation, Inc.<br></div>24 Wooster Ave.<br></div>Waterbury, CT 06708<br></div><a href="mailto:mllewell@biblio.org" target="_blank">mllewell@biblio.org</a><br></div></div>