Error 644 - Index Error

Aug 4, 2006

We have encountered this error and we need help tp be resolved. Please view the following result after running DBCC CHECKDB :

DBCC results for 'KOTRA_App'.
DBCC results for 'sysobjects'.
There are 22423 rows in 349 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 5895 rows in 316 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 55026 rows in 1087 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 1357 rows in 22 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 32250 rows in 14096 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 50 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 12 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 813 rows in 9 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 127027 rows in 792 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 1426 rows in 10 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 0 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 'unitcd3'.
There are 0 rows in 0 pages for object 'unitcd3'.
DBCC results for 'RESATTR000'.
There are 0 rows in 0 pages for object 'RESATTR000'.
DBCC results for 'site_compression'.
There are 0 rows in 0 pages for object 'site_compression'.
DBCC results for 'APPCFG'.
There are 1 rows in 1 pages for object 'APPCFG'.
DBCC results for 'org_cpny'.
There are 0 rows in 0 pages for object 'org_cpny'.
DBCC results for 'experience'.
There are 0 rows in 0 pages for object 'experience'.
DBCC results for 'commdue_all'.
There are 0 rows in 0 pages for object 'commdue_all'.
DBCC results for 'unitcd3_all'.
There are 0 rows in 0 pages for object 'unitcd3_all'.
DBCC results for 'RESLOAD000'.
There are 0 rows in 0 pages for object 'RESLOAD000'.
DBCC results for 'site_group'.
There are 1 rows in 1 pages for object 'site_group'.
DBCC results for 'APPSTRING'.
There are 0 rows in 0 pages for object 'APPSTRING'.
DBCC results for 'parms'.
There are 1 rows in 1 pages for object 'parms'.
DBCC results for 'export_aptrx'.
There are 0 rows in 0 pages for object 'export_aptrx'.
DBCC results for 'commodity'.
There are 0 rows in 0 pages for object 'commodity'.
DBCC results for 'unitcd4'.
There are 0 rows in 0 pages for object 'unitcd4'.
DBCC results for 'RESMNT000'.
There are 0 rows in 0 pages for object 'RESMNT000'.
DBCC results for 'site_hierarchy'.
There are 1 rows in 1 pages for object 'site_hierarchy'.
DBCC results for 'APPSTRLIST'.
There are 0 rows in 0 pages for object 'APPSTRLIST'.
DBCC results for 'parms_all'.
There are 1 rows in 1 pages for object 'parms_all'.
DBCC results for 'export_aptrxd'.
There are 0 rows in 0 pages for object 'export_aptrxd'.
DBCC results for 'commtab'.
There are 0 rows in 0 pages for object 'commtab'.
DBCC results for 'unitcd4_all'.
There are 0 rows in 0 pages for object 'unitcd4_all'.
DBCC results for 'RESPAIR000'.
There are 0 rows in 0 pages for object 'RESPAIR000'.
DBCC results for 'tmp_aps_sync'.
There are 16391 rows in 326 pages for object 'tmp_aps_sync'.
DBCC results for 'site_link_info'.
There are 0 rows in 0 pages for object 'site_link_info'.
DBCC results for 'APSSITE'.
There are 0 rows in 0 pages for object 'APSSITE'.
DBCC results for 'pck_hdr'.
There are 0 rows in 0 pages for object 'pck_hdr'.
DBCC results for 'export_arinv'.
There are 0 rows in 0 pages for object 'export_arinv'.
DBCC results for 'commtran'.
There are 0 rows in 0 pages for object 'commtran'.
DBCC results for 'user_class'.
There are 1 rows in 1 pages for object 'user_class'.
DBCC results for 'RESPLAN000'.
There are 0 rows in 0 pages for object 'RESPLAN000'.
DBCC results for 'site_live_link'.
There are 0 rows in 0 pages for object 'site_live_link'.
DBCC results for 'ATTRIB000'.
There are 0 rows in 0 pages for object 'ATTRIB000'.
DBCC results for 'pckitem'.
There are 0 rows in 0 pages for object 'pckitem'.
DBCC results for 'export_arinvd'.
There are 0 rows in 0 pages for object 'export_arinvd'.
DBCC results for 'con_inv_hdr'.
There are 0 rows in 0 pages for object 'con_inv_hdr'.
DBCC results for 'user_class_committed'.
There are 0 rows in 0 pages for object 'user_class_committed'.
DBCC results for 'RESQ000'.
There are 0 rows in 0 pages for object 'RESQ000'.
DBCC results for 'sitenet'.
There are 0 rows in 0 pages for object 'sitenet'.
DBCC results for 'AccountAuthorizations'.
There are 5893 rows in 138 pages for object 'AccountAuthorizations'.
DBCC results for 'per_sort'.
There are 0 rows in 0 pages for object 'per_sort'.
DBCC results for 'extfin_parms'.
There are 1 rows in 1 pages for object 'extfin_parms'.
DBCC results for 'con_inv_item'.
There are 0 rows in 0 pages for object 'con_inv_item'.
DBCC results for 'user_class_fld'.
There are 1 rows in 1 pages for object 'user_class_fld'.
DBCC results for 'RESRC000'.
There are 116 rows in 7 pages for object 'RESRC000'.
DBCC results for 'skill'.
There are 0 rows in 0 pages for object 'skill'.
DBCC results for 'ActiveBGTasks'.
There are 0 rows in 0 pages for object 'ActiveBGTasks'.
DBCC results for 'per_sort_all'.
There are 0 rows in 0 pages for object 'per_sort_all'.
DBCC results for 'fabonus'.
There are 0 rows in 0 pages for object 'fabonus'.
DBCC results for 'con_inv_line'.
There are 0 rows in 0 pages for object 'con_inv_line'.
DBCC results for 'user_class_fld_committed'.
There are 0 rows in 0 pages for object 'user_class_fld_committed'.
DBCC results for 'RESSCHD000'.
There are 0 rows in 0 pages for object 'RESSCHD000'.
DBCC results for 'slparms'.
There are 0 rows in 0 pages for object 'slparms'.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:92560) allocated to object ID 133575514, index ID 0 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 133575514, index ID 1. Page (1:92560) was not seen in the scan although its parent (1:140572) and previous (1:92407) refer to it. Check any previous errors.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 133575514, index ID 1. Page (1:92561) is missing a reference from previous page (1:92560). Possible chain linkage problem.
DBCC results for 'tmp_jobmatl_copy'.
There are 0 rows in 0 pages for object 'tmp_jobmatl_copy'.
DBCC results for 'ApplicationMessages'.
There are 4072 rows in 66 pages for object 'ApplicationMessages'.
DBCC results for 'per_unit'.
There are 0 rows in 0 pages for object 'per_unit'.
DBCC results for 'faclass'.
There are 13 rows in 1 pages for object 'faclass'.
DBCC results for 'coparms'.
There are 1 rows in 1 pages for object 'coparms'.
DBCC results for 'user_class_fld_impacted'.
There are 0 rows in 0 pages for object 'user_class_fld_impacted'.
DBCC results for 'RESSEND000'.
There are 0 rows in 0 pages for object 'RESSEND000'.
DBCC results for 'slsclass'.
There are 7 rows in 1 pages for object 'slsclass'.
DBCC results for 'AuditLog'.
There are 978910 rows in 24693 pages for object 'AuditLog'.
CHECKDB found 0 allocation errors and 3 consistency errors in table 'AuditLog' (object ID 133575514).
DBCC results for 'per_unit_all'.
There are 0 rows in 0 pages for object 'per_unit_all'.
DBCC results for 'facost'.
There are 224 rows in 4 pages for object 'facost'.
DBCC results for 'coparms_all'.
There are 1 rows in 1 pages for object 'coparms_all'.
DBCC results for 'user_class_impacted'.
There are 0 rows in 0 pages for object 'user_class_impacted'.
DBCC results for 'RESSUM000'.
There are 0 rows in 0 pages for object 'RESSUM000'.
DBCC results for 'slsman'.
There are 352 rows in 15 pages for object 'slsman'.
DBCC results for 'AuditLogTypes'.
There are 472 rows in 7 pages for object 'AuditLogTypes'.
DBCC results for 'periods'.
There are 10 rows in 1 pages for object 'periods'.
DBCC results for 'fadepr'.
There are 227 rows in 6 pages for object 'fadepr'.
DBCC results for 'costcode'.
There are 0 rows in 0 pages for object 'costcode'.
DBCC results for 'user_class_record_assoc'.
There are 0 rows in 0 pages for object 'user_class_record_assoc'.
DBCC results for 'RGATTR000'.
There are 0 rows in 0 pages for object 'RGATTR000'.
DBCC results for 'slsman_all'.
There are 352 rows in 6 pages for object 'slsman_all'.
DBCC results for 'BATCH000'.
There are 0 rows in 0 pages for object 'BATCH000'.
DBCC results for 'periods_all'.
There are 10 rows in 1 pages for object 'periods_all'.
DBCC results for 'fadeptab'.
There are 1 rows in 1 pages for object 'fadeptab'.
DBCC results for 'country'.
There are 25 rows in 1 pages for object 'country'.
DBCC results for 'user_fld'.
There are 1 rows in 1 pages for object 'user_fld'.
DBCC results for 'RGLOAD000'.
There are 0 rows in 0 pages for object 'RGLOAD000'.
DBCC results for 'ssd'.
There are 0 rows in 0 pages for object 'ssd'.
DBCC results for 'BATRL000'.
There are 0 rows in 0 pages for object 'BATRL000'.
DBCC results for 'periods_seq'.
There are 70 rows in 3 pages for object 'periods_seq'.
DBCC results for 'fadisp'.
There are 0 rows in 0 pages for object 'fadisp'.
DBCC results for 'country_all'.
There are 25 rows in 1 pages for object 'country_all'.
DBCC results for 'user_fld_committed'.
There are 0 rows in 0 pages for object 'user_fld_committed'.
DBCC results for 'RGRP000'.
There are 53 rows in 1 pages for object 'RGRP000'.
DBCC results for 'state'.
There are 16 rows in 1 pages for object 'state'.
DBCC results for 'BATSUM000'.
There are 0 rows in 0 pages for object 'BATSUM000'.
DBCC results for 'pertot'.
There are 0 rows in 0 pages for object 'pertot'.
DBCC results for 'fadist'.
There are 0 rows in 0 pages for object 'fadist'.
DBCC results for 'course'.
There are 0 rows in 0 pages for object 'course'.
DBCC results for 'user_fld_impacted'.
There are 0 rows in 0 pages for object 'user_fld_impacted'.
DBCC results for 'RGRPMBR000'.
There are 116 rows in 2 pages for object 'RGRPMBR000'.
DBCC results for 'sup_edi_parms'.
There are 0 rows in 0 pages for object 'sup_edi_parms'.
DBCC results for 'BATTIME000'.
There are 0 rows in 0 pages for object 'BATTIME000'.
DBCC results for 'pertot_all'.
There are 0 rows in 0 pages for object 'pertot_all'.
DBCC results for 'famaster'.
There are 224 rows in 10 pages for object 'famaster'.
DBCC results for 'ctc_log'.
There are 0 rows in 0 pages for object 'ctc_log'.
DBCC results for 'user_index'.
There are 1 rows in 1 pages for object 'user_index'.
DBCC results for 'RGRPSUM000'.
There are 0 rows in 0 pages for object 'RGRPSUM000'.
DBCC results for 'system_type'.
There are 11 rows in 1 pages for object 'system_type'.
DBCC results for 'artranTemp'.
There are 0 rows in 0 pages for object 'artranTemp'.
DBCC results for 'BATWAIT000'.
There are 0 rows in 0 pages for object 'BATWAIT000'.
DBCC results for 'phyinv'.
There are 0 rows in 0 pages for object 'phyinv'.
DBCC results for 'famcode'.
There are 0 rows in 0 pages for object 'famcode'.
DBCC results for 'curr_uk'.
There are 0 rows in 0 pages for object 'curr_uk'.
DBCC results for 'user_index_committed'.
There are 0 rows in 0 pages for object 'user_index_committed'.
DBCC results for 'ReplicatedRows3'.
There are 0 rows in 0 pages for object 'ReplicatedRows3'.
DBCC results for 'table_class'.
There are 374 rows in 21 pages for object 'table_class'.
DBCC results for 'BGTaskDefinitions'.
There are 536 rows in 20 pages for object 'BGTaskDefinitions'.
DBCC results for 'phytags'.
There are 5 rows in 1 pages for object 'phytags'.
DBCC results for 'faparms'.
There are 1 rows in 1 pages for object 'faparms'.
DBCC results for 'curr_uk_all'.
There are 0 rows in 0 pages for object 'curr_uk_all'.
DBCC results for 'user_index_fld'.
There are 1 rows in 1 pages for object 'user_index_fld'.
DBCC results for 'ReplicatedRowsErrors'.
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'BGTaskHistory' (ID 261575970). Missing or invalid key in index 'IX_BGTaskHistory_RowPointer' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:89662:11) identified by (RID = (1:89662:11) ) has index values (RowPointer = A41369EA-8888-493C-8B7A-F47922383FA6h¢¿).
There are 0 rows in 0 pages for object 'ReplicatedRowsErrors'.
DBCC results for 'table_class_committed'.
There are 0 rows in 0 pages for object 'table_class_committed'.
DBCC results for 'BGTaskHistory'.
There are 144344 rows in 19374 pages for object 'BGTaskHistory'.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'BGTaskHistory' (object ID 261575970).
DBCC results for 'pitemh'.
There are 934 rows in 77 pages for object 'pitemh'.
DBCC results for 'fatran'.
There are 0 rows in 0 pages for object 'fatran'.
DBCC results for 'curracct'.
There are 4 rows in 1 pages for object 'curracct'.
DBCC results for 'user_index_fld_committed'.
There are 0 rows in 0 pages for object 'user_index_fld_committed'.
DBCC results for 'ReplicationOperationCounter'.
There are 0 rows in 0 pages for object 'ReplicationOperationCounter'.
DBCC results for 'table_class_impacted'.
There are 0 rows in 0 pages for object 'table_class_impacted'.
DBCC results for 'BOM000'.
There are 1630 rows in 245 pages for object 'BOM000'.
DBCC results for 'plan_ra'.
There are 0 rows in 0 pages for object 'plan_ra'.
DBCC results for 'featqty'.
There are 0 rows in 0 pages for object 'featqty'.
DBCC results for 'curracct_all'.
There are 4 rows in 1 pages for object 'curracct_all'.
DBCC results for 'user_index_fld_impacted'.
There are 0 rows in 0 pages for object 'user_index_fld_impacted'.
DBCC results for 'ReportOptions'.
There are 106 rows in 2 pages for object 'ReportOptions'.
DBCC results for 'tax_item_jur'.
There are 0 rows in 0 pages for object 'tax_item_jur'.
DBCC results for 'CAL000'.
There are 10 rows in 1 pages for object 'CAL000'.
DBCC results for 'po'.
There are 6203 rows in 618 pages for object 'po'.
DBCC results for 'featqty_all'.
There are 0 rows in 0 pages for object 'featqty_all'.
DBCC results for 'currate'.
There are 219 rows in 4 pages for object 'currate'.
DBCC results for 'user_index_impacted'.
There are 0 rows in 0 pages for object 'user_index_impacted'.
DBCC results for 'ReusableNotesToSite'.
There are 0 rows in 0 pages for object 'ReusableNotesToSite'.
DBCC results for 'tax_item_jur_all'.
There are 0 rows in 0 pages for object 'tax_item_jur_all'.
DBCC results for 'ClassNotes'.
There are 0 rows in 0 pages for object 'ClassNotes'.
DBCC results for 'po_all'.
There are 6203 rows in 83 pages for object 'po_all'.
DBCC results for 'featrank'.
There are 0 rows in 0 pages for object 'featrank'.
DBCC results for 'currate_all'.
There are 219 rows in 4 pages for object 'currate_all'.
DBCC results for 'user_local'.
There are 53 rows in 1 pages for object 'user_local'.
DBCC results for 'SCHEDOP000'.
There are 0 rows in 0 pages for object 'SCHEDOP000'.
DBCC results for 'tax_jur'.
There are 1 rows in 1 pages for object 'tax_jur'.
DBCC results for 'ConnectionInformation'.
There are 5 rows in 4 pages for object 'ConnectionInformation'.
DBCC results for 'po_bln'.
There are 1 rows in 1 pages for object 'po_bln'.
DBCC results for 'featrank_all'.
There are 0 rows in 0 pages for object 'featrank_all'.
DBCC results for 'currency'.
There are 12 rows in 1 pages for object 'currency'.
DBCC results for 'vacation'.
There are 0 rows in 0 pages for object 'vacation'.
DBCC results for 'SHIFT000'.
There are 11 rows in 1 pages for object 'SHIFT000'.
DBCC results for 'tax_jur_all'.
There are 1 rows in 1 pages for object 'tax_jur_all'.
DBCC results for 'DOWN000'.
There are 0 rows in 0 pages for object 'DOWN000'.
DBCC results for 'po_bln_all'.
There are 1 rows in 1 pages for object 'po_bln_all'.
DBCC results for 'feature'.
There are 0 rows in 0 pages for object 'feature'.
DBCC results for 'currency_all'.
There are 12 rows in 1 pages for object 'currency_all'.
DBCC results for 'vacparms'.
There are 0 rows in 0 pages for object 'vacparms'.
DBCC results for 'SHIFTEXDI000'.
There are 0 rows in 0 pages for object 'SHIFTEXDI000'.
DBCC results for 'tax_system'.
There are 1 rows in 1 pages for object 'tax_system'.
DBCC results for 'DOWNPLAN000'.
There are 0 rows in 0 pages for object 'DOWNPLAN000'.
DBCC results for 'po_lang'.
There are 0 rows in 0 pages for object 'po_lang'.
DBCC results for 'feature_all'.
There are 0 rows in 0 pages for object 'feature_all'.
DBCC results for 'currparms'.
There are 1 rows in 1 pages for object 'currparms'.
DBCC results for 'vch_dist'.
There are 34807 rows in 776 pages for object 'vch_dist'.
DBCC results for 'SampleTable_1'.
There are 0 rows in 0 pages for object 'SampleTable_1'.
DBCC results for 'tax_system_all'.
There are 1 rows in 1 pages for object 'tax_system_all'.
DBCC results for 'DefaultTypes'.
There are 4 rows in 1 pages for object 'DefaultTypes'.
DBCC results for 'po_rcpt'.
There are 16536 rows in 550 pages for object 'po_rcpt'.
DBCC results for 'fingroup'.
There are 0 rows in 0 pages for object 'fingroup'.
DBCC results for 'currparms_all'.
There are 1 rows in 1 pages for object 'currparms_all'.
DBCC results for 'vch_hdr'.
There are 32755 rows in 1291 pages for object 'vch_hdr'.
DBCC results for 'SessionContextNames'.
There are 116 rows in 3 pages for object 'SessionContextNames'.
DBCC results for 'taxcode'.
There are 1 rows in 1 pages for object 'taxcode'.
DBCC results for 'DefineVariables'.
There are 61 rows in 6 pages for object 'DefineVariables'.
DBCC results for 'po_vch'.
There are 36187 rows in 889 pages for object 'po_vch'.
DBCC results for 'forecast'.
There are 0 rows in 1 pages for object 'forecast'.
DBCC results for 'cust_lcr'.
There are 0 rows in 0 pages for object 'cust_lcr'.
DBCC results for 'vch_hdr_all'.
There are 32755 rows in 718 pages for object 'vch_hdr_all'.
DBCC results for 'ShadowValues'.
There are 0 rows in 0 pages for object 'ShadowValues'.
DBCC results for 'taxcode_all'.
There are 1 rows in 1 pages for object 'taxcode_all'.
DBCC results for 'DocProfileCustomer'.
There are 0 rows in 0 pages for object 'DocProfileCustomer'.
DBCC results for 'poblnchg'.
There are 0 rows in 0 pages for object 'poblnchg'.
DBCC results for 'frzcost'.
There are 888 rows in 41 pages for object 'frzcost'.
DBCC results for 'cust_lcr_all'.
There are 0 rows in 0 pages for object 'cust_lcr_all'.
DBCC results for 'vch_item'.
There are 15979 rows in 418 pages for object 'vch_item'.
DBCC results for 'ShadowValuesErrors'.
There are 0 rows in 0 pages for object 'ShadowValuesErrors'.
DBCC results for 'taxparms'.
There are 1 rows in 1 pages for object 'taxparms'.
DBCC results for 'DocProfileVendor'.
There are 0 rows in 0 pages for object 'DocProfileVendor'.
DBCC results for 'poblnh'.
There are 0 rows in 0 pages for object 'poblnh'.
DBCC results for 'glbank'.
There are 9743 rows in 213 pages for object 'glbank'.
DBCC results for 'cust_tp'.
There are 0 rows in 0 pages for object 'cust_tp'.
DBCC results for 'vch_item_all'.
There are 15979 rows in 306 pages for object 'vch_item_all'.
DBCC results for 'SiteUserMap'.
There are 0 rows in 0 pages for object 'SiteUserMap'.
DBCC results for 'taxparms_all'.
There are 1 rows in 1 pages for object 'taxparms_all'.
DBCC results for 'EFFECT000'.
There are 5010 rows in 251 pages for object 'EFFECT000'.
DBCC results for 'pochange'.
There are 2906 rows in 57 pages for object 'pochange'.
DBCC results for 'glrpth'.
There are 0 rows in 1 pages for object 'glrpth'.
DBCC results for 'custaddr'.
There are 7094 rows in 524 pages for object 'custaddr'.
DBCC results for 'vch_pr'.
There are 0 rows in 0 pages for object 'vch_pr'.
DBCC results for 'SpecificNotes'.
There are 703271 rows in 8916 pages for object 'SpecificNotes'.
DBCC results for 'term_lang'.
There are 0 rows in 0 pages for object 'term_lang'.
DBCC results for 'ERDB'.
There are 0 rows in 0 pages for object 'ERDB'.
DBCC results for 'pochg'.
There are 130 rows in 14 pages for object 'pochg'.
DBCC results for 'glrpthc'.
There are 0 rows in 1 pages for object 'glrpthc'.
DBCC results for 'custdrft'.
There are 0 rows in 0 pages for object 'custdrft'.
DBCC results for 'vch_pr_all'.
There are 0 rows in 0 pages for object 'vch_pr_all'.
DBCC results for 'SystemNotes'.
There are 1 rows in 1 pages for object 'SystemNotes'.
DBCC results for 'termination'.
There are 0 rows in 0 pages for object 'termination'.
DBCC results for 'slsmanTemp'.
There are 252 rows in 6 pages for object 'slsmanTemp'.
DBCC results for 'ERDBGW'.
There are 0 rows in 0 pages for object 'ERDBGW'.
DBCC results for 'poh'.
There are 480 rows in 47 pages for object 'poh'.
DBCC results for 'glrptl'.
There are 0 rows in 1 pages for object 'glrptl'.
DBCC results for 'custdrft_all'.
There are 0 rows in 0 pages for object 'custdrft_all'.
DBCC results for 'vch_pr_stax'.
There are 0 rows in 0 pages for object 'vch_pr_stax'.
DBCC results for 'SystemProcessDefaults'.
There are 4 rows in 1 pages for object 'SystemProcessDefaults'.
DBCC results for 'terms'.
There are 17 rows in 1 pages for object 'terms'.
DBCC results for 'ERRORLOG'.
There are 0 rows in 0 pages for object 'ERRORLOG'.
DBCC results for 'poitem'.
There are 13098 rows in 1030 pages for object 'poitem'.
DBCC results for 'glrptl_all'.
There are 0 rows in 1 pages for object 'glrptl_all'.
DBCC results for 'custlog'.
There are 1 rows in 1 pages for object 'custlog'.
DBCC results for 'vch_pr_stax_all'.
There are 0 rows in 0 pages for object 'vch_pr_stax_all'.
DBCC results for 'TBLLIST000'.
There are 0 rows in 0 pages for object 'TBLLIST000'.
DBCC results for 'terms_all'.
There are 17 rows in 1 pages for object 'terms_all'.
DBCC results for 'FDBVER'.
There are 1 rows in 1 pages for object 'FDBVER'.
DBCC results for 'poitem_all'.
There are 13098 rows in 236 pages for object 'poitem_all'.
DBCC results for 'glrptlc'.
There are 0 rows in 1 pages for object 'glrptlc'.
DBCC results for 'customer'.
There are 7094 rows in 842 pages for object 'customer'.
DBCC results for 'vch_stax'.
There are 0 rows in 0 pages for object 'vch_stax'.
DBCC results for 'TODEMAND000'.
There are 0 rows in 0 pages for object 'TODEMAND000'.
DBCC results for 'tick_cal'.
There are 330 rows in 35 pages for object 'tick_cal'.
DBCC results for 'FIELDS'.
There are 1151 rows in 16 pages for object 'FIELDS'.
DBCC results for 'poitmchg'.
There are 10264 rows in 749 pages for object 'poitmchg'.
DBCC results for 'glrptls'.
There are 0 rows in 1 pages for object 'glrptls'.
DBCC results for 'customer_all'.
There are 7094 rows in 368 pages for object 'customer_all'.
DBCC results for 'vch_stax_all'.
There are 0 rows in 0 pages for object 'vch_stax_all'.
DBCC results for 'TOODP000'.
There are 0 rows in 0 pages for object 'TOODP000'.
DBCC results for 'time_zone'.
There are 88 rows in 2 pages for object 'time_zone'.
DBCC results for 'GNTHLCAT'.
There are 0 rows in 0 pages for object 'GNTHLCAT'.
DBCC results for 'poparms'.
There are 1 rows in 1 pages for object 'poparms'.
DBCC results for 'grn_hdr'.
There are 1 rows in 1 pages for object 'grn_hdr'.
DBCC results for 'custtype'.
There are 24 rows in 1 pages for object 'custtype'.
DBCC results for 'vend_lcr'.
There are 0 rows in 0 pages for object 'vend_lcr'.
DBCC results for 'TOSUPPLY000'.
There are 0 rows in 0 pages for object 'TOSUPPLY000'.
DBCC results for 'timeatt'.
There are 0 rows in 0 pages for object 'timeatt'.
DBCC results for 'GNTHLCRIT'.
There are 0 rows in 0 pages for object 'GNTHLCRIT'.
DBCC results for 'pos_chg'.
There are 0 rows in 0 pages for object 'pos_chg'.
DBCC results for 'grn_line'.
There are 1 rows in 1 pages for object 'grn_line'.
DBCC results for 'custtype_all'.
There are 24 rows in 1 pages for object 'custtype_all'.
DBCC results for 'vend_tp'.
There are 0 rows in 0 pages for object 'vend_tp'.
DBCC results for 'TRACELOG000'.
There are 0 rows in 0 pages for object 'TRACELOG000'.
DBCC results for 'tmp_MessageBuffer'.
There are 0 rows in 0 pages for object 'tmp_MessageBuffer'.
DBCC results for 'GNTSELCAT'.
There are 0 rows in 0 pages for object 'GNTSELCAT'.
DBCC results for 'pos_class'.
There are 0 rows in 0 pages for object 'pos_class'.
DBCC results for 'horizon'.
There are 0 rows in 0 pages for object 'horizon'.
DBCC results for 'cycle'.
There are 0 rows in 1 pages for object 'cycle'.
DBCC results for 'vendaddr'.
There are 814 rows in 56 pages for object 'vendaddr'.
DBCC results for 'TaskExclusion'.
There are 0 rows in 0 pages for object 'TaskExclusion'.
DBCC results for 'tmp_apdraftt'.
There are 0 rows in 0 pages for object 'tmp_apdraftt'.
DBCC results for 'GNTSELMBR'.
There are 0 rows in 0 pages for object 'GNTSELMBR'.
DBCC results for 'pos_det'.
There are 0 rows in 0 pages for object 'pos_det'.
DBCC results for 'hrparms'.
There are 1 rows in 1 pages for object 'hrparms'.
DBCC results for 'dcco'.
There are 0 rows in 0 pages for object 'dcco'.
DBCC results for 'vendcat'.
There are 19 rows in 1 pages for object 'vendcat'.
DBCC results for 'TaskTypes'.
There are 0 rows in 0 pages for object 'TaskTypes'.
DBCC results for 'tmp_appmt'.
There are 0 rows in 0 pages for object 'tmp_appmt'.
DBCC results for 'GroupNames'.
There are 109 rows in 2 pages for object 'GroupNames'.
DBCC results for 'pos_rqmt'.
There are 0 rows in 0 pages for object 'pos_rqmt'.
DBCC results for 'hrstep'.
There are 0 rows in 0 pages for object 'hrstep'.
DBCC results for 'dcco_serial'.
There are 0 rows in 0 pages for object 'dcco_serial'.
DBCC results for 'vendlog'.
There are 0 rows in 0 pages for object 'vendlog'.
DBCC results for 'TrackRows'.
There are 61 rows in 5 pages for object 'TrackRows'.
DBCC results for 'tmp_appmtd'.
There are 0 rows in 0 pages for object 'tmp_appmtd'.
DBCC results for 'INVPLAN000'.
There are 0 rows in 0 pages for object 'INVPLAN000'.
DBCC results for 'position'.
There are 0 rows in 0 pages for object 'position'.
DBCC results for 'i9doc'.
There are 0 rows in 0 pages for object 'i9doc'.
DBCC results for 'dcitem'.
There are 0 rows in 0 pages for object 'dcitem'.
DBCC results for 'vendor'.
There are 814 rows in 61 pages for object 'vendor'.
DBCC results for 'UserDefinedFields'.
There are 1329 rows in 667 pages for object 'UserDefinedFields'.
DBCC results for 'tmp_ardraftt'.
There are 0 rows in 0 pages for object 'tmp_ardraftt'.
DBCC results for 'JOB000'.
There are 0 rows in 0 pages for object 'JOB000'.
DBCC results for 'pr_comm'.
There are 0 rows in 0 pages for object 'pr_comm'.
DBCC results for 'indcode'.
There are 0 rows in 0 pages for object 'indcode'.
DBCC results for 'dcitem_serial'.
There are 0 rows in 0 pages for object 'dcitem_serial'.
DBCC results for 'vendor_all'.
There are 814 rows in 27 pages for object 'vendor_all'.
DBCC results for 'UserDefinedTypeValues'.
There are 0 rows in 0 pages for object 'UserDefinedTypeValues'.
DBCC results for 'tmp_arfin'.
There are 0 rows in 0 pages for object 'tmp_arfin'.
DBCC results for 'tmp_co_job'.
There are 0 rows in 0 pages for object 'tmp_co_job'.
DBCC results for 'JOBLNKS000'.
There are 0 rows in 0 pages for object 'JOBLNKS000'.
DBCC results for 'prbank'.
There are 0 rows in 0 pages for object 'prbank'.
DBCC results for 'ins_age'.
There are 0 rows in 0 pages for object 'ins_age'.
DBCC results for 'dcjit'.
There are 0 rows in 0 pages for object 'dcjit'.
DBCC results for 'vendtype'.
There are 0 rows in 0 pages for object 'vendtype'.
DBCC results for 'UserDefinedTypes'.
There are 0 rows in 0 pages for object 'UserDefinedTypes'.
DBCC results for 'tmp_arinv'.
There are 3381 rows in 162 pages for object 'tmp_arinv'.
DBCC results for 'JOBPLAN000'.
There are 0 rows in 0 pages for object 'JOBPLAN000'.
DBCC results for 'prdecd'.
There are 0 rows in 0 pages for object 'prdecd'.
DBCC results for 'ins_hc'.
There are 0 rows in 0 pages for object 'ins_hc'.
DBCC results for 'dcjit_serial'.
There are 0 rows in 0 pages for object 'dcjit_serial'.
DBCC results for 'wa_pos'.
There are 0 rows in 0 pages for object 'wa_pos'.
DBCC results for 'UserGroupMap'.
There are 350 rows in 6 pages for object 'UserGroupMap'.
DBCC results for 'tmp_arinvd'.
There are 3262 rows in 91 pages for object 'tmp_arinvd'.
DBCC results for 'JOBSTEP000'.
There are 10538 rows in 801 pages for object 'JOBSTEP000'.
DBCC results for 'preq'.
There are 4583 rows in 78 pages for object 'preq'.
DBCC results for 'jobroute_ii'.
There are 0 rows in 1 pages for object 'jobroute_ii'.
DBCC results for 'insurance'.
There are 0 rows in 0 pages for object 'insurance'.
DBCC results for 'dcjm'.
There are 0 rows in 0 pages for object 'dcjm'.
DBCC results for 'wa_usage'.
There are 0 rows in 0 pages for object 'wa_usage'.
DBCC results for 'UserModules'.
There are 3 rows in 4 pages for object 'UserModules'.
DBCC results for 'tmp_arpaypost'.
There are 1662 rows in 56 pages for object 'tmp_arpaypost'.
DBCC results for 'JS10VR000'.
There are 0 rows in 0 pages for object 'JS10VR000'.
DBCC results for 'preq_all'.
There are 4583 rows in 52 pages for object 'preq_all'.
DBCC results for 'intranet'.
There are 1 rows in 1 pages for object 'intranet'.
DBCC results for 'dcjm_serial'.
There are 0 rows in 0 pages for object 'dcjm_serial'.
DBCC results for 'want_ad'.
There are 0 rows in 0 pages for object 'want_ad'.
DBCC results for 'UserNames'.
There are 53 rows in 2 pages for object 'UserNames'.
DBCC results for 'tmp_arpmt'.
There are 1102 rows in 36 pages for object 'tmp_arpmt'.
DBCC results for 'tmp_co_jobroute'.
There are 0 rows in 0 pages for object 'tmp_co_jobroute'.
DBCC results for 'JS11VR000'.
There are 0 rows in 0 pages for object 'JS11VR000'.
DBCC results for 'preqcode'.
There are 3 rows in 1 pages for object 'preqcode'.
DBCC results for 'jobroute_dd'.
There are 0 rows in 1 pages for object 'jobroute_dd'.
DBCC results for 'inv_category'.
There are 1 rows in 1 pages for object 'inv_category'.
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'inv_hdr' (ID 731149650). Missing or invalid key in index 'IX_inv_hdr_cust_curr' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:92505:7) identified by (RID = (1:92505:7) inv_num = '0' and inv_seq = 38132) has index values (cust_num = 'APR0003' and curr_code = NULL and inv_num = '0' and inv_seq = 38132).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'inv_hdr' (ID 731149650). Missing or invalid key in index 'IX_inv_hdr_cust_curr' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:92505:9) identified by (RID = (1:92505:9) inv_num = '0' and inv_seq = 38134) has index values (cust_num = 'APW0001' and curr_code = NULL and inv_num = '0' and inv_seq = 38134).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'inv_hdr' (ID 731149650). Missing or invalid key in index 'IX_inv_hdr_RowPointer' (ID 12) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:92505:7) identified by (RID = (1:92505:7) inv_num = '0' and inv_seq = 38132) has index values (RowPointer = 2CFD6073-656E-4B7E-B276-FB59D14440ADh¢¿ and inv_num = '0' and inv_seq = 38132).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'inv_hdr' (ID 731149650). Missing or invalid key in index 'IX_inv_hdr_RowPointer' (ID 12) for the row:
DBCC results for 'dcmove'.
There are 0 rows in 0 pages for object 'dcmove'.
DBCC results for 'wbs_hdr'.
There are 0 rows in 0 pages for object 'wbs_hdr'.
DBCC results for 'UserNotes'.
There are 1 rows in 1 pages for object 'UserNotes'.
DBCC results for 'tmp_arpmtd'.
There are 1947 rows in 92 pages for object 'tmp_arpmtd'.
DBCC results for 'JS12VR000'.
There are 0 rows in 0 pages for object 'JS12VR000'.
DBCC results for 'preqitem'.
There are 9273 rows in 438 pages for object 'preqitem'.
DBCC results for 'inv_hdr'.
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:92505:9) identified by (RID = (1:92505:9) inv_num = '0' and inv_seq = 38134) has index values (RowPointer = D531C719-87C7-4BA8-BEF3-213A772349D5h¢¿ and inv_num = '0' and inv_seq = 38134).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'inv_hdr_all' (ID 747149707). Missing or invalid key in index 'IX_inv_hdr_all_RowPointer' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:92521:2) identified by (RID = (1:92521:2) site_ref = 'KOTRA' and inv_num = '0' and inv_seq = 38132) has index values (RowPointer = 2CFD6073-656E-4B7E-B276-FB59D14440ADh¢¿ and site_ref = 'KOTRA' and site_ref = 'KOTRA' and inv_num = '0' and inv_seq = 38132).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'inv_hdr_all' (ID 747149707). Missing or invalid key in index 'IX_inv_hdr_all_RowPointer' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:92521:4) identified by (RID = (1:92521:4) site_ref = 'KOTRA' and inv_num = '0' and inv_seq = 38134) has index values (RowPointer = D531C719-87C7-4BA8-BEF3-213A772349D5h¢¿ and site_ref = 'KOTRA' and site_ref = 'KOTRA' and inv_num = '0' and inv_seq = 38134).
There are 212606 rows in 12941 pages for object 'inv_hdr'.
CHECKDB found 0 allocation errors and 4 consistency errors in table 'inv_hdr' (object ID 731149650).
DBCC results for 'dcmove_serial'.
There are 0 rows in 0 pages for object 'dcmove_serial'.
DBCC results for 'wbs_item'.
There are 0 rows in 0 pages for object 'wbs_item'.
DBCC results for 'UserProcessDefaults'.
There are 0 rows in 0 pages for object 'UserProcessDefaults'.
DBCC results for 'tmp_co_ship'.
There are 0 rows in 0 pages for object 'tmp_co_ship'.
DBCC results for 'JS13VR000'.
There are 0 rows in 0 pages for object 'JS13VR000'.
DBCC results for 'preqitem_all'.
There are 9273 rows in 137 pages for object 'preqitem_all'.
DBCC results for 'inv_hdr_all'.
There are 212606 rows in 7414 pages for object 'inv_hdr_all'.
CHECKDB found 0 allocation errors and 2 consistency errors in table 'inv_hdr_all' (object ID 747149707).
DBCC results for 'dcparm'.
There are 1 rows in 1 pages for object 'dcparm'.
DBCC results for 'wc'.
There are 53 rows in 7 pages for object 'wc'.
DBCC results for 'WAIT000'.
There are 0 rows in 0 pages for object 'WAIT000'.
DBCC results for 'tmp_dcsfc_item'.
There are 0 rows in 0 pages for object 'tmp_dcsfc_item'.
DBCC results for 'JS14VR000'.
There are 0 rows in 0 pages for object 'JS14VR000'.
DBCC results for 'prhrs'.
There are 0 rows in 0 pages for object 'prhrs'.
DBCC results for 'inv_item'.
There are 691269 rows in 25037 pages for object 'inv_item'.
DBCC results for 'dcparm_all'.
There are 1 rows in 1 pages for object 'dcparm_all'.
DBCC results for 'wcresourcegroup'.
There are 53 rows in 1 pages for object 'wcresourcegroup'.
DBCC results for 'WorkflowTemplates'.
There are 0 rows in 0 pages for object 'WorkflowTemplates'.
DBCC results for 'tmp_edi_RSEQ_DTL'.
There are 0 rows in 0 pages for object 'tmp_edi_RSEQ_DTL'.
DBCC results for 'tmp_co_jrt_sch'.
There are 0 rows in 0 pages for object 'tmp_co_jrt_sch'.
DBCC results for 'JS15VR000'.
There are 0 rows in 0 pages for object 'JS15VR000'.
DBCC results for 'pricecode'.
There are 17 rows in 1 pages for object 'pricecode'.
DBCC results for 'inv_item_all'.
There are 691269 rows in 15557 pages for object 'inv_item_all'.
DBCC results for 'dcpo'.
There are 0 rows in 0 pages for object 'dcpo'.
DBCC results for 'wcseq'.
There are 0 rows in 0 pages for object 'wcseq'.
DBCC results for 'Workflows'.
There are 0 rows in 0 pages for object 'Workflows'.
DBCC results for 'tmp_edi_RSEQ_HDR'.
There are 0 rows in 0 pages for object 'tmp_edi_RSEQ_HDR'.
DBCC results for 'JS16VR000'.
There are 0 rows in 0 pages for object 'JS16VR000'.
DBCC results for 'pricecode_all'.
There are 17 rows in 1 pages for object 'pricecode_all'.
DBCC results for 'inv_map'.
There are 0 rows in 0 pages for object 'inv_map'.
DBCC results for 'dcpo_serial'.
There are 0 rows in 0 pages for object 'dcpo_serial'.
DBCC results for 'whse'.
There are 5 rows in 1 pages for object 'whse'.
DBCC results for 'absence'.
There are 0 rows in 0 pages for object 'absence'.
DBCC results for 'tmp_edi_co_100'.
There are 0 rows in 0 pages for object 'tmp_edi_co_100'.
DBCC results for 'JS17VR000'.
There are 0 rows in 0 pages for object 'JS17VR000'.
DBCC results for 'priceformula'.
There are 8 rows in 1 pages for object 'priceformula'.
DBCC results for 'inv_ms'.
There are 0 rows in 0 pages for object 'inv_ms'.
DBCC results for 'dcps'.
There are 0 rows in 0 pages for object 'dcps'.
DBCC results for 'whse_all'.
There are 5 rows in 1 pages for object 'whse_all'.
DBCC results for 'ack'.
There are 0 rows in 0 pages for object 'ack'.
DBCC results for 'tmp_edi_co_300'.
There are 0 rows in 0 pages for object 'tmp_edi_co_300'.
DBCC results for 'JS18VR000'.
There are 0 rows in 0 pages for object 'JS18VR000'.
DBCC results for 'priceformula_all'.
There are 8 rows in 1 pages for object 'priceformula_all'.
DBCC results for 'inv_ms_log'.
There are 0 rows in 0 pages for object 'inv_ms_log'.
DBCC results for 'dcps_serial'.
There are 0 rows in 0 pages for object 'dcps_serial'.
DBCC results for 'ack_bln'.
There are 0 rows in 0 pages for object 'ack_bln'.
DBCC results for 'tmp_edi_output'.
There are 0 rows in 0 pages for object 'tmp_edi_output'.
DBCC results for 'tmp_co_jobmatl'.
There are 0 rows in 0 pages for object 'tmp_co_jobmatl'.
DBCC results for 'JS19VR000'.
There are 10538 rows in 798 pages for object 'JS19VR000'.
DBCC results for 'pricematrix'.
There are 6 rows in 1 pages for object 'pricematrix'.
DBCC results for 'inv_ms_seq'.
There are 0 rows in 0 pages for object 'inv_ms_seq'.
DBCC results for 'dcsfc'.
There are 0 rows in 0 pages for object 'dcsfc'.
DBCC results for 'ackitem'.
There are 0 rows in 0 pages for object 'ackitem'.
DBCC results for 'tmp_edi_poack_100'.
There are 0 rows in 0 pages for object 'tmp_edi_poack_100'.
DBCC results for 'JS2VR000'.
There are 0 rows in 0 pages for object 'JS2VR000'.
DBCC results for 'pricematrix_all'.
There are 6 rows in 1 pages for object 'pricematrix_all'.
DBCC results for 'inv_pro'.
There are 0 rows in 0 pages for object 'inv_pro'.
DBCC results for 'dcsfc_item'.
There are 0 rows in 0 pages for object 'dcsfc_item'.
DBCC results for 'adp_parm'.
There are 0 rows in 0 pages for object 'adp_parm'.
DBCC results for 'tmp_edi_poack_200'.
There are 0 rows in 0 pages for object 'tmp_edi_poack_200'.
DBCC results for 'JS3VR000'.
There are 0 rows in 0 pages for object 'JS3VR000'.
DBCC results for 'prlog'.
There are 0 rows in 0 pages for object 'prlog'.
DBCC results for 'inv_sequence'.
There are 3 rows in 1 pages for object 'inv_sequence'.
DBCC results for 'dcsfc_serial'.
There are 0 rows in 0 pages for object 'dcsfc_serial'.
DBCC results for 'ana_ledger'.
There are 0 rows in 0 pages for object 'ana_ledger'.
DBCC results for 'tmp_edi_poack_300'.
There are 0 rows in 0 pages for object 'tmp_edi_poack_300'.
DBCC results for 'JS4VR000'.
There are 0 rows in 0 pages for object 'JS4VR000'.
DBCC results for 'probcode'.
There are 10 rows in 1 pages for object 'probcode'.
DBCC results for 'inv_stax'.
There are 0 rows in 0 pages for object 'inv_stax'.
DBCC results for 'dcta'.
There are 0 rows in 0 pages for object 'dcta'.
DBCC results for 'ana_ledger_all'.
There are 0 rows in 0 pages for object 'ana_ledger_all'.
DBCC results for 'tmp_edi_ship_dtl'.
There are 0 rows in 0 pages for object 'tmp_edi_ship_dtl'.
DBCC results for 'JS6VR000'.
There are 0 rows in 0 pages for object 'JS6VR000'.
DBCC results for 'prod_mix'.
There are 0 rows in 0 pages for object 'prod_mix'.
DBCC results for 'inv_stax_all'.
There are 0 rows in 0 pages for object 'inv_stax_all'.
DBCC results for 'dctrans'.
There are 0 rows in 0 pages for object 'dctrans'.
DBCC results for 'ana_pertot'.
There are 0 rows in 0 pages for object 'ana_pertot'.
DBCC results for 'tmp_edi_ship_hdr'.
There are 0 rows in 0 pages for object 'tmp_edi_ship_hdr'.
DBCC results for 'JS7VR000'.
There are 0 rows in 0 pages for object 'JS7VR000'.
DBCC results for 'prod_mix_irt'.
There are 0 rows in 0 pages for object 'prod_mix_irt'.
DBCC results for 'inv_void'.
There are 0 rows in 0 pages for object 'inv_void'.
DBCC results for 'dctrans_serial'.
There are 0 rows in 0 pages for object 'dctrans_serial'.
DBCC results for 'ana_pertot_all'.
There are 0 rows in 0 pages for object 'ana_pertot_all'.
DBCC results for 'tmp_edi_vinv_100'.
There are 0 rows in 0 pages for object 'tmp_edi_vinv_100'.
DBCC results for 'JS8VR000'.
There are 0 rows in 0 pages for object 'JS8VR000'.
DBCC results for 'prod_mix_item'.
There are 0 rows in 0 pages for object 'prod_mix_item'.
DBCC results for 'invc_lang'.
There are 0 rows in 0 pages for object 'invc_lang'.
DBCC results for 'dcwc'.
There are 0 rows in 0 pages for object 'dcwc'.
DBCC results for 'ap_batch_counter'.
There are 0 rows in 0 pages for object 'ap_batch_counter'.
DBCC results for 'tmp_edi_vinv_200'.
There are 0 rows in 0 pages for object 'tmp_edi_vinv_200'.
DBCC results for 'JS9VR000'.
There are 0 rows in 0 pages for object 'JS9VR000'.
DBCC results for 'prodcode'.
There are 101 rows in 7 pages for object 'prodcode'.
DBCC results for 'invparms'.
There are 1 rows in 1 pages for object 'invparms'.
DBCC results for 'dcwc_serial'.
There are 0 rows in 0 pages for object 'dcwc_serial'.
DBCC results for 'apdraftt'.
There are 0 rows in 0 pages for object 'apdraftt'.
DBCC results for 'tmp_edi_vsn_100'.
There are 0 rows in 0 pages for object 'tmp_edi_vsn_100'.
DBCC results for 'JSATTR000'.
There are 0 rows in 0 pages for object 'JSATTR000'.
DBCC results for 'prodcode_all'.
There are 101 rows in 2 pages for object 'prodcode_all'.
DBCC results for 'invparms_all'.
There are 1 rows in 1 pages for object 'invparms_all'.
DBCC results for 'del_term'.
There are 0 rows in 0 pages for object 'del_term'.
DBCC results for 'apdraftt_all'.
There are 0 rows in 0 pages for object 'apdraftt_all'.
DBCC results for 'tmp_edi_vsn_200'.
There are 0 rows in 0 pages for object 'tmp_edi_vsn_200'.
DBCC results for 'JSTYPE'.
There are 39 rows in 1 pages for object 'JSTYPE'.
DBCC results for 'prodvar'.
There are 101 rows in 6 pages for object 'prodvar'.
DBCC results for 'kotra_ETHProdGrp_Old_20052006'.
There are 1654 rows in 207 pages for object 'kotra_ETHProdGrp_Old_20052006'.
DBCC results for 'item'.
There are 2423 rows in 419 pages for object 'item'.
DBCC results for 'del_term_all'.
There are 0 rows in 0 pages for object 'del_term_all'.
DBCC results for 'app_int'.
There are 0 rows in 0 pages for object 'app_int'.
DBCC results for 'tmp_finstmt'.
There are 0 rows in 1 pages for object 'tmp_finstmt'.
DBCC results for 'kotra_ProdIncGrp-180406'.
There are 21 rows in 2 pages for object 'kotra_ProdIncGrp-180406'.
DBCC results for 'LOADPERF000'.
There are 0 rows in 0 pages for object 'LOADPERF000'.
DBCC results for 'progbill'.
There are 0 rows in 0 pages for object 'progbill'.
DBCC results for 'kotra_OTCProdGrp-260606'.
There are 361 rows in 46 pages for object 'kotra_OTCProdGrp-260606'.
DBCC results for 'item_all'.
There are 2423 rows in 286 pages for object 'item_all'.
DBCC results for 'dep_dtl'.
There are 0 rows in 0 pages for object 'dep_dtl'.
DBCC results for 'app_ref'.
There are 0 rows in 0 pages for object 'app_ref'.
DBCC results for 'tmp_inv'.
There are 1 rows in 1 pages for object 'tmp_inv'.
DBCC results for 'kotra_MgmtGrp_old'.
There are 29 rows in 1 pages for object 'kotra_MgmtGrp_old'.
DBCC results for 'LOADSUM000'.
There are 0 rows in 0 pages for object 'LOADSUM000'.
DBCC results for 'progh'.
There are 0 rows in 0 pages for object 'progh'.
DBCC results for 'kotra_OTCProdGrp-130706'.
There are 361 rows in 51 pages for object 'kotra_OTCProdGrp-130706'.
DBCC results for 'item_glbl'.
There are 2423 rows in 76 pages for object 'item_glbl'.
DBCC results for 'dept'.
There are 12 rows in 1 pages for object 'dept'.
DBCC results for 'app_source'.
There are 0 rows in 0 pages for object 'app_source'.
DBCC results for 'tmp_itemlifo'.
There are 0 rows in 0 pages for object 'tmp_itemlifo'.
DBCC results for 'LOCALE'.
There are 0 rows in 0 pages for object 'LOCALE'.
DBCC results for 'proj'.
There are 0 rows in 0 pages for object 'proj'.
DBCC results for 'Sheet1$'.
There are 361 rows in 73 pages for object 'Sheet1$'.
DBCC results for 'item_lang'.
There are 0 rows in 0 pages for object 'item_lang'.
DBCC results for 'dept_supv'.
There are 0 rows in 0 pages for object 'dept_supv'.
DBCC results for 'apparms'.
There are 1 rows in 1 pages for object 'apparms'.
DBCC results for 'tmp_job_split'.
There are 0 rows in 1 pages for object 'tmp_job_split'.
DBCC results for 'LOCALSTR'.
There are 0 rows in 0 pages for object 'LOCALSTR'.
DBCC results for 'proj_all'.
There are 0 rows in 0 pages for object 'proj_all'.
DBCC results for 'itemcust'.
There are 22 rows in 1 pages for object 'itemcust'.
DBCC results for 'discount'.
There are 0 rows in 0 pages for object 'discount'.
DBCC results for 'apparms_all'.
There are 1 rows in 1 pages for object 'apparms_all'.
DBCC results for 'tmp_journal'.
There are 9350 rows in 433 pages for object 'tmp_journal'.
DBCC results for 'LOOKUP000'.
There are 0 rows in 0 pages for object 'LOOKUP000'.
DBCC results for 'proj_bol'.
There are 0 rows in 0 pages for object 'proj_bol'.
DBCC results for 'kotra_IDSCustList'.
There are 7299 rows in 93 pages for object 'kotra_IDSCustList'.
DBCC results for 'itemcust_all'.
There are 22 rows in 1 pages for object 'itemcust_all'.
DBCC results for 'dispcode'.
There are 6 rows in 1 pages for object 'dispcode'.
DBCC results for 'applicant'.
There are 0 rows in 0 pages for object 'applicant'.
DBCC results for 'tmp_lc_tax_dist'.
There are 0 rows in 0 pages for object 'tmp_lc_tax_dist'.
DBCC results for 'LSTATUS000'.
There are 0 rows in 0 pages for object 'LSTATUS000'.
DBCC results for 'proj_bol_item'.
There are 0 rows in 0 pages for object 'proj_bol_item'.
DBCC results for 'itemcustprice'.
There are 3 rows in 1 pages for object 'itemcustprice'.
DBCC results for 'distacct'.
There are 101 rows in 10 pages for object 'distacct'.
DBCC results for 'appmt'.
There are 189 rows in 6 pages for object 'appmt'.
DBCC results for 'tmp_ledger'.
There are 0 rows in 0 pages for object 'tmp_ledger'.
DBCC results for 'LanguageIDs'.
There are 33 rows in 1 pages for object 'LanguageIDs'.
DBCC results for 'proj_inv_hdr'.
There are 0 rows in 0 pages for object 'proj_inv_hdr'.
DBCC results for 'itemcustprice_all'.
There are 3 rows in 1 pages for object 'itemcustprice_all'.
DBCC results for 'div_mgr'.
There are 0 rows in 0 pages for object 'div_mgr'.
DBCC results for 'appmtd'.
There are 596 rows in 26 pages for object 'appmtd'.
DBCC results for 'tmp_matltran'.
There are 0 rows in 0 pages for object 'tmp_matltran'.
DBCC results for 'License'.
There are 1 rows in 1 pages for object 'License'.
DBCC results for 'proj_inv_item'.
There are 0 rows in 0 pages for object 'proj_inv_item'.
DBCC results for 'itemlifo'.
There are 12 rows in 1 pages for object 'itemlifo'.
DBCC results for 'do_hdr'.
There are 0 rows in 0 pages for object 'do_hdr'.
DBCC results for 'aps_parm'.
There are 1 rows in 1 pages for object 'aps_parm'.
DBCC results for 'tmp_matltran_amt'.
There are 0 rows in 0 pages for object 'tmp_matltran_amt'.
DBCC results for 'LoginCfg'.
There are 1 rows in 1 pages for object 'LoginCfg'.
DBCC results for 'proj_inv_item_all'.
There are 0 rows in 0 pages for object 'proj_inv_item_all'.
DBCC results for 'itemloc'.
There are 9265 rows in 635 pages for object 'itemloc'.
DBCC results for 'do_line'.
There are 0 rows in 0 pages for object 'do_line'.
DBCC results for 'aps_seq'.
There are 13 rows in 1 pages for object 'aps_seq'.
DBCC results for 'tmp_phyinv'.
There are 0 rows in 0 pages for object 'tmp_phyinv'.
DBCC results for 'MATADDQ000'.
There are 0 rows in 0 pages for object 'MATADDQ000'.
DBCC results for 'proj_pck_hdr'.
There are 0 rows in 0 pages for object 'proj_pck_hdr'.
DBCC results for 'itemloc_all'.
There are 9265 rows in 564 pages for object 'itemloc_all'.
DBCC results for 'do_seq'.
There are 0 rows in 0 pages for object 'do_seq'.
DBCC results for 'aps_site'.
There are 0 rows in 0 pages for object 'aps_site'.
DBCC results for 'tmp_pick_itemdet'.
There are 79 rows in 3 pages for object 'tmp_pick_itemdet'.
DBCC results for 'MATDELOUT000'.
There are 0 rows in 0 pages for object 'MATDELOUT000'.
DBCC results for 'proj_pckitem'.
There are 0 rows in 0 pages for object 'proj_pckitem'.
DBCC results for 'itemprice'.
There are 1233 rows in 73 pages for object 'itemprice'.
DBCC results for 'dynamic_table'.
There are 57 rows in 1 pages for object 'dynamic_table'.
DBCC results for 'apsplan'.
There are 0 rows in 0 pages for object 'apsplan'.
DBCC results for 'tmp_pick_itemloclot'.
There are 119 rows in 4 pages for object 'tmp_pick_itemloclot'.
DBCC results for 'MATL000'.
There are 2989 rows in 274 pages for object 'MATL000'.
DBCC results for 'proj_ship'.
There are 0 rows in 0 pages for object 'proj_ship'.
DBCC results for 'itemprice_all'.
There are 1233 rows in 76 pages for object 'itemprice_all'.
DBCC results for 'ecn'.
There are 0 rows in 0 pages for object 'ecn'.
DBCC results for 'apsplandetail'.
There are 0 rows in 0 pages for object 'apsplandetail'.
DBCC results for 'tmp_pick_itemtot'.
There are 63 rows in 2 pages for object 'tmp_pick_itemtot'.
DBCC results for 'MATLALT000'.
There are 0 rows in 0 pages for object 'MATLALT000'.
DBCC results for 'proj_wip'.
There are 0 rows in 0 pages for object 'proj_wip'.
DBCC results for 'itemrev'.
There are 0 rows in 0 pages for object 'itemrev'.
DBCC results for 'ecndist'.
There are 0 rows in 0 pages for object 'ecndist'.
DBCC results for 'aptrx'.
There are 229 rows in 49 pages for object 'aptrx'.
DBCC results for 'tmp_ser'.
There are 0 rows in 0 pages for object 'tmp_ser'.
DBCC results for 'MATLATTR000'.
There are 2424 rows in 52 pages for object 'MATLATTR000'.
DBCC results for 'projcost'.
There are 0 rows in 0 pages for object 'projcost'.
DBCC results for 'itemvend'.
There are 1699 rows in 94 pages for object 'itemvend'.
DBCC results for 'ecnh'.
There are 0 rows in 0 pages for object 'ecnh'.
DBCC results for 'aptrxd'.
There are 251 rows in 25 pages for object 'aptrxd'.
DBCC results for 'tmp_ship'.
There are 0 rows in 1 pages for object 'tmp_ship'.
DBCC results for 'MATLDELV000'.
There are 226 rows in 30 pages for object 'MATLDELV000'.
DBCC results for 'projlabr'.
There are 0 rows in 0 pages for object 'projlabr'.
DBCC results for 'itemvendprice'.
There are 1770 rows in 106 pages for object 'itemvendprice'.
DBCC results for 'ecnhitem'.
There are 0 rows in 0 pages for object 'ecnhitem'.
DBCC results for 'aptrxp'.
There are 64775 rows in 4076 pages for object 'aptrxp'.
DBCC results for 'tmp_snapshot_apdraftt'.
There are 0 rows in 0 pages for object 'tmp_snapshot_apdraftt'.
DBCC results for 'target4SQLdb$'.
There are 3720 rows in 33 pages for object 'target4SQLdb$'.
DBCC results for 'MATLGRP000'.
There are 0 rows in 0 pages for object 'MATLGRP000'.
DBCC results for 'projmatl'.
There are 0 rows in 0 pages for object 'projmatl'.
DBCC results for 'itemwhse'.
There are 2423 rows in 176 pages for object 'itemwhse'.
DBCC results for 'ecnitem'.
There are 0 rows in 0 pages for object 'ecnitem'.
DBCC results for 'aptrxp_all'.
There are 64775 rows in 3508 pages for object 'aptrxp_all'.
DBCC results for 'tmp_snapshot_appmt'.
There are 801 rows in 28 pages for object 'tmp_snapshot_appmt'.
DBCC results for 'kotra_OTCTarget_Old'.
There are 3600 rows in 76 pages for object 'kotra_OTCTarget_Old'.
DBCC results for 'MATLPBOMS000'.
There are 2502 rows in 106 pages for object 'MATLPBOMS000'.
DBCC results for 'projparm'.
There are 1 rows in 1 pages for object 'projparm'.
DBCC results for 'itemwhse_all'.
There are 2423 rows in 111 pages for object 'itemwhse_all'.
DBCC results for 'ecnpri'.
There are 0 rows in 0 pages for object 'ecnpri'.
DBCC results for 'aptrxr'.
There are 1 rows in 1 pages for object 'aptrxr'.
DBCC results for 'tmp_snapshot_appmtd'.
There are 2315 rows in 101 pages for object 'tmp_snapshot_appmtd'.
DBCC results for 'kotra_ETHTarget_old'.
There are 2160 rows in 48 pages for object 'kotra_ETHTarget_old'.
DBCC results for 'MATLPLAN000'.
There are 0 rows in 0 pages for object 'MATLPLAN000'.
DBCC results for 'projsale'.
There are 0 rows in 0 pages for object 'projsale'.
DBCC results for 'jmatlc'.
There are 0 rows in 0 pages for object 'jmatlc'.
DBCC results for 'ed_major'.
There are 0 rows in 0 pages for object 'ed_major'.
DBCC results for 'aptrxt'.
There are 0 rows in 0 pages for object 'aptrxt'.
DBCC results for 'tmp_snapshot_aptrx'.
There are 9443 rows in 588 pages for object 'tmp_snapshot_aptrx'.
DBCC results for 'MATLPPS000'.
There are 1661 rows in 70 pages for object 'MATLPPS000'.
DBCC results for 'projtask'.
There are 0 rows in 0 pages for object 'projtask'.
DBCC results for 'job'.
There are 16484 rows in 1618 pages for object 'job'.
DBCC results for 'edi_bol'.
There are 0 rows in 0 pages for object 'edi_bol'.
DBCC results for 'aptxrd'.
There are 0 rows in 0 pages for object 'aptxrd'.
DBCC results for 'tmp_snapshot_aptrxd'.
There are 9936 rows in 270 pages for object 'tmp_snapshot_aptrxd'.
DBCC results for 'MATLRULE000'.
There are 0 rows in 0 pages for object 'MATLRULE000'.
DBCC results for 'projtask_all'.
There are 0 rows in 0 pages for object 'projtask_all'.
DBCC results for 'job_all'.
There are 16484 rows in 334 pages for object 'job_all'.
DBCC results for 'edi_bol_item'.
There are 0 rows in 0 pages for object 'edi_bol_item'.
DBCC results for 'ar_batch_counter'.
There are 0 rows in 0 pages for object 'ar_batch_counter'.
DBCC results for 'tmp_snapshot_aptrxp'.
There are 0 rows in 0 pages for object 'tmp_sna

