SQL Server Error

[Former Member]

After running dbcc checkdb (SA1) with no_infomsgs on SQL server, I'm getting following error:

Msg 8928, Level 16, State 1, Line 1

Object ID 223350464, index ID 0: Page (4:1477419) could not be processed. See other errors for details.

Msg 8939, Level 16, State 106, Line 1

Table error: Object ID 223350464, index ID 0, page (4:1477419). Test (m_freeCnt == freeCnt) failed. Values are 5290 and 5378.

Msg 8939, Level 16, State 108, Line 1

Table error: Object ID 223350464, index ID 0, page (4:1477419). Test (emptySlotCnt == 0) failed. Values are 2 and 0.

CHECKDB found 0 allocation errors and 3 consistency errors in table 'sa1.sap_perfinfo' (object ID 223350464).

CHECKDB found 0 allocation errors and 3 consistency errors in database 'SA1'.

repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (SA1 ).

[former_member184473]

Hi Alex,

As we can see in the log the three inconsistency errors on table sap_perfinfo are from one index. Try to recreat this index and check this table again.

>Msg 8928, Level 16, State 1, Line 1

>Object ID 223350464, index ID 0: Page (4:1477419) could not be processed. See other errors for details.

>Msg 8939, Level 16, State 106, Line 1

>Table error: Object ID 223350464, index ID 0, page (4:1477419). Test (m_freeCnt == freeCnt) failed. Values are 5290 and >5378.

>Msg 8939, Level 16, State 108, Line 1

>Table error: Object ID 223350464, index ID 0, page (4:1477419). Test (emptySlotCnt == 0) failed. Values are 2 and 0.

Regards,

Eduardo Rezende

[former_member189546]

Hello,

Also check note

142731 - DBCC checks of SQL server

regards,

John Feely

[markus_doehr2]

> Table error: Object ID 223350464, index ID 0, page (4:1477419). Test (emptySlotCnt == 0) failed. Values are 2 and 0.

> CHECKDB found 0 allocation errors and 3 consistency errors in table 'sa1.sap_perfinfo' (object ID 223350464).

> CHECKDB found 0 allocation errors and 3 consistency errors in database 'SA1'.

> repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (SA1 ).

I suggest you open an OSS call quickly and let the support check the corruption.

Markus