DBCC DBCHECK errors - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

DBCC DBCHECK errors

Author

Topic

mahajanakhil1985
Yak Posting Veteran

71 Posts

Posted - 2010-08-11 : 05:55:48

The following error was seen in Event log:

Event :

Log Name: Application
Source: MSSQLSERVER
Date: 8/10/2010 1:09:19 AM
Event ID: 9100
Task Category: (2)
Level: Error
Keywords: Classic
User: JOURNALMTL\_SVC-SQL02
Computer: JM1DISSAWI0066.journalmtl.com
Description:
Possible index corruption detected. Run DBCC CHECKDB.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MSSQLSERVER" />
<EventID Qualifiers="49152">9100</EventID>
<Level>2</Level>
<Task>2</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2010-08-10T05:09:19.000Z" />
<EventRecordID>2378224</EventRecordID>
<Channel>Application</Channel>
<Computer>JM1DISSAWI0066.journalmtl.com</Computer>
<Security UserID="S-1-5-21-700139034-744305528-622611216-12066" />
</System>
<EventData>

<Binary>8C23000017000000090000004A004D003100530051004C0030003200000005000000
51005000530038000000</Binary>
</EventData>
</Event>

Afterwards, the DBCC DBCHECK shows the following error:

DBCC results for 'QPS8.QPP_STATUS_REDLINES'.
There are 0 rows in 0 pages for object "QPS8.QPP_STATUS_REDLINES".
DBCC results for 'QPS8.QPP_ASSETS'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_ASSETS' (ID 85575343). Data row does not have a
matching index row in the index 'FK_USRDET_AST_LSTMOD' (ID 13). Possible
missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:26248:7) identified by (ID = 14233) with index values
'LAST_MODIFIER = 49 and ID = 14233'.
Msg 8952, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_ASSETS' (ID 85575343). Index row in index
'FK_USRDET_AST_LSTMOD' (ID 13) does not match any data row. Possible extra
or invalid keys for:
Msg 8956, Level 16, State 1, Line 1
Index row (4:6126:71) with values (LAST_MODIFIER = 172 and ID = 14233)
pointing to the data row identified by (ID = 14233).
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_ASSETS' (ID 85575343). Data row does not have a
matching index row in the index 'FK_USRDET_AST_LSCOUPBY' (ID 15). Possible
missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:26248:7) identified by (ID = 14233) with index values
'LAST_CONTENT_UPDATED_BY = 49 and ID = 14233'.
Msg 8952, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_ASSETS' (ID 85575343). Index row in index
'FK_USRDET_AST_LSCOUPBY' (ID 15) does not match any data row. Possible extra
or invalid keys for:
Msg 8956, Level 16, State 1, Line 1
Index row (4:701:87) with values (LAST_CONTENT_UPDATED_BY = 172 and ID =
14233) pointing to the data row identified by (ID = 14233).
There are 6287 rows in 1149 pages for object "QPS8.QPP_ASSETS".
CHECKDB found 0 allocation errors and 4 consistency errors in table
'QPS8.QPP_ASSETS' (object ID 85575343).

.......... and many more errors.

Could anybody please suggest me the remedy? I am not sure if rebuilding the indexes could resolve it.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-08-11 : 07:26:24

Please run the following and post the full and complete output. I can't advise you on how to resolve this without seeing all the errors.

DBCC CheckDB (<Database Name>) WITH No_INFOMSGS, ALL_ERRORMSGS

Do you have a clean backup of this database? (A backup from before the corruption occurred)

--
Gail Shaw
SQL Server MVP

mahajanakhil1985
Yak Posting Veteran

71 Posts

Posted - 2010-08-11 : 07:44:08

Thanks Gail!

I am an Oracle guy, so don't know much about SQL Server. Will running BCC CheckDB (<Database Name>) WITH No_INFOMSGS, ALL_ERRORMSGS affect the database (any data loss or any other changes) in any way or will it generate only a report from the database?

Is the database corrupted?

I have the full report generated by an IT guy which is:

Event :

Log Name: Application
Source: MSSQLSERVER
Date: 8/10/2010 1:09:19 AM
Event ID: 9100
Task Category: (2)
Level: Error
Keywords: Classic
User: JOURNALMTL\_SVC-SQL02
Computer: JM1DISSAWI0066.journalmtl.com
Description:
Possible index corruption detected. Run DBCC CHECKDB.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MSSQLSERVER" />
<EventID Qualifiers="49152">9100</EventID>
<Level>2</Level>
<Task>2</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2010-08-10T05:09:19.000Z" />
<EventRecordID>2378224</EventRecordID>
<Channel>Application</Channel>
<Computer>JM1DISSAWI0066.journalmtl.com</Computer>
<Security UserID="S-1-5-21-700139034-744305528-622611216-12066" />
</System>
<EventData>

<Binary>8C23000017000000090000004A004D003100530051004C0030003200000005000000
51005000530038000000</Binary>
</EventData>
</Event>

_________________________________________

DBCC results for 'QPS8'.
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.
DBCC results for 'sys.sysrowsetcolumns'.
There are 1964 rows in 14 pages for object "sys.sysrowsetcolumns".
DBCC results for 'sys.sysrowsets'.
There are 423 rows in 3 pages for object "sys.sysrowsets".
DBCC results for 'sysallocunits'.
There are 458 rows in 5 pages for object "sysallocunits".
DBCC results for 'sys.sysfiles1'.
There are 5 rows in 1 pages for object "sys.sysfiles1".
DBCC results for 'sys.syshobtcolumns'.
There are 1964 rows in 15 pages for object "sys.syshobtcolumns".
DBCC results for 'sys.syshobts'.
There are 423 rows in 3 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 458 rows in 4 pages for object "sys.sysserefs".
DBCC results for 'sys.sysowners'.
There are 16 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysprivs'.
There are 136 rows in 1 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 572 rows in 8 pages for object "sys.sysschobjs".
DBCC results for 'sys.syscolpars'.
There are 1252 rows in 23 pages for object "sys.syscolpars".
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 9 rows in 1 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 622 rows in 10 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 851 rows in 5 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 757 rows in 239 pages for object "sys.sysobjvalues".
DBCC results for 'sys.sysclsobjs'.
There are 18 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 737 rows in 5 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 253 rows in 1 pages for object "sys.sysmultiobjrefs".
DBCC results for 'sys.sysdbfiles'.
There are 5 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 91 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".
DBCC results for 'QPS8.QPP_FILE_TYPES'.
There are 0 rows in 0 pages for object "QPS8.QPP_FILE_TYPES".
DBCC results for 'QPS8.QPP_STATUS_REDLINES'.
There are 0 rows in 0 pages for object "QPS8.QPP_STATUS_REDLINES".
DBCC results for 'QPS8.QPP_ASSETS'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_ASSETS' (ID 85575343). Data row does not have a
matching index row in the index 'FK_USRDET_AST_LSTMOD' (ID 13). Possible
missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:26248:7) identified by (ID = 14233) with index values
'LAST_MODIFIER = 49 and ID = 14233'.
Msg 8952, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_ASSETS' (ID 85575343). Index row in index
'FK_USRDET_AST_LSTMOD' (ID 13) does not match any data row. Possible extra
or invalid keys for:
Msg 8956, Level 16, State 1, Line 1
Index row (4:6126:71) with values (LAST_MODIFIER = 172 and ID = 14233)
pointing to the data row identified by (ID = 14233).
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_ASSETS' (ID 85575343). Data row does not have a
matching index row in the index 'FK_USRDET_AST_LSCOUPBY' (ID 15). Possible
missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:26248:7) identified by (ID = 14233) with index values
'LAST_CONTENT_UPDATED_BY = 49 and ID = 14233'.
Msg 8952, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_ASSETS' (ID 85575343). Index row in index
'FK_USRDET_AST_LSCOUPBY' (ID 15) does not match any data row. Possible extra
or invalid keys for:
Msg 8956, Level 16, State 1, Line 1
Index row (4:701:87) with values (LAST_CONTENT_UPDATED_BY = 172 and ID =
14233) pointing to the data row identified by (ID = 14233).
There are 6287 rows in 1149 pages for object "QPS8.QPP_ASSETS".
CHECKDB found 0 allocation errors and 4 consistency errors in table
'QPS8.QPP_ASSETS' (object ID 85575343).
DBCC results for 'QPS8.QPP_JOJ_RULE_EVALUATIONS'.
There are 50 rows in 3 pages for object "QPS8.QPP_JOJ_RULE_EVALUATIONS".
DBCC results for 'QPS8.QPP_STATUS_ROUTINGS'.
There are 229 rows in 2 pages for object "QPS8.QPP_STATUS_ROUTINGS".
DBCC results for 'QPS8.QPP_TABLE_SEQUENCES'.
There are 29 rows in 1 pages for object "QPS8.QPP_TABLE_SEQUENCES".
DBCC results for 'QPS8.QPP_SCRIPTS'.
There are 0 rows in 0 pages for object "QPS8.QPP_SCRIPTS".
DBCC results for 'QPS8.QPP_ATT_DEL_ASSETS'.
There are 562 rows in 12 pages for object "QPS8.QPP_ATT_DEL_ASSETS".
DBCC results for 'QPS8.QPP_TRUSTEE_DEFINITIONS'.
There are 280 rows in 3 pages for object "QPS8.QPP_TRUSTEE_DEFINITIONS".
DBCC results for 'QPS8.QPP_ASSET_VERSIONS'.
Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 229575856, index ID 1, partition ID
72057594038910976, alloc unit ID 72057594042974208 (type In-row data).
B-tree chain linkage mismatch. (4:37182)->next = (4:17341), but
(4:17341)->Prev = (4:2002).
Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 229575856, index ID 1, partition ID
72057594038910976, alloc unit ID 72057594042974208 (type In-row data).
Parent node for page (4:37182) was not encountered.
There are 33743 rows in 6134 pages for object "QPS8.QPP_ASSET_VERSIONS".
CHECKDB found 0 allocation errors and 2 consistency errors in table
'QPS8.QPP_ASSET_VERSIONS' (object ID 229575856).
DBCC results for 'QPS8.QPP_SCHEDULES'.
There are 0 rows in 0 pages for object "QPS8.QPP_SCHEDULES".
DBCC results for 'QPS8.QPP_ASSET_ATTR_IPTC_VALUES'.
There are 16 rows in 1 pages for object "QPS8.QPP_ASSET_ATTR_IPTC_VALUES".
DBCC results for 'QPS8.QPP_USER_DETAILS'.
There are 261 rows in 5 pages for object "QPS8.QPP_USER_DETAILS".
DBCC results for 'QPS8.QPP_ASSETS_TEMP'.
There are 0 rows in 1 pages for object "QPS8.QPP_ASSETS_TEMP".
DBCC results for 'QPS8.QPP_AST_ATTR_IPTC_VAL_VERSIONS'.
There are 1 rows in 1 pages for object
"QPS8.QPP_AST_ATTR_IPTC_VAL_VERSIONS".
DBCC results for 'QPS8.QPP_COMPONENT_CATEGORIES'.
There are 3 rows in 1 pages for object "QPS8.QPP_COMPONENT_CATEGORIES".
DBCC results for 'QPS8.QPP_USERCLASS_DEFINITIONS'.
There are 12 rows in 1 pages for object "QPS8.QPP_USERCLASS_DEFINITIONS".
DBCC results for 'QPS8.QPP_ENTITY_CATEGORIES'.
There are 8 rows in 1 pages for object "QPS8.QPP_ENTITY_CATEGORIES".
DBCC results for 'QPS8.QPP_REVISION_CONTROLS'.
There are 4 rows in 1 pages for object "QPS8.QPP_REVISION_CONTROLS".
DBCC results for 'QPS8.QPP_ASSET_ATTR_CHKBOX_VALUES'.
There are 6096 rows in 41 pages for object
"QPS8.QPP_ASSET_ATTR_CHKBOX_VALUES".
DBCC results for 'QPS8.QPP_ASSET_ATTR_DATE_VALUES'.
There are 6265 rows in 80 pages for object
"QPS8.QPP_ASSET_ATTR_DATE_VALUES".
DBCC results for 'QPS8.QPP_ASSET_ATTR_DOMAIN_VALUES'.
There are 0 rows in 1 pages for object "QPS8.QPP_ASSET_ATTR_DOMAIN_VALUES".
DBCC results for 'QPS8.QPP_QUERY_DEFINITIONS'.
There are 195 rows in 2 pages for object "QPS8.QPP_QUERY_DEFINITIONS".
DBCC results for 'QPS8.QPP_ASSET_ATTR_NUM_VALUES'.
There are 0 rows in 0 pages for object "QPS8.QPP_ASSET_ATTR_NUM_VALUES".
DBCC results for 'QPS8.QPP_ASSET_ATTR_TEXT_VALUES'.
There are 4936 rows in 70 pages for object
"QPS8.QPP_ASSET_ATTR_TEXT_VALUES".
DBCC results for 'QPS8.QPP_QUERY_ASSIGNMENTS'.
There are 981 rows in 7 pages for object "QPS8.QPP_QUERY_ASSIGNMENTS".
DBCC results for 'QPS8.QPP_AST_ATTR_CHK_VAL_VERSIONS'.
Msg 8952, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_AST_ATTR_CHK_VAL_VERSIONS' (ID 613577224).
Index row in index 'FK_ATTDEF_ASATCHVALV' (ID 2) does not match any data
row. Possible extra or invalid keys for:
Msg 8956, Level 16, State 1, Line 1
Index row (4:15290:71) with values (ATTRIBUTE_ID = 512 and ASSET_ID = 11236
and VERSION_NUMBER = 3) pointing to the data row identified by (ATTRIBUTE_ID
= 512 and ASSET_ID = 11236 and VERSION_NUMBER = 3).
Msg 8952, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_AST_ATTR_CHK_VAL_VERSIONS' (ID 613577224).
Index row in index 'FK_ATTDEF_ASATCHVALV' (ID 2) does not match any data
row. Possible extra or invalid keys for:
Msg 8956, Level 16, State 1, Line 1
Index row (4:15290:74) with values (ATTRIBUTE_ID = 512 and ASSET_ID = 11237
and VERSION_NUMBER = 3) pointing to the data row identified by (ATTRIBUTE_ID
= 512 and ASSET_ID = 11237 and VERSION_NUMBER = 3).
Msg 8952, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_AST_ATTR_CHK_VAL_VERSIONS' (ID 613577224).
Index row in index 'FK_ATTDEF_ASATCHVALV' (ID 2) does not match any data
row. Possible extra or invalid keys for:
Msg 8956, Level 16, State 1, Line 1
Index row (4:15290:77) with values (ATTRIBUTE_ID = 512 and ASSET_ID = 11238
and VERSION_NUMBER = 3) pointing to the data row identified by (ATTRIBUTE_ID
= 512 and ASSET_ID = 11238 and VERSION_NUMBER = 3).
Msg 8952, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_AST_ATTR_CHK_VAL_VERSIONS' (ID 613577224).
Index row in index 'FK_ATTDEF_ASATCHVALV' (ID 2) does not match any data
row. Possible extra or invalid keys for:
Msg 8956, Level 16, State 1, Line 1
Index row (4:15290:80) with values (ATTRIBUTE_ID = 512 and ASSET_ID = 11239
and VERSION_NUMBER = 3) pointing to the data row identified by (ATTRIBUTE_ID
= 512 and ASSET_ID = 11239 and VERSION_NUMBER = 3).
Msg 8952, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_AST_ATTR_CHK_VAL_VERSIONS' (ID 613577224).
Index row in index 'FK_ATTDEF_ASATCHVALV' (ID 2) does not match any data
row. Possible extra or invalid keys for:
Msg 8956, Level 16, State 1, Line 1
Index row (4:15290:83) with values (ATTRIBUTE_ID = 512 and ASSET_ID = 11240
and VERSION_NUMBER = 3) pointing to the data row identified by (ATTRIBUTE_ID
= 512 and ASSET_ID = 11240 and VERSION_NUMBER = 3).
Msg 8952, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_AST_ATTR_CHK_VAL_VERSIONS' (ID 613577224).
Index row in index 'FK_ATTDEF_ASATCHVALV' (ID 2) does not match any data
row. Possible extra or invalid keys for:
Msg 8956, Level 16, State 1, Line 1
Index row (4:15290:86) with values (ATTRIBUTE_ID = 512 and ASSET_ID = 11241
and VERSION_NUMBER = 3) pointing to the data row identified by (ATTRIBUTE_ID
= 512 and ASSET_ID = 11241 and VERSION_NUMBER = 3).
Msg 8952, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_AST_ATTR_CHK_VAL_VERSIONS' (ID 613577224).
Index row in index 'FK_ASSETV_ASATCHVALV' (ID 3) does not match any data
row. Possible extra or invalid keys for:
Msg 8956, Level 16, State 1, Line 1
Index row (4:9337:29) with values (ASSET_ID = 11236 and VERSION_NUMBER = 3
and ATTRIBUTE_ID = 512) pointing to the data row identified by (ATTRIBUTE_ID
= 512 and ASSET_ID = 11236 and VERSION_NUMBER = 3).
Msg 8952, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_AST_ATTR_CHK_VAL_VERSIONS' (ID 613577224).
Index row in index 'FK_ASSETV_ASATCHVALV' (ID 3) does not match any data
row. Possible extra or invalid keys for:
Msg 8956, Level 16, State 1, Line 1
Index row (4:9337:35) with values (ASSET_ID = 11237 and VERSION_NUMBER = 3
and ATTRIBUTE_ID = 512) pointing to the data row identified by (ATTRIBUTE_ID
= 512 and ASSET_ID = 11237 and VERSION_NUMBER = 3).
Msg 8952, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_AST_ATTR_CHK_VAL_VERSIONS' (ID 613577224).
Index row in index 'FK_ASSETV_ASATCHVALV' (ID 3) does not match any data
row. Possible extra or invalid keys for:
Msg 8956, Level 16, State 1, Line 1
Index row (4:9337:41) with values (ASSET_ID = 11238 and VERSION_NUMBER = 3
and ATTRIBUTE_ID = 512) pointing to the data row identified by (ATTRIBUTE_ID
= 512 and ASSET_ID = 11238 and VERSION_NUMBER = 3).
Msg 8952, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_AST_ATTR_CHK_VAL_VERSIONS' (ID 613577224).
Index row in index 'FK_ASSETV_ASATCHVALV' (ID 3) does not match any data
row. Possible extra or invalid keys for:
Msg 8956, Level 16, State 1, Line 1
Index row (4:9337:47) with values (ASSET_ID = 11239 and VERSION_NUMBER = 3
and ATTRIBUTE_ID = 512) pointing to the data row identified by (ATTRIBUTE_ID
= 512 and ASSET_ID = 11239 and VERSION_NUMBER = 3).
Msg 8952, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_AST_ATTR_CHK_VAL_VERSIONS' (ID 613577224).
Index row in index 'FK_ASSETV_ASATCHVALV' (ID 3) does not match any data
row. Possible extra or invalid keys for:
Msg 8956, Level 16, State 1, Line 1
Index row (4:9337:53) with values (ASSET_ID = 11240 and VERSION_NUMBER = 3
and ATTRIBUTE_ID = 512) pointing to the data row identified by (ATTRIBUTE_ID
= 512 and ASSET_ID = 11240 and VERSION_NUMBER = 3).
Msg 8952, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_AST_ATTR_CHK_VAL_VERSIONS' (ID 613577224).
Index row in index 'FK_ASSETV_ASATCHVALV' (ID 3) does not match any data
row. Possible extra or invalid keys for:
Msg 8956, Level 16, State 1, Line 1
Index row (4:9337:59) with values (ASSET_ID = 11241 and VERSION_NUMBER = 3
and ATTRIBUTE_ID = 512) pointing to the data row identified by (ATTRIBUTE_ID
= 512 and ASSET_ID = 11241 and VERSION_NUMBER = 3).
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_AST_ATTR_CHK_VAL_VERSIONS' (ID 613577224). Data
row does not have a matching index row in the index 'IDX_ASATCHVALV_VAL' (ID
4). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:1623:17) identified by (ATTRIBUTE_ID = 514 and ASSET_ID = 5616
and VERSION_NUMBER = 2) with index values 'VALUE = 0 and ATTRIBUTE_ID = 514
and ASSET_ID = 5616 and VERSION_NUMBER = 2'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_AST_ATTR_CHK_VAL_VERSIONS' (ID 613577224). Data
row does not have a matching index row in the index 'IDX_ASATCHVALV_VAL' (ID
4). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:26840:43) identified by (ATTRIBUTE_ID = 514 and ASSET_ID = 14233
and VERSION_NUMBER = 1) with index values 'VALUE = 0 and ATTRIBUTE_ID = 514
and ASSET_ID = 14233 and VERSION_NUMBER = 1'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_AST_ATTR_CHK_VAL_VERSIONS' (ID 613577224). Data
row does not have a matching index row in the index 'IDX_ASATCHVALV_VAL' (ID
4). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:26840:45) identified by (ATTRIBUTE_ID = 514 and ASSET_ID = 14234
and VERSION_NUMBER = 2) with index values 'VALUE = 0 and ATTRIBUTE_ID = 514
and ASSET_ID = 14234 and VERSION_NUMBER = 2'.
Msg 8952, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_AST_ATTR_CHK_VAL_VERSIONS' (ID 613577224).
Index row in index 'IDX_ASATCHVALV_VAL' (ID 4) does not match any data row.
Possible extra or invalid keys for:
Msg 8956, Level 16, State 1, Line 1
Index row (4:6063:19) with values (VALUE = 0 and ATTRIBUTE_ID = 512 and
ASSET_ID = 11236 and VERSION_NUMBER = 3) pointing to the data row identified
by (ATTRIBUTE_ID = 512 and ASSET_ID = 11236 and VERSION_NUMBER = 3).
Msg 8952, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_AST_ATTR_CHK_VAL_VERSIONS' (ID 613577224).
Index row in index 'IDX_ASATCHVALV_VAL' (ID 4) does not match any data row.
Possible extra or invalid keys for:
Msg 8956, Level 16, State 1, Line 1
Index row (4:6063:22) with values (VALUE = 0 and ATTRIBUTE_ID = 512 and
ASSET_ID = 11237 and VERSION_NUMBER = 3) pointing to the data row identified
by (ATTRIBUTE_ID = 512 and ASSET_ID = 11237 and VERSION_NUMBER = 3).
Msg 8952, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_AST_ATTR_CHK_VAL_VERSIONS' (ID 613577224).
Index row in index 'IDX_ASATCHVALV_VAL' (ID 4) does not match any data row.
Possible extra or invalid keys for:
Msg 8956, Level 16, State 1, Line 1
Index row (4:6063:25) with values (VALUE = 0 and ATTRIBUTE_ID = 512 and
ASSET_ID = 11238 and VERSION_NUMBER = 3) pointing to the data row identified
by (ATTRIBUTE_ID = 512 and ASSET_ID = 11238 and VERSION_NUMBER = 3).
Msg 8952, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_AST_ATTR_CHK_VAL_VERSIONS' (ID 613577224).
Index row in index 'IDX_ASATCHVALV_VAL' (ID 4) does not match any data row.
Possible extra or invalid keys for:
Msg 8956, Level 16, State 1, Line 1
Index row (4:6063:28) with values (VALUE = 0 and ATTRIBUTE_ID = 512 and
ASSET_ID = 11239 and VERSION_NUMBER = 3) pointing to the data row identified
by (ATTRIBUTE_ID = 512 and ASSET_ID = 11239 and VERSION_NUMBER = 3).
Msg 8952, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_AST_ATTR_CHK_VAL_VERSIONS' (ID 613577224).
Index row in index 'IDX_ASATCHVALV_VAL' (ID 4) does not match any data row.
Possible extra or invalid keys for:
Msg 8956, Level 16, State 1, Line 1
Index row (4:6063:31) with values (VALUE = 0 and ATTRIBUTE_ID = 512 and
ASSET_ID = 11240 and VERSION_NUMBER = 3) pointing to the data row identified
by (ATTRIBUTE_ID = 512 and ASSET_ID = 11240 and VERSION_NUMBER = 3).
Msg 8952, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_AST_ATTR_CHK_VAL_VERSIONS' (ID 613577224).
Index row in index 'IDX_ASATCHVALV_VAL' (ID 4) does not match any data row.
Possible extra or invalid keys for:
Msg 8956, Level 16, State 1, Line 1
Index row (4:6063:34) with values (VALUE = 0 and ATTRIBUTE_ID = 512 and
ASSET_ID = 11241 and VERSION_NUMBER = 3) pointing to the data row identified
by (ATTRIBUTE_ID = 512 and ASSET_ID = 11241 and VERSION_NUMBER = 3).
There are 23224 rows in 236 pages for object
"QPS8.QPP_AST_ATTR_CHK_VAL_VERSIONS".
CHECKDB found 0 allocation errors and 21 consistency errors in table
'QPS8.QPP_AST_ATTR_CHK_VAL_VERSIONS' (object ID 613577224).
DBCC results for 'QPS8.QPP_QUERY_CONDITIONS'.
Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 642101328, index ID 3, partition ID
72057594049986560, alloc unit ID 72057594054901760 (type In-row data).
Parent node for page (4:2509) was not encountered.
Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 642101328, index ID 3, partition ID
72057594049986560, alloc unit ID 72057594054901760 (type In-row data). The
high key value on page (4:41266) (level 0) is not less than the low key
value in the parent (0:1), slot 0 of the next page (4:2509).
There are 554 rows in 14 pages for object "QPS8.QPP_QUERY_CONDITIONS".
CHECKDB found 0 allocation errors and 2 consistency errors in table
'QPS8.QPP_QUERY_CONDITIONS' (object ID 642101328).
DBCC results for 'QPS8.QPP_AST_ATTR_DATE_VAL_VERSIONS'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_AST_ATTR_DATE_VAL_VERSIONS' (ID 645577338).
Data row does not have a matching index row in the index
'FK_ATTDEF_ASATDAVALV' (ID 2). Possible missing or invalid keys for the
index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:25957:24) identified by (ATTRIBUTE_ID = 501 and ASSET_ID = 14233
and VERSION_NUMBER = 1) with index values 'ATTRIBUTE_ID = 501 and ASSET_ID =
14233 and VERSION_NUMBER = 1'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_AST_ATTR_DATE_VAL_VERSIONS' (ID 645577338).
Data row does not have a matching index row in the index
'FK_ATTDEF_ASATDAVALV' (ID 2). Possible missing or invalid keys for the
index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:25957:26) identified by (ATTRIBUTE_ID = 501 and ASSET_ID = 14234
and VERSION_NUMBER = 2) with index values 'ATTRIBUTE_ID = 501 and ASSET_ID =
14234 and VERSION_NUMBER = 2'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_AST_ATTR_DATE_VAL_VERSIONS' (ID 645577338).
Data row does not have a matching index row in the index
'FK_ASSETV_ASATDAVALV' (ID 3). Possible missing or invalid keys for the
index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:25957:24) identified by (ATTRIBUTE_ID = 501 and ASSET_ID = 14233
and VERSION_NUMBER = 1) with index values 'ASSET_ID = 14233 and
VERSION_NUMBER = 1 and ATTRIBUTE_ID = 501'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_AST_ATTR_DATE_VAL_VERSIONS' (ID 645577338).
Data row does not have a matching index row in the index
'FK_ASSETV_ASATDAVALV' (ID 3). Possible missing or invalid keys for the
index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:25957:26) identified by (ATTRIBUTE_ID = 501 and ASSET_ID = 14234
and VERSION_NUMBER = 2) with index values 'ASSET_ID = 14234 and
VERSION_NUMBER = 2 and ATTRIBUTE_ID = 501'.
There are 33847 rows in 411 pages for object
"QPS8.QPP_AST_ATTR_DATE_VAL_VERSIONS".
CHECKDB found 0 allocation errors and 4 consistency errors in table
'QPS8.QPP_AST_ATTR_DATE_VAL_VERSIONS' (object ID 645577338).
DBCC results for 'QPS8.QPP_AST_ATTR_DOM_VAL_VERSIONS'.
There are 0 rows in 1 pages for object "QPS8.QPP_AST_ATTR_DOM_VAL_VERSIONS".
DBCC results for 'QPS8.QPP_AST_ATTR_NUM_VAL_VERSIONS'.
There are 0 rows in 0 pages for object "QPS8.QPP_AST_ATTR_NUM_VAL_VERSIONS".
DBCC results for 'QPS8.QPP_QUERY_SORTINGS'.
There are 1112 rows in 86 pages for object "QPS8.QPP_QUERY_SORTINGS".
DBCC results for 'QPS8.QPP_AST_ATTR_TXT_VAL_VERSIONS'.
There are 28577 rows in 310 pages for object
"QPS8.QPP_AST_ATTR_TXT_VAL_VERSIONS".
DBCC results for 'QPS8.QPP_COMPONENT_ATTR_VALUES'.
There are 0 rows in 0 pages for object "QPS8.QPP_COMPONENT_ATTR_VALUES".
DBCC results for 'QPS8.QPP_QUERY_GROUPINGS'.
There are 237 rows in 2 pages for object "QPS8.QPP_QUERY_GROUPINGS".
DBCC results for 'QPS8.QPP_COMP_ATTR_VAL_VERSIONS'.
There are 0 rows in 0 pages for object "QPS8.QPP_COMP_ATTR_VAL_VERSIONS".
DBCC results for 'QPS8.QPP_ATTRIBUTE_CONSTRAINTS'.
There are 720 rows in 6 pages for object "QPS8.QPP_ATTRIBUTE_CONSTRAINTS".
DBCC results for 'QPS8.QPP_QUERY_MODES'.
There are 839 rows in 7 pages for object "QPS8.QPP_QUERY_MODES".
DBCC results for 'QPS8.QPP_ATTRIBUTE_DEFINITIONS'.
There are 102 rows in 3 pages for object "QPS8.QPP_ATTRIBUTE_DEFINITIONS".
DBCC results for 'QPS8.QPP_QUERY_DISPLAY_SETTINGS'.
There are 6089 rows in 641 pages for object
"QPS8.QPP_QUERY_DISPLAY_SETTINGS".
DBCC results for 'QPS8.QPP_ASSET_REPOSITORY_TYPES'.
There are 2 rows in 1 pages for object "QPS8.QPP_ASSET_REPOSITORY_TYPES".
DBCC results for 'QPS8.QPP_PROJ_DOC_RELATIONS_V'.
There are 2957 rows in 29 pages for object "QPS8.QPP_PROJ_DOC_RELATIONS_V".
DBCC results for 'QPS8.QPP_ASSET_REPOSITORIES'.
There are 4 rows in 1 pages for object "QPS8.QPP_ASSET_REPOSITORIES".
DBCC results for 'QPS8.QPP_REVISION_CONTROLS_V'.
There are 0 rows in 0 pages for object "QPS8.QPP_REVISION_CONTROLS_V".
DBCC results for 'QPS8.QPP_JOB_JACKET_DEFAULTS_V1'.
There are 5 rows in 1 pages for object "QPS8.QPP_JOB_JACKET_DEFAULTS_V1".
DBCC results for 'QPS8.QPP_JOB_JACKET_DEFAULTS_V2'.
There are 47 rows in 1 pages for object "QPS8.QPP_JOB_JACKET_DEFAULTS_V2".
DBCC results for 'QPS8.QPP_STORAGE_RULES'.
There are 4 rows in 1 pages for object "QPS8.QPP_STORAGE_RULES".
DBCC results for 'QPS8.QPP_PRIV_GROUP_DEFINITIONS'.
There are 65 rows in 1 pages for object "QPS8.QPP_PRIV_GROUP_DEFINITIONS".
DBCC results for 'QPS8.QPP_DOMAIN_DEFINITIONS'.
There are 18 rows in 1 pages for object "QPS8.QPP_DOMAIN_DEFINITIONS".
DBCC results for 'QPS8.QPP_PRIVILEGE_DEFINITIONS'.
There are 159 rows in 2 pages for object "QPS8.QPP_PRIVILEGE_DEFINITIONS".
DBCC results for 'QPS8.QPP_JOB_DETAILS'.
There are 0 rows in 0 pages for object "QPS8.QPP_JOB_DETAILS".
DBCC results for 'QPS8.QPP_PRIVILEGE_VALUE_TYPES'.
There are 6 rows in 1 pages for object "QPS8.QPP_PRIVILEGE_VALUE_TYPES".
DBCC results for 'QPS8.QPP_JOB_LISTENERS'.
There are 0 rows in 0 pages for object "QPS8.QPP_JOB_LISTENERS".
DBCC results for 'QPS8.QPP_PRIVILEGE_ASSIGNMENTS'.
There are 765 rows in 7 pages for object "QPS8.QPP_PRIVILEGE_ASSIGNMENTS".
DBCC results for 'QPS8.QPP_DOMAIN_VALUES'.
There are 47 rows in 1 pages for object "QPS8.QPP_DOMAIN_VALUES".
DBCC results for 'QPS8.QPP_TRIGGERS'.
There are 0 rows in 0 pages for object "QPS8.QPP_TRIGGERS".
DBCC results for 'QPS8.QPP_SIMPLE_TRIGGERS'.
There are 0 rows in 0 pages for object "QPS8.QPP_SIMPLE_TRIGGERS".
DBCC results for 'QPS8.QPP_GROUP_MEMBERS'.
There are 292 rows in 4 pages for object "QPS8.QPP_GROUP_MEMBERS".
DBCC results for 'QPS8.QPP_STATUS_PRIV_ASSIGNMENTS'.
There are 1 rows in 111 pages for object "QPS8.QPP_STATUS_PRIV_ASSIGNMENTS".
DBCC results for 'QPS8.QPP_CRON_TRIGGERS'.
There are 0 rows in 0 pages for object "QPS8.QPP_CRON_TRIGGERS".
DBCC results for 'QPS8.QPP_ARTICLE_COMPONENTS'.
There are 18197 rows in 1286 pages for object "QPS8.QPP_ARTICLE_COMPONENTS".
DBCC results for 'QPS8.QPP_BLOB_TRIGGERS'.
There are 0 rows in 0 pages for object "QPS8.QPP_BLOB_TRIGGERS".
DBCC results for 'QPS8.QPP_DEL_ART_COMPONENTS'.
There are 3561 rows in 107 pages for object "QPS8.QPP_DEL_ART_COMPONENTS".
DBCC results for 'QPS8.QPP_TRIGGER_LISTENERS'.
There are 0 rows in 0 pages for object "QPS8.QPP_TRIGGER_LISTENERS".
DBCC results for 'QPS8.QPP_STATUS_OVRD_USERCLASSES'.
There are 1 rows in 2 pages for object "QPS8.QPP_STATUS_OVRD_USERCLASSES".
DBCC results for 'QPS8.QPP_ARTICLE_COMP_VERSIONS'.
Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 1429580131, index ID 1, partition ID
72057594040680448, alloc unit ID 72057594044874752 (type In-row data). The
previous link (4:36085) on page (4:13957) does not match the previous page
(4:37235) that the parent (4:13176), slot 122 expects for this page.
Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 1429580131, index ID 1, partition ID
72057594040680448, alloc unit ID 72057594044874752 (type In-row data).
B-tree chain linkage mismatch. (4:37235)->next = (4:13957), but
(4:13957)->Prev = (4:36085).
Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 1429580131, index ID 1, partition ID
72057594040680448, alloc unit ID 72057594044874752 (type In-row data).
B-tree chain linkage mismatch. (4:17350)->next = (4:17351), but
(4:17351)->Prev = (4:37234).
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1429580131, index ID 1, partition ID
72057594040680448, alloc unit ID 72057594044874752 (type In-row data). Page
(4:37234) is missing a reference from previous page (4:17350). Possible
chain linkage problem.
There are 76833 rows in 5479 pages for object
"QPS8.QPP_ARTICLE_COMP_VERSIONS".
CHECKDB found 0 allocation errors and 4 consistency errors in table
'QPS8.QPP_ARTICLE_COMP_VERSIONS' (object ID 1429580131).
DBCC results for 'QPS8.QPP_CALENDARS'.
There are 0 rows in 0 pages for object "QPS8.QPP_CALENDARS".
DBCC results for 'QPS8.QPP_JOB_JACKET_DEFINITIONS'.
There are 15 rows in 1 pages for object "QPS8.QPP_JOB_JACKET_DEFINITIONS".
DBCC results for 'QPS8.QPP_PROJ_DOC_RELATIONS'.
There are 4379 rows in 110 pages for object "QPS8.QPP_PROJ_DOC_RELATIONS".
DBCC results for 'QPS8.QPP_PAUSED_TRIGGER_GRPS'.
There are 0 rows in 0 pages for object "QPS8.QPP_PAUSED_TRIGGER_GRPS".
DBCC results for 'QPS8.QPP_PROJECT_ATTACHMENTS'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_PRODOCREL_PRJATT' (ID
2). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8702:0) identified by (ATTACHMENT_ID = 16214) with index values
'DOCUMENT_ID = 12077 and ATTACHMENT_ID = 16214'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_PRODOCREL_PRJATT' (ID
2). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8702:1) identified by (ATTACHMENT_ID = 16216) with index values
'DOCUMENT_ID = 12077 and ATTACHMENT_ID = 16216'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_PRODOCREL_PRJATT' (ID
2). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:0) identified by (ATTACHMENT_ID = 16191) with index values
'DOCUMENT_ID = 12077 and ATTACHMENT_ID = 16191'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_PRODOCREL_PRJATT' (ID
2). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:1) identified by (ATTACHMENT_ID = 16193) with index values
'DOCUMENT_ID = 12077 and ATTACHMENT_ID = 16193'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_PRODOCREL_PRJATT' (ID
2). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:2) identified by (ATTACHMENT_ID = 16194) with index values
'DOCUMENT_ID = 12077 and ATTACHMENT_ID = 16194'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_PRODOCREL_PRJATT' (ID
2). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:3) identified by (ATTACHMENT_ID = 16195) with index values
'DOCUMENT_ID = 12077 and ATTACHMENT_ID = 16195'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_PRODOCREL_PRJATT' (ID
2). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:4) identified by (ATTACHMENT_ID = 16196) with index values
'DOCUMENT_ID = 12077 and ATTACHMENT_ID = 16196'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_PRODOCREL_PRJATT' (ID
2). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:5) identified by (ATTACHMENT_ID = 16197) with index values
'DOCUMENT_ID = 12077 and ATTACHMENT_ID = 16197'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_PRODOCREL_PRJATT' (ID
2). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:6) identified by (ATTACHMENT_ID = 16198) with index values
'DOCUMENT_ID = 12077 and ATTACHMENT_ID = 16198'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_PRODOCREL_PRJATT' (ID
2). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:7) identified by (ATTACHMENT_ID = 16199) with index values
'DOCUMENT_ID = 12077 and ATTACHMENT_ID = 16199'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_PRODOCREL_PRJATT' (ID
2). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:8) identified by (ATTACHMENT_ID = 16200) with index values
'DOCUMENT_ID = 12077 and ATTACHMENT_ID = 16200'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_PRODOCREL_PRJATT' (ID
2). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:9) identified by (ATTACHMENT_ID = 16201) with index values
'DOCUMENT_ID = 12077 and ATTACHMENT_ID = 16201'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_PRODOCREL_PRJATT' (ID
2). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:10) identified by (ATTACHMENT_ID = 16202) with index values
'DOCUMENT_ID = 12077 and ATTACHMENT_ID = 16202'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_PRODOCREL_PRJATT' (ID
2). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:11) identified by (ATTACHMENT_ID = 16203) with index values
'DOCUMENT_ID = 12077 and ATTACHMENT_ID = 16203'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_PRODOCREL_PRJATT' (ID
2). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:12) identified by (ATTACHMENT_ID = 16204) with index values
'DOCUMENT_ID = 12077 and ATTACHMENT_ID = 16204'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_PRODOCREL_PRJATT' (ID
2). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:13) identified by (ATTACHMENT_ID = 16205) with index values
'DOCUMENT_ID = 12077 and ATTACHMENT_ID = 16205'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_PRODOCREL_PRJATT' (ID
2). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:14) identified by (ATTACHMENT_ID = 16207) with index values
'DOCUMENT_ID = 12077 and ATTACHMENT_ID = 16207'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_PRODOCREL_PRJATT' (ID
2). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:15) identified by (ATTACHMENT_ID = 16208) with index values
'DOCUMENT_ID = 12077 and ATTACHMENT_ID = 16208'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_PRODOCREL_PRJATT' (ID
2). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:16) identified by (ATTACHMENT_ID = 16209) with index values
'DOCUMENT_ID = 12077 and ATTACHMENT_ID = 16209'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_PRODOCREL_PRJATT' (ID
2). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:17) identified by (ATTACHMENT_ID = 16211) with index values
'DOCUMENT_ID = 12077 and ATTACHMENT_ID = 16211'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_PRODOCREL_PRJATT' (ID
2). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:18) identified by (ATTACHMENT_ID = 16212) with index values
'DOCUMENT_ID = 12077 and ATTACHMENT_ID = 16212'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_PRODOCREL_PRJATT' (ID
2). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:19) identified by (ATTACHMENT_ID = 16213) with index values
'DOCUMENT_ID = 12077 and ATTACHMENT_ID = 16213'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ASSETS_PRJATT' (ID 3).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8702:0) identified by (ATTACHMENT_ID = 16214) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16214'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ASSETS_PRJATT' (ID 3).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8702:1) identified by (ATTACHMENT_ID = 16216) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16216'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ASSETS_PRJATT' (ID 3).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:0) identified by (ATTACHMENT_ID = 16191) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16191'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ASSETS_PRJATT' (ID 3).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:1) identified by (ATTACHMENT_ID = 16193) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16193'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ASSETS_PRJATT' (ID 3).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:2) identified by (ATTACHMENT_ID = 16194) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16194'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ASSETS_PRJATT' (ID 3).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:3) identified by (ATTACHMENT_ID = 16195) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16195'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ASSETS_PRJATT' (ID 3).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:4) identified by (ATTACHMENT_ID = 16196) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16196'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ASSETS_PRJATT' (ID 3).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:5) identified by (ATTACHMENT_ID = 16197) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16197'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ASSETS_PRJATT' (ID 3).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:6) identified by (ATTACHMENT_ID = 16198) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16198'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ASSETS_PRJATT' (ID 3).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:7) identified by (ATTACHMENT_ID = 16199) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16199'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ASSETS_PRJATT' (ID 3).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:8) identified by (ATTACHMENT_ID = 16200) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16200'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ASSETS_PRJATT' (ID 3).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:9) identified by (ATTACHMENT_ID = 16201) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16201'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ASSETS_PRJATT' (ID 3).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:10) identified by (ATTACHMENT_ID = 16202) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16202'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ASSETS_PRJATT' (ID 3).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:11) identified by (ATTACHMENT_ID = 16203) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16203'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ASSETS_PRJATT' (ID 3).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:12) identified by (ATTACHMENT_ID = 16204) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16204'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ASSETS_PRJATT' (ID 3).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:13) identified by (ATTACHMENT_ID = 16205) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16205'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ASSETS_PRJATT' (ID 3).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:14) identified by (ATTACHMENT_ID = 16207) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16207'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ASSETS_PRJATT' (ID 3).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:15) identified by (ATTACHMENT_ID = 16208) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16208'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ASSETS_PRJATT' (ID 3).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:16) identified by (ATTACHMENT_ID = 16209) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16209'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ASSETS_PRJATT' (ID 3).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:17) identified by (ATTACHMENT_ID = 16211) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16211'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ASSETS_PRJATT' (ID 3).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:18) identified by (ATTACHMENT_ID = 16212) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16212'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ASSETS_PRJATT' (ID 3).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:19) identified by (ATTACHMENT_ID = 16213) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16213'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ARTCOM_PRJATT' (ID 4).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8702:0) identified by (ATTACHMENT_ID = 16214) with index values
'COMPONENT_ID = 23073 and ATTACHMENT_ID = 16214'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ARTCOM_PRJATT' (ID 4).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8702:1) identified by (ATTACHMENT_ID = 16216) with index values
'COMPONENT_ID = 23075 and ATTACHMENT_ID = 16216'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ARTCOM_PRJATT' (ID 4).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:0) identified by (ATTACHMENT_ID = 16191) with index values
'COMPONENT_ID = 23050 and ATTACHMENT_ID = 16191'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ARTCOM_PRJATT' (ID 4).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:1) identified by (ATTACHMENT_ID = 16193) with index values
'COMPONENT_ID = 23052 and ATTACHMENT_ID = 16193'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ARTCOM_PRJATT' (ID 4).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:2) identified by (ATTACHMENT_ID = 16194) with index values
'COMPONENT_ID = 23053 and ATTACHMENT_ID = 16194'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ARTCOM_PRJATT' (ID 4).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:3) identified by (ATTACHMENT_ID = 16195) with index values
'COMPONENT_ID = 23054 and ATTACHMENT_ID = 16195'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ARTCOM_PRJATT' (ID 4).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:4) identified by (ATTACHMENT_ID = 16196) with index values
'COMPONENT_ID = 23055 and ATTACHMENT_ID = 16196'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ARTCOM_PRJATT' (ID 4).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:5) identified by (ATTACHMENT_ID = 16197) with index values
'COMPONENT_ID = 23056 and ATTACHMENT_ID = 16197'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ARTCOM_PRJATT' (ID 4).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:6) identified by (ATTACHMENT_ID = 16198) with index values
'COMPONENT_ID = 23057 and ATTACHMENT_ID = 16198'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ARTCOM_PRJATT' (ID 4).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:7) identified by (ATTACHMENT_ID = 16199) with index values
'COMPONENT_ID = 23058 and ATTACHMENT_ID = 16199'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ARTCOM_PRJATT' (ID 4).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:8) identified by (ATTACHMENT_ID = 16200) with index values
'COMPONENT_ID = 23059 and ATTACHMENT_ID = 16200'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ARTCOM_PRJATT' (ID 4).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:9) identified by (ATTACHMENT_ID = 16201) with index values
'COMPONENT_ID = 23060 and ATTACHMENT_ID = 16201'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ARTCOM_PRJATT' (ID 4).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:10) identified by (ATTACHMENT_ID = 16202) with index values
'COMPONENT_ID = 23061 and ATTACHMENT_ID = 16202'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ARTCOM_PRJATT' (ID 4).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:11) identified by (ATTACHMENT_ID = 16203) with index values
'COMPONENT_ID = 23062 and ATTACHMENT_ID = 16203'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ARTCOM_PRJATT' (ID 4).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:12) identified by (ATTACHMENT_ID = 16204) with index values
'COMPONENT_ID = 23063 and ATTACHMENT_ID = 16204'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ARTCOM_PRJATT' (ID 4).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:13) identified by (ATTACHMENT_ID = 16205) with index values
'COMPONENT_ID = 23064 and ATTACHMENT_ID = 16205'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ARTCOM_PRJATT' (ID 4).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:14) identified by (ATTACHMENT_ID = 16207) with index values
'COMPONENT_ID = 23066 and ATTACHMENT_ID = 16207'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ARTCOM_PRJATT' (ID 4).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:15) identified by (ATTACHMENT_ID = 16208) with index values
'COMPONENT_ID = 23067 and ATTACHMENT_ID = 16208'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ARTCOM_PRJATT' (ID 4).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:16) identified by (ATTACHMENT_ID = 16209) with index values
'COMPONENT_ID = 23068 and ATTACHMENT_ID = 16209'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ARTCOM_PRJATT' (ID 4).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:17) identified by (ATTACHMENT_ID = 16211) with index values
'COMPONENT_ID = 23070 and ATTACHMENT_ID = 16211'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ARTCOM_PRJATT' (ID 4).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:18) identified by (ATTACHMENT_ID = 16212) with index values
'COMPONENT_ID = 23071 and ATTACHMENT_ID = 16212'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index 'FK_ARTCOM_PRJATT' (ID 4).
Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:19) identified by (ATTACHMENT_ID = 16213) with index values
'COMPONENT_ID = 23072 and ATTACHMENT_ID = 16213'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_1' (ID 5). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8702:0) identified by (ATTACHMENT_ID = 16214) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_STATE = 3 and ATTACHMENT_ID =
16214 and DOCUMENT_ID = 12077'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_1' (ID 5). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8702:1) identified by (ATTACHMENT_ID = 16216) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_STATE = 3 and ATTACHMENT_ID =
16216 and DOCUMENT_ID = 12077'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_1' (ID 5). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:0) identified by (ATTACHMENT_ID = 16191) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_STATE = 3 and ATTACHMENT_ID =
16191 and DOCUMENT_ID = 12077'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_1' (ID 5). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:1) identified by (ATTACHMENT_ID = 16193) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_STATE = 3 and ATTACHMENT_ID =
16193 and DOCUMENT_ID = 12077'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_1' (ID 5). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:2) identified by (ATTACHMENT_ID = 16194) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_STATE = 3 and ATTACHMENT_ID =
16194 and DOCUMENT_ID = 12077'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_1' (ID 5). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:3) identified by (ATTACHMENT_ID = 16195) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_STATE = 3 and ATTACHMENT_ID =
16195 and DOCUMENT_ID = 12077'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_1' (ID 5). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:4) identified by (ATTACHMENT_ID = 16196) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_STATE = 3 and ATTACHMENT_ID =
16196 and DOCUMENT_ID = 12077'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_1' (ID 5). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:5) identified by (ATTACHMENT_ID = 16197) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_STATE = 3 and ATTACHMENT_ID =
16197 and DOCUMENT_ID = 12077'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_1' (ID 5). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:6) identified by (ATTACHMENT_ID = 16198) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_STATE = 3 and ATTACHMENT_ID =
16198 and DOCUMENT_ID = 12077'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_1' (ID 5). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:7) identified by (ATTACHMENT_ID = 16199) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_STATE = 3 and ATTACHMENT_ID =
16199 and DOCUMENT_ID = 12077'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_1' (ID 5). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:8) identified by (ATTACHMENT_ID = 16200) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_STATE = 3 and ATTACHMENT_ID =
16200 and DOCUMENT_ID = 12077'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_1' (ID 5). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:9) identified by (ATTACHMENT_ID = 16201) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_STATE = 3 and ATTACHMENT_ID =
16201 and DOCUMENT_ID = 12077'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_1' (ID 5). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:10) identified by (ATTACHMENT_ID = 16202) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_STATE = 3 and ATTACHMENT_ID =
16202 and DOCUMENT_ID = 12077'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_1' (ID 5). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:11) identified by (ATTACHMENT_ID = 16203) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_STATE = 3 and ATTACHMENT_ID =
16203 and DOCUMENT_ID = 12077'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_1' (ID 5). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:12) identified by (ATTACHMENT_ID = 16204) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_STATE = 3 and ATTACHMENT_ID =
16204 and DOCUMENT_ID = 12077'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_1' (ID 5). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:13) identified by (ATTACHMENT_ID = 16205) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_STATE = 3 and ATTACHMENT_ID =
16205 and DOCUMENT_ID = 12077'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_1' (ID 5). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:14) identified by (ATTACHMENT_ID = 16207) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_STATE = 3 and ATTACHMENT_ID =
16207 and DOCUMENT_ID = 12077'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_1' (ID 5). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:15) identified by (ATTACHMENT_ID = 16208) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_STATE = 3 and ATTACHMENT_ID =
16208 and DOCUMENT_ID = 12077'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_1' (ID 5). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:16) identified by (ATTACHMENT_ID = 16209) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_STATE = 3 and ATTACHMENT_ID =
16209 and DOCUMENT_ID = 12077'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_1' (ID 5). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:17) identified by (ATTACHMENT_ID = 16211) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_STATE = 3 and ATTACHMENT_ID =
16211 and DOCUMENT_ID = 12077'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_1' (ID 5). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:18) identified by (ATTACHMENT_ID = 16212) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_STATE = 3 and ATTACHMENT_ID =
16212 and DOCUMENT_ID = 12077'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_1' (ID 5). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:19) identified by (ATTACHMENT_ID = 16213) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_STATE = 3 and ATTACHMENT_ID =
16213 and DOCUMENT_ID = 12077'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_2' (ID 6). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8702:0) identified by (ATTACHMENT_ID = 16214) with index values
'LINKED_ASSET_ID = NULL and ATTACHMENT_STATE = 3 and ATTACHMENT_ID = 16214'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_2' (ID 6). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8702:1) identified by (ATTACHMENT_ID = 16216) with index values
'LINKED_ASSET_ID = NULL and ATTACHMENT_STATE = 3 and ATTACHMENT_ID = 16216'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_2' (ID 6). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:0) identified by (ATTACHMENT_ID = 16191) with index values
'LINKED_ASSET_ID = NULL and ATTACHMENT_STATE = 3 and ATTACHMENT_ID = 16191'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_2' (ID 6). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:1) identified by (ATTACHMENT_ID = 16193) with index values
'LINKED_ASSET_ID = NULL and ATTACHMENT_STATE = 3 and ATTACHMENT_ID = 16193'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_2' (ID 6). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:2) identified by (ATTACHMENT_ID = 16194) with index values
'LINKED_ASSET_ID = NULL and ATTACHMENT_STATE = 3 and ATTACHMENT_ID = 16194'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_2' (ID 6). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:3) identified by (ATTACHMENT_ID = 16195) with index values
'LINKED_ASSET_ID = NULL and ATTACHMENT_STATE = 3 and ATTACHMENT_ID = 16195'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_2' (ID 6). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:4) identified by (ATTACHMENT_ID = 16196) with index values
'LINKED_ASSET_ID = NULL and ATTACHMENT_STATE = 3 and ATTACHMENT_ID = 16196'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_2' (ID 6). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:5) identified by (ATTACHMENT_ID = 16197) with index values
'LINKED_ASSET_ID = NULL and ATTACHMENT_STATE = 3 and ATTACHMENT_ID = 16197'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_2' (ID 6). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:6) identified by (ATTACHMENT_ID = 16198) with index values
'LINKED_ASSET_ID = NULL and ATTACHMENT_STATE = 3 and ATTACHMENT_ID = 16198'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_2' (ID 6). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:7) identified by (ATTACHMENT_ID = 16199) with index values
'LINKED_ASSET_ID = NULL and ATTACHMENT_STATE = 3 and ATTACHMENT_ID = 16199'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_2' (ID 6). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:8) identified by (ATTACHMENT_ID = 16200) with index values
'LINKED_ASSET_ID = NULL and ATTACHMENT_STATE = 3 and ATTACHMENT_ID = 16200'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_2' (ID 6). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:9) identified by (ATTACHMENT_ID = 16201) with index values
'LINKED_ASSET_ID = NULL and ATTACHMENT_STATE = 3 and ATTACHMENT_ID = 16201'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_2' (ID 6). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:10) identified by (ATTACHMENT_ID = 16202) with index values
'LINKED_ASSET_ID = NULL and ATTACHMENT_STATE = 3 and ATTACHMENT_ID = 16202'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_2' (ID 6). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:11) identified by (ATTACHMENT_ID = 16203) with index values
'LINKED_ASSET_ID = NULL and ATTACHMENT_STATE = 3 and ATTACHMENT_ID = 16203'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_2' (ID 6). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:12) identified by (ATTACHMENT_ID = 16204) with index values
'LINKED_ASSET_ID = NULL and ATTACHMENT_STATE = 3 and ATTACHMENT_ID = 16204'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_2' (ID 6). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:13) identified by (ATTACHMENT_ID = 16205) with index values
'LINKED_ASSET_ID = NULL and ATTACHMENT_STATE = 3 and ATTACHMENT_ID = 16205'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_2' (ID 6). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:14) identified by (ATTACHMENT_ID = 16207) with index values
'LINKED_ASSET_ID = NULL and ATTACHMENT_STATE = 3 and ATTACHMENT_ID = 16207'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_2' (ID 6). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:15) identified by (ATTACHMENT_ID = 16208) with index values
'LINKED_ASSET_ID = NULL and ATTACHMENT_STATE = 3 and ATTACHMENT_ID = 16208'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_2' (ID 6). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:16) identified by (ATTACHMENT_ID = 16209) with index values
'LINKED_ASSET_ID = NULL and ATTACHMENT_STATE = 3 and ATTACHMENT_ID = 16209'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_2' (ID 6). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:17) identified by (ATTACHMENT_ID = 16211) with index values
'LINKED_ASSET_ID = NULL and ATTACHMENT_STATE = 3 and ATTACHMENT_ID = 16211'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_2' (ID 6). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:18) identified by (ATTACHMENT_ID = 16212) with index values
'LINKED_ASSET_ID = NULL and ATTACHMENT_STATE = 3 and ATTACHMENT_ID = 16212'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_2' (ID 6). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:19) identified by (ATTACHMENT_ID = 16213) with index values
'LINKED_ASSET_ID = NULL and ATTACHMENT_STATE = 3 and ATTACHMENT_ID = 16213'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_3' (ID 7). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8702:0) identified by (ATTACHMENT_ID = 16214) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16214 and LINKED_ASSET_ID =
NULL and ATTACHMENT_STATE = 3'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_3' (ID 7). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8702:1) identified by (ATTACHMENT_ID = 16216) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16216 and LINKED_ASSET_ID =
NULL and ATTACHMENT_STATE = 3'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_3' (ID 7). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:0) identified by (ATTACHMENT_ID = 16191) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16191 and LINKED_ASSET_ID =
NULL and ATTACHMENT_STATE = 3'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_3' (ID 7). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:1) identified by (ATTACHMENT_ID = 16193) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16193 and LINKED_ASSET_ID =
NULL and ATTACHMENT_STATE = 3'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_3' (ID 7). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:2) identified by (ATTACHMENT_ID = 16194) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16194 and LINKED_ASSET_ID =
NULL and ATTACHMENT_STATE = 3'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_3' (ID 7). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:3) identified by (ATTACHMENT_ID = 16195) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16195 and LINKED_ASSET_ID =
NULL and ATTACHMENT_STATE = 3'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_3' (ID 7). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:4) identified by (ATTACHMENT_ID = 16196) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16196 and LINKED_ASSET_ID =
NULL and ATTACHMENT_STATE = 3'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_3' (ID 7). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:5) identified by (ATTACHMENT_ID = 16197) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16197 and LINKED_ASSET_ID =
NULL and ATTACHMENT_STATE = 3'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_3' (ID 7). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:6) identified by (ATTACHMENT_ID = 16198) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16198 and LINKED_ASSET_ID =
NULL and ATTACHMENT_STATE = 3'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_3' (ID 7). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:7) identified by (ATTACHMENT_ID = 16199) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16199 and LINKED_ASSET_ID =
NULL and ATTACHMENT_STATE = 3'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_3' (ID 7). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:8) identified by (ATTACHMENT_ID = 16200) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16200 and LINKED_ASSET_ID =
NULL and ATTACHMENT_STATE = 3'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_3' (ID 7). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:9) identified by (ATTACHMENT_ID = 16201) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16201 and LINKED_ASSET_ID =
NULL and ATTACHMENT_STATE = 3'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_3' (ID 7). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:10) identified by (ATTACHMENT_ID = 16202) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16202 and LINKED_ASSET_ID =
NULL and ATTACHMENT_STATE = 3'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_3' (ID 7). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:11) identified by (ATTACHMENT_ID = 16203) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16203 and LINKED_ASSET_ID =
NULL and ATTACHMENT_STATE = 3'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_3' (ID 7). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:12) identified by (ATTACHMENT_ID = 16204) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16204 and LINKED_ASSET_ID =
NULL and ATTACHMENT_STATE = 3'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_3' (ID 7). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:13) identified by (ATTACHMENT_ID = 16205) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16205 and LINKED_ASSET_ID =
NULL and ATTACHMENT_STATE = 3'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_3' (ID 7). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:14) identified by (ATTACHMENT_ID = 16207) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16207 and LINKED_ASSET_ID =
NULL and ATTACHMENT_STATE = 3'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_3' (ID 7). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:15) identified by (ATTACHMENT_ID = 16208) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16208 and LINKED_ASSET_ID =
NULL and ATTACHMENT_STATE = 3'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_3' (ID 7). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:16) identified by (ATTACHMENT_ID = 16209) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16209 and LINKED_ASSET_ID =
NULL and ATTACHMENT_STATE = 3'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_3' (ID 7). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:17) identified by (ATTACHMENT_ID = 16211) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16211 and LINKED_ASSET_ID =
NULL and ATTACHMENT_STATE = 3'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_3' (ID 7). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:18) identified by (ATTACHMENT_ID = 16212) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16212 and LINKED_ASSET_ID =
NULL and ATTACHMENT_STATE = 3'.
Msg 8951, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_PROJECT_ATTACHMENTS' (ID 1509580416). Data row
does not have a matching index row in the index
'IDX_QPP_PROJECT_ATTACHMENTS_3' (ID 7). Possible missing or invalid keys for
the index row matching:
Msg 8955, Level 16, State 1, Line 1
Data row (4:8703:19) identified by (ATTACHMENT_ID = 16213) with index values
'ATTACHED_ASSET_ID = 16021 and ATTACHMENT_ID = 16213 and LINKED_ASSET_ID =
NULL and ATTACHMENT_STATE = 3'.
There are 8648 rows in 679 pages for object "QPS8.QPP_PROJECT_ATTACHMENTS".
CHECKDB found 0 allocation errors and 132 consistency errors in table
'QPS8.QPP_PROJECT_ATTACHMENTS' (object ID 1509580416).
DBCC results for 'QPS8.QPP_FIRED_TRIGGERS'.
There are 0 rows in 0 pages for object "QPS8.QPP_FIRED_TRIGGERS".
DBCC results for 'QPS8.QPP_JOB_JACKET_DEFAULTS'.
There are 53 rows in 1 pages for object "QPS8.QPP_JOB_JACKET_DEFAULTS".
DBCC results for 'QPS8.QPP_SCHEDULER_STATE'.
There are 0 rows in 0 pages for object "QPS8.QPP_SCHEDULER_STATE".
DBCC results for 'QPS8.QPP_RENDITION_TYPES'.
There are 6 rows in 1 pages for object "QPS8.QPP_RENDITION_TYPES".
DBCC results for 'QPS8.QPP_DEL_PROJ_ATTACHMENTS'.
There are 25 rows in 8 pages for object "QPS8.QPP_DEL_PROJ_ATTACHMENTS".
DBCC results for 'QPS8.QPP_LOCKS'.
There are 5 rows in 1 pages for object "QPS8.QPP_LOCKS".
DBCC results for 'QPS8.QPP_RENDITION_PATHS'.
Msg 8952, Level 16, State 1, Line 1
Table error: table 'QPS8.QPP_RENDITION_PATHS' (ID 1634104862). Index row in
index 'FK_ASSREP_RENPAT' (ID 2) does not match any data row. Possible extra
or invalid keys for:
Msg 8956, Level 16, State 1, Line 1
Index row (4:14221:167) with values (REPOSITORY_ID = 3 and ASSET_ID = 16365
and RENDITION_TYPE_ID = 2 and PAGE_NUMBER = 1) pointing to the data row
identified by (ASSET_ID = 16365 and RENDITION_TYPE_ID = 2 and PAGE_NUMBER =
1).
There are 40919 rows in 1286 pages for object "QPS8.QPP_RENDITION_PATHS".
CHECKDB found 0 allocation errors and 1 consistency errors in table
'QPS8.QPP_RENDITION_PATHS' (object ID 1634104862).
DBCC results for 'QPS8.QPP_PROJ_ATTACHMENT_VERSIONS'.
There are 62818 rows in 1045 pages for object
"QPS8.QPP_PROJ_ATTACHMENT_VERSIONS".
DBCC results for 'QPS8.QPP_REND_PATH_VERSIONS'.
Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 1666104976, index ID 1, partition ID
72057594044153856, alloc unit ID 72057594048806912 (type In-row data). The
previous link (4:36364) on page (4:17318) does not match the previous page
(4:37174) that the parent (4:10021), slot 174 expects for this page.
Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 1666104976, index ID 1, partition ID
72057594044153856, alloc unit ID 72057594048806912 (type In-row data).
B-tree chain linkage mismatch. (4:37174)->next = (4:17318), but
(4:17318)->Prev = (4:36364).
Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 1666104976, index ID 1, partition ID
72057594044153856, alloc unit ID 72057594048806912 (type In-row data).
B-tree chain linkage mismatch. (4:19632)->next = (4:36511), but
(4:36511)->Prev = (4:43678).
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1666104976, index ID 1, partition ID
72057594044153856, alloc unit ID 72057594048806912 (type In-row data). Page
(4:37172) is missing a reference from previous page (4:34570). Possible
chain linkage problem.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1666104976, index ID 1, partition ID
72057594044153856, alloc unit ID 72057594048806912 (type In-row data). Page
(4:37240) is missing a reference from previous page (4:19632). Possible
chain linkage problem.
Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 1666104976, index ID 2, partition ID
72057594047037440, alloc unit ID 72057594051952640 (type In-row data). The
previous link (4:13074) on page (4:14040) does not match the previous page
(4:37195) that the parent (4:12001), slot 32 expects for this page.
Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 1666104976, index ID 2, partition ID
72057594047037440, alloc unit ID 72057594051952640 (type In-row data).
B-tree chain linkage mismatch. (4:37195)->next = (4:14040), but
(4:14040)->Prev = (4:13074).
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1666104976, index ID 2, partition ID
72057594047037440, alloc unit ID 72057594051952640 (type In-row data). Page
(4:37195) is missing a reference from previous page (4:13074). Possible
chain linkage problem.
Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 1666104976, index ID 3, partition ID
72057594047102976, alloc unit ID 72057594052018176 (type In-row data).
B-tree chain linkage mismatch. (4:37187)->next = (4:17370), but
(4:17370)->Prev = (4:3592).
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1666104976, index ID 3, partition ID
72057594047102976, alloc unit ID 72057594052018176 (type In-row data). Page
(4:37185) is missing a reference from previous page (4:34362). Possible
chain linkage problem.
Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 1666104976, index ID 3, partition ID
72057594047102976, alloc unit ID 72057594052018176 (type In-row data).
Parent node for page (4:37187) was not encountered.
Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 1666104976, index ID 4, partition ID
72057594047168512, alloc unit ID 72057594052083712 (type In-row data). The
previous link (4:14798) on page (4:11543) does not match the previous page
(4:37224) that the parent (4:797), slot 22 expects for this page.
Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 1666104976, index ID 4, partition ID
72057594047168512, alloc unit ID 72057594052083712 (type In-row data).
B-tree chain linkage mismatch. (4:37224)->next = (4:11543), but
(4:11543)->Prev = (4:14798).
There are 217704 rows in 5355 pages for object
"QPS8.QPP_REND_PATH_VERSIONS".
CHECKDB found 0 allocation errors and 13 consistency errors in table
'QPS8.QPP_REND_PATH_VERSIONS' (object ID 1666104976).
DBCC results for 'QPS8.QPP_ARTICLE_DIMENSIONS'.
There are 86 rows in 2 pages for object "QPS8.QPP_ARTICLE_DIMENSIONS".
DBCC results for 'QPS8.QPP_PROJ_ATTACHMENT_VALUES'.
There are 8802 rows in 383 pages for object
"QPS8.QPP_PROJ_ATTACHMENT_VALUES".
DBCC results for 'sysdiagrams'.
There are 0 rows in 0 pages for object "sysdiagrams".
DBCC results for 'QPS8.QPP_FORM_DEFINITIONS'.
There are 8 rows in 2 pages for object "QPS8.QPP_FORM_DEFINITIONS".
DBCC results for 'QPS8.QPP_DEL_PROJ_ATT_VALUES'.
There are 25 rows in 4 pages for object "QPS8.QPP_DEL_PROJ_ATT_VALUES".
DBCC results for 'QPS8.QPP_REP_MAP_DEFINITIONS'.
There are 2 rows in 1 pages for object "QPS8.QPP_REP_MAP_DEFINITIONS".
DBCC results for 'QPS8.QPP_PROJ_ATTCHMNT_VAL_VERSIONS'.
There are 64108 rows in 1687 pages for object
"QPS8.QPP_PROJ_ATTCHMNT_VAL_VERSIONS".
DBCC results for 'QPS8.QPP_REP_MAP_ATTRIBUTE_SETS'.
There are 158 rows in 3 pages for object "QPS8.QPP_REP_MAP_ATTRIBUTE_SETS".
DBCC results for 'QPS8.QPP_REP_MAP_SECTION_SETS'.
There are 6852 rows in 78 pages for object "QPS8.QPP_REP_MAP_SECTION_SETS".
DBCC results for 'QPS8.QPP_SCHEMA_CONTROL'.
There are 3 rows in 1 pages for object "QPS8.QPP_SCHEMA_CONTROL".
DBCC results for 'QPS8.QPP_PUBLICATION_DEFINITIONS'.
There are 11 rows in 1 pages for object "QPS8.QPP_PUBLICATION_DEFINITIONS".
DBCC results for 'QPS8.QPP_PREFERENCE_DEFINITIONS'.
There are 100 rows in 3 pages for object "QPS8.QPP_PREFERENCE_DEFINITIONS".
DBCC results for 'QPS8.QPP_PUBLICATION_TRUSTEES'.
There are 1389 rows in 14 pages for object "QPS8.QPP_PUBLICATION_TRUSTEES".
DBCC results for 'QPS8.QPP_PUBLICATION_USERCLASSES'.
There are 3 rows in 2 pages for object "QPS8.QPP_PUBLICATION_USERCLASSES".
DBCC results for 'sys.queue_messages_1977058079'.
There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".
DBCC results for 'QPS8.QPP_PREF_POSSIBLE_VALUES'.
There are 161 rows in 2 pages for object "QPS8.QPP_PREF_POSSIBLE_VALUES".
DBCC results for 'QPS8.QPP_SECTION_DEFINITIONS'.
There are 87 rows in 1 pages for object "QPS8.QPP_SECTION_DEFINITIONS".
DBCC results for 'sys.queue_messages_2009058193'.
There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".
DBCC results for 'QPS8.QPP_USER_PREF_VALUES'.
There are 5807 rows in 64 pages for object "QPS8.QPP_USER_PREF_VALUES".
DBCC results for 'QPS8.QPP_SECTION_TRUSTEES'.
There are 11235 rows in 104 pages for object "QPS8.QPP_SECTION_TRUSTEES".
DBCC results for 'sys.queue_messages_2041058307'.
There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".
DBCC results for 'QPS8.QPP_ENTITIES'.
There are 2 rows in 1 pages for object "QPS8.QPP_ENTITIES".
DBCC results for 'QPS8.QPP_USER_REDLINES'.
There are 231 rows in 2 pages for object "QPS8.QPP_USER_REDLINES".
DBCC results for 'QPS8.QPP_SECTION_USERCLASSES'.
There are 128 rows in 8 pages for object "QPS8.QPP_SECTION_USERCLASSES".
DBCC results for 'QPS8.QPP_STATUS_DEFINITIONS'.
There are 109 rows in 2 pages for object "QPS8.QPP_STATUS_DEFINITIONS".
DBCC results for 'QPS8.QPP_FILE_CLASSES'.
There are 5 rows in 1 pages for object "QPS8.QPP_FILE_CLASSES".
CHECKDB found 0 allocation errors and 183 consistency errors in database
'QPS8'.
repair_rebuild is the minimum repair level for the errors found by DBCC
CHECKDB (QPS8).
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.