View 7 Replies


ADVERTISEMENT

Error Message With Index

Feb 9, 2001

URGENT!!!!!
I am getting this error and cannot find out what is happening anywhere!!!

Server: Msg 7319, Level 16, State 1, Line 3
OLE DB provider 'SQLOLEDB' returned a 'NON-CLUSTERED and NOT INTEGRATED' index 'account_index' with bookmark ordinal 0.


This is a SQL7 with service pack 3.

Please help me on this issue.



Jim

View 3 Replies View Related

SQL Error When Deleting Index

Jan 6, 2004

Hi.

I have a SQL 2000 database. The table's primary key is set up as a "regular" index and another field is set up as a clustered index. When attempting to delete the index on this other field, I am receiving the following error message:

'tblQuestionAnswer' table
- Unable to delete index 'tblQuestionAnswer1'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]A column has been specified more than once in the order by list. Columns in the order by list must be unique.

I do not understand why I am receiving this message in relation to the deletion of an index. Any ideas?

View 4 Replies View Related

Help Me Please Error Index - Primary Key

Apr 9, 2008

'PXQ_2' table
- Unable to delete index 'PK_PXQ'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]I/O error (bad page ID) detected during read at offset 0x0000000102e000 in file 'D:MSSQL2000MSSQLxxx.mdf'.

