<div dir="ltr">Problem solved. I was able to narrow it down to two subroutines in which the STC.CRED.TYPE needed to checked as Reference Only. Once I did that, I no longer got the "LOCKED..." message. <div><br></div><div>Thanks for your help!</div><div><br></div><div>Carol</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Jun 4, 2015 at 11:33 AM, <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:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Send download-list mailing list submissions to<br>
<a href="mailto:download-list@cedarville.edu">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">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">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: download-list Digest, Vol 79, Issue 6 (Rotman, David)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Thu, 4 Jun 2015 11:33:15 -0400<br>
From: "Rotman, David" <<a href="mailto:rotmand@cedarville.edu">rotmand@cedarville.edu</a>><br>
Subject: Re: [Download-List] download-list Digest, Vol 79, Issue 6<br>
To: Cedarville DOWNLOAD Users <<a href="mailto:download-list@cedarville.edu">download-list@cedarville.edu</a>><br>
Message-ID:<br>
<CAL3MR=<a href="mailto:Uhne-u6dU9-0ge_RjsejNj0dayAUrJoiwmc4N74g6sRw@mail.gmail.com">Uhne-u6dU9-0ge_RjsejNj0dayAUrJoiwmc4N74g6sRw@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Thanks for the additional note.<br>
<br>
I tried the scenario that you had...going into STAT->ACTD->SACD and then<br>
referencing STUDENT.ACAD.CRED records for that same student. My DOWNLOAD<br>
worked okay.<br>
<br>
I'm puzzled by the LOCKED message you are getting. That word does not<br>
appear in the source for DOWNLOAD. By chance, is one of your dictionary<br>
entries calling a subroutine? I'm wondering if a subroutine has opened the<br>
file without using READONLY. This would be the usual pattern for an<br>
Envision subroutine and many locally-written subroutines.<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">rotmand@cedarville.edu</a><br>
voice <a href="tel:937-766-7905" value="+19377667905">937-766-7905</a><br>
fax <a href="tel:937-766-8819" value="+19377668819">937-766-8819</a><br>
<br>
<br>
On Mon, Jun 1, 2015 at 4:03 PM, Kobayashi, Carol <<a href="mailto:ckobayashi@agnesscott.edu">ckobayashi@agnesscott.edu</a>><br>
wrote:<br>
<br>
> Dave,<br>
><br>
> I have not been able to resolve this and was just able to recreate it<br>
> myself. We have only had this problem for the last 4 to 6 months, never in<br>
> the 15+ years before. I was in STAT--> ACTD-->SACD for one student. When<br>
> I execute the DOWNLOAD command I get the record lock message below.<br>
><br>
> FYI the DOWNLOAD uses the STUDENTS file and several SECONDARY.FILES.<br>
> See below<br>
><br>
> [image: Inline image 1]<br>
><br>
> 015: GET.LIST TD.START.LIST<br>
><br>
> 016: DOWNLOAD STUDENTS SECONDARY.FILE STUDENT.ACAD.LEVELS \<br>
><br>
> 017: KEY <a href="http://XSTU.ACAD.LEVEL.ID" target="_blank">XSTU.ACAD.LEVEL.ID</a> \<br>
><br>
> 018: SECONDARY.FILE APPLICANTS KEY @ID \<br>
><br>
> 019: SECONDARY.FILE PERSON KEY @ID \<br>
><br>
> 020: SECONDARY.FILE SA.2014 KEY @ID \<br>
><br>
> 021: ASC.EMAIL.NAME1 \<br>
><br>
> Thanks for looking into this.<br>
><br>
> Carol<br>
><br>
><br>
> On Thu, May 28, 2015 at 12:00 PM, <<a href="mailto:download-list-request@cedarville.edu">download-list-request@cedarville.edu</a>><br>
> wrote:<br>
><br>
>> Send download-list mailing list submissions to<br>
>> <a href="mailto:download-list@cedarville.edu">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">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">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">rotmand@cedarville.edu</a>><br>
>> Subject: Re: [Download-List] Record Lock<br>
>> To: Cedarville DOWNLOAD Users <<a href="mailto:download-list@cedarville.edu">download-list@cedarville.edu</a>><br>
>> Message-ID:<br>
>> <CAL3MR=<br>
>> <a href="mailto:WEXqDzOJYf_1PjChbf7LntKbnaW9oQdo3eRpioJE8v-g@mail.gmail.com">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">rotmand@cedarville.edu</a><br>
>> voice <a href="tel:937-766-7905" value="+19377667905">937-766-7905</a><br>
>> fax <a href="tel:937-766-8819" value="+19377668819">937-766-8819</a><br>
>><br>
>><br>
>> On Fri, May 22, 2015 at 9:52 AM, Kobayashi, Carol <<br>
>> <a href="mailto:ckobayashi@agnesscott.edu">ckobayashi@agnesscott.edu</a><br>
>> > wrote:<br>
>><br>
>> > We have been using DOWNLOAD for years and have never had the problem<br>
>> until<br>
>> > very recently. When the DOWNLOAD is running, we occasionally get a<br>
>> Record<br>
>> > Lock message. I'm not sure if we have gotten it with other files, but<br>
>> we<br>
>> > do get it with STUDENT.ACAD.CRED. The message display every 20 seconds<br>
>> or<br>
>> > so and the DOWNLOAD does not continue until the record is no longer<br>
>> locked.<br>
>> ><br>
>> > Example: STUDENT.ACAD.CRED - 477299 LOCKED by user 454535(CBURON)<br>
>> 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<br>
>> 30030*<br>
>> ><br>
>> > *Voice: <a href="tel:%28404%29%20471-6319" value="+14044716319">(404) 471-6319</a> <%28404%29%20471-6319> Fax: <a href="tel:%28404%29%20471-6195" value="+14044716195">(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">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: <<br>
>> <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>
>> _______________________________________________<br>
>> download-list mailing list<br>
>> <a href="mailto:download-list@cedarville.edu">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>
>><br>
><br>
><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">(404) 471-6319</a> <%28404%29%20471-6319> Fax: <a href="tel:%28404%29%20471-6195" value="+14044716195">(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">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/20150604/c1429c45/attachment.htm" target="_blank">http://mail.cedarville.edu/mailman/private/download-list/attachments/20150604/c1429c45/attachment.htm</a>><br>
-------------- next part --------------<br>
A non-text attachment was scrubbed...<br>
Name: image.png<br>
Type: image/png<br>
Size: 44167 bytes<br>
Desc: not available<br>
URL: <<a href="http://mail.cedarville.edu/mailman/private/download-list/attachments/20150604/c1429c45/attachment.png" target="_blank">http://mail.cedarville.edu/mailman/private/download-list/attachments/20150604/c1429c45/attachment.png</a>><br>
<br>
------------------------------<br>
<br>
_______________________________________________<br>
download-list mailing list<br>
<a href="mailto:download-list@cedarville.edu">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 80, Issue 2<br>
********************************************<br>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr"><p><b><i><span style="font-size:10.0pt;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:8.0pt;font-family:"Comic Sans MS";color:navy">Assistant Director/Administrative Computing System
Manager </span></i></p>
<p><i><span style="font-size:8.0pt;font-family:"Comic Sans MS";color:navy">Information Technology Services</span></i></p>
<p><i><span style="font-size:8.0pt;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:8.0pt;font-family:"Comic Sans MS";color:navy">Voice: (404) 471-6319 Fax: (404) 471-6195</span></i></p>
<p><i><span></span></i></p>
<p><i><span style="font-size:8.0pt;font-family:"Comic Sans MS";color:navy"> </span></i></p>
<p><span style="font-size:9.0pt;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>