Got a stupid 108 error on a simple INSERT INTO SQL today, yet no other application had that program/table open, and all usage is SHARED (set exclusive is OFF).
Anybody else ever get an Error 108 on a simple INSERT where there's no exclusive use???
I haven't used dbfs in years and can't say I've ever got this error but this might help:
https://www.tek-tips.com/viewthread.cfm?qid=686993
On 31 July 2020 16:00:32 GMT-04:00, "MB Software Solutions, LLC" mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
Got a stupid 108 error on a simple INSERT INTO SQL today, yet no other application had that program/table open, and all usage is SHARED (set exclusive is OFF).
Anybody else ever get an Error 108 on a simple INSERT where there's no exclusive use???
-- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/f933b99f-c4a3-c3ab-9184-a8d733c597c0@mbsoft... ** 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.
Report [OT] Abuse: http://leafe.com/reportAbuse/f933b99f-c4a3-c3ab-9184-a8d733c597c0@mbsoftware...
Yeah I stopped using DBFs in 2004!!!!! Took over Jeff Johnson's (RIP) client a few years back when he passed which is an all Fox backend.
I added the SET TABLEVALIDATE TO 0. Will see if that helps. I don't have any RLOCKs or FLOCKs on this table. In this case, it's a simple logging table that only gets INSERT INTO commands to it. Never UPDATE or DELETE.
Thanks for the lead, Frank!!!
On 7/31/2020 4:11 PM, Frank Cazabon wrote:
I haven't used dbfs in years and can't say I've ever got this error but this might help:
https://www.tek-tips.com/viewthread.cfm?qid=686993
On 31 July 2020 16:00:32 GMT-04:00, "MB Software Solutions, LLC" mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
Got a stupid 108 error on a simple INSERT INTO SQL today, yet no other application had that program/table open, and all usage is SHARED (set exclusive is OFF).
Anybody else ever get an Error 108 on a simple INSERT where there's no exclusive use???
-- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/f933b99f-c4a3-c3ab-9184-a8d733c597c0@mbsoft... ** 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.
Report [OT] Abuse: http://leafe.com/reportAbuse/f933b99f-c4a3-c3ab-9184-a8d733c597c0@mbsoftware...
Our customers occasionally get an error like this. Most of the time we find it is related to Anti-Virus or On-Demand backup tools causing the problem. Sometimes, but it's more rare, it's related to network (LAN) issues and the machine with the DBF is over taxed.
HTH, Tracy
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Friday, July 31, 2020 5:43 PM To: profoxtech@leafe.com Subject: Re: VFP9SP2 Error 108: File is in use by another user.
Yeah I stopped using DBFs in 2004!!!!! Took over Jeff Johnson's (RIP) client a few years back when he passed which is an all Fox backend.
I added the SET TABLEVALIDATE TO 0. Will see if that helps. I don't have any RLOCKs or FLOCKs on this table. In this case, it's a simple logging table that only gets INSERT INTO commands to it. Never UPDATE or DELETE.
Thanks for the lead, Frank!!!
On 7/31/2020 4:11 PM, Frank Cazabon wrote:
I haven't used dbfs in years and can't say I've ever got this error but this might help:
https://www.tek-tips.com/viewthread.cfm?qid=686993
On 31 July 2020 16:00:32 GMT-04:00, "MB Software Solutions, LLC" mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
Got a stupid 108 error on a simple INSERT INTO SQL today, yet no other application had that program/table open, and all usage is SHARED (set exclusive is OFF).
Anybody else ever get an Error 108 on a simple INSERT where there's no exclusive use???
-- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/f933b99f-c4a3-c3ab-9184-a8d733c597c0@mbsoft... ** 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.
Report [OT] Abuse: http://leafe.com/reportAbuse/f933b99f-c4a3-c3ab-9184-a8d733c597c0@mbsoftware...
[excessive quoting removed by server]
Ouch. Some old memories :) Glad to be indirectly helping!
wOOdy
-----Ursprüngliche Nachricht----- Von: ProFox profox-bounces@leafe.com Im Auftrag von MB Software Solutions, LLC Gesendet: Freitag, 31. Juli 2020 23:43 An: profox@leafe.com Betreff: Re: VFP9SP2 Error 108: File is in use by another user.
Yeah I stopped using DBFs in 2004!!!!! Took over Jeff Johnson's (RIP) client a few years back when he passed which is an all Fox backend.
I added the SET TABLEVALIDATE TO 0. Will see if that helps. I don't have any RLOCKs or FLOCKs on this table. In this case, it's a simple logging table that only gets INSERT INTO commands to it. Never UPDATE or DELETE.
Thanks for the lead, Frank!!!
On 7/31/2020 4:11 PM, Frank Cazabon wrote:
I haven't used dbfs in years and can't say I've ever got this error but this might help:
Even with SET TABLEVALIDATE TO 0, I was *still* getting the Error 108 on the simple INSERT INTO (lcFile) command. In the Exception WHEN event, I added a WAIT WINDOW TIMEOUT 1 "Retrying" and then reissued the call to the same method (ala recursion).
Testing now....
On 8/1/2020 12:44 PM, Jürgen Wondzinski wrote:
Ouch. Some old memories :) Glad to be indirectly helping!
wOOdy
-----Ursprüngliche Nachricht----- Von: ProFox profox-bounces@leafe.com Im Auftrag von MB Software Solutions, LLC Gesendet: Freitag, 31. Juli 2020 23:43 An: profox@leafe.com Betreff: Re: VFP9SP2 Error 108: File is in use by another user.
Yeah I stopped using DBFs in 2004!!!!! Took over Jeff Johnson's (RIP) client a few years back when he passed which is an all Fox backend.
I added the SET TABLEVALIDATE TO 0. Will see if that helps. I don't have any RLOCKs or FLOCKs on this table. In this case, it's a simple logging table that only gets INSERT INTO commands to it. Never UPDATE or DELETE.
Thanks for the lead, Frank!!!
On 7/31/2020 4:11 PM, Frank Cazabon wrote:
I haven't used dbfs in years and can't say I've ever got this error but this might help:
[excessive quoting removed by server]
-
Frank Cazabon -
Jürgen Wondzinski -
MB Software Solutions, LLC -
Tracy Pearson