I can't drop Primary Key. How to fix this problem?

Hardware(HDD) no error. I test oke?

Please help me.





-= MIB =-

View 7 Replies View Related

Index Fail Error 644

Jan 19, 2006

Guys,
We just got an Error 644 on our DB, the error was:

Could not find the index entry for RID '169bc61301c3950000209e1a0002000000030000' in index page (1:1683508), index ID 0, database 'TR'..

Error: 644, Severity: 21, State: 3

We run dbcc CheckDB on the TR DB with no error:

CHECKDB found 0 allocation errors and 0 consistency errors in database 'TR'.

I read JohnSharp post, and tried the script from Paul:

DBCC CHECKTABLE (sysindexes) WITH NO_INFOMSGS, ALL_ERRORMSGS

it return no erros as well, anyone got any more info on whats this error is?

At the time of this happen, its seems that a process is running, which run some stored proc which will create some temp tables, will that message be relating to some index that created on the tempdb (from the temp tables) rather then the index on the TR DB? Since we can't even tell which table its affected, is there any way to find out?

Thanks.

View 10 Replies View Related

Help, Index Out Of Bounds Error

Sep 7, 2007

Hi,

I really don't know why I'm getting this error! Index was outside the bounds of the array.

I am reading a comma-delimited flat file, line by line. This is part of my script component:


Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)

