Search

Thursday, November 22, 2012

Msg 8992, Level 16, State 1, Line 1

Today I had got the some error in a database. I ran DBCC CheckDB and found below errors:


DBCC results for 'Data'.
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=399091823) of row (object_id=399091823,column_id=11) in sys.columns does not have a matching row (object_id=399091823) in sys.objects.
CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object.
DBCC results for 'sys.sysrowsetcolumns'.
There are 4119 rows in 34 pages for object "sys.sysrowsetcolumns".
DBCC results for 'sys.sysrowsets'.
There are 480 rows in 7 pages for object "sys.sysrowsets".
DBCC results for 'sysallocunits'.
There are 515 rows in 13 pages for object "sysallocunits".
DBCC results for 'sys.sysfiles1'.
There are 2 rows in 1 pages for object "sys.sysfiles1".
DBCC results for 'sys.syshobtcolumns'.
There are 4119 rows in 40 pages for object "sys.syshobtcolumns".
DBCC results for 'sys.syshobts'.
There are 480 rows in 7 pages for object "sys.syshobts".
DBCC results for 'sys.sysftinds'.
There are 0 rows in 0 pages for object "sys.sysftinds".
DBCC results for 'sys.sysserefs'.
There are 515 rows in 6 pages for object "sys.sysserefs".
DBCC results for 'sys.sysowners'.
There are 14 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysprivs'.
There are 134 rows in 1 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 3337 rows in 69 pages for object "sys.sysschobjs".
DBCC results for 'sys.syscolpars'.
Msg 2511, Level 16, State 2, Line 1
Table error: Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data). Keys out of order on page (1:565), slots 9 and 10.
There are 3866 rows in 99 pages for object "sys.syscolpars".
CHECKDB found 0 allocation errors and 1 consistency errors in table 'sys.syscolpars' (object ID 41).
DBCC results for 'sys.sysnsobjs'.
There are 1 rows in 1 pages for object "sys.sysnsobjs".
DBCC results for 'sys.syscerts'.
There are 0 rows in 0 pages for object "sys.syscerts".
DBCC results for 'sys.sysxprops'.
There are 28 rows in 13 pages for object "sys.sysxprops".
DBCC results for 'sys.sysscalartypes'.
There are 27 rows in 1 pages for object "sys.sysscalartypes".
DBCC results for 'sys.systypedsubobjs'.
There are 0 rows in 0 pages for object "sys.systypedsubobjs".
DBCC results for 'sys.sysidxstats'.
There are 1878 rows in 52 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 2117 rows in 14 pages for object "sys.sysiscols".
DBCC results for 'sys.sysbinobjs'.
There are 23 rows in 1 pages for object "sys.sysbinobjs".
DBCC results for 'sys.sysobjvalues'.
There are 4438 rows in 725 pages for object "sys.sysobjvalues".
DBCC results for 'sys.sysclsobjs'.
There are 17 rows in 1 pages for object "sys.sysclsobjs".
DBCC results for 'sys.sysrowsetrefs'.
There are 0 rows in 0 pages for object "sys.sysrowsetrefs".
DBCC results for 'sys.sysremsvcbinds'.
There are 0 rows in 0 pages for object "sys.sysremsvcbinds".
DBCC results for 'sys.sysxmitqueue'.
There are 0 rows in 0 pages for object "sys.sysxmitqueue".
DBCC results for 'sys.sysrts'.
There are 1 rows in 1 pages for object "sys.sysrts".
DBCC results for 'sys.sysconvgroup'.
There are 0 rows in 0 pages for object "sys.sysconvgroup".
DBCC results for 'sys.sysdesend'.
There are 0 rows in 0 pages for object "sys.sysdesend".
DBCC results for 'sys.sysdercv'.
There are 0 rows in 0 pages for object "sys.sysdercv".
DBCC results for 'sys.syssingleobjrefs'.
There are 1861 rows in 15 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 1135 rows in 21 pages for object "sys.sysmultiobjrefs".
DBCC results for 'sys.sysdbfiles'.
There are 2 rows in 1 pages for object "sys.sysdbfiles".
DBCC results for 'sys.sysguidrefs'.
There are 3 rows in 1 pages for object "sys.sysguidrefs".
DBCC results for 'sys.sysqnames'.
There are 96 rows in 1 pages for object "sys.sysqnames".
DBCC results for 'sys.sysxmlcomponent'.
There are 93 rows in 1 pages for object "sys.sysxmlcomponent".
DBCC results for 'sys.sysxmlfacet'.
There are 97 rows in 1 pages for object "sys.sysxmlfacet".
DBCC results for 'sys.sysxmlplacement'.
There are 17 rows in 1 pages for object "sys.sysxmlplacement".
DBCC results for 'sys.sysobjkeycrypts'.
There are 0 rows in 0 pages for object "sys.sysobjkeycrypts".
DBCC results for 'sys.sysasymkeys'.
There are 0 rows in 0 pages for object "sys.sysasymkeys".
DBCC results for 'sys.syssqlguides'.
There are 0 rows in 0 pages for object "sys.syssqlguides".
DBCC results for 'sys.sysbinsubobjs'.
There are 0 rows in 0 pages for object "sys.sysbinsubobjs".
Msg 8914, Level 16, State 1, Line 1
Incorrect PFS free space information for page (1:1332) in object ID 1712985429, index ID 1, partition ID 72057594446741504, alloc unit ID 72057594164084736 (type LOB data). Expected value   0_PCT_FULL, actual value 100_PCT_FULL.
Msg 8914, Level 16, State 1, Line 1
Incorrect PFS free space information for page (1:1333) in object ID 1712985429, index ID 1, partition ID 72057594446741504, alloc unit ID 72057594164084736 (type LOB data). Expected value   0_PCT_FULL, actual value 100_PCT_FULL.
Msg 8914, Level 16, State 1, Line 1
Incorrect PFS free space information for page (1:1334) in object ID 1712985429, index ID 1, partition ID 72057594446741504, alloc unit ID 72057594164084736 (type LOB data). Expected value   0_PCT_FULL, actual value 100_PCT_FULL.
Msg 8914, Level 16, State 1, Line 1
Incorrect PFS free space information for page (1:1335) in object ID 1712985429, index ID 1, partition ID 72057594446741504, alloc unit ID 72057594164084736 (type LOB data). Expected value   0_PCT_FULL, actual value 100_PCT_FULL.

CHECKDB found 0 allocation errors and 6 consistency errors in database 'Data'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Here check DB found consistency errors on multiple system tables in user database. Unlike the report, which we generally see after running DBCC checkdb, this report didn’t show like
‘repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB’
or
‘repair_fast is the minimum repair level for the errors found by DBCC CHECKDB’
or
‘repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB’
None of the above solved the errors. Than I created a blank database and exported all database objects with data from old Database to the newly created database. 

22 comments:

  1. i have the same issue.....

    help please.

    ReplyDelete
    Replies
    1. Create a blank database and move all objects from old database to new database.

      Delete
  2. How did you copy all the objects, did you use ssis?

    ReplyDelete
  3. How did you copy all the objects, did you use ssis?

    ReplyDelete
    Replies
    1. No, I use SQL Server Import Export Wizard (SQL Server Native Client) for Exporting and Importing Data.

      Delete