RE: VFP9-strange behaviour
Could this be another disk write ahead cache blunder Al -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sytze de Boer Sent: Saturday, November 01, 2008 10:58 PM To: [EMAIL PROTECTED] Subject: VFP9-strange behaviour In my app, I have a re-index routine. Before it re-creates the indexex, it packs the files (All free standing tables) The routine goes blah blah use (thefile) excl delete tag all of (thefile) pack ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: VFP9-strange behaviour
I've had weird errors that went away when I checked the "run in separate memory space" on the shortcut. Just for giggles, give it a try. --- On Sat, 11/1/08, Sytze de Boer <[EMAIL PROTECTED]> wrote: > From: Sytze de Boer <[EMAIL PROTECTED]> > Subject: VFP9-strange behaviour > To: profox@leafe.com > Date: Saturday, November 1, 2008, 5:58 PM > In my app, I have a re-index routine. > Before it re-creates the indexex, it packs the files > (All free standing tables) > > The routine goes > > blah blah > use (thefile) excl > delete tag all of (thefile) > pack > > This has worked without problems for 10 years and I cannot > identify why it > bombs out with this client. > The message is "File already exists.", error no 7 > > The system bombs out > When I re-enter, the message is error 5. > With error 5, my system automatically performs a re-index > and all is well > (again) > i.e. error 7 is not encountered till you explicitly perform > the re-index > routine > > This user has 23 people on Terminal Server > > I can't figure the problem > Diskspace is ok > > Any help is appreciated > > -- > Regards > Sytze de Boer > Kiss Systems > Ph: 64-7-8391670, Mob:021 937611, > Skype: kissman2 > www.kiss.co.nz > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > > ___ > Post Messages to: ProFox@leafe.com > Subscription Maintenance: > http://leafe.com/mailman/listinfo/profox > OT-free version of this list: > http://leafe.com/mailman/listinfo/profoxtech > Searchable Archive: http://leafe.com/archives/search/profox > This message: > http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] > ** All postings, unless explicitly stated otherwise, are > the opinions of the author, and do not constitute legal or > medical advice. This statement is added to the messages for > those lawyers who are too stupid to see the obvious. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: VFP9-strange behaviour
Make sure all the TS users are creating temporary files in seperate locations. -- Alan Bourke [EMAIL PROTECTED] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: VFP9-strange behaviour
We found an Anti-Virus program kept the dbf open long enough for the PACK to fail. We would usually find the packed data in a temp file sitting in the folder where the DBF should be. For some clients, it might have been a combination of spyware and anti-virus applications conflicting with the open state of the DBF. HTH, Tracy -Original Message- From: Sytze de Boer Sent: Saturday, November 01, 2008 5:58 PM In my app, I have a re-index routine. Before it re-creates the indexex, it packs the files (All free standing tables) The routine goes blah blah use (thefile) excl delete tag all of (thefile) pack This has worked without problems for 10 years and I cannot identify why it bombs out with this client. The message is "File already exists.", error no 7 The system bombs out When I re-enter, the message is error 5. With error 5, my system automatically performs a re-index and all is well (again) i.e. error 7 is not encountered till you explicitly perform the re-index routine This user has 23 people on Terminal Server I can't figure the problem Diskspace is ok Any help is appreciated -- Regards Sytze de Boer Kiss Systems Ph: 64-7-8391670, Mob:021 937611, Skype: kissman2 www.kiss.co.nz ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: VFP9-strange behaviour
Tracy, thanks for your input I'm still struggling with this problem. This has happened to me once before, about 2 years ago, same client, same circumstances Then it went away but I never knew what started it or what I did to make it go away I've now copied all the datafiles to a different folder. (dbf, fpt,cdx) Same hard drive, still Terninal Server, same exe No problems This weekend I plan to copy all these files into 2nd folder, then delete them in folder 1 Then copy back again, then I'll re-try the routine. When the system crashes, it is always the same table. The largest table is half a gig. The problem table is relatively small. Sheesh SdB On Tue, Nov 4, 2008 at 3:05 AM, Tracy Pearson <[EMAIL PROTECTED]> wrote: > We found an Anti-Virus program kept the dbf open long enough for the PACK > to > fail. We would usually find the packed data in a temp file sitting in the > folder where the DBF should be. > > For some clients, it might have been a combination of spyware and > anti-virus > applications conflicting with the open state of the DBF. > > HTH, > > Tracy > > -Original Message- > From: Sytze de Boer > Sent: Saturday, November 01, 2008 5:58 PM > > In my app, I have a re-index routine. > Before it re-creates the indexex, it packs the files (All free standing > tables) > > The routine goes > > blah blah > use (thefile) excl > delete tag all of (thefile) > pack > > This has worked without problems for 10 years and I cannot identify why it > bombs out with this client. > The message is "File already exists.", error no 7 > > The system bombs out > When I re-enter, the message is error 5. > With error 5, my system automatically performs a re-index and all is well > (again) > i.e. error 7 is not encountered till you explicitly perform the re-index > routine > > This user has 23 people on Terminal Server > > I can't figure the problem > Diskspace is ok > > Any help is appreciated > > -- > Regards > Sytze de Boer > Kiss Systems > Ph: 64-7-8391670, Mob:021 937611, > Skype: kissman2 > www.kiss.co.nz > > > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: VFP9-strange behaviour
I feel something still has an Open state on your problem file. Has someone figured out they can access the data via Excel? Since we do not have control over our clients environments, I have changed from using the VFP PACK command. I now use something similar to: OPEN EXCLUSIVE SELECT * INTO CURSOR ... WHERE NOT DELETED() NOFILTER ZAP APPEND FROM DBF() USE I haven't heard of the problem lately, unless someone is using an older release of our product. Tracy -Original Message- From: Sytze de Boer Sent: Monday, November 03, 2008 2:28 PM Tracy, thanks for your input I'm still struggling with this problem. This has happened to me once before, about 2 years ago, same client, same circumstances Then it went away but I never knew what started it or what I did to make it go away I've now copied all the datafiles to a different folder. (dbf, fpt,cdx) Same hard drive, still Terninal Server, same exe No problems This weekend I plan to copy all these files into 2nd folder, then delete them in folder 1 Then copy back again, then I'll re-try the routine. When the system crashes, it is always the same table. The largest table is half a gig. The problem table is relatively small. Sheesh SdB ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: VFP9-strange behaviour
Hi Michael I hav eseen reference to this before ("run in separate memory space") and I have asked for clarification. i.e. on my laptop, this is greyed out. (with a tick) I don't know where to turn this off or on, and since it is ticked and greyed out, if in fact it is working. Can you throw some light on this grey matter ? On Sun, Nov 2, 2008 at 5:24 PM, Michael Madigan <[EMAIL PROTECTED]>wrote: > I've had weird errors that went away when I checked the "run in separate > memory space" on the shortcut. > > Just for giggles, give it a try. > > > > --- On Sat, 11/1/08, Sytze de Boer <[EMAIL PROTECTED]> wrote: > > > From: Sytze de Boer <[EMAIL PROTECTED]> > > Subject: VFP9-strange behaviour > > To: profox@leafe.com > > Date: Saturday, November 1, 2008, 5:58 PM > > In my app, I have a re-index routine. > > Before it re-creates the indexex, it packs the files > > (All free standing tables) > > > > The routine goes > > > > blah blah > > use (thefile) excl > > delete tag all of (thefile) > > pack > > > > This has worked without problems for 10 years and I cannot > > identify why it > > bombs out with this client. > > The message is "File already exists.", error no 7 > > > > The system bombs out > > When I re-enter, the message is error 5. > > With error 5, my system automatically performs a re-index > > and all is well > > (again) > > i.e. error 7 is not encountered till you explicitly perform > > the re-index > > routine > > > > This user has 23 people on Terminal Server > > > > I can't figure the problem > > Diskspace is ok > > > > Any help is appreciated > > > > -- > > Regards > > Sytze de Boer > > Kiss Systems > > Ph: 64-7-8391670, Mob:021 937611, > > Skype: kissman2 > > www.kiss.co.nz > > > > > > --- StripMime Report -- processed MIME parts --- > > multipart/alternative > > text/plain (text body -- kept) > > text/html > > --- > > > > ___ > > Post Messages to: ProFox@leafe.com > > Subscription Maintenance: > > http://leafe.com/mailman/listinfo/profox > > OT-free version of this list: > > http://leafe.com/mailman/listinfo/profoxtech > > Searchable Archive: http://leafe.com/archives/search/profox > > This message: > > > http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] > > ** All postings, unless explicitly stated otherwise, are > > the opinions of the author, and do not constitute legal or > > medical advice. This statement is added to the messages for > > those lawyers who are too stupid to see the obvious. > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: VFP9-strange behaviour
Michael I've asked this before but I suspect it may have been rejected because my message may have been in Rich format. The 2 questions are 1 If my icon has a tick in the "Run in separate memory space", and is greyed out, is it running in separate memory space. 2 Where can you change the system so it isn't greyed out (I've googled this question without success) Sytze On Sun, Nov 2, 2008 at 5:24 PM, Michael Madigan <[EMAIL PROTECTED]> wrote: > I've had weird errors that went away when I checked the "run in separate > memory space" on the shortcut. > > Just for giggles, give it a try. > > > > --- On Sat, 11/1/08, Sytze de Boer <[EMAIL PROTECTED]> wrote: > >> From: Sytze de Boer <[EMAIL PROTECTED]> >> Subject: VFP9-strange behaviour >> To: profox@leafe.com >> Date: Saturday, November 1, 2008, 5:58 PM >> In my app, I have a re-index routine. >> Before it re-creates the indexex, it packs the files >> (All free standing tables) >> >> The routine goes >> >> blah blah >> use (thefile) excl >> delete tag all of (thefile) >> pack >> >> This has worked without problems for 10 years and I cannot >> identify why it >> bombs out with this client. >> The message is "File already exists.", error no 7 >> >> The system bombs out >> When I re-enter, the message is error 5. >> With error 5, my system automatically performs a re-index >> and all is well >> (again) >> i.e. error 7 is not encountered till you explicitly perform >> the re-index >> routine >> >> This user has 23 people on Terminal Server >> >> I can't figure the problem >> Diskspace is ok >> >> Any help is appreciated >> >> -- >> Regards >> Sytze de Boer >> Kiss Systems >> Ph: 64-7-8391670, Mob:021 937611, >> Skype: kissman2 >> www.kiss.co.nz >> >> >> --- StripMime Report -- processed MIME parts --- >> multipart/alternative >> text/plain (text body -- kept) >> text/html >> --- >> >> ___ >> Post Messages to: ProFox@leafe.com >> Subscription Maintenance: >> http://leafe.com/mailman/listinfo/profox >> OT-free version of this list: >> http://leafe.com/mailman/listinfo/profoxtech >> Searchable Archive: http://leafe.com/archives/search/profox >> This message: >> http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] >> ** All postings, unless explicitly stated otherwise, are >> the opinions of the author, and do not constitute legal or >> medical advice. This statement is added to the messages for >> those lawyers who are too stupid to see the obvious. > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.