Clarion Community Help

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
| **Navigation:**  ISAM File Drivers > TopSpeed File Utilities >====== TopSpeed Database Recovery Utility ====== | [[topspeed file errors.htm|{{btn_prev_n.gif|Previous page}}]][[coming future.htm|{{btn_home_n.gif|Return to chapter overview}}]][[tpsfix command line parameters.htm|{{btn_next_n.gif|Next page}}]] |
|  ||

The TopSpeed file system is designed to automatically repair most errors. However, if a TopSpeed file is physically damaged during a system malfunction, the TopSpeed Database Recovery Utility (TPSFIX.EXE) can recover the undamaged portions of your data.

{{notebox.jpg|NoteBox.jpg}}

**The TopSpeed Database Recovery Utility is an emergency repair tool and should not be used on a regular basis. Use it only when a file has been damaged.**

The TopSpeed Database Recovery Utility reads the damaged file and writes the recovered records to a new file. It uses the information stored in the file's header and scans the file recovering undamaged portions.

Optionally, you can provide an example file containing the header information in the event the original header information is damaged. An example file is any file with a FILE declaration identical to the damaged file. You can create an example file by issuing a CREATE(file) command, then saving the resulting empty file to a new name.

The TopSpeed Database Recovery Utility is a distributable utility designed to help your end users recover damaged files.

The following DLLs, found in the Clarion BIN folder, also need to be distributed with TPSFIX.EXE:

ClaRUN.dll

ClaTPS.dll

{{tipbox.jpg|TipBox.jpg}}

**The Clarion license agreement applies to TPSFIX.EXE and its associated DLLs. You may distribute to your users, but they may not redistribute it.**

The recovery utility is designed to work either interactively or noninteractively with command line parameters. Interactively, you provide the parameters through two wizard dialogs. You can run TPSFIX noninteractively by supplying the command line parameters with the Clarion RUN() statement, Windows API calls, Windows 95 shortcuts, or Program Manager Icons.

**ERRORCODE 90 and Corrupted Files**

The TopSpeed driver posts an ERRORCODE of 90 for unexpected runtime errors. When an ERRORCODE of 90 occurs, the driver also posts a FILEERRORCODE (the former TPSBT error code) that helps us diagnose the problem.

An ERRORCODE of 90 usually indicates your TopSpeed file is corrupted. In most cases the corruption is a result of hardware failure. For example, one customer with a 50 machine network traced a near daily file corruption to bad network cards on 2 of the 50 machines. After replacing the bad cards, the corruptions disappeared.

However, should you receive an ERRORCODE of 90 from the TopSpeed driver, we want to know about it. Before you repair the file, please make a copy of the damaged file and send it to us along with the corresponding FILEERRORCODE value. We analyze all the corrupted files we receive for recognizable patterns that can help us improve the driver.

[[topspeed file errors.htm|TopSpeed File Errors]]

[[trappable run time errors.htm|Standard Errorcodes and Errors]]