Consultor Eletrônico

Status: Unverified

SYMPTOM(s):

SYSTEM ERROR: record usecount overflow (4402)

CAUSE:

Possible data corruption as every record has the table number as the first
field in the record. Alternatively memory violation when attempting to read the table-number out
of the record.

FIX:

There are levels of data corruption detection:
Corruption Type Indicators Method of Detection

Block Level corruption 1124 message probkup, procopy,
any process that reads
the entire database.
Block content Core dumps dbanalys, idxbuild,
Corruption etc.
Record Corruption 137, or other dbanalys, idxbuild,
record based msg
Index Corruption or 1422, or other idxfix, idxcheck
Record Content index based msg
Corruption
The above table is order based with the least intensive checks
at the top and the most intensive types of checking at the bottom.
In general the more intensive checks also perform the same
checks as what gets done at the previous level. For example,
idxcheck performs both index and record level checking as
well as block level checking, while dbanalys, does record checking,
and block checking, but not index checking.
Please first run a dbanalys (online) to see if any unexpected messages
pop up. If you have downtime available, or you can make a copy of the
database, then run an idxcheck on the database (or the copy).