Author: Alan Lukachko
Posted: 2014-07-17 13:34:19 Link
One of my customers recently purchased a new HP Reliant server with Windows
Server 2012 R2 installed. The hardware vendor installed our program and data
and it worked as before without a site visit on our part. Our VFP 9.0
program hasn't changed in more than 4 years. Now they get corruption of
indexes. A message flashes up when this happens. They have yet to capture
the content of it. I have been unable to see it remotely and it's a 3 hour
journey to see it live. We have a way of repairing the DBC and a reindexing
routine, which they can do themselves without our intervention. This doesn't
happen every day and more random that regular.
Any suggestions on what I could try remotely?
TIA
Alan Lukachko
<mailto:al@software-strategies-na.com> al@software-strategies-na.com
Software Strategies
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/0f7201cfa1ed$bdcd8e80$3968ab80$@com
** 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.
Author: Frank Cazabon
Posted: 2014-07-17 13:50:18 Link
On 17/07/2014 02:34 PM, Alan Lukachko wrote:
> One of my customers recently purchased a new HP Reliant server with Windows
> Server 2012 R2 installed. The hardware vendor installed our program and data
> and it worked as before without a site visit on our part. Our VFP 9.0
> program hasn't changed in more than 4 years. Now they get corruption of
> indexes.
Sounds like SMB2 needs to be switched off.
This might help:
or the short version:
These are my notes on switching it off (can't remember the site I got
this off of):
When using the terms "client" and "server" in case of file and print
sharing, it does not necessarily mean that a client-type OS such as
Vista "always" connects to a server-type Os such as Windows Server 2008.
Sometimes, a Vista computer will connect to another Vista computer, and
in that case, the computer that is "serving" the shares is considered to
be the "server".
Here's how SMB is used when related to SMB versions:
* When a Windows Server 2008/Vista "client" connects to a Windows
Server 2008/Vista "server", SMB 2.0 is used.
* When a Windows Server 2008/Vista "client" connects to a Windows
2000/XP/2003 "server", SMB 1.0 is used.
* When a Windows 2000/XP/2003 "client" connects to a Windows Server
2008/Vista "server", SMB 1.0 is used.
* When a Windows 2000/XP/2003 "client" connects to a Windows
2000/XP/2003 "server", SMB 1.0 is used.
So, for troubleshooting purposes, mostly in an environment that has
mixes operating systems, you might want to consider disabling SMB 2.0.
You need to do so on both the "client" and the "server" operating
systems. To disable SMB 2.0 for Windows Vista or Windows Server 2008
systems that are the "client" systems run the following commands:
sc config lanmanworkstation depend= bowser/mrxsmb10/nsi
sc config mrxsmb20 start= disabled
Note there's an extra " " (space) after the "=" sign.
To enable back SMB 2.0 for Windows Vista or Windows Server 2008 systems
that are the "client" systems run the following commands:
sc config lanmanworkstation depend= bowser/mrxsmb10/mrxsmb20/nsisc config mrxsmb20 start= auto
Again, note there's an extra " " (space) after the "=" sign.
In order to disable SMB 2.0 on the server-side computer, follow these steps:
Warning!
This document contains instructions for editing the registry. If you
make any error while editing the registry, you can potentially cause
Windows to fail or be unable to boot, requiring you to reinstall
Windows. Edit the registry at your own risk. Always back up the registry
before making any changes. If you do not feel comfortable editing the
registry, do not attempt these instructions. Instead, seek the help of a
trained computer specialist.
1. Run "regedit" on Windows Server 2008 based computer.
2. Expand and locate the sub tree as follows.
HKLM\System\CurrentControlSet\Services\LanmanServer\Parameters
3. Add a new REG_DWORD key with the name of "Smb2" (without quotation
mark)
Value name: Smb2Value type: REG_DWORD0 = disabled1 = enabled
4. Set the value to 0 to disable SMB 2.0, or set it to 1 to re-enable
SMB 2.0.
5. Reboot the server.
--
Frank.
Frank Cazabon
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/53C81AEA.9070909@gmail.com
** 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.
Author: Fernando D. Bozzo
Posted: 2014-07-17 13:57:50 Link
Hi Alan:
I've read something about this problem on various sites/forums. I've made a
quick search of "Windows Server 2012 R2 vfp data corruption" and found some
interesting info talking about opportunistic locking and smb2 (there are
some of the same topic about Server 2008 R2 too):
http://fox.wikis.com/wc.dll?Wiki~OplocksAndWindowsServer2003/2008
A very Interesting white paper
http://www.dataaccess.com/whitepapers/opportunlockingreadcaching.html
Someone even mention antivirus interferences
Another search on the topic "Windows Server 2012 R2 file share data
corruption" shows more corruption errors on other VFP-like tools, as MS
Access:
Apparently, disabling SMB2/3 can resolve the problem for some people.
Best regards!
2014-07-17 20:34 GMT+02:00 Alan Lukachko <al@software-strategies-na.com>:
> One of my customers recently purchased a new HP Reliant server with Windows
> Server 2012 R2 installed. The hardware vendor installed our program and
> data
> and it worked as before without a site visit on our part. Our VFP 9.0
> program hasn't changed in more than 4 years. Now they get corruption of
> indexes. A message flashes up when this happens. They have yet to capture
> the content of it. I have been unable to see it remotely and it's a 3 hour
> journey to see it live. We have a way of repairing the DBC and a reindexing
> routine, which they can do themselves without our intervention. This
> doesn't
> happen every day and more random that regular.
>
>
>
> Any suggestions on what I could try remotely?
>
>
>
> TIA
>
>
>
> Alan Lukachko
>
> <mailto:al@software-strategies-na.com> al@software-strategies-na.com
>
> Software Strategies
>
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
> text/plain (text body -- kept)
> text/html
> ---
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAGQ_Jumg+71qmo=OM85bgTid-F-ErWUna8EgDz6ZAa3DDtNhyA@mail.gmail.com
** 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.
Author: Ted Roche
Posted: 2014-07-17 14:24:41 Link
On Thu, Jul 17, 2014 at 2:34 PM, Alan Lukachko <
al@software-strategies-na.com> wrote:
> and it worked as before without a site visit on our part. Our VFP 9.0
> program hasn't changed in more than 4 years. Now they get corruption of
> indexes. A message flashes up when this happens. They have yet to capture
>
Well, something's changed. If you press the client, they may admit they've
installed new machines (in which case I'd blame SMB2 and disable it) or a
new anti-virus (which likely needs to be configured better) or a new
network (which needs debugging).
The client might not be able to do these things, but they ought to be able
to answer the questions.
--
Ted Roche
Ted Roche & Associates, LLC
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CACW6n4vgxNJhhzYo3rfDtMUsPL-DVsOnp=oWYPX7w5x5hTddkw@mail.gmail.com
** 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.
I have just had data problems and after getting the cause could be anti
virus from members here I passed that on to the client. Turned out to be the
wrong version of anti virus, so I was told. Whatever that means it was the
anti virus
Al
-----Original Message-----
Someone even mention antivirus interferences
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/007801cfa1f4$f3637f30$da2a7d90$@com
** 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.
Author: Tracy Pearson
Posted: 2014-07-17 14:46:26 Link
Ted Roche wrote on 2014-07-17:
> On Thu, Jul 17, 2014 at 2:34 PM, Alan Lukachko <
> al@software-strategies-na.com> wrote:
>
>> and it worked as before without a site visit on our part. Our VFP 9.0
>> program hasn't changed in more than 4 years. Now they get corruption of
>> indexes. A message flashes up when this happens. They have yet to capture
>>
>>
> Well, something's changed. If you press the client, they may admit
they've
> installed new machines (in which case I'd blame SMB2 and disable it) or a
> new anti-virus (which likely needs to be configured better) or a new
> network (which needs debugging).
>
> The client might not be able to do these things, but they ought to be
able
> to answer the questions.
Any software based cached writing may cause this behavior. (write behind
cache, delayed write cache, SMB2, etc...)
Tracy Pearson
PowerChurch Software
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/001b01cfa1f7$cc150f40$643f2dc0$@powerchurch.com
** 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.
Author: Fernando D. Bozzo
Posted: 2014-07-17 14:55:57 Link
The antivirus always was --and is-- the most common problem, and in general
terms the solution is adding the VFP extensions for exclusion of the
analisys, because the AV can cause not only corruption, but slowness to.
As an example, latest versions of Symantec Antivirus scans ALL files (DBF,
CDX, TXT, FPT, ..... you get the idea) and sometimes the corruption is
caused because VFP can't update some of the bundle DBF/FPT/CDX because the
AV is scanning it, and it can take the necessary time to cause some errors
in the lan packets or the communication layer that end with data corruption.
Have seen this many times in many years, from Windows Server 2003 up what I
can remember.
2014-07-17 21:26 GMT+02:00 Allen <profox@gatwicksoftware.com>:
> I have just had data problems and after getting the cause could be anti
> virus from members here I passed that on to the client. Turned out to be
> the
> wrong version of anti virus, so I was told. Whatever that means it was the
> anti virus
>
> Al
>
> -----Original Message-----
>
>
> Someone even mention antivirus interferences
>
>
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAGQ_JunnmxKqDcONaDSnDbWLsie2t+bNO8Axsp9STp2yHQ5ApA@mail.gmail.com
** 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.
Author: Richard Kaye
Posted: 2014-07-17 15:04:29 Link
The short answer is disable SMB2/3 and turn off opportunistic locking on servers & workstations. MS has said multiple times they have corrected problems introduced with SMB2 but my experience has been that 99% of my data corruption issues went away by doing the above.
Here are some other useful links.
http://support.microsoft.com/kb/296264
http://www.petri.co.il/how-to-disable-smb-2-on-windows-vista-or-server-2008.htm
http://www.caseware.com/support/caseknowledge/kb-271
I've also got this in my bag of tricks
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanWorkstation\Parameters
Create a DWORD value named DirectoryCacheLifetime and give it a binary or hexidecimal value of 0.
I would also make sure that if you're using a share that you turn off off-line file support.
--
rk
-----Original Message-----
From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Alan Lukachko
Sent: Thursday, July 17, 2014 2:34 PM
To: profoxtech@leafe.com
Subject: VFP9.0 data corruption on Windows Server 2012 RC
One of my customers recently purchased a new HP Reliant server with Windows Server 2012 R2 installed. The hardware vendor installed our program and data and it worked as before without a site visit on our part. Our VFP 9.0 program hasn't changed in more than 4 years. Now they get corruption of indexes. A message flashes up when this happens. They have yet to capture the content of it. I have been unable to see it remotely and it's a 3 hour journey to see it live. We have a way of repairing the DBC and a reindexing routine, which they can do themselves without our intervention. This doesn't happen every day and more random that regular.
Any suggestions on what I could try remotely?
TIA
Alan Lukachko
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/DF1EEF11E586A64FB54A97F22A8BD04423A2B818A5@ACKBWDDQH1.artfact.local
** 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.
Author: Eurico Chagas Filho
Posted: 2014-07-17 15:26:37 Link
On Thursday, July 17, 2014 4:46 PM, Tracy Pearson <tracy@powerchurch.com> wrote:
>
>
>Ted Roche wrote on 2014-07-17:
>> On Thu, Jul 17, 2014 at 2:34 PM, Alan Lukachko <
>> al@software-strategies-na.com> wrote:
>>
>>> and it worked as before without a site visit on our part. Our VFP 9.0
>>> program hasn't changed in more than 4 years. Now they get corruption of
>>> indexes. A message flashes up when this happens. They have yet to capture
>>>
>>>
>> Well, something's changed. If you press the client, they may admit
>they've
>> installed new machines (in which case I'd blame SMB2 and disable it) or a
>> new anti-virus (which likely needs to be configured better) or a new
>> network (which needs debugging).
>>
>> The client might not be able to do these things, but they ought to be
>able
>> to answer the questions.
>
>Any software based cached writing may cause this behavior. (write behind
>cache, delayed write cache, SMB2, etc...)
>
>
>Tracy Pearson
>PowerChurch Software
>
>
>_______________________________________________
>Post Messages to: ProFox@leafe.com
>Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
>OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
>Searchable Archive: http://leafe.com/archives/search/profox
>This message: http://leafe.com/archives/byMID/profox/001b01cfa1f7$cc150f40$643f2dc0$@powerchurch.com
>
>** 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.
>
>
>
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/1405628797.1245.YahooMailNeo@web163403.mail.gq1.yahoo.com
** 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.
Author: Alan Bourke
Posted: 2014-07-17 16:21:23 Link
Respectfully have to disagree regarding disabling SMB2/3. That was
necessary for a period on server 2008 where there was a bug that
corrupted indexes. It is not necessary or advisable any more. What you
probably need on Server 2008 and any Win7 workstations is apply the
Enterprise Hotfix Rollup. This has a number of fixes to SMB and won't
have been installed by Windows Update.
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
On Thu, Jul 17, 2014, at 09:26 PM, Eurico Chagas Filho wrote:
>
>
>
>
> On Thursday, July 17, 2014 4:46 PM, Tracy Pearson <tracy@powerchurch.com>
> wrote:
>
>
> >
> >
> >Ted Roche wrote on 2014-07-17:
> >> On Thu, Jul 17, 2014 at 2:34 PM, Alan Lukachko <
> >> al@software-strategies-na.com> wrote:
> >>
> >>> and it worked as before without a site visit on our part. Our VFP 9.0
> >>> program hasn't changed in more than 4 years. Now they get corruption of
> >>> indexes. A message flashes up when this happens. They have yet to capture
> >>>
> >>>
> >> Well, something's changed. If you press the client, they may admit
> >they've
> >> installed new machines (in which case I'd blame SMB2 and disable it) or a
> >> new anti-virus (which likely needs to be configured better) or a new
> >> network (which needs debugging).
> >>
> >> The client might not be able to do these things, but they ought to be
> >able
> >> to answer the questions.
> >
> >Any software based cached writing may cause this behavior. (write behind
> >cache, delayed write cache, SMB2, etc...)
> >
> >
> >Tracy Pearson
> >PowerChurch Software
> >
> >
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/1405632083.13701.142872269.7BCD55D2@webmail.messagingengine.com
** 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.