Rebuild Unrecoverable Error
I was recently sent a QuickBooks Company file for analysis because the file not only failed to Verify but it also failed Rebuild with a critical fault [Unrecoverable Error – Code: 00000 50828] (seen in the headline illustration for this article). You won’t find that error number in any of the Intuit QuickBooks Technical Support KBAs.
I soon discovered that this was indeed a very ‘sick’ QuickBooks Company file with a lot of different problems including some ‘duplicate record numbers’, as shown in the QBWin.log excerpt below.:
LVL_ERROR--Duplicate Record Numbers found within this company file
Even though duplicate record numbers represent a serious form of corruption (which will cause Verify to fail), these were not the only (or most serious) problems existing within the file. We also found structural integrity errors including corruptions affecting various tables QuickBooks makes use of during its Rebuild routines.
Some of the errors we encountered are defined in Sybase as SQL Code error -110 which translates to an “Item “XXXXX” already existing”. As you can see from the log excerpt below, two (of several) of the tables showing this kind of corruption were the ‘all record numbers’ (all_recnums) table and the ‘duplicate records only’ (dups_recs_only) table.
LVL_ERROR--Unable to create a table in support of verify/rebuild. DB error code -110, Msg: Item 'vi_all_recnums' already exists
LVL_ERROR--Unable to create a table in support of verify/rebuild. DB error code -110, Msg: Item 'vi_dups_recs_only' already exists
These two tables (along with many others) are normally created within the database during the rebuild routines to allow any duplicate record numbers to be written to a temporary table so that their identities can be changed to a new record number before being written back to the appropriate table(s) with their corresponding data.
When the structural integrity of the database no longer supports the creation of the necessary temporary tables, the Rebuild utility cannot perform the necessary steps to resolve the duplicate record number repairs, as evidence by the errors seen below:
LVL_SEVERE_ERROR--Could not clean up temporary tables after verify/fix of database IDs
LVL_SEVERE_ERROR--Unexpected error in Duplicate ID verification. error code: -6184, msg: Deletion of one of the temporary tables required to identify/fix the 'duplicate ID' problem failed
These seem to be extremely rare forms of corruption. In researching these errors I spoke with my good friend and colleague, the old master of QuickBooks Data Repair, Shannon Tucker1about these errors, Shannon told me that he “didn’t recall seeing this form of corruption before”.
I wanted you, our readers, to see examples of these Errors; while I believe this to be an isolated instance of a severely corrupted file it would be very beneficial to know if anyone else has encountered this type of corruption in recent history, and to ask you to keep an eye out for similar problems.
If you have seen these problems before, or you encounter them in the near future, I would ask that you contact me here at Intuitive Accountant with the details concerning such a file.
1 - Shannon Tucker, is co-founder of AccountingUsers,Inc., a Colorado based company (not owned, operated or affiliated with Intuit); he has been specializing as a database consultant providing 3rd-party support resources for users of QuickBooks software since 1986.