Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange Corruption
Message
From
28/09/2005 07:41:22
Neil Mc Donald
Cencom Systems P/L
The Sun, Australia
 
 
To
28/09/2005 05:27:42
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 3
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01053347
Message ID:
01053841
Views:
32
Hi,
Check the char field occasionaly, you will see the control characters.

FWIW the exact cause of the corruption at either end of the file is unknown, possibly Network, software or hardware errors, all this method dose is keep the system running without grinding to a halt.

The cache problem is a totally different problem with other resolutions i.e. disable write caching & oplocking, which I will list below.

XP workstation reg Hacks
Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanWorkstation\Parameters]
"UseLockReadUnlock"=dword:00000000
"UtilizeNtCaching"=dword:00000000

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MRxSmb\Parameters]
"OplocksDisabled"=dword:00000001
Win2003 Server reg Hacks
Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\lanmanserver\parameters]
"autodisconnect"=dword:ffffffff
"CachedOpenLimit"=dword:00000000
"EnableOplocks"=dword:00000000
"enablesecuritysignature"=dword:00000000
"requiresecuritysignature"=dword:00000000
"SizReqBuf"=dword:0000ffff
>>>There are references here on UT regarding this, mind you some time ago. I >> will see what I can dig up.
>
>>>Look at Message # 941950
>
>
>Neil,
>
>I though these where more to do with cache problems and VFP updating the table header before records are saved back to disk. These I have seen before and continue to see & repair.
>
>My worry over this one is that there is only one record in the table and none are every added or removed, We have over 80 installs of this product starting roughlt 8 years ago and i have never seen this corruption.
>
>Have taken you advice though and added the character field.
>
>Many Thanks
>
>
>Gary.
Regards N Mc Donald
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform