<div dir="ltr"><div class="gmail_extra">Dave,</div><div class="gmail_extra"><br></div><div class="gmail_extra">I have not been able to resolve this and was just able to recreate it myself. We have only had this problem for the last 4 to 6 months, never in the 15+ years before. I was in STAT--> ACTD-->SACD for one student. When I execute the DOWNLOAD command I get the record lock message below. </div><div class="gmail_extra"><br></div><div class="gmail_extra">FYI the DOWNLOAD uses the STUDENTS file and several SECONDARY.FILES. See below</div><div class="gmail_extra"><br></div><div class="gmail_extra"><img src="cid:ii_14db0b463a85ac83" alt="Inline image 1" width="543" height="157"><br></div><div class="gmail_extra"><br></div><div class="gmail_extra"><div class="gmail_extra">015: GET.LIST TD.START.LIST </div><div class="gmail_extra">016: DOWNLOAD STUDENTS SECONDARY.FILE STUDENT.ACAD.LEVELS \ </div><div class="gmail_extra">017: KEY <a href="http://XSTU.ACAD.LEVEL.ID">XSTU.ACAD.LEVEL.ID</a> \ </div><div class="gmail_extra">018: SECONDARY.FILE APPLICANTS KEY @ID \ </div><div class="gmail_extra">019: SECONDARY.FILE PERSON KEY @ID \ </div><div class="gmail_extra">020: SECONDARY.FILE SA.2014 KEY @ID \ </div><div class="gmail_extra">021: ASC.EMAIL.NAME1 \ </div><div class="gmail_extra"><br></div><div class="gmail_extra">Thanks for looking into this.</div><div class="gmail_extra"><br></div><div class="gmail_extra">Carol</div></div><div class="gmail_extra"><br></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, May 28, 2015 at 12:00 PM, <span dir="ltr"><<a href="mailto:download-list-request@cedarville.edu" target="_blank">download-list-request@cedarville.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">Send download-list mailing list submissions to<br>
<a href="mailto:download-list@cedarville.edu" target="_blank">download-list@cedarville.edu</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="http://mail.cedarville.edu/mailman/listinfo/download-list" target="_blank">http://mail.cedarville.edu/mailman/listinfo/download-list</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:download-list-request@cedarville.edu" target="_blank">download-list-request@cedarville.edu</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:download-list-owner@cedarville.edu" target="_blank">download-list-owner@cedarville.edu</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of download-list digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Re: Record Lock (Rotman, David)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Thu, 28 May 2015 10:58:02 -0400<br>
From: "Rotman, David" <<a href="mailto:rotmand@cedarville.edu" target="_blank">rotmand@cedarville.edu</a>><br>
Subject: Re: [Download-List] Record Lock<br>
To: Cedarville DOWNLOAD Users <<a href="mailto:download-list@cedarville.edu" target="_blank">download-list@cedarville.edu</a>><br>
Message-ID:<br>
<CAL3MR=<a href="mailto:WEXqDzOJYf_1PjChbf7LntKbnaW9oQdo3eRpioJE8v-g@mail.gmail.com" target="_blank">WEXqDzOJYf_1PjChbf7LntKbnaW9oQdo3eRpioJE8v-g@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Carol--<br>
<br>
Were you able to get this situation resolved? DOWNLOAD opens the files in<br>
READONLY mode, so there should not be an issue with record locks.<br>
<br>
<br>
<br>
<br>
David Rotman, Ph.D.<br>
Associate Vice President for Technology<br>
Chief Information Officer<br>
Cedarville University<br>
251 N. Main Street<br>
Cedarville, OH 45314<br>
<a href="mailto:rotmand@cedarville.edu" target="_blank">rotmand@cedarville.edu</a><br>
voice <a href="tel:937-766-7905" value="+19377667905" target="_blank">937-766-7905</a><br>
fax <a href="tel:937-766-8819" value="+19377668819" target="_blank">937-766-8819</a><br>
<br>
<br>
On Fri, May 22, 2015 at 9:52 AM, Kobayashi, Carol <<a href="mailto:ckobayashi@agnesscott.edu" target="_blank">ckobayashi@agnesscott.edu</a><br>
> wrote:<br>
<br>
> We have been using DOWNLOAD for years and have never had the problem until<br>
> very recently. When the DOWNLOAD is running, we occasionally get a Record<br>
> Lock message. I'm not sure if we have gotten it with other files, but we<br>
> do get it with STUDENT.ACAD.CRED. The message display every 20 seconds or<br>
> so and the DOWNLOAD does not continue until the record is no longer locked.<br>
><br>
> Example: STUDENT.ACAD.CRED - 477299 LOCKED by user 454535(CBURON) Please<br>
> wait....<br>
><br>
><br>
> I don't see permission differences on the STUDENT.ACAD.CRED file that<br>
> would cause this. How do we prevent this?<br>
><br>
> Thanks,<br>
> Carol<br>
><br>
> --<br>
><br>
> *Carol E. Kobayashi*<br>
><br>
> *Assistant Director/Administrative Computing System Manager *<br>
><br>
> *Information Technology Services*<br>
><br>
> *Agnes Scott College - 141 East College Avenue - Decatur, Georgia 30030*<br>
><br>
> *Voice: <a href="tel:%28404%29%20471-6319" value="+14044716319" target="_blank">(404) 471-6319</a> <%28404%29%20471-6319> Fax: <a href="tel:%28404%29%20471-6195" value="+14044716195" target="_blank">(404) 471-6195</a><br>
> <%28404%29%20471-6195>*<br>
><br>
><br>
><br>
> Agnes Scott College - A liberal arts, women's college in metro Atlanta,<br>
> Georgia <<a href="http://www.agnesscott.edu/" target="_blank">http://www.agnesscott.edu/</a>><br>
><br>
> _______________________________________________<br>
> download-list mailing list<br>
> <a href="mailto:download-list@cedarville.edu" target="_blank">download-list@cedarville.edu</a><br>
> <a href="http://mail.cedarville.edu/mailman/listinfo/download-list" target="_blank">http://mail.cedarville.edu/mailman/listinfo/download-list</a><br>
><br>
><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://mail.cedarville.edu/mailman/private/download-list/attachments/20150528/f8171254/attachment-0001.htm" target="_blank">http://mail.cedarville.edu/mailman/private/download-list/attachments/20150528/f8171254/attachment-0001.htm</a>><br>
<br>
------------------------------<br>
<br>
_______________________________________________<br>
download-list mailing list<br>
<a href="mailto:download-list@cedarville.edu" target="_blank">download-list@cedarville.edu</a><br>
<a href="http://mail.cedarville.edu/mailman/listinfo/download-list" target="_blank">http://mail.cedarville.edu/mailman/listinfo/download-list</a><br>
<br>
<br>
End of download-list Digest, Vol 79, Issue 6<br>
********************************************<br>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div><div dir="ltr"><p><b><i><span style="font-size:10pt;font-family:'Comic Sans MS';color:navy">Carol E.
Kobayashi</span></i></b><span style="font-family:Arial,sans-serif"></span></p>
<p><i><span style="font-size:8pt;font-family:'Comic Sans MS';color:navy">Assistant Director/Administrative Computing System
Manager </span></i></p>
<p><i><span style="font-size:8pt;font-family:'Comic Sans MS';color:navy">Information Technology Services</span></i></p>
<p><i><span style="font-size:8pt;font-family:'Comic Sans MS';color:navy">Agnes Scott College - 141 East College Avenue - Decatur, Georgia
30030</span></i></p>
<p><i><span style="font-size:8pt;font-family:'Comic Sans MS';color:navy">Voice: <a href="tel:%28404%29%20471-6319" value="+14044716319" target="_blank">(404) 471-6319</a> Fax: <a href="tel:%28404%29%20471-6195" value="+14044716195" target="_blank">(404) 471-6195</a></span></i></p>
<p><i><span></span></i></p>
<p><i><span style="font-size:8pt;font-family:'Comic Sans MS';color:navy"> </span></i></p>
<p><span style="font-size:9pt;font-family:'Times New Roman',serif;color:navy"><a href="http://www.agnesscott.edu/" target="_blank"><span style="color:navy">Agnes
Scott College - A liberal arts, women's college in metro Atlanta, Georgia</span></a></span><span style="color:navy"></span></p></div></div>
</div></div>