Dim rowValues As String()

rowValues = Row.Line.Split(columnDelimiter) 'parse rows by comma



Row.col1 = rowValues(0).Replace("""", String.Empty)

Row.col2 = rowValues(1).Replace("""", String.Empty)


I've done this quite a few times before in other packages. WHY is it telling me that rowValues(1) is out of bounds?? I've commented out EVERYTHING in my script, except for these 2 rows. If I comment out Row.col2, I don't get the out of bounds error. If I include Row.col2, I get the out of bounds error, so it doesn't like rowValues(1).

The file has 13 columns in it. A row looks like this:

"ATMC","004930202",529.000000,"L",11.380000,6020.020000,7210.270000,6072.920000,"BSZTX","MTPO",,"Equities","My Fund Appreciation","06/30/2006"

Thanks

View 6 Replies View Related

Reorganize Index Error

Jan 7, 2008

Any assistance with this issue would be greatly appreciated. TIA!

Server: DBServer-1
Task Detail: Reorganize index on Local server connection
Databases: dbA,dbB,dbC,dbD,dbE,master,model,msdb



Object: Tables and views
Compact large objects
Error No: -1073548784
Error Message: Executing the query "ALTER INDEX [PK_Residential] ON [dbo].[Residential] REORGANIZE WITH ( LOB_COMPACTION = ON )" failed with the following error: "A severe error occurred on the current command. The results, if any, should be discarded.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.


Windows Server 2003 Standard Edition w/ SP2
SQL Server 2005 Standard Edition (9.0.3054)

View 8 Replies View Related

Error While Droping Unique Index

Apr 4, 2002

Hi,

I get the following error message while droping unique index.

Server: Msg 3723, Level 16, State 5, Line 1
An explicit DROP INDEX is not allowed on index 'dbo.ALEG.IX_ALEG'. It is being used for UNIQUE KEY constraint enforcement.

Could you please how the index can be droped.

Thanks

View 1 Replies View Related

Create Unique Index Error

Jan 11, 2005

Does anybody know the significance of 3 in the following error message?

"CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 3. "

Thank you

View 3 Replies View Related

Index Tuning Wizard Error

May 9, 2006

Hi

When I try to run the ITW to increase performance I get this error in the event viewer. Earlier I have used the ITW with success but now I dont get any more index recommendations, just this error. Do you know what it means :


"The description for Event ID ( 4 ) in Source ( ITW ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event:
Error in Parsing Event:
execute sp_Sys'.

View 3 Replies View Related

SYSINDEXES Index Fail, Error 644

Jan 16, 2006

A few days ago a sproc stopped working, only noticed it this morning, when checking information to see what's up I get this:

Server: Msg 644, Level 21, State 1, Procedure uspV2InventoryFetch, Line 83
Could not find the index entry for RID '45574f44523738313834202020202020202020202020202020202020202020' in index page (1:11690152), index ID 2, database 'ASOS'.

Connection Broken

I've treid DBCC CHECKDBing all related tables and everything else. Even tried dbreindexing a couple of them too, everything reports as correct. When I looked further at the problem I spotted "index ID 2" in there, on checking this out in sysindexes it seems that the name field of sysindexes where id = 2 is SYSINDEXES and TSYSINDEXES.

I can't seem to do a DBB DBRECINDEX against a system table.

Any help appreciated.

John

View 3 Replies View Related

Full Text Index Error

Feb 11, 2008

Hi,

I build some t-sql code to check if full text is installed on the sql server. If not, some sql statements must be not executed. Here is my code:


if (select serverproperty('IsFullTextInstalled')) = 1

Begin


EXEC sp_fulltext_database 'enable'


CREATE FULLTEXT CATALOG [...] WITH ACCENT_SENSITIVITY = OFF AS DEFAULT




CREATE FULLTEXT INDEX ON dbo.Test (Name LANGUAGE 0, Description LANGUAGE 0) KEY INDEX IX_Test_1 ON [...] WITH CHANGE_TRACKING AUTO
ALTER FULLTEXT INDEX ON dbo.Test ENABLE


End


Statement 1 and 2 is not executed, but for statement 3 the server throws the following error:
Full-Text Search is not installed, or a full-text component cannot be loaded.


I don't know why the server tries to execute statement 3, because it is in an if statement.

Any help is welcome.

View 10 Replies View Related

Invalid Descriptor Index Error

Oct 2, 2006

I'm testing db to db transactional replication on a box ( all on the same box ) and the distribution agent fails with the above error. I know it's something to do with the physical server as this test works on other servers fine. SQL2k Ent sp4 on w2k3 ent sp1. ( clustered )

Server and Agent accounts are in local admins, tried push and pull, named and anonymous. Replication also fails if I use the default snapshot location. I suspect policy restrictions ( maybe on the sql service accounts ) Any pointers would be helpful - there are no errors other than above, sadly.

View 12 Replies View Related

SQL 2012 :: Error - Index Was Outside The Bounds Of The Array

Sep 2, 2014

Currently underway with migrating from SQL 2005 to SQL2012. I have loaded all of my SSRS reports into Visual Studio 2010 (SQL Server Data Tools) and they all appeared to upgrade fine. I have 150+ reports and I'm in the middle of recreating a tonne of Subscriptions.

However, I have 4 reports that run fine, execute nicely.... but as soon as I click on 'Subscriptions' I get the index bounds array error.

I could attempt to re-create them. It's only 4 reports after all. But it doesn't answer the question, why would the reports execute fine, but unable to create a subscription?

View 0 Replies View Related

Consistency Error On Merge Table Index

May 30, 2007

I'm getting the following error on our merge contents table in one of our DBs:


Msg 8952, Level 16, State 1, Line 1
Table error: Database 'ks241', index 'MSmerge_contents.nc3MSmerge_contents' (ID 1950682047) (index ID 3). Extra or invalid key for the keys:
Msg 8956, Level 16, State 1, Line 1
Index row (1:1893:42) with values (partchangegen = NULL and tablenick = 17665001 and rowguid = AEAE7256-F571-478E-B2B4-D142B47C38C1) points to the data row identified by ().
Msg 8952, Level 16, State 1, Line 1
Table error: Database 'ks241', index 'MSmerge_contents.nc3MSmerge_contents' (ID 1950682047) (index ID 3). Extra or invalid key for the keys:
Msg 8956, Level 16, State 1, Line 1
Index row (1:1893:66) with values (partchangegen = NULL and tablenick = 17665001 and rowguid = B94F1591-33B0-4625-A269-DB9B8B05BCCE) points to the data row identified by ().
CHECKTABLE found 0 allocation errors and 2 consistency errors in table 'MSmerge_contents' (object ID 1950682047).
repair_fast is the minimum repair level for the errors found by DBCC CHECKTABLE (ks241.dbo.MSmerge_contents ).


There are no other corruption issues on the server that I can find. I do not believe there are any current hardware issues, though I am not on site.

What would be the best way to resolve this? Is recreating or defrag/rebuild the index an option, here? Or can I just run a repair on this? Since it's a merge table, I'm a little gun shy, having limited experience with replication.

Thanks.

____________________________________________________________________________________
"Believe in those who are seeking the truth. Doubt those who say they have found it." -Andre Gide

View 4 Replies View Related

Table Error: Object ID XX, Index ID X. Keys

Jan 2, 2008

I have a problem with multiple databases on a server. I originally read another post that went into detail on this same error. After reading the post I decided to re-index the table to see if that would fix my issue. I started on Saturday by re-indexing a table on database 'a' - the process completed after that; I received another error on database 'b' on Monday i subsequently re-indexed all indexes on this database; today I have received the same message on database 'c' and 'd'. All post that I have read seem to point to an issue with only one database and not multiple databases. I have approximately 100 databases on this cluster - SQL 2000. The physical server logs only error shown is '000009ac.00001744::2007/12/29-15:12:58.848 ERR [CP] CppReadCheckpoint unable to copy file U:Disk12Partition1d61e68e-a60f-4ca6-b9ae-df3b893e4bb20000001.CPT to C:DOCUME~1mscsLOCALS~1TempCLS302F.tmp, error 3
000009ac.00001744::2007/12/29-15:12:58.848 ERR [CP] CppReadCheckpoint - Was that due to quorum resource not being up ???
' before corruption of database 'a'.

Here is the entire error if you think it will help. The error has been the same on all databases: 12/28/2007 6:23 AM A possible database consistency problem has been detected on database ‘ substituted_name'. DBCC CHECKDB and DBCC CHECKCATALOG should be run on database 'substituted_name'..

When I run the DBCC CHECKDB command I got these errors on Substite name database:
DBCC results for 'FVD_A'.
Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 165575628, Index ID 2. Keys out of order on page (1:12743984), slots 97 and 98.
There are 72920059 rows in 2281375 pages for object 'FVD_A'.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'FVD_A' (object ID 165575628).
DBCC results for 'FVD_CVS322'.
Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 181575685, Index ID 2. Keys out of order on page (1:7250519), slots 30 and 31.


I am at a loss. I believe we may have a bigger issue, but the SAN Administrator and Server Admin are saying there is nothing they can do. Do I have a true SQL Server issue or something else.

HELP!

View 2 Replies View Related

Index Server Error MSIDX 0x8004181d... HELP

Mar 13, 2008

p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:'Calibri','sans-serif';}
span.EmailStyle15
{font-family:'Calibri','sans-serif';color:#1F497D;}
.MsoChpDefault
{font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}



I had this query that was working fine before, but suddenly start giving me errors. Anyone can give me an idea where do I look for?

I get the error



p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:'Calibri','sans-serif';}
.MsoChpDefault
{font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}