Kristen
Test

22859 Posts

Posted - 2010-08-11 : 08:40:27

"Will running BCC CheckDB (<Database Name>) WITH No_INFOMSGS, ALL_ERRORMSGS affect the database "

No, its informational only. It will leave out the INFOMSGS - included in what you have posted above - which makes seeing the wood-for-the-trees much easier, and also it will NOT stop after N errors (which is the case if you do not use the ALL_ERRORMSGS option - I don't remember the exact value for "N")

As you don't know me from Adam! you can confirm via the SQL documentation - so called "Books Online" - available on Microsoft's site to view, or to download and run locally on your machine.

mahajanakhil1985
Yak Posting Veteran

71 Posts

Posted - 2010-08-11 : 09:18:57

Ok, I will ask the IT guy to run DBCC DBCheck. But can't you advise, using the error information that I posted in my previous post, on how to go further to correct the database?

Would rebuilding all indexes help me? Or anything else that you may recommend?
Please justify the reason if you make any recommendations on how I should go further.

I shall be grateful to you!

Kristen
Test

22859 Posts

Posted - 2010-08-11 : 09:27:13

If it was me I would restore from backup. period.

Beyond that I don't have skills to advise you on whether the errors are significant, or not. Gail is the only person here who routinely answers such questions. You could open a case with Microsoft of course.

mahajanakhil1985
Yak Posting Veteran

71 Posts

Posted - 2010-08-11 : 09:51:12

Thanks Kristen! In that case, I would wait for Gail to answer.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-08-11 : 11:04:39

quote:
Originally posted by Kristen

If it was me I would restore from backup. period.

Complete waste of time in this case, possibly unnecessary downtime, possibly unnecessary data loss (if not full recovery and log backups). The errors are repairable.

--
Gail Shaw
SQL Server MVP

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-08-11 : 11:09:16

Rebuilding the indexes won't work. It'll just throw errors as the rebuild process reads the old indexes to recreate them.

Two options, both will work, up to you which you go for.

1) Script out and then drop all the nonclustered indexes that are mentioned in the list of errors (I'm not going through and finding them all). Recreate the indexes.
Example: "Object ID 1666104976, index ID 3", use sys.tables and sys.indexes to get the table name and index name.
2) Put the database into single user mode and run DBCC CheckDB (QPS8, repair_rebuild). This will repair the errors. The database will be inaccessible for the duration.

