Repairing data corruption on ISAM file systems from NT workstations.

NETKEEPER^{^{^�}}
nklin1.gif (3727 bytes)
|Home|Products|Demos|Tech Support|Top FAQ list| Help Desk Software| CRM Software|

Repairing data corruption on ISAM file systems from NT workstations.
Document ID : 000-000583 Created:11/07/2000 Last changed on: 3/02/2001

Note: Does not apply to NetKeeper Help Desk Captain CRM(tm) or NetKeeper Help Desk Admiral(tm) as they are SQL server based.

Data table corruption is usually caused by incorrect data sharing settings on workstations. Check your workstation's data sharing settings and turn off and write caches or write delays. Do not turn off write caches at the server. Also turn off opportunistic locking at the server.

To fix a data file from an NT workstation:
(This example uses the SCMNK - service call master table. If necessary, substitute the name of the table you need to fix.)

*- File maintenance requires single user access. Have all users of the NetKeeper software exit the program. Close down any NetKeeper automated procecees such as CAPCOM or HD Mail.

*- Make a backup of your NetKeeper database.

*-Open a command prompt (DOS prompt)

*-Navigate to the directory (folder) where your NetKeeper program is installed.

*-Rename your data file, at the command prompt type:
REN SCMNK.* TEMP.* (press enter)
This command will rename the table to be fixed (SCMNK) to TEMP. The above command will rename all SCMNK files regardless of the extension. For example SCMNK.K01 will be
renamed TEMP.K01

*-Start the CSRT utility, at the command prompt type:
CSRT (press enter)
This command will start the Clarion sorter utility

*-Enter data into the CSRT utility:
The input file is TEMP.DAT (press ENTER)
The output file is SCMNK.DAT (press ENTER)
Press ENTER to accept the remaining defaults
Press ENTER to run the utility.

*-You are done if CSRT completes without errors. If CSRT reports errors or duplicate records:
-Read the error message and fix the problem. Other users may be using the table if the error message includes "non-sense" characters.
-If the CSRT utility reports duplicates in the file the utility will save the record numbers of the duplicated entries to a file. Print or TYPE the file.

Deleting duplicate records
Use the CSCN - Clarion Scanner - utility to remove duplicate records
To delete the duplicate records:
*- File maintenance requires single user access. Have all users of the NetKeeper software exit the program. Close down any NetKeeper automated processes such as CAPCOM or HD Mail.

*- Make a backup of your NetKeeper database.

*-Open a command prompt (DOS prompt)

*-Navigate to the directory (folder) where your NetKeeper program is installed.

*-Print or TYPE the file that CSRT created and that lists the duplicate records
This file will list pairs of records that are duplicated. For example:
867, 1054

*-At the command prompt type:
CSCN (press enter)
Note: You can also start the CSCN utility by double-clicking the CSCN.EXE file in Windows(R) Explorer.

*-Input file is SCMNK (or the table you need to repair)
*-Sort order: Record Number (press ENTER to select)
*-Press ENTER to scan the file
*-For each pair in the duplicated records list you need to delete one of the records.
*-Press Ctrl+J and enter the record number to delete
*-Check that the record is the one you need to delete. Do not confuse Record Number with a data identifier such as SRVCID. The record number can be read on the bottom line of the CSCN utility.
*-Press Ctrl+D to delete the record.
*-Once done, re-run the CSRT utility (see above). The utility should not report errors.
*-Start your NetKeeper programs and check that the data displays correctly.

Note: Data corruption should be a very rare (if ever) occurrence. Repeated data corruption of your data files indicates that one or more workstations (or maybe even a server) are not properly sent to share data in real time.

This solution text WEB page is automatically generated from your knowledge base and service data by NetKeeper Help Desk Software or NetKeeper CRM software. You can customize the pages to your site's look and feel or even include advertisements.