Отправлено: 07.04.06 08:44. Заголовок: HELP PLEASE ! Вылетает ошибка в ADS_ERR.dbf

привет всем. Помогите идетифицировать ошибку отображенную в ads_err.dbf

привожу последние 2 строки этого файла (для удобства поля записей располагаю в столбец):



DATE 04/07/2006
TIME 09:13:21
THREAD_NUM 1200
ERR_CLASS 2
ERROR_CODE 55002
ADS_SOURCE TPSVIS.C
SRC_LINE 705
CNNCT_NAME GALA
FILENAME C:\BK\entries.DBF
ADS_VER 6.11
ENVIRONMNT Windows NT
OS_VERSION 5.0



DATE 04/07/2006
TIME 09:13:21
THREAD_NUM 1200
ERR_CLASS 7000
ERROR_CODE 7042
ADS_SOURCE TPSVIS.C
SRC_LINE 706
CNNCT_NAME GALA
FILENAME C:\BK\entries.DBF
ADS_VER 6.11
ENVIRONMNT Windows NT
OS_VERSION 5.0

 Отправлено: 07.04.06 10:12. Заголовок: Re:

ERROR_CODE 55002
Такой ошибки в HELP нет посмотри, может ошибся
ERROR_CODE 7042
Problem: With DBF tables, the byte being used for the Transaction Processing System (TPS) semaphore byte (either the "deleted" byte or the AXS_TPS field, if one exists) has bits set that are invalid for that byte.

With ADT tables, the bytes being used to store TPS information contains invalid data for those bytes. This error usually has nothing to do with the use of transaction processing itself. For some reason, data in the TPS semaphore byte(s) is being corrupted.

With DBF tables, a non-Advantage product is most likely causing the corruption. With ADT tables, the server likely crashed in the midst of a transaction, and the transaction was not properly recovered from when the Advantage Database Server was restarted. The previous Advantage Database Server error log file (ADS_ERR.DBF) entry contains the record number of the record that has invalid bits in its TPS semaphore byte(s).

Solution for DBF tables: When not in a transaction, clear the invalid bits in the TPS semaphore byte. If the semaphore byte is the "deleted" byte, open the DBF table exclusively via a non-Advantage driver. Then loop through all records in the table re-marking all records for deletion that are currently marked for deletion and recalling all records that are not currently marked for deletion. If the TPS semaphore byte is the AXS_TPS field, open the table exclusively (doesn't matter which driver is used). Then loop through all records in the DBF table and clear all contents in the AXS_TPS field by replacing the field with a single space " ". If 7042 errors keep recurring, determine what product or operation corrupts the TPS semaphore byte, and have the product fixed or the operation altered.

Solution for ADT tables: Run the ADT table repair utility (ADTFIX.EXE) against the offending ADT table. This utility is available for download from the Advantage Developer Zone Web site in the "Tools & Utilities" section, http://solutions.AdvantageDatabase.com.

 Отправлено: 07.04.06 10:19. Заголовок: Re:

Первая непонятно

Вторая: Invalid bits set in the TPS semaphore byte

Т.е неверное значение в байте, описывающем состояние тразнакции
Это поле AXS_TPS (если есть) или отметка Deleted, которая в Ads
используется для служебных целей, в том числе при транзакции