Option 2 is far less work considering the number of errors you have. If you have a maintenance window, do it then.

--
Gail Shaw
SQL Server MVP

mahajanakhil1985
Yak Posting Veteran

71 Posts

Posted - 2010-08-11 : 11:12:08

Gail, can you please let me know how I can repair them?

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-08-11 : 11:14:32

See my last post. It's explained there.

--
Gail Shaw
SQL Server MVP

mahajanakhil1985
Yak Posting Veteran

71 Posts

Posted - 2010-08-11 : 11:46:26

Thanks Gail, I think that we both were posting at the same time. That's why, I did not notice.

I will try the solution you recommended. For further help, I will keep this thread posted.

mahajanakhil1985
Yak Posting Veteran

71 Posts

Posted - 2010-08-11 : 11:50:01

Gail, can you please let me know if there are any side effects of DBCC CheckDB (QPS8, repair_rebuild)?

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-08-11 : 11:57:16

It'll repair all of the errors that you have. It won't delete data or anything like that. Do note that the DB MUST be in single user mode to run that, so no one else will be able to connect.

--
Gail Shaw
SQL Server MVP

Kristen
Test

22859 Posts

Posted - 2010-08-11 : 13:11:12

quote:
Originally posted by GilaMonster

quote:
Originally posted by Kristen

