[Download-List] download-list Digest, Vol 79, Issue 6

Thu Jun 4 11:33:15 EDT 2015

Thanks for the additional note.

I tried the scenario that you had...going into STAT->ACTD->SACD and then
referencing STUDENT.ACAD.CRED records for that same student.  My DOWNLOAD
worked okay.

I'm puzzled by the LOCKED message you are getting.  That word does not
appear in the source for DOWNLOAD.  By chance, is one of your dictionary
entries calling a subroutine?  I'm wondering if a subroutine has opened the
file without using READONLY.  This would be the usual pattern for an
Envision subroutine and many locally-written subroutines.

David Rotman, Ph.D.
Associate Vice President for Technology
Chief Information Officer
Cedarville University
251 N. Main Street
Cedarville, OH 45314
rotmand at cedarville.edu
voice 937-766-7905
fax 937-766-8819

On Mon, Jun 1, 2015 at 4:03 PM, Kobayashi, Carol <ckobayashi at agnesscott.edu>
wrote:

> Dave,
>
> 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.
>
> FYI the DOWNLOAD uses the STUDENTS file and several SECONDARY.FILES.
>  See below
>
> [image: Inline image 1]
>
> 015: GET.LIST TD.START.LIST
>
> 016: DOWNLOAD STUDENTS SECONDARY.FILE STUDENT.ACAD.LEVELS \
>
> 017: KEY XSTU.ACAD.LEVEL.ID \
>
> 018: SECONDARY.FILE APPLICANTS KEY @ID \
>
> 019: SECONDARY.FILE PERSON KEY @ID \
>
> 020: SECONDARY.FILE SA.2014 KEY @ID \
>
> 021: ASC.EMAIL.NAME1 \
>
> Thanks for looking into this.
>
> Carol
>
>
> On Thu, May 28, 2015 at 12:00 PM, <download-list-request at cedarville.edu>
> wrote:
>
>> Send download-list mailing list submissions to
>>         download-list at cedarville.edu
>>
>> To subscribe or unsubscribe via the World Wide Web, visit
>>         http://mail.cedarville.edu/mailman/listinfo/download-list
>> or, via email, send a message with subject or body 'help' to
>>         download-list-request at cedarville.edu
>>
>> You can reach the person managing the list at
>>         download-list-owner at cedarville.edu
>>
>> When replying, please edit your Subject line so it is more specific
>> than "Re: Contents of download-list digest..."
>>
>>
>> Today's Topics:
>>
>>    1. Re: Record Lock (Rotman, David)
>>
>>
>> ----------------------------------------------------------------------
>>
>> Message: 1
>> Date: Thu, 28 May 2015 10:58:02 -0400
>> From: "Rotman, David" <rotmand at cedarville.edu>
>> Subject: Re: [Download-List] Record Lock
>> To: Cedarville DOWNLOAD Users <download-list at cedarville.edu>
>> Message-ID:
>>         <CAL3MR=
>> WEXqDzOJYf_1PjChbf7LntKbnaW9oQdo3eRpioJE8v-g at mail.gmail.com>
>> Content-Type: text/plain; charset="utf-8"
>>
>> Carol--
>>
>> Were you able to get this situation resolved?  DOWNLOAD opens the files in
>> READONLY mode, so there should not be an issue with record locks.
>>
>>
>>
>>
>> David Rotman, Ph.D.
>> Associate Vice President for Technology
>> Chief Information Officer
>> Cedarville University
>> 251 N. Main Street
>> Cedarville, OH 45314
>> rotmand at cedarville.edu
>> voice 937-766-7905
>> fax 937-766-8819
>>
>>
>> On Fri, May 22, 2015 at 9:52 AM, Kobayashi, Carol <
>> ckobayashi at agnesscott.edu
>> > wrote:
>>
>> > We have been using DOWNLOAD for years and have never had the problem
>> until
>> > very recently.  When the DOWNLOAD is running, we occasionally get a
>> Record
>> > Lock  message.  I'm not sure if we have gotten it with other files, but
>> we
>> > do get it  with STUDENT.ACAD.CRED. The message display every 20 seconds
>> or
>> > so and the DOWNLOAD does not continue until the record is no longer
>> locked.
>> >
>> > Example: STUDENT.ACAD.CRED - 477299 LOCKED by user 454535(CBURON)
>>  Please
>> > wait....
>> >
>> >
>> > I don't see permission differences on the STUDENT.ACAD.CRED file that
>> > would cause this.   How do we prevent this?
>> >
>> > Thanks,
>> > Carol
>> >
>> > --
>> >
>> > *Carol E. Kobayashi*
>> >
>> > *Assistant Director/Administrative Computing System Manager *
>> >
>> > *Information Technology Services*
>> >
>> > *Agnes Scott College -  141 East College Avenue - Decatur, Georgia
>> 30030*
>> >
>> > *Voice: (404) 471-6319 <%28404%29%20471-6319>   Fax: (404) 471-6195
>> > <%28404%29%20471-6195>*
>> >
>> >
>> >
>> > Agnes Scott College - A liberal arts, women's college in metro Atlanta,
>> > Georgia <http://www.agnesscott.edu/>
>> >
>> > _______________________________________________
>> > download-list mailing list
>> > download-list at cedarville.edu
>> > http://mail.cedarville.edu/mailman/listinfo/download-list
>> >
>> >
>> -------------- next part --------------
>> An HTML attachment was scrubbed...
>> URL: <
>> http://mail.cedarville.edu/mailman/private/download-list/attachments/20150528/f8171254/attachment-0001.htm
>> >
>>
>> ------------------------------
>>
>> _______________________________________________
>> download-list mailing list
>> download-list at cedarville.edu
>> http://mail.cedarville.edu/mailman/listinfo/download-list
>>
>>
>> End of download-list Digest, Vol 79, Issue 6
>> ********************************************
>>
>
>
>
> --
>
> *Carol E. Kobayashi*
>
> *Assistant Director/Administrative Computing System Manager *
>
> *Information Technology Services*
>
> *Agnes Scott College -  141 East College Avenue - Decatur, Georgia 30030*
>
> *Voice: (404) 471-6319 <%28404%29%20471-6319>   Fax: (404) 471-6195
> <%28404%29%20471-6195>*
>
>
>
> Agnes Scott College - A liberal arts, women's college in metro Atlanta,
> Georgia <http://www.agnesscott.edu/>
>
> _______________________________________________
> download-list mailing list
> download-list at cedarville.edu
> http://mail.cedarville.edu/mailman/listinfo/download-list
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20150604/c1429c45/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 44167 bytes
Desc: not available
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20150604/c1429c45/attachment.png>