[Download-List] download-list Digest, Vol 80, Issue 2
Kobayashi, Carol
ckobayashi at agnesscott.edu
Thu Jun 4 13:01:06 EDT 2015
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.
Thanks for your help!
Carol
On Thu, Jun 4, 2015 at 11:33 AM, <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: download-list Digest, Vol 79, Issue 6 (Rotman, David)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Thu, 4 Jun 2015 11:33:15 -0400
> From: "Rotman, David" <rotmand at cedarville.edu>
> Subject: Re: [Download-List] download-list Digest, Vol 79, Issue 6
> To: Cedarville DOWNLOAD Users <download-list at cedarville.edu>
> Message-ID:
> <CAL3MR=
> Uhne-u6dU9-0ge_RjsejNj0dayAUrJoiwmc4N74g6sRw at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> 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/mailman/private/download-list/attachments/20150604/c1429c45/attachment.htm
> >
> -------------- 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/mailman/private/download-list/attachments/20150604/c1429c45/attachment.png
> >
>
> ------------------------------
>
> _______________________________________________
> download-list mailing list
> download-list at cedarville.edu
> http://mail.cedarville.edu/mailman/listinfo/download-list
>
>
> End of download-list Digest, Vol 80, Issue 2
> ********************************************
>
--
*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 Fax: (404) 471-6195*
Agnes Scott College - A liberal arts, women's college in metro Atlanta,
Georgia <http://www.agnesscott.edu/>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20150604/64e6c4ec/attachment.html>
More information about the download-list
mailing list