Aug 10, 2005
Hi, Any info will be greatly appreciated to fix this issue.
I am getting the following errors in my event log.
Error: 823, Severity: 24, State: 2
I/O error 2(The system cannot find the file specified.) detected during read at offset 0x00000004f7e000 in file 'F:Program FilesMicrosoft SQL ServerMSSQLDataPENANGwiptrack_targetpng_data2.ndf'.
I am getting these error when I run DBCC:
Server: Msg 8966, Level 16, State 2, Line 1
Could not read and latch page (3:9944) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:9945) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:9946) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:9947) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:9948) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:9949) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:9950) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:9951) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10168) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10169) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10170) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10171) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10173) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10174) with latch type UP. 2(The system cannot find the file specified.) failed.
DBCC results for 'PNG_TARGET'.
Server: Msg 8966, Level 16, State 2, Line 1
Could not read and latch page (3:10175) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10176) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10177) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10178) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10179) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10180) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10181) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10182) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10183) with latch type UP. 2(The system cannot find the file specified.) failed.
CHECKDB found 0 allocation errors and 23 consistency errors not associated with any single object.
DBCC results for 'sysobjects'.
There are 215 rows in 10 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 220 rows in 14 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 1390 rows in 78 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 187 rows in 64 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 4 rows in 1 pages for object 'sysfiles1'.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Page (1:87967) is missing a reference from previous page (3:10176). Possible chain linkage problem.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Page (1:88969) is missing a reference from previous page (3:10183). Possible chain linkage problem.
DBCC results for 'syspermissions'.
There are 221 rows in 4 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 255 rows in 4 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 0 rows in 0 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 570 rows in 8 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 0 rows in 1 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 1 pages for object 'sysfulltextcatalogs'.
DBCC results for 'sysfulltextnotify'.
There are 0 rows in 0 pages for object 'sysfulltextnotify'.
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
DBCC results for 'TblReject'.
There are 396620 rows in 10949 pages for object 'TblReject'.
DBCC results for 'TblBoxGroup'.
There are 22669 rows in 380 pages for object 'TblBoxGroup'.
DBCC results for 'TblCustShipment'.
There are 4425 rows in 83 pages for object 'TblCustShipment'.
DBCC results for 'TblFlowDetail'.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10176) allocated to object ID 421576540, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Index node page (1:90702), slot 10 refers to child page (3:10176) and previous child (3:10177), but they were not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10177) allocated to object ID 421576540, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Page (3:10177) was not seen in the scan although its parent (1:90702) and previous (1:87966) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10178) allocated to object ID 421576540, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Index node page (1:90702), slot 13 refers to child page (3:10178) and previous child (3:10179), but they were not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10179) allocated to object ID 421576540, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Page (3:10179) was not seen in the scan although its parent (1:90702) and previous (1:87967) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10180) allocated to object ID 421576540, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Index node page (1:90702), slot 14 refers to child page (3:10180) and previous child (3:10178), but they were not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10181) allocated to object ID 421576540, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Index node page (1:90702), slot 15 refers to child page (3:10181) and previous child (3:10180), but they were not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10182) allocated to object ID 421576540, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Index node page (1:90702), slot 16 refers to child page (3:10182) and previous child (3:10181), but they were not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10183) allocated to object ID 421576540, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Index node page (1:90702), slot 17 refers to child page (3:10183) and previous child (3:10182), but they were not encountered.
There are 523629 rows in 9233 pages for object 'TblFlowDetail'.
CHECKDB found 0 allocation errors and 18 consistency errors in table 'TblFlowDetail' (object ID 421576540).
DBCC results for 'TblJob'.
There are 18895 rows in 623 pages for object 'TblJob'.
DBCC results for 'TblRejectDetailCross'.
There are 0 rows in 0 pages for object 'TblRejectDetailCross'.
DBCC results for 'TblStationChkPoint'.
There are 298610 rows in 6273 pages for object 'TblStationChkPoint'.
DBCC results for 'ci_control_TblBoxGroup'.
There are 0 rows in 1 pages for object 'ci_control_TblBoxGroup'.
DBCC results for 'ci_control_TblCustomer'.
There are 0 rows in 0 pages for object 'ci_control_TblCustomer'.
DBCC results for 'TblLine'.
There are 7 rows in 1 pages for object 'TblLine'.
DBCC results for 'ci_control_TblCustShipment'.
There are 0 rows in 1 pages for object 'ci_control_TblCustShipment'.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (1:65650) is missing a reference from previous page (3:9950). Possible chain linkage problem.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (1:80141) is missing a reference from previous page (3:9949). Possible chain linkage problem.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (1:81931) is missing a reference from previous page (3:9948). Possible chain linkage problem.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (1:88745) is missing a reference from previous page (3:9944). Possible chain linkage problem.
DBCC results for 'ci_control_TblDefect'.
There are 0 rows in 1 pages for object 'ci_control_TblDefect'.
DBCC results for 'ci_control_TblFlowDetail'.
There are 0 rows in 1 pages for object 'ci_control_TblFlowDetail'.
DBCC results for 'TblStationQty'.
There are 487814 rows in 8946 pages for object 'TblStationQty'.
DBCC results for 'TblMachine'.
There are 5 rows in 1 pages for object 'TblMachine'.
DBCC results for 'ci_control_TblJob'.
There are 0 rows in 1 pages for object 'ci_control_TblJob'.
DBCC results for 'ci_control_TblJobDetail'.
There are 0 rows in 1 pages for object 'ci_control_TblJobDetail'.
DBCC results for 'TblOperator'.
There are 470 rows in 7 pages for object 'TblOperator'.
DBCC results for 'ci_control_TblLine'.
There are 0 rows in 0 pages for object 'ci_control_TblLine'.
DBCC results for 'TblOperatorGroup'.
There are 22 rows in 1 pages for object 'TblOperatorGroup'.
DBCC results for 'TblTransaction'.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (1:91159) is missing a reference from previous page (3:9945). Possible chain linkage problem.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (1:95791) is missing a reference from previous page (3:9951). Possible chain linkage problem.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (1:857249) is missing a reference from previous page (3:9946). Possible chain linkage problem.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (3:9630) is missing a reference from previous page (3:9947). Possible chain linkage problem.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:9944) allocated to object ID 768057822, index ID 4 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (3:9944) was not seen in the scan although its parent (1:86516) and previous (3:10996) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:9945) allocated to object ID 768057822, index ID 4 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (3:9945) was not seen in the scan although its parent (1:862260) and previous (1:81719) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:9946) allocated to object ID 768057822, index ID 4 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (3:9946) was not seen in the scan although its parent (1:2888) and previous (1:39804) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:9947) allocated to object ID 768057822, index ID 4 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (3:9947) was not seen in the scan although its parent (1:858889) and previous (1:84220) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:9948) allocated to object ID 768057822, index ID 4 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (3:9948) was not seen in the scan although its parent (1:51120) and previous (1:81279) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:9949) allocated to object ID 768057822, index ID 4 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (3:9949) was not seen in the scan although its parent (1:81180) and previous (1:79351) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:9950) allocated to object ID 768057822, index ID 4 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (3:9950) was not seen in the scan although its parent (1:51120) and previous (1:65448) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:9951) allocated to object ID 768057822, index ID 4 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (3:9951) was not seen in the scan although its parent (1:60668) and previous (1:87177) refer to it. Check any previous errors.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (1:921) is missing a reference from previous page (3:10169). Possible chain linkage problem.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:17475) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:55333) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:58600) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:66724) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:73049) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:73183) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:77526) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:80853) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:82680) was not encountered.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (1:83104) is missing a reference from previous page (3:10170). Possible chain linkage problem.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:83310) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:85752) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:87603) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:91416) was not encountered.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (1:91418) is missing a reference from previous page (3:10173). Possible chain linkage problem.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:92037) was not encountered.
Server: Msg 8979, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (1:92278) is missing references from parent (unknown) and previous (page (3:10168)) nodes. Possible bad root entry in sysindexes.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:94476) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:98109) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:99231) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:100289) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:103626) was not encountered.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (1:104154) is missing a reference from previous page (3:10175). Possible chain linkage problem.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:104303) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:107339) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:110106) was not encountered.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (1:985785) is missing a reference from previous page (3:10174). Possible chain linkage problem.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989636) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989637) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989638) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989639) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989640) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989641) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989642) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989643) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989644) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989645) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989646) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989647) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989648) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989649) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989650) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989651) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989652) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989653) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989654) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989655) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989656) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989657) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989658) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989659) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989660) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989661) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989662) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989663) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989664) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989665) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989666) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989667) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989668) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989669) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989670) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989671) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989672) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989673) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989674) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989675) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989676) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989677) was not encountered.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (1:990949) is missing a reference from previous page (3:10171). Possible chain linkage problem.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (3:4460) was not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10168) allocated to object ID 768057822, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8981, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. The next pointer of (1:83310) refers to page (3:10168). Neither (3:10168) nor its parent were encountered. Possible bad chain linkage.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10169) allocated to object ID 768057822, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (3:10169) was not seen in the scan although its parent (1:9152) and previous (1:989626) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10170) allocated to object ID 768057822, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (3:10170) was not seen in the scan although its parent (1:76565) and previous (1:83980) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10171) allocated to object ID 768057822, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (3:10171) was not seen in the scan although its parent (1:925) and previous (1:34912) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10173) allocated to object ID 768057822, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (3:10173) was not seen in the scan although its parent (1:76565) and previous (1:78785) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10174) allocated to object ID 768057822, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (3:10174) was not seen in the scan although its parent (1:985742) and previous (1:80575) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10175) allocated to object ID 768057822, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (3:10175) was not seen in the scan although its parent (1:88169) and previous (1:83978) refer to it. Check any previous errors.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (3:10339) was not encountered.
There are 4277643 rows in 97804 pages for object 'TblTransaction'.
CHECKDB found 0 allocation errors and 111 consistency errors in table 'TblTransaction' (object ID 768057822).
DBCC results for 'ci_control_TblLot'.
There are 0 rows in 1 pages for object 'ci_control_TblLot'.
DBCC results for 'ci_control_TblMachine'.
There are 0 rows in 0 pages for object 'ci_control_TblMachine'.
DBCC results for 'ci_control_TblOperator'.
There are 0 rows in 1 pages for object 'ci_control_TblOperator'.
DBCC results for 'ci_control_TblOperatorGroup'.
There are 0 rows in 0 pages for object 'ci_control_TblOperatorGroup'.
DBCC results for 'TtmpTransaction'.
There are 0 rows in 0 pages for object 'TtmpTransaction'.
DBCC results for 'TblCPQWeekNbr'.
There are 53 rows in 1 pages for object 'TblCPQWeekNbr'.
DBCC results for 'ci_control_TblPartDetail'.
There are 0 rows in 1 pages for object 'ci_control_TblPartDetail'.
DBCC results for 'TblCPQYearNbr'.
There are 180 rows in 1 pages for object 'TblCPQYearNbr'.
DBCC results for 'TblKitModSNRship'.
There are 472666 rows in 5462 pages for object 'TblKitModSNRship'.
DBCC results for 'ci_control_TblPartSupplier'.
There are 0 rows in 0 pages for object 'ci_control_TblPartSupplier'.
DBCC results for 'TblShift'.
There are 3 rows in 1 pages for object 'TblShift'.
DBCC results for 'ci_control_TblReject'.
There are 0 rows in 1 pages for object 'ci_control_TblReject'.
DBCC results for 'ci_control_TblRejectDetail'.
There are 0 rows in 1 pages for object 'ci_control_TblRejectDetail'.
DBCC results for 'ci_control_TblShift'.
There are 0 rows in 0 pages for object 'ci_control_TblShift'.
DBCC results for 'ci_control_TblStation'.
There are 0 rows in 1 pages for object 'ci_control_TblStation'.
DBCC results for 'ci_control_TblStationChkPoint'.
There are 0 rows in 1 pages for object 'ci_control_TblStationChkPoint'.
DBCC results for 'ci_control_TblStationQty'.
There are 3 rows in 1 pages for object 'ci_control_TblStationQty'.
DBCC results for 'ci_control_TblTester'.
There are 0 rows in 0 pages for object 'ci_control_TblTester'.
DBCC results for 'ci_control_TblTransaction'.
There are 0 rows in 1 pages for object 'ci_control_TblTransaction'.
DBCC results for 'TblCustomer'.
There are 7 rows in 1 pages for object 'TblCustomer'.
DBCC results for 'TblTester'.
There are 16 rows in 1 pages for object 'TblTester'.
DBCC results for 'ci_control_TblKitModSNRship'.
There are 0 rows in 1 pages for object 'ci_control_TblKitModSNRship'.
DBCC results for 'ci_control_TblSystemBuild'.
There are 1 rows in 1 pages for object 'ci_control_TblSystemBuild'.
DBCC results for 'TblRejectDetail'.
There are 104402 rows in 2403 pages for object 'TblRejectDetail'.
DBCC results for 'TblJobDetail'.
There are 1107946 rows in 23608 pages for object 'TblJobDetail'.
DBCC results for 'TblPartSupplier'.
There are 79 rows in 1 pages for object 'TblPartSupplier'.
DBCC results for 'TblDefect'.
There are 21113 rows in 337 pages for object 'TblDefect'.
DBCC results for 'png_ci_TblRowCount'.
There are 24 rows in 1 pages for object 'png_ci_TblRowCount'.
DBCC results for 'TblTbSetup'.
There are 1 rows in 1 pages for object 'TblTbSetup'.
DBCC results for 'TblStationQty1'.
There are 61755 rows in 974 pages for object 'TblStationQty1'.
DBCC results for 'TtmpStationProdLoad'.
There are 57 rows in 1 pages for object 'TtmpStationProdLoad'.
DBCC results for 'TblPartDetail'.
There are 3053 rows in 93 pages for object 'TblPartDetail'.
DBCC results for 'TblLot'.
There are 515677 rows in 11268 pages for object 'TblLot'.
DBCC results for 'TblStation'.
There are 474 rows in 11 pages for object 'TblStation'.
DBCC results for 'TblSystemBuild'.
There are 128623 rows in 2362 pages for object 'TblSystemBuild'.
DBCC results for 'dtproperties'.
There are 0 rows in 1 pages for object 'dtproperties'.
DBCC results for 'TblEqMaster'.
There are 0 rows in 1 pages for object 'TblEqMaster'.
DBCC results for 'TblEqMasterSNRShip'.
There are 0 rows in 1 pages for object 'TblEqMasterSNRShip'.
CHECKDB found 0 allocation errors and 152 consistency errors in database 'PNG_TARGET'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (PNG_TARGET ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
View 4 Replies
View Related