[OLE/DB provider returned message: There is no catalog. ]
OLE DB error trace [OLE/DB Provider 'MSIDXS' ICommandText::Execute returned 0x8004181d].
Msg 7320, Level 16, State 2, Line 1Could not execute query against OLE DB provider 'MSIDXS'.


this is the query where BookPDF is a link index server.




Code Snippet

select * from articles INNER JOIN




((SELECT Articles_id as XID,FTBL.Rank from Articles inner join
OpenQuery(BookPDF,'select rank,filename from scope('' "" '')
where contains(contents,'' legal '')') as FTBL on Articles.[book_pdf] like '%' + FTBL.[filename] ) Union (SELECT Articles_id as XID,Keytbl.rank from Articles inner join Containstable(Articles,*,'legal') as KEYTBL on Articles.Articles_id = KEYTBL.[Key] )) as XTBL on Articles.Articles_id = XTBL.XID where (newsletter_name NOT IN(select Newsletters_id from Newsletters where Product IN (23,24)) AND (dont_show_in_search = 0
))
order by issue_date desc

View 1 Replies View Related

Merge Replication: Unique Index Error 1505

Mar 23, 2002

We are currently attempting to (Merge) replicate a database between 2 servers; distributor and subscriber. Apparently there are no Primary Keys in the database, and without the input of the developers, we can only assume that data integrity must be maintained by the application and the database is somewhat generic. In any case, what we are experiencing is that when we attempt to replicate, and you may know, you need PKs. Without any, SQL Server has utilized it's own (Row GUIDs). The Snapshot worked fine, but the merge agent reports error 1505.

The error is "CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID %d. Most significant primary key is '%S_KEY'."

The fix and workaround are SP2 and deselecting Unique in the index propoerties of the index raising the error. We already had SP2 on the system. Tried the other and still the same issue occurs.

Microsoft's Knowledgebase has nothing. Any suggestions or fixes would be greatly appreciated.

Regards,
Alex Cohen (MCSE, MCDBA, MCT)

View 1 Replies View Related

Fulltext Index Error With Query Word BARBE

Jul 30, 2007

For demonstration I created a fulltext index on table employee in Northwind database.

The following query gives an error:

SELECT * FROM employees
WHERE CONTAINS (FirstName, 'Barbe')

Replacing 'Barbe' by 'Barb' or other words it works fine.

The error message is (I have a french version of SQL installed, here the translation: "A clause in the query contains only ignored words"
Une clause de la requête ne contient que des mots ignorés)

Language for wordbreak in fulltext index is French and the error happens only with French, with English it works.

Is this a Microsoft bug?

View 1 Replies View Related

Package Migration Wizard Error -- Index Was Out Of Range

Nov 10, 2005

I am unable to migrate any DTS packages, from a SQL Server 2000 package, from a structured storage file, or from a DTS package imported into SQL2005 (Developer Edition, 32 bit).  Running the Package Migration Wizard, every time I get to the List Package screen, i get the error below.  I haven't found any other mention of this so far.  Anyone else seen this error or have suggestions?

View 20 Replies View Related

SQL 2005 Index Issue – General Network Error

Jan 2, 2007

Info: CE.Net 4.2
CF 2
SQL Server 2005

First of all, sorry for the cross post but i need a quick answer on this.

I am executing a CLR Stored Procedure from a Windows Mobile device and regularly get a general network error.

The stored procedure cycles through up to 70 tables, checking for any records between two dates. The LastUpdate field is in each one of the 70 tables and is indexed.

The mobile device regularly reports general network error, which is due to a timeout. Command timeout is now set to 10 minutes but the timeout still occurs.

The stored procedure appears to get stuck on a particular table. If I rebuild the index on this table, it will get past it but then get stuck on the next table.

I set up a maintenance plan to run every 5 minutes (extreme, I know!) but the indices would appear to corrupt (without any activity on the table) in less than this interval.

However, running the exact same query from SQL Server Management Studio works correctly every time and usually within 10 seconds.

I€™m sure that it has something to do with the indices but cannot seem to resolve the issue. It€™s even more confusing how only the mobile device is affected!

Any help or advice would be greatly appreciated.

View 3 Replies View Related

SQL Server 2014 :: Error - Cannot Create More Than One Clustered Index On Table

Aug 18, 2015

i have created a fact table which has unique cluster index as below,

CREATE UNIQUE CLUSTERED INDEX [FactSales_SalesID] ON [dbo].[FactSales] (salesid ASC)
WITH (DATA_COMPRESSION = PAGE)
GO
however later when i add CLUSTERED COLUMNSTORE INDEXES :
CREATE CLUSTERED COLUMNSTORE INDEX CSI_FactSales
ON dbo.FactSales WITH (DATA_COMPRESSION = COLUMNSTORE)
GO

it prompts error.

Msg 35372, Level 16, State 3, Line 167 You cannot create more than one clustered index on table 'dbo.FactSales'. Consider creating a new clustered index using 'with (drop_existing = on)' option.

View 4 Replies View Related

SQL Server 2014 :: Error On Unique Index - Duplicate Key When Insert / Select

Aug 4, 2014

I have an issue where I am getting an error on an unique index.

I know why I am getting the error but not sure how to get around it.

The query does a check on whether a unique value exists in the Insert/Select. If I run it one record at a time (SELECT TOP 1...) it works fine and just won't update it if the record exists.

But if I do it in a batch, I get the error. I assume this is because it does the checking on the file before records are written out and then writes out the records one at a time from a temporary table.

It thinks all the records are unique because it compares the records one at a time to the original table (where there would be no duplicates). But it doesn't check the records against each other. Then when it actually writes out the record, the duplicate is there.

How do I do a batch where the Insert/Select would write out the records without the duplicates as it does when I do it one record at a time.

CREATE TABLE #TestTable
(
Name varchar(50),
Email varchar (40)
)
Insert #TestTable (Name,Email) Values('Tom', 'tom@aol.com')

[Code] .....

View 1 Replies View Related

An Error Occurred During Local Report Processing. Index Was Outside The Bounds Of The Array.

Oct 29, 2007

I got rid of the .rdl.data files, which apparently has been a successful fix for this problem in the past. Everything worked fine Thursday when I left (I was off Friday - Saturday), but today I get this error for all but one of the reports in the solution when I try to preview the report. BTW, the published stuff works fine. Thanks in advance for any help.

View 6 Replies View Related

SQL Server 2005 Install Error (Error 29528. Unexpected Error While Installing Performance Counters. )

Jun 12, 2007

I'm currently receiving the following error message whilst attempting to install SQL Server 2005 Standard Edition on Windows Server 2003 (32 Bit):
Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.

This server already has an install of SQL Server 2000 as the default instance. I'm attempting to install a new named instance of SQL Server 2005.

Extract from log:

<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='0' GetLastError='2'>
PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
MSI (s) (4C:FC) [10:20:02:833]: Executing op: ActionStart(Name=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Removing performance counters,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1281,Source=BinaryData,Target=Rollback_Do_sqlPerfmon2,CustomActionData=100Removing performance counters200000DTSPipelineC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INI)
MSI (s) (4C:FC) [10:20:02:849]: Executing op: ActionStart(Name=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing performance counters,)
MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlPerfmon2,CustomActionData=100Installing performance counters200000C:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INIC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.HC:Program FilesMicrosoft SQL Server90DTSBinnDTSPipelinePerf.dllDTSPipeline0DTSPipelinePrfData_OpenPrfData_CollectPrfData_Close)
MSI (s) (4C:94) [10:20:02:864]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI1683.tmp, Entrypoint: Do_sqlPerfmon2
<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='2' GetLastError='2'>
PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
Gathering darwin properties for failure handling.
Error Code: 2
MSI (s) (4C!F0) [10:23:46:381]: Product: Microsoft SQL Server 2005 Integration Services -- Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.

