on 02-17-2010 7:24 AM
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
I'd open an OSS call for this and let the support have a look on the system.
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
9 | |
9 | |
6 | |
6 | |
6 | |
5 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.