Steps to delete duplicate records from damaged (corrupted) data files in the ISAM (server based NetKeeper data files). Does NOT apply to SQL systems.

The example below uses the SCMNK table (file) replace with the file name that you need to service.

*- 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.

*-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 set up 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.

Powered by NetKeeper^� Help Desk Software
Copyright 1991-2026 Multima Corporation - Conditions of use
Contact us