User Tools

Site Tools


topspeed_file_errors.htm
Navigation:  ISAM File Drivers > TopSpeed Database Driver > More Details >====== TopSpeed File Errors ====== Previous pageReturn to chapter overviewNext page

Here is a list of the TopSpeed file errors returned by FILEERRORCODE , and a brief explanation:

231 trying to append a record when the btree is marked read-only
232 cannot get btree header when trying to append a record
256 cannot get btree header when trying to get a record
300 btree structure corrupt (discovered when deleting a record)
327 btree structure corrupt (discovered when putting a record)
337 trying to put a record when the btree is marked read-only
522 invalid data size found while unpacking record (from disk)
530 invalid repeat count found while unpacking record (from disk)
706 btree structure corrupt (discovered when inserting a record)
780 btree structure corrupt (discovered when removing a record)
824 btree record size to big (on allocation)
1013 cannot get btree header (while loading root page)
1043 cannot get btree header (while packing a record to disk)
1163 trying to create new record ID when the btree is marked read-only
1164 cannot get btree header (while allocating new record ID)
1173 maximum record ID reached on allocation (probably indicating file corruption)
1194 trying to insert record when the btree is marked read-only
1203 trying to remove record when the btree is marked read-only
1364 btree structure corrupt (discovered while splitting a page)
1477 btree page size (from header) does not match size stored on disk
1602 btree unpacked page size (from header) does not match size loaded from disk
1659 btree page size increased after packing
1678 btree page size larger than maximum allowed
1735 btree header corrupt (discovered when trying to calculate disk file size)
1781 btree structure corrupt (discovered while shifting btree pages up)
1891 btree structure corrupt (discovered while moving btree pages)
1894 btree structure corrupt invalid page parent level (discovered while moving btree pages)
2172 reading of btree page from disk failed
2183 too many files logged out
2272 encryption block invalid size (discovered when reading page from disk)
2277 ReadFile Win32 API function failed (when reading page from disk)
2286 encryption block invalid size (discovered when writing a page to disk)
2328 invalid internal btree locking mode (on lock)
2352 invalid internal btree locking mode (on unlock)
2341 SetFilePointer Win32 API function failed (when reading page from disk)

Using the Recovery Utility Interactively

1.Start the utility by DOUBLE-CLICKING on the TopSpeed Database Recovery Utility Icon In the Clarion Program Group.

The TopSpeed Database Recovery Utility dialog appears. The utility consists of two wizard dialogs.

2.In the Source (file to recover) section, specify the file name or press the Browse button to select it from a standard file open dialog.

3.If the file has a password, type it in the Password entry box.

If the database file contains multiple tables (data files), each table must have the same password.

4.Optionally, in the Destination (result file) section, specify the file name for the target file or press the Browse button to select it from a standard file open dialog.

By default the .TPR extension is added to the source file name. This parameter is optional. If omitted, the original (source file) is overwritten and a backup file is created. The source file is renamed to filename.TPx, where x is automatically incremented from 1 to 9 each time a new file is created. If all nine numbers are used, any subsequent files created are given the extension .TP$ and are overwritten.

5.If the result file is to have a different password, type it in the Password entry box. If omitted, the password is removed.

6.Press the Next button.

The second wizard dialog for the TopSpeed Database Recovery Utility appears.

7.Optionally, specify the Example File file name or press the Browse button to select it from a standard file open dialog.

The utility uses the Example File to determine table layouts and key definitions in the event those areas of the source file are damaged. The default extension is .TPE, but if you choose, you may use any valid DOS extension

TipBox.jpg

We recommend shipping an example file when you deploy your application. This improves data recovery from a damaged file.

8.If the example file has a password, type it in the Password entry box.

9.If you want the utility to rebuild Keys, check the Build Keys box.

If omitted, the keys are rebuilt by the original application when it attempts to open it.

10.If you want to use the Header Information in the source file, check the Use Header box.

Using Header Information optimizes the utility's performance, but should not be used if the file header is corrupt. If omitted, the utility searches the entire data file and restores all undamaged pages.

11.If the application uses a Locale (.ENV) File for an alternate collating sequence, specify the .ENV file or press the Browse button to select it from a standard file open dialog.

12.If the file is using the OEM attribute to control the collating sequence, Check the Use OEM box.

This enables the OEMTOANSI and ANSITOOEM conversion.

13.Press the Start button to begin the recovery process.

If the utility does not find any errors, a message appears informing you that “No Errors Detected in <;fliename.ext>” and asks if you want to continue with recovery.

topspeed_file_errors.htm.txt · Last modified: 2021/04/15 15:57 by 127.0.0.1