Encountering error (FETCH ec = 49153) on table CBBTDT on DBDUMP

[SGL497712]

I encounter the above error when performing DBDUMP, and cannot add or modify anything in CB batches

 

[ettienne]

What database engine and version are you using? Pervasive, MS SQL, ...

Your data is corrupt, run a database verify and data integrity check and let us know what the results are.

 

[SGL497712]

I am running Accpac 5.4, Pervasive SQL 9.1. Verifying the database passes successfully. The data integrity check is per below.







Page: 1
06 06 2010 4:06:56PM
Cashbook 5.4A (June 6, 2010 16:05:02)
Check Batches: [Yes]
Fix Batches: [No]
Check Balances and Transactions: [Yes]
Fix Transactions: [No]
Check History: [Yes]
Fix History: [No]
Setup Tables: [Yes]
Fix Setup Tables: [No]
Checking SP4 Upgrade Completed...
0 Error(s) found
Checking Sequences...
0 Error(s) found
Checking Bank Details...
0 Error(s) found
Checking Miscellaneous Banks...
0 Error(s) found
Checking Batches...
E: CB Batch Detail.
Database error (operation=REV-FETCH, error=0).
E: CB Batch Detail.
Database error (operation=REV-FETCH, error=0).
E: Orphan batch header found for batch 002261 entry 00006.
E: Internal error.
CB Batch Detail.
Invalid logical position.
E: Orphan batch header found for batch 002261 entry 00007.
2 Error(s) found
Checking Miscellaneous Batches...
0 Error(s) found
Checking Balances and Transactions...
0 Error(s) found
Checking Reconciliation Totals...
0 Error(s) found
Checking History...
0 Error(s) found
5 Error(s) found in Cashbook 5.4A
5 Error(s) in Total (June 6, 2010 16:06:55)

 

[Jay Converse]

Your CBBTDT table is corrupt. Try a Pervasive Rebuild on it. If that doesn't work, restore from a good backup (which I doubt you have). It that doesn't work, replace it with a good empty copy, and live with the integrity errors.