You can ignore this and it will complete the installation, but subsequently trying to patch with SP2 will fail on the same sections - Hotfix.exe crashes whilst attempting to patch Database Services, Integration Services and Client Components (3 separate crashes).

I've removed SQL Server 2005 elements and tried to re-install, but it's not improved the situation.

Any ideas?

View 3 Replies View Related

[File System Task] Error: An Error Occurred With The Following Error Message: Access To The Path Is Denied

Sep 7, 2007

Hi -

I have an File System Task that copies a file from one directory ot another. When I hard code the target directory (c:dirfile.txt) it works fine. When I change it to a virtual directory (\serverdirfile.txt) I get a security error:

[File System Task] Error: An error occurred with the following error message: "Access to the path '\gracehbtest oS2TMM_Live_Title_000002.xml' is denied.".

Where do I change the security settings?

Thanks - Grace

View 5 Replies View Related

Exec Pkg Task: Error 0xC0202009 While Preparing To Load The Package. An OLE DB Error Has Occurred. Error Code: 0x%1!8.8X!.

Feb 21, 2007

I cannot execute a package by using Execute Package task.
I supplied sa credentials to connection manager, and it shows the list of Packages on SQL Server but when running the task it says

Error 0xC0202009 while preparing to load the package. An OLE DB error has occurred. Error code: 0x%1!8.8X!.



