Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Intermittent error 111
Message
From
13/05/2014 14:31:04
 
 
To
13/05/2014 13:31:06
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01599929
Message ID:
01599935
Views:
87
>I have a client where at least one person (one of the testers, so intense user of the app) is intermittently getting error 111 "Cannot update the cursor "cursor", since it is read-only." He says he sees it at least once every other day.
>
>The error log tells me that it's always the same table and always on the ZAP in this sequence:
>
>
>USE Network EXCL
>ZAP
>USE Network
>
>
>This is in a routine that does the same thing to about 10 different tables and this is not the first one listed. (And no, I didn't write this code originally and wouldn't have done it this way, but changing the architecture at this point would be significant.)
>
>This is a DBF permanently stored on disk, not a cursor, and not a table created temporarily.
>
>One question is whether this could be related to OpLocks, but if so, would I see it always on the same table?
>
>I have ideas for work-arounds, but I'd prefer to figure out what's actually going on.
>
>Any suggestions?

- Antivirus
- Background process running e.g. backup, defrag etc.
- Network connectivity issues, check event logs
- Existence of Network.* or excessive number of temp files in temp files folder
- Problem with CDX or FPT file(s) if present
- Problem with DBF file "found" by SET TABLEVALIDATE
- Problem with database files if table is part of a DB
- "Network" appears to be a reserved word in VFP
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform