dbcc checkdb failed - AITM table is corrupted

[Former Member]

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

Emanuele

[former_member192773 · Accepted solution]

Hello,

Create a backup of the database and use this test-database for trying to repair the database.

For example: [MSDN|http://msdn.microsoft.com/en-us/library/ms176064.aspx]

or [http://www.sqlhacks.com/FAQs/DBCC-REPAIR_ALLOW_DATA_LOSS]

Else contact SAP- support (again) for support or your channel manager

HTH Regards Teun

[Former Member · Accepted solution]

We solved the error repairing the database by the third party Stellar Phoenix SQL Recovery tool.

We also had to use another third free tool to copy all the encrypted stored procedure.

Last step was to add all the not-encrypted views.

Best regards

Emanuele

[marcozer · Accepted solution]

Hi Emanuele,

I'm in Italy and I'll be happy to send you my mail to dicuss about SAP B1 features, because is very difficult to find italian solution.

ciao.

[Former Member]

DBCC CHECKDB  command checks the physical as well as logical consistency of database pages allocation pages and other structure checks. If any of these checks fail, errors will be reported as part of the command. The main reason for the occurence of this error is corruption in SQL database, hardware failure etc. But with the help of SQL Server database recovery software you van perform the perfect SQL database recovery without any loss. Read More..... http://www.sqlrepairtool.org