Any clue ?


Thanks,
Fahad

View 1 Replies View Related

Error Source : Microsoft Data Transformation Services (DTS) Package Error Description : Error Accessing Windows Event Log

Dec 13, 2007



Hi,

I am running dts in Sql Server 2005 management studio from Management, Legacy and data Transformation Services.

Once the dts has run, I get this error message "Error Source : Microsoft Data Transformation Services (DTS) Package Error Description : Error accessing Windows Event Log."

Please help me

thanks in advance

Srinivas



View 1 Replies View Related

Language Error When Creating FULLTEXT INDEX By Using SQL Server 2005 Management Express!

Apr 12, 2007

Hello..
When I used Microsoft SQL Server 2005 Management Studio Express to Create FULL TEXT INDEX by this code:

CREATE FULLTEXT INDEX ON txtfilestbl(txtfile) KEY INDEX PK_txtfilestbl ON ForumsArchiveLibCtlg WITH CHANGE_TRACKING AUTO

It returns this ERR MSG:

Informational: No full-text supported languages found.
Informational: No full-text supported languages found.
Msg 7680, Level 16, State 1, Line 1
Default full-text index language is not a language supported by full-text search.

I Use same this code to create FULL TEXT INDEX by using Microsoft SQL Server 2005 Management Studio, and it was working properly.
What I have to do?