If it was me I would restore from backup. period.

Complete waste of time in this case, possibly unnecessary downtime, possibly unnecessary data loss (if not full recovery and log backups). The errors are repairable.

Yeah, well that's you and using the knowledge you have which, given that you are the only person that answers these type of questions here, strikes me is knowledge that is not commonplace; plus like I said: "If it was me".

I would thus have avoided having to be dependent on your time constraints and I would have got my database back upright within a predictable amount of time, and I wouldn't have been fretting about whether an error, which I didn't fully understand, could turn out to be an issue that might mean users re-entering data if they just carried on, or users making duff decisions from incomplete data on reports because of corrupted indexes, or users seeing runtime errors which prevented them working anyway. None of those may be the case, but all those things would have been bothering me if I had been confronted with this type of error message.

But in my case I do have the benefit of being confident that we could make a tail TLOG backup and restore without data loss in most cases, and that I could take other precautions to be able to have another go if Restore was unsuccessful.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-08-11 : 13:53:29

quote:
Originally posted by Kristen

Yeah, well that's you and using the knowledge you have which, given that you are the only person that answers these type of questions here, strikes me is knowledge that is not commonplace;

The basics of corruption & repairs aren't hard. The key is the line right at the end. Minimum level = repair_rebuild means that the damage is completely repairable without data loss, typically with drop/create of the mentioned indexes or checkDB with the specified repair level. Minimum level = repair allow data loss means repair will discard data, restore from backup if possible. No repair level specified means at least one error is not repairable

--
Gail Shaw
SQL Server MVP

Kristen
Test

22859 Posts

Posted - 2010-08-11 : 14:01:01

Yes, that does indeed feel "comfortable". In fact I Googled "repair_rebuild is the minimum repair level for the errors found by DBCC" earlier when the O/P posted the error list hoping to get that reassurance, in particular because I have seen "repair with data loss" type messages posted in such lists here before, which is clearly a whole different level of hurt

But I didn't find anything reassuring - in the sense that having used the Repair option that DBCC wouldn't then reveal some further action that was needed (and if that were to be the case I wouldn't know if that might lead to the discovery of NON repairable data). I also didn't find anything suggesting that it was likely to be a quick & easy job, or otherwise.

Bothers me that folk post these things here though <fx: knock on wood>. Something has to have caused the corruption in the first place ...

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-08-11 : 14:16:39

Yes, and if the poster comes back here once he's fixed, I'll add some comments about that.

If you're interested in a summary - [url]http://www.sqlservercentral.com/articles/65804/[/url]

--
Gail Shaw
SQL Server MVP

Kristen
Test

22859 Posts

Posted - 2010-08-12 : 02:27:40

Very useful article, thanks.

mahajanakhil1985
Yak Posting Veteran

71 Posts

Posted - 2010-08-12 : 05:45:02

Gail, it helped in repairing most of the errors.

I executed following:
DBCC CheckDB (qps8) WITH No_INFOMSGS, ALL_ERRORMSGS
It displayed the same error log as posted earlier.

Afterwards, I executed following to repair or rebuild.
DBCC CheckDB (QPS8, repair_rebuild)
It repaired/rebuilt as expected.

Then I re-executed:
DBCC CheckDB (qps8) WITH No_INFOMSGS, ALL_ERRORMSGS

Output is:
Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 1429580131, index ID 1, partition ID 72057594040680448, alloc unit ID 72057594044874752 (type In-row data). The previous link (4:36085) on page (4:13957) does not match the previous page (4:37235) that the parent (4:13176), slot 122 expects for this page.
Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 1429580131, index ID 1, partition ID 72057594040680448, alloc unit ID 72057594044874752 (type In-row data). B-tree chain linkage mismatch. (4:37235)->next = (4:13957), but (4:13957)->Prev = (4:36085).
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1429580131, index ID 1, partition ID 72057594040680448, alloc unit ID 72057594044874752 (type In-row data). Page (4:37234) is missing a reference from previous page (4:17350). Possible chain linkage problem.
CHECKDB found 0 allocation errors and 3 consistency errors in table 'QPS8.QPP_ARTICLE_COMP_VERSIONS' (object ID 1429580131).
CHECKDB found 0 allocation errors and 3 consistency errors in database 'QPS8'.
repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (QPS8).

Then I re-executed the following:
DBCC CheckDB (QPS8, repair_rebuild)

Output is:
Msg 1505, Level 16, State 1, Line 1
The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'QPS8.QPP_ARTICLE_COMP_VERSIONS' and the index name 'PK_ARTCOM_COM_VER'. The duplicate key value is (10548, 4).
Msg 1505, Level 16, State 1, Line 1
The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'QPS8.QPP_ARTICLE_COMP_VERSIONS' and the index name 'FK_ASSETSV_ARTCOMV_AAIDVNO'. The duplicate key value is (9870, 4, 10548).
DBCC results for 'QPS8'.
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.
DBCC results for 'sys.sysrowsetcolumns'.
There are 1962 rows in 15 pages for object "sys.sysrowsetcolumns".
DBCC results for 'sys.sysrowsets'.
There are 423 rows in 3 pages for object "sys.sysrowsets".
DBCC results for 'sysallocunits'.
There are 464 rows in 5 pages for object "sysallocunits".
DBCC results for 'sys.sysfiles1'.
There are 5 rows in 1 pages for object "sys.sysfiles1".
DBCC results for 'sys.syshobtcolumns'.
There are 1962 rows in 16 pages for object "sys.syshobtcolumns".
DBCC results for 'sys.syshobts'.
There are 423 rows in 3 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 464 rows in 4 pages for object "sys.sysserefs".
DBCC results for 'sys.sysowners'.
There are 16 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysprivs'.
There are 136 rows in 1 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 572 rows in 8 pages for object "sys.sysschobjs".
DBCC results for 'sys.syscolpars'.
There are 1252 rows in 23 pages for object "sys.syscolpars".
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 9 rows in 1 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 622 rows in 10 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 851 rows in 5 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 757 rows in 241 pages for object "sys.sysobjvalues".
DBCC results for 'sys.sysclsobjs'.
There are 18 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 737 rows in 5 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 253 rows in 1 pages for object "sys.sysmultiobjrefs".
DBCC results for 'sys.sysdbfiles'.
There are 5 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 91 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".
DBCC results for 'QPS8.QPP_FILE_TYPES'.
There are 0 rows in 0 pages for object "QPS8.QPP_FILE_TYPES".
DBCC results for 'QPS8.QPP_STATUS_REDLINES'.
There are 0 rows in 0 pages for object "QPS8.QPP_STATUS_REDLINES".
DBCC results for 'QPS8.QPP_ASSETS'.
There are 6649 rows in 1201 pages for object "QPS8.QPP_ASSETS".
DBCC results for 'QPS8.QPP_JOJ_RULE_EVALUATIONS'.
There are 50 rows in 3 pages for object "QPS8.QPP_JOJ_RULE_EVALUATIONS".
DBCC results for 'QPS8.QPP_STATUS_ROUTINGS'.
There are 229 rows in 2 pages for object "QPS8.QPP_STATUS_ROUTINGS".
DBCC results for 'QPS8.QPP_TABLE_SEQUENCES'.
There are 29 rows in 1 pages for object "QPS8.QPP_TABLE_SEQUENCES".
DBCC results for 'QPS8.QPP_SCRIPTS'.
There are 0 rows in 0 pages for object "QPS8.QPP_SCRIPTS".
DBCC results for 'QPS8.QPP_ATT_DEL_ASSETS'.
There are 562 rows in 12 pages for object "QPS8.QPP_ATT_DEL_ASSETS".
DBCC results for 'QPS8.QPP_TRUSTEE_DEFINITIONS'.
There are 280 rows in 3 pages for object "QPS8.QPP_TRUSTEE_DEFINITIONS".
DBCC results for 'QPS8.QPP_ASSET_VERSIONS'.
There are 35058 rows in 3717 pages for object "QPS8.QPP_ASSET_VERSIONS".
DBCC results for 'QPS8.QPP_SCHEDULES'.
There are 0 rows in 0 pages for object "QPS8.QPP_SCHEDULES".
DBCC results for 'QPS8.QPP_ASSET_ATTR_IPTC_VALUES'.
There are 18 rows in 2 pages for object "QPS8.QPP_ASSET_ATTR_IPTC_VALUES".
DBCC results for 'QPS8.QPP_USER_DETAILS'.
There are 261 rows in 5 pages for object "QPS8.QPP_USER_DETAILS".
DBCC results for 'QPS8.QPP_ASSETS_TEMP'.
There are 0 rows in 1 pages for object "QPS8.QPP_ASSETS_TEMP".
DBCC results for 'QPS8.QPP_AST_ATTR_IPTC_VAL_VERSIONS'.
There are 1 rows in 1 pages for object "QPS8.QPP_AST_ATTR_IPTC_VAL_VERSIONS".
DBCC results for 'QPS8.QPP_COMPONENT_CATEGORIES'.
There are 3 rows in 1 pages for object "QPS8.QPP_COMPONENT_CATEGORIES".
DBCC results for 'QPS8.QPP_USERCLASS_DEFINITIONS'.
There are 12 rows in 1 pages for object "QPS8.QPP_USERCLASS_DEFINITIONS".
DBCC results for 'QPS8.QPP_ENTITY_CATEGORIES'.
There are 8 rows in 1 pages for object "QPS8.QPP_ENTITY_CATEGORIES".
DBCC results for 'QPS8.QPP_REVISION_CONTROLS'.
There are 4 rows in 1 pages for object "QPS8.QPP_REVISION_CONTROLS".
DBCC results for 'QPS8.QPP_ASSET_ATTR_CHKBOX_VALUES'.
There are 6334 rows in 43 pages for object "QPS8.QPP_ASSET_ATTR_CHKBOX_VALUES".
DBCC results for 'QPS8.QPP_ASSET_ATTR_DATE_VALUES'.
There are 6626 rows in 84 pages for object "QPS8.QPP_ASSET_ATTR_DATE_VALUES".
DBCC results for 'QPS8.QPP_ASSET_ATTR_DOMAIN_VALUES'.
There are 0 rows in 1 pages for object "QPS8.QPP_ASSET_ATTR_DOMAIN_VALUES".
DBCC results for 'QPS8.QPP_QUERY_DEFINITIONS'.
There are 196 rows in 2 pages for object "QPS8.QPP_QUERY_DEFINITIONS".
DBCC results for 'QPS8.QPP_ASSET_ATTR_NUM_VALUES'.
There are 0 rows in 0 pages for object "QPS8.QPP_ASSET_ATTR_NUM_VALUES".
DBCC results for 'QPS8.QPP_ASSET_ATTR_TEXT_VALUES'.
There are 5263 rows in 74 pages for object "QPS8.QPP_ASSET_ATTR_TEXT_VALUES".
DBCC results for 'QPS8.QPP_QUERY_ASSIGNMENTS'.
There are 984 rows in 7 pages for object "QPS8.QPP_QUERY_ASSIGNMENTS".
DBCC results for 'QPS8.QPP_AST_ATTR_CHK_VAL_VERSIONS'.
There are 24020 rows in 240 pages for object "QPS8.QPP_AST_ATTR_CHK_VAL_VERSIONS".
DBCC results for 'QPS8.QPP_QUERY_CONDITIONS'.
There are 564 rows in 16 pages for object "QPS8.QPP_QUERY_CONDITIONS".
DBCC results for 'QPS8.QPP_AST_ATTR_DATE_VAL_VERSIONS'.
There are 35162 rows in 426 pages for object "QPS8.QPP_AST_ATTR_DATE_VAL_VERSIONS".
DBCC results for 'QPS8.QPP_AST_ATTR_DOM_VAL_VERSIONS'.
There are 0 rows in 1 pages for object "QPS8.QPP_AST_ATTR_DOM_VAL_VERSIONS".
DBCC results for 'QPS8.QPP_AST_ATTR_NUM_VAL_VERSIONS'.
There are 0 rows in 0 pages for object "QPS8.QPP_AST_ATTR_NUM_VAL_VERSIONS".
DBCC results for 'QPS8.QPP_QUERY_SORTINGS'.
There are 1116 rows in 86 pages for object "QPS8.QPP_QUERY_SORTINGS".
DBCC results for 'QPS8.QPP_AST_ATTR_TXT_VAL_VERSIONS'.
There are 29687 rows in 320 pages for object "QPS8.QPP_AST_ATTR_TXT_VAL_VERSIONS".
DBCC results for 'QPS8.QPP_COMPONENT_ATTR_VALUES'.
There are 0 rows in 0 pages for object "QPS8.QPP_COMPONENT_ATTR_VALUES".
DBCC results for 'QPS8.QPP_QUERY_GROUPINGS'.
There are 239 rows in 2 pages for object "QPS8.QPP_QUERY_GROUPINGS".
DBCC results for 'QPS8.QPP_COMP_ATTR_VAL_VERSIONS'.
There are 0 rows in 0 pages for object "QPS8.QPP_COMP_ATTR_VAL_VERSIONS".
DBCC results for 'QPS8.QPP_ATTRIBUTE_CONSTRAINTS'.
There are 720 rows in 6 pages for object "QPS8.QPP_ATTRIBUTE_CONSTRAINTS".
DBCC results for 'QPS8.QPP_QUERY_MODES'.
There are 842 rows in 7 pages for object "QPS8.QPP_QUERY_MODES".
DBCC results for 'QPS8.QPP_ATTRIBUTE_DEFINITIONS'.
There are 102 rows in 3 pages for object "QPS8.QPP_ATTRIBUTE_DEFINITIONS".
DBCC results for 'QPS8.QPP_QUERY_DISPLAY_SETTINGS'.
There are 6109 rows in 641 pages for object "QPS8.QPP_QUERY_DISPLAY_SETTINGS".
DBCC results for 'QPS8.QPP_ASSET_REPOSITORY_TYPES'.
There are 2 rows in 1 pages for object "QPS8.QPP_ASSET_REPOSITORY_TYPES".
DBCC results for 'QPS8.QPP_PROJ_DOC_RELATIONS_V'.
There are 3197 rows in 30 pages for object "QPS8.QPP_PROJ_DOC_RELATIONS_V".
DBCC results for 'QPS8.QPP_ASSET_REPOSITORIES'.
There are 4 rows in 1 pages for object "QPS8.QPP_ASSET_REPOSITORIES".
DBCC results for 'QPS8.QPP_REVISION_CONTROLS_V'.
There are 0 rows in 0 pages for object "QPS8.QPP_REVISION_CONTROLS_V".
DBCC results for 'QPS8.QPP_JOB_JACKET_DEFAULTS_V1'.
There are 5 rows in 1 pages for object "QPS8.QPP_JOB_JACKET_DEFAULTS_V1".
DBCC results for 'QPS8.QPP_JOB_JACKET_DEFAULTS_V2'.
There are 53 rows in 1 pages for object "QPS8.QPP_JOB_JACKET_DEFAULTS_V2".
DBCC results for 'QPS8.QPP_STORAGE_RULES'.
There are 4 rows in 1 pages for object "QPS8.QPP_STORAGE_RULES".
DBCC results for 'QPS8.QPP_PRIV_GROUP_DEFINITIONS'.
There are 65 rows in 1 pages for object "QPS8.QPP_PRIV_GROUP_DEFINITIONS".
DBCC results for 'QPS8.QPP_DOMAIN_DEFINITIONS'.
There are 18 rows in 1 pages for object "QPS8.QPP_DOMAIN_DEFINITIONS".
DBCC results for 'QPS8.QPP_PRIVILEGE_DEFINITIONS'.
There are 159 rows in 2 pages for object "QPS8.QPP_PRIVILEGE_DEFINITIONS".
DBCC results for 'QPS8.QPP_JOB_DETAILS'.
There are 0 rows in 0 pages for object "QPS8.QPP_JOB_DETAILS".
DBCC results for 'QPS8.QPP_PRIVILEGE_VALUE_TYPES'.
There are 6 rows in 1 pages for object "QPS8.QPP_PRIVILEGE_VALUE_TYPES".
DBCC results for 'QPS8.QPP_JOB_LISTENERS'.
There are 0 rows in 0 pages for object "QPS8.QPP_JOB_LISTENERS".
DBCC results for 'QPS8.QPP_PRIVILEGE_ASSIGNMENTS'.
There are 765 rows in 7 pages for object "QPS8.QPP_PRIVILEGE_ASSIGNMENTS".
DBCC results for 'QPS8.QPP_DOMAIN_VALUES'.
There are 47 rows in 1 pages for object "QPS8.QPP_DOMAIN_VALUES".
DBCC results for 'QPS8.QPP_TRIGGERS'.
There are 0 rows in 0 pages for object "QPS8.QPP_TRIGGERS".
DBCC results for 'QPS8.QPP_SIMPLE_TRIGGERS'.
There are 0 rows in 0 pages for object "QPS8.QPP_SIMPLE_TRIGGERS".
DBCC results for 'QPS8.QPP_GROUP_MEMBERS'.
There are 292 rows in 4 pages for object "QPS8.QPP_GROUP_MEMBERS".
DBCC results for 'QPS8.QPP_STATUS_PRIV_ASSIGNMENTS'.
There are 1 rows in 111 pages for object "QPS8.QPP_STATUS_PRIV_ASSIGNMENTS".
DBCC results for 'QPS8.QPP_CRON_TRIGGERS'.
There are 0 rows in 0 pages for object "QPS8.QPP_CRON_TRIGGERS".
DBCC results for 'QPS8.QPP_ARTICLE_COMPONENTS'.
There are 18806 rows in 1343 pages for object "QPS8.QPP_ARTICLE_COMPONENTS".
DBCC results for 'QPS8.QPP_BLOB_TRIGGERS'.
There are 0 rows in 0 pages for object "QPS8.QPP_BLOB_TRIGGERS".
DBCC results for 'QPS8.QPP_DEL_ART_COMPONENTS'.
There are 3561 rows in 107 pages for object "QPS8.QPP_DEL_ART_COMPONENTS".
DBCC results for 'QPS8.QPP_TRIGGER_LISTENERS'.
There are 0 rows in 0 pages for object "QPS8.QPP_TRIGGER_LISTENERS".
DBCC results for 'QPS8.QPP_STATUS_OVRD_USERCLASSES'.
There are 1 rows in 2 pages for object "QPS8.QPP_STATUS_OVRD_USERCLASSES".
DBCC results for 'QPS8.QPP_ARTICLE_COMP_VERSIONS'.
Msg 8945, Level 16, State 1, Line 1
Table error: Object ID 1429580131, index ID 1 will be rebuilt.
Could not repair this error.
Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 1429580131, index ID 1, partition ID 72057594040680448, alloc unit ID 72057594044874752 (type In-row data). The previous link (4:36085) on page (4:13957) does not match the previous page (4:37235) that the parent (4:13176), slot 122 expects for this page.
The error has been repaired.
Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 1429580131, index ID 1, partition ID 72057594040680448, alloc unit ID 72057594044874752 (type In-row data). B-tree chain linkage mismatch. (4:37235)->next = (4:13957), but (4:13957)->Prev = (4:36085).
The error has been repaired.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1429580131, index ID 1, partition ID 72057594040680448, alloc unit ID 72057594044874752 (type In-row data). Page (4:37234) is missing a reference from previous page (4:17350). Possible chain linkage problem.
The error has been repaired.
Msg 8945, Level 16, State 1, Line 1
Table error: Object ID 1429580131, index ID 2 will be rebuilt.
Could not repair this error.
There are 79378 rows in 5676 pages for object "QPS8.QPP_ARTICLE_COMP_VERSIONS".
CHECKDB found 0 allocation errors and 3 consistency errors in table 'QPS8.QPP_ARTICLE_COMP_VERSIONS' (object ID 1429580131).
CHECKDB fixed 0 allocation errors and 3 consistency errors in table 'QPS8.QPP_ARTICLE_COMP_VERSIONS' (object ID 1429580131).
DBCC results for 'QPS8.QPP_CALENDARS'.
There are 0 rows in 0 pages for object "QPS8.QPP_CALENDARS".
DBCC results for 'QPS8.QPP_JOB_JACKET_DEFINITIONS'.
There are 15 rows in 1 pages for object "QPS8.QPP_JOB_JACKET_DEFINITIONS".
DBCC results for 'QPS8.QPP_PROJ_DOC_RELATIONS'.
There are 4620 rows in 113 pages for object "QPS8.QPP_PROJ_DOC_RELATIONS".
DBCC results for 'QPS8.QPP_PAUSED_TRIGGER_GRPS'.
There are 0 rows in 0 pages for object "QPS8.QPP_PAUSED_TRIGGER_GRPS".
DBCC results for 'QPS8.QPP_PROJECT_ATTACHMENTS'.
There are 9100 rows in 721 pages for object "QPS8.QPP_PROJECT_ATTACHMENTS".
DBCC results for 'QPS8.QPP_FIRED_TRIGGERS'.
There are 0 rows in 0 pages for object "QPS8.QPP_FIRED_TRIGGERS".
DBCC results for 'QPS8.QPP_JOB_JACKET_DEFAULTS'.
There are 59 rows in 1 pages for object "QPS8.QPP_JOB_JACKET_DEFAULTS".
DBCC results for 'QPS8.QPP_SCHEDULER_STATE'.
There are 0 rows in 0 pages for object "QPS8.QPP_SCHEDULER_STATE".
DBCC results for 'QPS8.QPP_RENDITION_TYPES'.
There are 6 rows in 1 pages for object "QPS8.QPP_RENDITION_TYPES".
DBCC results for 'QPS8.QPP_DEL_PROJ_ATTACHMENTS'.
There are 25 rows in 8 pages for object "QPS8.QPP_DEL_PROJ_ATTACHMENTS".
DBCC results for 'QPS8.QPP_LOCKS'.
There are 5 rows in 1 pages for object "QPS8.QPP_LOCKS".
DBCC results for 'QPS8.QPP_RENDITION_PATHS'.
There are 42943 rows in 1345 pages for object "QPS8.QPP_RENDITION_PATHS".
DBCC results for 'QPS8.QPP_PROJ_ATTACHMENT_VERSIONS'.
There are 64795 rows in 1077 pages for object "QPS8.QPP_PROJ_ATTACHMENT_VERSIONS".
DBCC results for 'QPS8.QPP_REND_PATH_VERSIONS'.
There are 225552 rows in 2838 pages for object "QPS8.QPP_REND_PATH_VERSIONS".
DBCC results for 'QPS8.QPP_ARTICLE_DIMENSIONS'.
There are 88 rows in 2 pages for object "QPS8.QPP_ARTICLE_DIMENSIONS".
DBCC results for 'QPS8.QPP_PROJ_ATTACHMENT_VALUES'.
There are 9260 rows in 411 pages for object "QPS8.QPP_PROJ_ATTACHMENT_VALUES".
DBCC results for 'sysdiagrams'.
There are 0 rows in 0 pages for object "sysdiagrams".
DBCC results for 'QPS8.QPP_FORM_DEFINITIONS'.
There are 8 rows in 2 pages for object "QPS8.QPP_FORM_DEFINITIONS".
DBCC results for 'QPS8.QPP_DEL_PROJ_ATT_VALUES'.
There are 25 rows in 4 pages for object "QPS8.QPP_DEL_PROJ_ATT_VALUES".
DBCC results for 'QPS8.QPP_REP_MAP_DEFINITIONS'.
There are 2 rows in 1 pages for object "QPS8.QPP_REP_MAP_DEFINITIONS".
DBCC results for 'QPS8.QPP_PROJ_ATTCHMNT_VAL_VERSIONS'.
There are 66116 rows in 1739 pages for object "QPS8.QPP_PROJ_ATTCHMNT_VAL_VERSIONS".
DBCC results for 'QPS8.QPP_REP_MAP_ATTRIBUTE_SETS'.
There are 158 rows in 3 pages for object "QPS8.QPP_REP_MAP_ATTRIBUTE_SETS".
DBCC results for 'QPS8.QPP_REP_MAP_SECTION_SETS'.
There are 6852 rows in 78 pages for object "QPS8.QPP_REP_MAP_SECTION_SETS".
DBCC results for 'QPS8.QPP_SCHEMA_CONTROL'.
There are 3 rows in 1 pages for object "QPS8.QPP_SCHEMA_CONTROL".
DBCC results for 'QPS8.QPP_PUBLICATION_DEFINITIONS'.
There are 11 rows in 1 pages for object "QPS8.QPP_PUBLICATION_DEFINITIONS".
DBCC results for 'QPS8.QPP_PREFERENCE_DEFINITIONS'.
There are 100 rows in 3 pages for object "QPS8.QPP_PREFERENCE_DEFINITIONS".
DBCC results for 'QPS8.QPP_PUBLICATION_TRUSTEES'.
There are 1354 rows in 14 pages for object "QPS8.QPP_PUBLICATION_TRUSTEES".
DBCC results for 'QPS8.QPP_PUBLICATION_USERCLASSES'.
There are 3 rows in 2 pages for object "QPS8.QPP_PUBLICATION_USERCLASSES".
DBCC results for 'sys.queue_messages_1977058079'.
There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".
DBCC results for 'QPS8.QPP_PREF_POSSIBLE_VALUES'.
There are 161 rows in 2 pages for object "QPS8.QPP_PREF_POSSIBLE_VALUES".
DBCC results for 'QPS8.QPP_SECTION_DEFINITIONS'.
There are 89 rows in 1 pages for object "QPS8.QPP_SECTION_DEFINITIONS".
DBCC results for 'sys.queue_messages_2009058193'.
There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".
DBCC results for 'QPS8.QPP_USER_PREF_VALUES'.
There are 5808 rows in 65 pages for object "QPS8.QPP_USER_PREF_VALUES".
DBCC results for 'QPS8.QPP_SECTION_TRUSTEES'.
There are 11289 rows in 106 pages for object "QPS8.QPP_SECTION_TRUSTEES".
DBCC results for 'sys.queue_messages_2041058307'.
There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".
DBCC results for 'QPS8.QPP_ENTITIES'.
There are 2 rows in 1 pages for object "QPS8.QPP_ENTITIES".
DBCC results for 'QPS8.QPP_USER_REDLINES'.
There are 231 rows in 2 pages for object "QPS8.QPP_USER_REDLINES".
DBCC results for 'QPS8.QPP_SECTION_USERCLASSES'.
There are 128 rows in 8 pages for object "QPS8.QPP_SECTION_USERCLASSES".
DBCC results for 'QPS8.QPP_STATUS_DEFINITIONS'.
There are 111 rows in 2 pages for object "QPS8.QPP_STATUS_DEFINITIONS".
DBCC results for 'QPS8.QPP_FILE_CLASSES'.
There are 5 rows in 1 pages for object "QPS8.QPP_FILE_CLASSES".
CHECKDB found 0 allocation errors and 3 consistency errors in database 'QPS8'.
CHECKDB fixed 0 allocation errors and 3 consistency errors in database 'QPS8'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
The statement has been terminated.

Can you advise me how I can correct the remaining errors?

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-08-12 : 06:29:30

You have duplicate values in a couple of indexes that are supposed to be unique. Specifically:

Object name 'QPS8.QPP_ARTICLE_COMP_VERSIONS' and the index name 'PK_ARTCOM_COM_VER'.
Object name 'QPS8.QPP_ARTICLE_COMP_VERSIONS' and the index name 'FK_ASSETSV_ARTCOMV_AAIDVNO'.

Drop those indexes, go in and fix the duplicate values manually (the error messages give you the key values) by either deleting the duplicate row or updating the key values, then recreate the indexes that you dropped.

--
Gail Shaw
SQL Server MVP

Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources