TABanalys and DBanalys crash due to 32K record sizes ( _dbutil.exe exception c0000409)

TABANALYS or DBANALYS crash with _dbutil.exe exception c0000409
DBTOOL Option 4. Record Version Validation, crashes against some tables
DBTOOL Option 4 confirms there are records with outdated schema: Number of fields mismatch. Expected (n), got (n-x) 

Dumping the data via the data dictionary (ASCII dump) the dump is successful but loading the data results in errors when reading record fields
Binary dump and load does not report any errors
Database integrity checks do not report any data or index corruption:

• DBTOOL Options: 3 &5
• DBRPR Options: 1&4 
• IDXCHECK Validation Options: 1-6 
• IDXFIX Options: 3&8 

There are records in the database that are very close to the 32k record limit:

• When the record version is being validated during the analysis process (due to a prior schema change) this crosses the 32k boundary when the record size metric is calculated for the report. 
• When TABANALYS | DBANALYS tries to put the record fragments together, it crashes as it does not expect the record to ever be greater than the maxrecsize (32000)

A similar issue was identified that was fixed at the same time:  DBANALYS crashes with error 15892 after a new LOB field was added  

Upgrade to OpenEdge 11.7.6 Service Pack, 12.2.0 or later.  

1. DBANALYS | TABANALYS uses the correct record fragment size when it assembles a record with multiple fragments including the 2-bit lob locator
2. DBTOOL Option 4 ( Record version validation) and DBANALYS will raise a warning message when they process records that exceed the max record size, which will need to be addressed:

• DBANALYS will write this message to the database lg file
• DBTOOL will write this message to the screen (STDOUT)

 

Identify large records and reduce their size by removing field data that can be deleted or truncated:
 

DEFINE VARIABLE hBufferHandle AS HANDLE NO-UNDO.
hBufferHandle = BUFFER <table name>:HANDLE.
FOR EACH <table name> NO-LOCK:
IF hBufferHandle:RECORD-LENGTH GT 31000 THEN
DISPLAY string(rowid(<table name>)) format "x(25)" <primary identifying field> hBufferHandle:RECORD-LENGTH .
END.