View 2 Replies View Related

An Internal Error Occurred On The Report Server. See The Error Log For More Details. RsInternal Error)

May 20, 2008

We have reports deployed in the Report Server. While connecting from client, we are getting the error
"An internal error occurred on the report server. See the error log for more details. rsInternal Error)"

Then we went to Report Server, Reporting Service and SQL Server service are all are running fine.

Important thing is some time the reports are working fine, sometimes i am receiving this error. Please help.

We predict whether the services are automatically restarted or transaction logs exceeding the limit or any other parameters to set to avaoid this error?

Please help.

View 1 Replies View Related

[XML Task] Error: An Error Occurred With The Following Error Message: There Are Multiple Root Elements.

Aug 18, 2006

I'm trying to use an XML Task to do a simple XSLT operation, but it fails with this error message:

[XML Task] Error: An error occurred with the following error message: "There are multiple root elements. Line 5, position 2.".

The source XML file validates fine and I've successfully used it as the XML Source in a data flow task to load some SQL Server tables. It has very few line breaks, so the first 5 lines are pretty long: almost 4000 characters, including 34 start-tags, 19 end-tags, and 2 empty element tags. Here's the very beginning of it:

<?xml version="1.0" encoding="UTF-8"?>
<ESDU releaselevel="2006-02" createdate="26 May 2006"><package id="1" title="_standard" shorttitle="_standard" filename="pk_stan" supplementdate="01/05/2005" supplementlevel="1"><abstract><![CDATA[This package contains the standard ESDU Series.]]></abstract>

There is only 1 ESDU root element and only 1 package element.

Of course, the XSLT stylesheet is also an XML document in its own right. I specify it directly in the XML Task:

<?xml version="1.0" encoding="UTF-8"?>

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"/>

<xsl:template name="identity" match="@*|node()">
<xsl:copy>
<xsl:apply-templates select="@*|node()"/>
</xsl:copy>
</xsl:template>

<xsl:template match="kw">
<xsl:copy>
<xsl:apply-templates select="@*"/>
<xsl:attribute name="ihs_cats_seq" select="position()"/>
<xsl:apply-templates select="node()"/>
</xsl:copy>
</xsl:template>

</xsl:stylesheet>


Its 5th line is the first xsl:template element.

What is going on here? I do not see multiple root elements in either the XML document or the XSLT stylesheet.

Thanks!

View 5 Replies View Related

I Have The Dreaded Internal Error Occured On The Report Server. See Error Log For More Details No Error Log

Apr 9, 2008

I have the error above, but no error log. I can preview the sub report - but this main report fails after working this morning. This is for internal company reports and I rebuilt this one after converting from access.
I have looked where the error logs should be, but there are no error logs.
I rebuilt the query as I needed to change this, but this did not help.
Is there someone who could point me in the correct direction.

Thanks!
Terry

View 4 Replies View Related

Just Started Getting This Error When Trying To Connect To SQL From ASP.NET--error: 26 - Error Locating Server/Instance Specified

Apr 3, 2007

This has worked fine for weeks, and months.

I'm running Vista Ultimate. SQL 2005 is set as my Default instance, and SQL2000 is set as (local)SQL2000.

Today, actually half way through today, I restarted my computer after installing Photoshop Updates.

Upon getting my computer back up and running, I cannot access SQL2000 from any website on my computer, nor can I access it from SQL2005 Management Stdio. I CAN access it from Enterprise Manager (SQL2000 tool).

Whenever I run an web app that connects to it I get this error:


An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Now I usually get these when ASP.NET can't point to the right spot, but in this case I'm pointing exactly where I need to go. Any thoughts?

--Edit

I should also add my password got changed a few days ago on our Domain. This was the first time restarting after the PW change.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved