<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Helvetica Neue";
panose-1:2 0 5 3 0 0 0 2 0 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.xmsonormal, li.xmsonormal, div.xmsonormal
{mso-style-name:x_msonormal;
margin:0in;
font-size:12.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle23
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">Blake,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Yeah, I’m guessing that the `asck` plugin we installed to check data a year ago makes those jobs invalid if the plugin isn’t installed.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Which is annoying.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks for the help!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:12.0pt;color:black">From: </span></b><span style="font-size:12.0pt;color:black"><archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Blake Carver <blake.carver@lyrasis.org><br>
<b>Reply-To: </b>Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Date: </b>Tuesday, August 25, 2020 at 9:31 AM<br>
<b>To: </b>Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject: </b>Re: [Archivesspace_Users_Group] Jobs indexing error<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div style="border:solid windowtext 1.0pt;padding:2.0pt 2.0pt 2.0pt 2.0pt;display:inline-block">
<p class="MsoNormal" style="line-height:13.0pt"><b><span style="font-size:12.0pt">***External***</span></b><em><span style="font-size:12.0pt;font-family:"Calibri",sans-serif"> This email originated from outside of the organization. Do not click links or open
attachments unless you recognize the sender and know the content is safe.***</span></em><span style="font-size:12.0pt"><o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><o:p> </o:p></p>
<div>
<div>
<p style="margin-bottom:12.0pt;line-height:15.0pt;background:white;outline: 0px">
<span style="font-size:10.5pt;font-family:"Helvetica Neue";color:#2F3941"> You could just get rid of the aspace_check_job jobs. <span style="background:white">(back up the DB just in case)</span><o:p></o:p></span></p>
<p style="margin-bottom:12.0pt;line-height:15.0pt;background:white;outline: 0px">
<span style="font-size:10.5pt;font-family:"Helvetica Neue";color:#2F3941">select * job where job_blob like '%aspace_check_job%';<o:p></o:p></span></p>
<p style="margin-bottom:12.0pt;line-height:15.0pt;background:white;outline: 0px">
<span style="font-size:10.5pt;font-family:"Helvetica Neue";color:#2F3941">Then:<o:p></o:p></span></p>
<p style="margin-bottom:12.0pt;line-height:15.0pt;background:white;outline: 0px">
<span style="font-size:10.5pt;font-family:"Helvetica Neue";color:#2F3941">delete FROM job where job_blob like '%aspace_check_job%';<o:p></o:p></span></p>
<p style="margin-bottom:12.0pt;line-height:15.0pt;background:white;outline: 0px">
<span style="font-size:10.5pt;font-family:"Helvetica Neue";color:#2F3941"> <o:p></o:p></span></p>
</div>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="0" width="100%" align="center">
</div>
<div id="divRplyFwdMsg">
<p class="MsoNormal"><b><span style="color:black">From:</span></b><span style="color:black"> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Galligan, Patrick <PGalligan@rockarch.org><br>
<b>Sent:</b> Tuesday, August 25, 2020 9:05 AM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> [Archivesspace_Users_Group] Jobs indexing error</span> <o:p></o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="xmsonormal"><span style="font-size:11.0pt">Hi all,</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:11.0pt"> </span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:11.0pt">Posting here in the off chance someone has run into this before. We’re testing out AS version 2.8, coming from 2.6.0 and running into a weird issue.</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:11.0pt"> </span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:11.0pt">Indexing works fine until we get to the job records section of indexing, and then we run into an unhandled exception ultimately stops indexing from finishing, and it just starts up again at resource records
after finishing the jobs.</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:11.0pt"> </span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:11.0pt">I’ve attached the relevant section of our log.</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:11.0pt"> </span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:11.0pt">Any ideas on how to fix this? I could just delete all of our job records from the table, but that seems like a bad solution to this issue.</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:11.0pt"> </span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:11.0pt">Thanks,</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:11.0pt">Patrick Galligan</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:11.0pt">He/Him</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:11.0pt">Digital Archivist</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:11.0pt">Rockefeller Archive Center</span><o:p></o:p></p>
</div>
</div>
</div>
</div>
</body>
</html>