Skip to Content
Former Member
Feb 01, 2012 at 08:17 AM

dbcc checkdb failed - AITM table is corrupted


Dear all,

I have a serious problem with a database of an our customer.

dbcc checkdb command gave us an error.

AITM table is corrupted.

We cannot execute any command on it (Select, Update, Delete, ...)

We cannot delete it or drop and recreate it.

Db is now corrupted. No SAP B1 upgrade is possible anymore.

SAP Support suggest to copy all data from the old SAP database to a new one.

Does SAP has a procedure and/or scripts to do this action?

We haven't the exact structure of tables so it is not easy to develop a procedure of copy of data from databases.

At this moment we suppose:

01. we have to create a new SAP B1 database with no data

02. copy from the old database to the new one (We need this procedure)

Can someone help us, please?

This is the error we have executing dbcc checkdb:

Executing the query "DBCC CHECKDB(N'SBOBettini') WITH NO_INFOMSGS" failed with the following error: "An internal error occurred in DBCC that prevented further processing. Contact Customer Support Services.

System table pre-checks: Object ID 7. Could not read and latch page (1:3523) with latch type SH. Check statement terminated due to unrepairable error.

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 458752 (type Unknown), page (1:3523), row 13. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 43240 and 539.

CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object.

CHECKDB found 0 allocation errors and 1 consistency errors in database 'SBOBettini'.

repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (SBOBettini).". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Best regards