cancel
Showing results for 
Search instead for 
Did you mean: 

DBCC CHECKTABLE Throwing Error

Former Member
0 Kudos

Dear Expert,

While executing

dbcc checktable('sm1.TBTCO') WITH ALL_ERRORMSGS, NO_INFOMSGS;

We are getting this following error

Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1838993978, index ID 1, partition ID 72057595857338368, alloc unit ID 72057595936440320 (type In-row data). Page (4:1571888) was not seen in the scan although its parent (3:1343710) and previous (1:1258069) refer to it. Check any previous errors.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1838993978, index ID 1, partition ID 72057595857338368, alloc unit ID 72057595936440320 (type In-row data). Page (4:1913622) is missing a reference from previous page (4:1571888). Possible chain linkage problem.
CHECKTABLE found 0 allocation errors and 2 consistency errors in table 'sm1.TBTCO' (object ID 1838993978).
repair_rebuild is the minimum repair level for the errors found by DBCC CHECKTABLE (SM1.sm1.TBTCO).

For the same reason we are getting ABAP dump with following information

Database error text........: "[601] Could not continue scan with NOLOCK due to

data movement."

Please advice me.

Regards,

Partha

Accepted Solutions (0)

Answers (1)

Answers (1)

markus_doehr2
Active Contributor
0 Kudos

I'd open an OSS call for this and let the support have a look on the system.

Markus