When application software is deployed on a network, any shortcomings or weaknesses in the operating system or network are inherited by the application. As a result, when network problems occur, they affect the application software. Because the problems appear to occur in the application software, frequently the application software is blamed. However, data corruption and problems that are manifested in the application software are quite often the fault of problematic networking software (and sometimes hardware issues). As the number of users increase, so does the network traffic and so can the frequency of any underlying problems. Because of the complexity of a networking system, when data corruption occurs, it can be very difficult to diagnose and troubleshoot problems, even for trained specialists.
This document is a white paper that was written to educate our customers, dealers and other third parties about the various problems associated with networks and redirectors that we have encountered on a regular basis. This document also discusses diagnosis and treatment of these problems.
Note: Software Technology, Inc. no longer supports Windows 95 since Microsoft has discontinued support of this operating system. However, references to Windows 95 have been retained in the article for historical purposes.
The following is a list of some of the issues that are discussed in this article:
The software that allows workstations or "clients" to "talk to" a server via a network is referred to as redirector software. Redirector software for networks is provided primarily by Microsoft and Novell. This software is an extremely critical component of any network. Each workstation on a network has its own redirector software. For example, if you have one workstation running Windows 98 and another workstation running Windows XP, each of these workstations has different redirector software. If there are "bugs" or "glitches" in the redirector software, it can cause all kinds of problems with other software programs.
We have had reports of problems with errors such as 1400-0-160-0 and 1400-0-69-0. Duplicate Key errors have been reported by our Data File Integrity Check (error 69) and Reindex Files programs. Other users have received intermittent lockups due to "Invalid Page Fault" errors.
Redirectors attempt to increase performance by caching parts of files in the
memory of the local computer instead of getting the latest information from the
network server. Unfortunately, the caching algorithms used have some problems
that interfere with multi-user database programs such as Tabs3. Microsoft and
Novell have been working on their redirector programs to reduce the data
corruption problems.
It is important to note that these data corruption problems are due to problems
in Microsoft and Novell software components. They are not due to
Tabs3 or PracticeMaster programs. Although the file access routines used in Tabs3
Version 9 or later expose these problems more so than previous versions, it is
important to note that the corruption problems are not limited to
our programs.
Examples of other software companies reporting corruption problems with these
redirectors are:
The solution to network or data corruption problems is a multi-pronged approach consisting of the following:
CAUTION: Editing the Windows registry is typically not recommended
because of potential problems that can occur when not done properly. We are not
responsible for edits made to the registry. The recommended registry changes
actually require the addition of values to subkeys and should not be attempted
unless familiar with the registry. Any registry changes should be made by your
network administrator or a qualified professional. Because of this
recommendation, we have provided the recommended registry changes; however, we
have not included step-by-step directions for implementing these changes.
(Our Support personnel do not have the necessary training to help you with
Windows registry changes.)
WARNING: The following disclaimer is used by Microsoft regarding editing
of the registry: "Using Registry Editor incorrectly can cause serious
problems that may require you to reinstall your operating system. Microsoft
cannot guarantee that problems resulting from the incorrect use of Registry
Editor can be solved. Use Registry Editor at your own risk."
IMPORTANT: Microsoft recommends making a back up copy of the registry
files before editing the registry. Refer to Microsoft documentation for details on how
to back up the registry.
We have written a utility program called REDRTEST.EXE that can be used to
test for current network redirector software on network workstations and most file
servers. This program also tests for our recommended Windows registry settings
including Windows 2003/XP/2000/NT opportunistic locking settings and can be used to automatically
implement those registry settings if they need to be changed (provided you have
sufficient rights and are logged in as an administrator).
The REDRTEST.EXE program file is installed when the System Configuration
program is installed from the program CD-ROM. However, you want to make sure you
have the most current version of the REDRTEST.EXE utility program. If the
REDRTEST.EXE file installed from the CD-ROM has a date earlier than April
2003, you will want to download the most current version from the Internet.
The REDRTEST.EXE program file can be found on the Internet at:
http://www.Tabs3.com/Support/Utilities.html
A redirector is the part of the operating system that lets a computer talk to another computer. The other computer may be a Novell server or other Windows computer. There are several redirectors available for Windows Me/98/95:
A computer can have redirectors for both Microsoft and Novell servers loaded simultaneously. So a user could have:
Client for Microsoft Networks and
Client for NetWare Networks
or
Client for Microsoft Networks and
Client 32 Redirector
but not
Client 32 Redirector and
Client for NetWare Networks (since both are for NetWare).
Do I need to update redirectors for Windows 95 clients?
Any Windows 95 computer that is not using the most current redirector software MUST be updated. This applies to both Windows and Novell networks.
Do I need to update redirectors for Windows XP/2000/NT clients?
Redirectors are updated differently for Windows XP/2000/NT clients. Instead of downloading and updating separate patches (as is the method with Windows 98/95), patches are included in a consolidated Service Pack. Therefore, for Windows XP/2000/NT clients, simply verify that the most current Service Pack has been installed. The most current Service Packs for Windows XP/2000/NT clients are the same as those listed in the Microsoft Server section of this document.
Do I need to update redirectors for Windows Me/98 clients?
If you are running under Novell Client 32, you need to make sure the most current version of Client 32 is installed for each workstation.
Do I need to implement registry settings for Windows Me/98/95 workstations?
Yes. Our REDRTEST.EXE utility program can easily do this for you.
Do I need to implement registry settings for Windows XP/2000/NT workstations?
Yes. Our REDRTEST.EXE utility program can easily do this for you.
How do you tell what redirector(s) a Windows Me/98/95 computer is using?
From the Control Panel, double-click Network to see which of the following network components is installed:
How can you tell which version of VREDIR.VXD or NWREDIR.VXD is being used on a Windows Me/98/95 computer?
--- OR
---
Note: Keep in mind that just because the file is shown in Explorer or the About Tabs3 dialog box doesn't indicate that the file is actually being used. The Control Panel | Network indicates which redirector(s) are being used.
How can you tell which version of the Client 32 Redirector is being used?
There are several methods that can be used.
--- OR
---
If you are using Windows Me/98/95:
--- OR
---
If you are using Windows NT:
Note: Windows XP/NT also shows the client version in the title bar of the initial Login window.
--- OR
---
If you are using Windows XP/2000:
The following information includes technical information, recommended
registry settings and how you can download the most current redirector from the
Internet.
|
Client for Microsoft Networks (VREDIR.VXD) |
|
|
Provided by |
Microsoft |
|
Used when |
Connecting a Windows Me/98/95 computer to a Windows computer |
|
Latest version |
4.00.1116 size = 156,773 (Windows 95) |
|
How to obtain the latest version |
www.Tabs3.com/Support/Utilities.html |
|
Recommended registry Settings |
We recommend that all Windows Me/98/95 workstations
implement the following registry setting: |
|
Client for NetWare Networks (NWREDIR.VXD) |
|
|
Provided by |
Microsoft |
|
Used when |
Connecting to a NetWare server |
|
Latest version |
4.00.960 size=123,987 (Windows 95 Bindery Mode) |
|
How to obtain the latest version |
www.Tabs3.com/Support/Utilities.html |
|
Recommended registry settings |
We recommend that all Windows 98/95 workstations
implement the following registry setting: |
|
Client 32 95/98/Me Redirector |
|
|
Also known as |
Novell Client for Windows 95/98/Me |
|
Provided by |
Novell |
|
Used when |
Connecting a Windows Me/98/95 workstation to a NetWare server |
|
We recommend |
We recommend using the latest version redirector with the most current patches in order to avoid potential problems with earlier redirector versions. |
|
Latest version |
As of this writing (November 2008), the latest version is v3.4 for Windows 95/98/Me. |
|
How to obtain the latest version |
Novell.com Communities
Cool Tools Note: Keep in mind that reinstalling a different redirector resets the Advanced Settings to their predefined defaults. Therefore, do not forget to change the Advanced Settings to the recommended values as follows. |
|
Recommended advanced settings |
Novell Technical Support has advised us to recommend the following advanced settings. A tier-based system is recommended because certain settings can result in slower performance. The Advanced Settings are located on the Multi-Tabbed Properties Dialog. For a typical configuration, use the following advanced settings:
Opportunistic Locking = OFF For a conservative configuration (to be used if you experience data corruption problems), use the following advanced settings:
Opportunistic Locking = OFF Note:
Our REDRTEST.EXE utility program can be used to
check and change these settings. |
|
Client 32 NT/2000/XP/2003/Vista Redirector |
|
|
Also known as |
Novell Client for Windows NT/2000/XP |
|
Provided by |
Novell |
|
Used when |
Connecting a Windows NT/2000/XP/2003 workstation to a NetWare server |
|
We recommend |
We recommend using the latest version redirector with the most current patches in order to avoid potential problems with earlier redirector versions. |
|
Latest version |
As of this writing (November 2008), the latest version is
v4.91 SP5 for Windows XP/2003. Note that this version does not
support the Windows NT or 2000 client.
Windows Vista Note: The latest version available for Windows Vista is Novell Client SP1. Windows 2000 Note: The last version available for Windows 2000 is v4.91 SP2 for Windows 2000/XP/2003. Windows NT Note: The last version available for Windows NT is v4.90 SP2 for Windows NT/2000/XP. |
|
How to obtain the latest version |
Novell.com Downloads Note: Keep in mind that reinstalling a different redirector resets the Advanced Settings to their predefined defaults. Therefore, do not forget to change the Advanced Settings to the recommended values if necessary. |
|
Suggested Advanced Settings |
Novell Technical Support has advised us to recommend the following advanced settings. A tier-based system is recommended because certain settings can result in slower performance. The Advanced Settings are located on the Multi-Tabbed Properties Dialog. For a typical configuration, use the following advanced settings:
File Caching = 0 (OFF)
File Caching = 0 (OFF) |
It is important to make sure that the server being used has the latest Service Pack installed. The following lists the most current Service Packs for both Microsoft and Novell servers and also identifies issues known to cause data corruption.
Make sure that the latest Service Pack is installed. As of this writing (November 2008), the latest versions of Windows servers are:
Server O/S |
Latest Service Pack |
Windows NTv4 |
SP6a Security Rollup Package (Nov 99) |
Windows 2000 |
Update Rollup 1 for SP4 (Apr 05) |
Windows Server 2003 |
SP2 (Mar 07) with various miscellaneous updates |
|
Windows Exchange Server 2003 |
SP2 (Oct 05) with various miscellaneous updates |
Windows XP |
SP3 (May 08) with various miscellaneous updates |
| Windows Vista | SP1 (Apr 08) with various miscellaneous updates |
|
Windows Server 2008 |
Evaluation R2 (Feb 08), release not yet available |
To determine which Service Pack is installed on a Microsoft server:
Users can also experience file corruption due to the use of opportunistic locking by Windows NT. This is a problem that affects networks with Windows 2003/XP/2000/NT servers. Novell networks are not affected.
What is opportunistic locking?
Opportunistic Locking is another attempt at allowing computers on a network
to cache data locally instead of retrieving data from the Windows 2003/XP/2000/NT server with
the hope of improving performance. Again, there seems to be problems in at least
some situations where opportunistic locking doesn't work quite right.
Opportunistic locking is explained in Microsoft Knowledge Base Article #129202,
"Explanation of Opportunistic
Locking on Windows NT".
It is interesting to note that this article states:
"Oplocks are a significant performance enhancement, but have the potential to cause lost cached data on some networks ..."
Microsoft has acknowledged problems with Opportunistic Locking in Microsoft Knowledge Base Article #303528, "How to Keep a Jet 4.0 Database in Top Working Condition".
How is opportunistic locking disabled?
We recommend disabling opportunistic locking at the Windows 2003/XP/2000/NT Server in order to prevent data corruption. To do so, you can use our REDRTEST.EXE utility program on a Windows 2003/XP/2000/NT Server or you can edit the Registry (on the 2003/XP/2000/NT server).
HKEY_LOCAL_MACHINE/System/CurrentControlSet/Services/LanmanServer/Parameters
EnableOpLocks = 0
(hex)
EnableOpLockForceClose
= 1 (hex)
CachedOpenLimit = 0
(hex)
Note: The above values should be added as DWORD values if not present.
Make sure that the latest Support Pack (SP) is installed. As of this writing (November 2008), the latest versions of NetWare servers are:
Server O/S |
Latest Support Pack |
NetWare Ver. 6.5 |
SP7 (9 Oct 2007) |
NetWare Ver. 6 |
SP5 (29 Jun 2004) with various miscellaneous updates |
NetWare Ver. 5.1 |
SP8 (8 Mar 2005) with various miscellaneous updates |
To determine which Support Pack is installed on a Novell server:
NSS Note: The following TURBO FAT issue does not apply to NetWare volumes that use an NSS filesystem. This issue only affects unpatched servers that use the old FAT file system. If you use an older Novell NetWare file server, you can download the patch as discussed in the following, or consider migrating the filesystem to NSS.
By default, older Novell servers used a special File Allocation Table feature called TURBO FAT to improve performance. However, there have been data corruption problems (not related to our software) reported with this feature. The corruption occurs while the file is in the server's memory. When the file is modified by an application and rewritten to the server's hard disk, the corruption is introduced. Novell's Technical Information Document 10064734, "How to Disable TurboFat", reports that "The problem is typically seen on NetWare 4.10, 4.11, 5.0, 5.1 and 6.0 file servers with database applications which use large files." The definition of a "large file" is somewhat subjective because it depends on how the hard drive was formatted and the file block size.
The aforementioned Novell article includes instructions to download a Novell patch that will disable this feature. The patch includes files named TURBODIS.NLM and TDIS600.NLM that when installed will disable the TURBO FAT feature.
Because many data files in our software can be considered large, such as the client file, the archive files, the fee and cost transaction files, etc., we STRONGLY recommend downloading this Novell patch and disabling this feature. Alternatively, consider migrating to an NSS filesystem.
Additional details regarding TURBO FAT can be found in the following Novell Technical Information Documents (TIDs) at support.novell.com:
Novell NetWare also includes an Opportunistic Locking feature. We recommend that Opportunistic Locking be DISABLED at the Novell NetWare File Server. This applies to servers running under Version 5.0 SP5, Version 5.1 SP2, or later.
This setting can be disabled by:
The command to disable the setting is the same regardless of which method is used to implement it. The command is:
SET CLIENT FILE CACHING ENABLED = OFF
We recommend editing the AUTOEXEC.NCF file, which requires rebooting the server after adding the command. However, the command line method can be used temporarily until it is more convenient to reboot the server.
Always make sure the latest Network Interface Card (NIC) driver is being used. Current drivers are typically available from the manufacturer of your NIC card.
The Realtek NIC drivers that Microsoft placed on the Windows 98 CD-ROM are problematic and definitely cause data corruption. If you are using these drivers, you need to get the latest drivers from Realtek or use a different NIC. (Details can be found in Microsoft's Knowledge Base Article 189778, "Possible Problems with Windows 98 Realtek Network Adapter Drive" on the Internet at support.Microsoft.com.)
NICs can be configured with their own set of power management features, but it may be necessary to disable these features. Enabling power management on a NIC can cause connection issues, resulting in fatal errors within the software. More information is available in KB Article R10339, "Power Management Issues with Tabs3 and PracticeMaster Software Products."
Improper configuration of NIC link speeds and duplex settings can cause sluggish network performance, timeout errors and lost network connections, all of which can in turn lead to data corruption. It is important that each NIC, including those on the file server(s), are configured to match the speed and duplex settings used by the ports on the hubs or switches to which they are connected.
Many NICs, hubs and switches support auto-detection (also called auto-sensing and auto-negotiation), which automatically detects and matches the speed and duplex settings configured for the connected hub or switch port. However, auto-detection may not work correctly when connecting certain brands of NICs, hubs and switches to certain other brands. Therefore, it may be necessary to manually configure the NIC to match the exact speed and duplex settings used by the hub or switch port. The following articles from Microsoft's Knowledge Base and Novell's Knowledge Base provide detailed information regarding speed and duplex settings:
THE INFORMATION PROVIDED IN THE SOFTWARE TECHNOLOGY, INC. KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. SOFTWARE TECHNOLOGY, INC. DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL SOFTWARE TECHNOLOGY, INC. OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF SOFTWARE TECHNOLOGY, INC. OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.
© 1999-2008 Software Technology, Inc. All rights
reserved. Terms of Use
The maker of Tabs3 and PracticeMaster
e-Mail Suggestions for the Knowledge Base to: kb@Tabs3.com
Technical Support via e-mail is not available.
Knowledge Base: http://support.Tabs3.com
Web Site: http://www.Tabs3.com