Please help me out with this error!

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

All Forums

General SQL Server Forums

Data Corruption Issues

Please help me out with this error!

Author

Topic

aa_ronnie
Starting Member

10 Posts

Posted - 2005-12-08 : 10:04:22

Database Server: Microsoft SQL Server
Version: 08.00.0194
Runtime Error: [Microsoft][ODBC SQL Server Driver][SQL Server]
Attempt to fetch logical page (1:39952) in database 'TEST' belongs to object 'wip_discrete_jobs', not to object 'wip_requirement_operations'

RONNIE

aa_ronnie
Starting Member

10 Posts

Posted - 2005-12-08 : 10:10:24

Following is the output from 'DBCC CHECKDB':

Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:39888) in database ID 7 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:39896) in database ID 7 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:39904) in database ID 7 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:39912) in database ID 7 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:39936) in database ID 7 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8904, Level 16, State 1, Line 1
Extent (1:39952) in database ID 7 is allocated by more than one allocation object.
Server: Msg 8913, Level 16, State 1, Line 1
Extent (1:39952) is allocated to 'GAM' and at least one other object.
Server: Msg 8913, Level 16, State 1, Line 1
Extent (1:39952) is allocated to 'wip_requirement_operations' and at least one other object.
DBCC results for 'TEST'.
CHECKDB found 7 allocation errors and 0 consistency errors not associated with any single object.
DBCC results for 'sysobjects'.
There are 704 rows in 12 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 1895 rows in 95 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 19225 rows in 492 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 524 rows in 222 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 18 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 0 rows in 0 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 10360 rows in 62 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 0 rows in 0 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 'txns_misc'.
There are 37499 rows in 1141 pages for object 'txns_misc'.
DBCC results for 'temp'.
There are 10374 rows in 558 pages for object 'temp'.
DBCC results for 'po_unique_identifier_cont_all'.
There are 0 rows in 0 pages for object 'po_unique_identifier_cont_all'.
DBCC results for 'cst_activity'.
There are 0 rows in 0 pages for object 'cst_activity'.
DBCC results for 'ar_salesreps_forecast'.
There are 145 rows in 3 pages for object 'ar_salesreps_forecast'.
DBCC results for 'po_usages'.
There are 0 rows in 0 pages for object 'po_usages'.
DBCC results for 'cst_resource_costs'.
There are 0 rows in 0 pages for object 'cst_resource_costs'.
DBCC results for 'Per_jobs'.
There are 0 rows in 0 pages for object 'Per_jobs'.
DBCC results for 'cst_cost_types'.
There are 4 rows in 1 pages for object 'cst_cost_types'.
DBCC results for 'dtproperties'.
There are 0 rows in 0 pages for object 'dtproperties'.
DBCC results for 'Per_all_positions'.
There are 0 rows in 0 pages for object 'Per_all_positions'.
DBCC results for 'po_vendor_sites_all'.
There are 325 rows in 67 pages for object 'po_vendor_sites_all'.
DBCC results for 'cst_item_costs'.
There are 7442 rows in 276 pages for object 'cst_item_costs'.
DBCC results for 'per_assignments'.
There are 0 rows in 0 pages for object 'per_assignments'.
DBCC results for 'Rcv_lot_transactions'.
There are 0 rows in 0 pages for object 'Rcv_lot_transactions'.
DBCC results for 'cst_item_cost_details'.
There are 0 rows in 0 pages for object 'cst_item_cost_details'.
DBCC results for 'per_addresses'.
There are 0 rows in 0 pages for object 'per_addresses'.
DBCC results for 'bom_routing_revisions'.
There are 1526 rows in 20 pages for object 'bom_routing_revisions'.
DBCC results for 'Rcv_lots_supply'.
There are 0 rows in 0 pages for object 'Rcv_lots_supply'.
DBCC results for 'cst_resource_overheads'.
There are 0 rows in 0 pages for object 'cst_resource_overheads'.
DBCC results for 'hr_s_common_lookups'.
There are 0 rows in 0 pages for object 'hr_s_common_lookups'.
DBCC results for 'Rcv_parameters'.
There are 2 rows in 1 pages for object 'Rcv_parameters'.
DBCC results for 'cst_department_overheads'.
There are 0 rows in 0 pages for object 'cst_department_overheads'.
DBCC results for 'rcv_receiving_sub_ledger'.
There are 0 rows in 0 pages for object 'rcv_receiving_sub_ledger'.
DBCC results for 'cst_update_transactions'.
There are 2 rows in 1 pages for object 'cst_update_transactions'.
DBCC results for 'rcv_route_steps'.
There are 0 rows in 0 pages for object 'rcv_route_steps'.
DBCC results for 'cst_update_accounts'.
There are 4 rows in 1 pages for object 'cst_update_accounts'.
DBCC results for 'Rcv_routing_headers'.
There are 0 rows in 0 pages for object 'Rcv_routing_headers'.
DBCC results for 'cst_cost_groups'.
There are 0 rows in 0 pages for object 'cst_cost_groups'.
DBCC results for 'Rcv_serial_transactions'.
There are 0 rows in 0 pages for object 'Rcv_serial_transactions'.
DBCC results for 'cst_cost_group_accounts'.
There are 0 rows in 0 pages for object 'cst_cost_group_accounts'.
DBCC results for 'rcv_serials_supply'.
There are 0 rows in 0 pages for object 'rcv_serials_supply'.
DBCC results for 'mfg_lookup'.
There are 2991 rows in 49 pages for object 'mfg_lookup'.
DBCC results for 'rcv_shpment_h'.
There are 8590 rows in 579 pages for object 'rcv_shpment_h'.
DBCC results for 'rcv_shpment_l'.
There are 12491 rows in 888 pages for object 'rcv_shpment_l'.
DBCC results for 'rcv_shpment_l_temp'.
There are 61 rows in 8 pages for object 'rcv_shpment_l_temp'.
DBCC results for 'msi1'.
There are 11420 rows in 1184 pages for object 'msi1'.
DBCC results for 'mtl_categories'.
There are 0 rows in 0 pages for object 'mtl_categories'.
DBCC results for 'rcv_supply'.
There are 0 rows in 4 pages for object 'rcv_supply'.
DBCC results for 'mtl_category_sets'.
There are 0 rows in 0 pages for object 'mtl_category_sets'.
DBCC results for 'mtl_category_set_valid_cats'.
There are 0 rows in 0 pages for object 'mtl_category_set_valid_cats'.
DBCC results for 'bom_alternate_designators'.
There are 6 rows in 1 pages for object 'bom_alternate_designators'.
DBCC results for 'Org_organization_unit'.
There are 3 rows in 1 pages for object 'Org_organization_unit'.
DBCC results for 'mtl_default_category_sets'.
There are 0 rows in 0 pages for object 'mtl_default_category_sets'.
DBCC results for 'bom_department_class'.
There are 2 rows in 1 pages for object 'bom_department_class'.
DBCC results for 'mtl_item_categories'.
There are 0 rows in 0 pages for object 'mtl_item_categories'.
DBCC results for 'bom_departments'.
There are 3 rows in 1 pages for object 'bom_departments'.
DBCC results for 'bom_department_resources'.
There are 20 rows in 1 pages for object 'bom_department_resources'.
DBCC results for 'soh'.
There are 1947 rows in 217 pages for object 'soh'.
DBCC results for 'bom_calendars'.
There are 0 rows in 0 pages for object 'bom_calendars'.
DBCC results for 'ap_bank_branches'.
There are 0 rows in 0 pages for object 'ap_bank_branches'.
DBCC results for 'sol'.
There are 2276 rows in 1139 pages for object 'sol'.
DBCC results for 'coa_b'.
There are 1 rows in 1 pages for object 'coa_b'.
DBCC results for 'bom_calendar_dates'.
There are 0 rows in 0 pages for object 'bom_calendar_dates'.
DBCC results for 'ap_bank_account_uses'.
There are 0 rows in 0 pages for object 'ap_bank_account_uses'.
DBCC results for 'sod'.
There are 2642 rows in 150 pages for object 'sod'.
DBCC results for 'bom_calendar_exceptions'.
There are 0 rows in 0 pages for object 'bom_calendar_exceptions'.
DBCC results for 'ap_bank_accounts'.
There are 0 rows in 0 pages for object 'ap_bank_accounts'.
DBCC results for 'subinvs'.
There are 6 rows in 1 pages for object 'subinvs'.
DBCC results for 'soc'.
There are 0 rows in 0 pages for object 'soc'.
DBCC results for 'bom_calendar_shifts'.
There are 0 rows in 0 pages for object 'bom_calendar_shifts'.
DBCC results for 'sys_errors'.
There are 0 rows in 0 pages for object 'sys_errors'.
DBCC results for 'sys_lan_distr'.
There are 0 rows in 0 pages for object 'sys_lan_distr'.
DBCC results for 'bom_cal_week_start_dates'.
There are 0 rows in 0 pages for object 'bom_cal_week_start_dates'.
DBCC results for 'txn_lotno'.
There are 0 rows in 0 pages for object 'txn_lotno'.
DBCC results for 'sys_menu_tree'.
There are 0 rows in 0 pages for object 'sys_menu_tree'.
DBCC results for 'mrp_material_plans'.
There are 0 rows in 0 pages for object 'mrp_material_plans'.
DBCC results for 'bom_cal_year_start_dates'.
There are 0 rows in 0 pages for object 'bom_cal_year_start_dates'.
DBCC results for 'sys_user_menu_tree'.
There are 0 rows in 0 pages for object 'sys_user_menu_tree'.
DBCC results for 'bom_explosions'.
There are 0 rows in 0 pages for object 'bom_explosions'.
DBCC results for 'txns_misc_h'.
There are 12631 rows in 169 pages for object 'txns_misc_h'.
DBCC results for 'sys_flexfields'.
There are 0 rows in 0 pages for object 'sys_flexfields'.
DBCC results for 'txns_rcv'.
There are 35423 rows in 1279 pages for object 'txns_rcv'.
DBCC results for 'sys_flexfield_value'.
There are 0 rows in 0 pages for object 'sys_flexfield_value'.
DBCC results for 'txns_stk'.
There are 0 rows in 0 pages for object 'txns_stk'.
DBCC results for 'ar_customer_trx'.
There are 0 rows in 0 pages for object 'ar_customer_trx'.
DBCC results for 'sys_error_log'.
There are 0 rows in 0 pages for object 'sys_error_log'.
DBCC results for 'txns_tot'.
There are 0 rows in 0 pages for object 'txns_tot'.
DBCC results for 'ar_customer_trx_lines'.
There are 0 rows in 0 pages for object 'ar_customer_trx_lines'.
DBCC results for 'reports_list'.
There are 0 rows in 0 pages for object 'reports_list'.
DBCC results for 'units_of_measure'.
There are 7 rows in 1 pages for object 'units_of_measure'.
DBCC results for 'ar_customers'.
There are 61 rows in 9 pages for object 'ar_customers'.
DBCC results for 'reports_result_list'.
There are 0 rows in 0 pages for object 'reports_result_list'.
DBCC results for 'bom_period_start_dates'.
There are 0 rows in 0 pages for object 'bom_period_start_dates'.
DBCC results for 'uom_class'.
There are 4 rows in 1 pages for object 'uom_class'.
DBCC results for 'ar_cus_address'.
There are 119 rows in 17 pages for object 'ar_cus_address'.
DBCC results for 'sys_rpts'.
There are 0 rows in 0 pages for object 'sys_rpts'.
DBCC results for 'gl_je_headers'.
There are 47 rows in 2 pages for object 'gl_je_headers'.
DBCC results for 'bom_resources'.
There are 20 rows in 1 pages for object 'bom_resources'.
DBCC results for 'gl_je_sources'.
There are 1 rows in 1 pages for object 'gl_je_sources'.
DBCC results for 'uom_class_conversions'.
There are 0 rows in 0 pages for object 'uom_class_conversions'.
DBCC results for 'ar_site_uses_all'.
There are 225 rows in 17 pages for object 'ar_site_uses_all'.
DBCC results for 'sys_rpts_assign'.
There are 0 rows in 0 pages for object 'sys_rpts_assign'.
DBCC results for 'bom_inventory_components'.
There are 12716 rows in 533 pages for object 'bom_inventory_components'.
DBCC results for 'gl_je_lines'.
There are 257 rows in 9 pages for object 'gl_je_lines'.
DBCC results for 'bom_resource_change'.
There are 0 rows in 0 pages for object 'bom_resource_change'.
DBCC results for 'gl_je_categories'.
There are 1 rows in 1 pages for object 'gl_je_categories'.
DBCC results for 'uom_conversions'.
There are 0 rows in 0 pages for object 'uom_conversions'.
DBCC results for 'ar_phones'.
There are 476 rows in 14 pages for object 'ar_phones'.
DBCC results for 'bom_resource_shifts'.
There are 0 rows in 0 pages for object 'bom_resource_shifts'.
DBCC results for 'inv_parameters'.
There are 2 rows in 1 pages for object 'inv_parameters'.
DBCC results for 'ven_contacts'.
There are 310 rows in 10 pages for object 'ven_contacts'.
DBCC results for 'ar_contacts'.
There are 185 rows in 19 pages for object 'ar_contacts'.
DBCC results for 'fnd_territories'.
There are 0 rows in 0 pages for object 'fnd_territories'.
DBCC results for 'ap_terms'.
There are 5 rows in 1 pages for object 'ap_terms'.
DBCC results for 'bom_shift_dates'.
There are 0 rows in 0 pages for object 'bom_shift_dates'.
DBCC results for 'ar_contact_roles'.
There are 1 rows in 1 pages for object 'ar_contact_roles'.
DBCC results for 'fnd_territories_tl'.
There are 0 rows in 0 pages for object 'fnd_territories_tl'.
DBCC results for 'ap_terms_lines'.
There are 1 rows in 1 pages for object 'ap_terms_lines'.
DBCC results for 'gl_authorization_limits'.
There are 0 rows in 0 pages for object 'gl_authorization_limits'.
DBCC results for 'bom_shift_exceptions'.
There are 0 rows in 0 pages for object 'bom_shift_exceptions'.
DBCC results for 'ar_receipt_methods'.
There are 0 rows in 0 pages for object 'ar_receipt_methods'.
DBCC results for 'fnd_common_lookups'.
There are 1954 rows in 32 pages for object 'fnd_common_lookups'.
DBCC results for 'gl_approval_history'.
There are 0 rows in 0 pages for object 'gl_approval_history'.
DBCC results for 'bom_shift_times'.
There are 0 rows in 0 pages for object 'bom_shift_times'.
DBCC results for 'ar_customer_relationships'.
There are 1 rows in 1 pages for object 'ar_customer_relationships'.
DBCC results for 'fnd_common_lookup_types'.
There are 457 rows in 7 pages for object 'fnd_common_lookup_types'.
DBCC results for 'bom_standard_comments'.
There are 0 rows in 0 pages for object 'bom_standard_comments'.
DBCC results for 'wip_parameters'.
There are 2 rows in 1 pages for object 'wip_parameters'.
DBCC results for 'ar_salesreps_all'.
There are 13 rows in 7 pages for object 'ar_salesreps_all'.
DBCC results for 'bom_standard_instructions'.
There are 0 rows in 0 pages for object 'bom_standard_instructions'.
DBCC results for 'gl_code_combinations'.
There are 605 rows in 14 pages for object 'gl_code_combinations'.
DBCC results for 'ar_salesrep_territories'.
There are 0 rows in 0 pages for object 'ar_salesrep_territories'.
DBCC results for 'bom_standard_operations'.
There are 6 rows in 1 pages for object 'bom_standard_operations'.
DBCC results for 'ar_system_parameters_all'.
There are 0 rows in 0 pages for object 'ar_system_parameters_all'.
DBCC results for 'bom_std_op_resources'.
There are 0 rows in 0 pages for object 'bom_std_op_resources'.
DBCC results for 'ar_lookups'.
There are 1421 rows in 711 pages for object 'ar_lookups'.
DBCC results for 'wip_operation_ovhd'.
There are 0 rows in 0 pages for object 'wip_operation_ovhd'.
DBCC results for 'mrp_gross_requirements'.
There are 34 rows in 18 pages for object 'mrp_gross_requirements'.
DBCC results for 'bom_workday_patterns'.
There are 0 rows in 0 pages for object 'bom_workday_patterns'.
DBCC results for 'ar_lookup_types'.
There are 307 rows in 154 pages for object 'ar_lookup_types'.
DBCC results for 'mrp_recommendations'.
There are 2050 rows in 147 pages for object 'mrp_recommendations'.
DBCC results for 'gl_lookups'.
There are 616 rows in 12 pages for object 'gl_lookups'.
DBCC results for 'ar_territories'.
There are 0 rows in 0 pages for object 'ar_territories'.
DBCC results for 'mtl_transaction_misc_accounts'.
There are 5770 rows in 172 pages for object 'mtl_transaction_misc_accounts'.
DBCC results for 'fnd_document_sequences'.
There are 1 rows in 1 pages for object 'fnd_document_sequences'.
DBCC results for 'ar_vat_tax'.
There are 0 rows in 0 pages for object 'ar_vat_tax'.
DBCC results for 'wip_period_balances'.
There are 0 rows in 0 pages for object 'wip_period_balances'.
DBCC results for 'mrp_item_wip_entities'.
There are 5022 rows in 129 pages for object 'mrp_item_wip_entities'.
DBCC results for 'mtl_transaction_accounts'.
There are 0 rows in 0 pages for object 'mtl_transaction_accounts'.
DBCC results for 'fnd_doc_sequence_assignments'.
There are 1 rows in 1 pages for object 'fnd_doc_sequence_assignments'.
DBCC results for 'mrp_parameters'.
There are 0 rows in 0 pages for object 'mrp_parameters'.
DBCC results for 'ar_cust_receipt_methods'.
There are 0 rows in 0 pages for object 'ar_cust_receipt_methods'.
DBCC results for 'wip_flow_schedules'.
There are 0 rows in 0 pages for object 'wip_flow_schedules'.
DBCC results for 'mrp_item_purchase_orders'.
There are 252 rows in 25 pages for object 'mrp_item_purchase_orders'.
DBCC results for 'gl_je_batches'.
There are 4 rows in 1 pages for object 'gl_je_batches'.
DBCC results for 'wip_move_transactions'.
There are 1834 rows in 69 pages for object 'wip_move_transactions'.
DBCC results for 'mrp_designators'.
There are 1 rows in 1 pages for object 'mrp_designators'.
DBCC results for 'ar_cus_profile_amts'.
There are 0 rows in 0 pages for object 'ar_cus_profile_amts'.
DBCC results for 'mrp_wip_components'.
There are 0 rows in 0 pages for object 'mrp_wip_components'.
DBCC results for 'gl_daily_conversion_types'.
There are 3 rows in 1 pages for object 'gl_daily_conversion_types'.
DBCC results for 'ar_cus_profiles'.
There are 0 rows in 0 pages for object 'ar_cus_profiles'.
DBCC results for 'wip_transaction_accounts'.
There are 0 rows in 0 pages for object 'wip_transaction_accounts'.
DBCC results for 'mrp_wip_resources'.
There are 0 rows in 0 pages for object 'mrp_wip_resources'.
DBCC results for 'gl_je_lines_temp'.
There are 0 rows in 0 pages for object 'gl_je_lines_temp'.
DBCC results for 'ar_cus_profile_classes'.
There are 0 rows in 0 pages for object 'ar_cus_profile_classes'.
DBCC results for 'wip_shop_floor_statuses'.
There are 0 rows in 0 pages for object 'wip_shop_floor_statuses'.
DBCC results for 'gl_balances'.
There are 0 rows in 0 pages for object 'gl_balances'.
DBCC results for 'wip_shop_floor_status_codes'.
There are 0 rows in 0 pages for object 'wip_shop_floor_status_codes'.
DBCC results for 'ar_terms'.
There are 0 rows in 0 pages for object 'ar_terms'.
DBCC results for 'ap_system_parameters_all'.
There are 0 rows in 0 pages for object 'ap_system_parameters_all'.
DBCC results for 'ar_terms_lines'.
There are 0 rows in 0 pages for object 'ar_terms_lines'.
DBCC results for 'Bom_bill_of_materials'.
There are 1468 rows in 46 pages for object 'Bom_bill_of_materials'.
DBCC results for 'org_freight'.
There are 3 rows in 2 pages for object 'org_freight'.
DBCC results for 'gl_period_types'.
There are 1 rows in 1 pages for object 'gl_period_types'.
DBCC results for 'ap_lookup_types'.
There are 207 rows in 104 pages for object 'ap_lookup_types'.
DBCC results for 'ar_terms_lines_discounts'.
There are 0 rows in 0 pages for object 'ar_terms_lines_discounts'.
DBCC results for 'wsh_departures'.
There are 792 rows in 398 pages for object 'wsh_departures'.
DBCC results for 'ap_lookup_codes'.
There are 2076 rows in 1038 pages for object 'ap_lookup_codes'.
DBCC results for 'ar_dunning_letter_sets'.
There are 0 rows in 0 pages for object 'ar_dunning_letter_sets'.
DBCC results for 'wsh_deliveries'.
There are 783 rows in 393 pages for object 'wsh_deliveries'.
DBCC results for 'ap_web_signing_limits'.
There are 0 rows in 0 pages for object 'ap_web_signing_limits'.
DBCC results for 'pofv_quotations'.
There are 0 rows in 0 pages for object 'pofv_quotations'.
DBCC results for 'mtl_demand'.
There are 0 rows in 0 pages for object 'mtl_demand'.
DBCC results for 'mtl_item_revisions'.
There are 7479 rows in 96 pages for object 'mtl_item_revisions'.
DBCC results for 'ap_approval_history'.
There are 0 rows in 0 pages for object 'ap_approval_history'.
DBCC results for 'pofv_quotation_lines'.
There are 0 rows in 0 pages for object 'pofv_quotation_lines'.
DBCC results for 'ap_aging_periods'.
There are 0 rows in 0 pages for object 'ap_aging_periods'.
DBCC results for 'pofv_quotation_price_breaks'.
There are 0 rows in 0 pages for object 'pofv_quotation_price_breaks'.
DBCC results for 'ap_aging_period_lines'.
There are 0 rows in 0 pages for object 'ap_aging_period_lines'.
DBCC results for 'pofv_quotation_shipments'.
There are 0 rows in 0 pages for object 'pofv_quotation_shipments'.
DBCC results for 'mtl_customer_items'.
There are 190 rows in 4 pages for object 'mtl_customer_items'.
DBCC results for 'financials_system_parameters'.
There are 0 rows in 0 pages for object 'financials_system_parameters'.
DBCC results for 'mtl_reservations'.
There are 11 rows in 2 pages for object 'mtl_reservations'.
DBCC results for 'mtl_commodity_codes'.
There are 0 rows in 0 pages for object 'mtl_commodity_codes'.
DBCC results for 'ap_batches_all'.
There are 0 rows in 0 pages for object 'ap_batches_all'.
DBCC results for 'mtl_customer_item_xrefs'.
There are 183 rows in 3 pages for object 'mtl_customer_item_xrefs'.
DBCC results for 'ap_invoices_all'.
There are 0 rows in 0 pages for object 'ap_invoices_all'.
DBCC results for 'ap_invoice_distributions_all'.
There are 0 rows in 0 pages for object 'ap_invoice_distributions_all'.
DBCC results for 'so_lookups'.
There are 506 rows in 253 pages for object 'so_lookups'.
DBCC results for 'ap_tolerances_all'.
There are 0 rows in 0 pages for object 'ap_tolerances_all'.
DBCC results for 'so_lookup_types'.
There are 142 rows in 71 pages for object 'so_lookup_types'.
DBCC results for 'ap_holds_all'.
There are 0 rows in 0 pages for object 'ap_holds_all'.
DBCC results for 'so_picking_rules'.
There are 0 rows in 0 pages for object 'so_picking_rules'.
DBCC results for 'cus'.
There are 0 rows in 0 pages for object 'cus'.
DBCC results for 'mtl_so_rma_interface'.
There are 29 rows in 2 pages for object 'mtl_so_rma_interface'.
DBCC results for 'ap_hold_codes'.
There are 0 rows in 0 pages for object 'ap_hold_codes'.
DBCC results for 'so_report_sets'.
There are 0 rows in 0 pages for object 'so_report_sets'.
DBCC results for 'cus_address'.
There are 0 rows in 0 pages for object 'cus_address'.
DBCC results for 'mtl_so_rma_receipts'.
There are 54 rows in 2 pages for object 'mtl_so_rma_receipts'.
DBCC results for 'ap_awt_groups'.
There are 0 rows in 0 pages for object 'ap_awt_groups'.
DBCC results for 'so_reports'.
There are 0 rows in 0 pages for object 'so_reports'.
DBCC results for 'cus_contacts'.
There are 0 rows in 0 pages for object 'cus_contacts'.
DBCC results for 'ap_tax_codes_all'.
There are 0 rows in 0 pages for object 'ap_tax_codes_all'.
DBCC results for 'so_report_set_lines'.
There are 0 rows in 0 pages for object 'so_report_set_lines'.
DBCC results for 'delivery'.
There are 0 rows in 0 pages for object 'delivery'.
DBCC results for 'gl_period_sets'.
There are 1 rows in 1 pages for object 'gl_period_sets'.
DBCC results for 'ap_awt_tax_rates_all'.
There are 0 rows in 0 pages for object 'ap_awt_tax_rates_all'.
DBCC results for 'so_freight_charges'.
There are 0 rows in 0 pages for object 'so_freight_charges'.
DBCC results for 'departure'.
There are 0 rows in 0 pages for object 'departure'.
DBCC results for 'mrp_safety_stock'.
There are 0 rows in 0 pages for object 'mrp_safety_stock'.
DBCC results for 'gl_periods'.
There are 12 rows in 1 pages for object 'gl_periods'.
DBCC results for 'ap_distribution_sets_all'.
There are 0 rows in 0 pages for object 'ap_distribution_sets_all'.
DBCC results for 'so_freight_charge_types'.
There are 0 rows in 0 pages for object 'so_freight_charge_types'.
DBCC results for 'fnd_currencies'.
There are 4 rows in 1 pages for object 'fnd_currencies'.
DBCC results for 'ap_distribution_set_lines_all'.
There are 0 rows in 0 pages for object 'ap_distribution_set_lines_all'.
DBCC results for 'so_sales_credit_types'.
There are 0 rows in 0 pages for object 'so_sales_credit_types'.
DBCC results for 'wsh_release_seq_rules'.
There are 0 rows in 0 pages for object 'wsh_release_seq_rules'.
DBCC results for 'ap_matching_temp'.
There are 0 rows in 0 pages for object 'ap_matching_temp'.
DBCC results for 'so_price_lists'.
There are 60 rows in 30 pages for object 'so_price_lists'.
DBCC results for 'wsh_pick_slip_rules'.
There are 0 rows in 0 pages for object 'wsh_pick_slip_rules'.
DBCC results for 'ap_income_tax_regions'.
There are 0 rows in 0 pages for object 'ap_income_tax_regions'.
DBCC results for 'so_price_list_lines'.
There are 522 rows in 175 pages for object 'so_price_list_lines'.
DBCC results for 'gl_daily_rates'.
There are 1095 rows in 13 pages for object 'gl_daily_rates'.
DBCC results for 'wsh_parameters'.
There are 1 rows in 1 pages for object 'wsh_parameters'.
DBCC results for 'pa_projects_all'.
There are 0 rows in 0 pages for object 'pa_projects_all'.
DBCC results for 'so_price_break_lines'.
There are 0 rows in 0 pages for object 'so_price_break_lines'.
DBCC results for 'wsh_container_load'.
There are 0 rows in 0 pages for object 'wsh_container_load'.
DBCC results for 'pa_tasks'.
There are 0 rows in 0 pages for object 'pa_tasks'.
DBCC results for 'so_price_adjustments'.
There are 0 rows in 0 pages for object 'so_price_adjustments'.
DBCC results for 'gl_period_set'.
There are 0 rows in 0 pages for object 'gl_period_set'.
DBCC results for 'wip_transactions'.
There are 50486 rows in 1862 pages for object 'wip_transactions'.
DBCC results for 'ap_payment_schedules_all'.
There are 0 rows in 0 pages for object 'ap_payment_schedules_all'.
DBCC results for 'so_agreements'.
There are 0 rows in 0 pages for object 'so_agreements'.
DBCC results for 'wip_accounting_classes'.
There are 2 rows in 1 pages for object 'wip_accounting_classes'.
DBCC results for 'ap_payment_schedules_temp'.
There are 0 rows in 0 pages for object 'ap_payment_schedules_temp'.
DBCC results for 'so_number_sources'.
There are 5 rows in 2 pages for object 'so_number_sources'.
DBCC results for 'gl_sets_of_books'.
There are 1 rows in 1 pages for object 'gl_sets_of_books'.
DBCC results for 'ap_checks_all'.
There are 0 rows in 0 pages for object 'ap_checks_all'.
DBCC results for 'hr_locations'.
There are 2 rows in 1 pages for object 'hr_locations'.
DBCC results for 'ap_check_formats'.
There are 0 rows in 0 pages for object 'ap_check_formats'.
DBCC results for 'ap_inv_selection_criteria_all'.
There are 0 rows in 0 pages for object 'ap_inv_selection_criteria_all'.
DBCC results for 'locator_items'.
There are 0 rows in 0 pages for object 'locator_items'.
DBCC results for 'ap_check_stocks_all'.
There are 0 rows in 0 pages for object 'ap_check_stocks_all'.
DBCC results for 'locators'.
There are 0 rows in 0 pages for object 'locators'.
DBCC results for 'coa_base'.
There are 388 rows in 10 pages for object 'coa_base'.
DBCC results for 'ap_invoice_payments_all'.
There are 0 rows in 0 pages for object 'ap_invoice_payments_all'.
DBCC results for 'so_picking_line_details'.
There are 1900 rows in 90 pages for object 'so_picking_line_details'.
DBCC results for 'lotno'.
There are 0 rows in 0 pages for object 'lotno'.
DBCC results for 'mtl_safety_stock'.
There are 0 rows in 0 pages for object 'mtl_safety_stock'.
DBCC results for 'so_picking_lines_all'.
There are 1900 rows in 72 pages for object 'so_picking_lines_all'.
DBCC results for 'so_picking_headers_all'.
There are 1792 rows in 48 pages for object 'so_picking_headers_all'.
DBCC results for 'wip_entity'.
There are 10374 rows in 171 pages for object 'wip_entity'.
DBCC results for 'so_picking_batches_all'.
There are 745 rows in 374 pages for object 'so_picking_batches_all'.
DBCC results for 'so_results'.
There are 21 rows in 1 pages for object 'so_results'.
DBCC results for 'mtl_generic_disposition'.
There are 2 rows in 1 pages for object 'mtl_generic_disposition'.
DBCC results for 'spld_tmp'.
There are 0 rows in 0 pages for object 'spld_tmp'.
DBCC results for 'wip_operations'.
There are 12636 rows in 419 pages for object 'wip_operations'.
DBCC results for 'so_history'.
There are 3398 rows in 57 pages for object 'so_history'.
DBCC results for 'Mtl_physical_adjustments'.
There are 0 rows in 0 pages for object 'Mtl_physical_adjustments'.
DBCC results for 'gl_period_statuses'.
There are 48 rows in 2 pages for object 'gl_period_statuses'.
DBCC results for 'spl_tmp'.
There are 0 rows in 0 pages for object 'spl_tmp'.
DBCC results for 'msi'.
There are 11420 rows in 318 pages for object 'msi'.
DBCC results for 'Mtl_physical_inventories'.
There are 0 rows in 0 pages for object 'Mtl_physical_inventories'.
DBCC results for 'bom_operational_routings'.
There are 1508 rows in 49 pages for object 'bom_operational_routings'.
DBCC results for 'sp_tmp'.
There are 0 rows in 0 pages for object 'sp_tmp'.
DBCC results for 'wip_operation_res'.
There are 10830 rows in 255 pages for object 'wip_operation_res'.
DBCC results for 'Mtl_physical_inventory_tags'.
There are 0 rows in 0 pages for object 'Mtl_physical_inventory_tags'.
DBCC results for 'mrp_schedule_designators'.
There are 3 rows in 2 pages for object 'mrp_schedule_designators'.
DBCC results for 'so_transactions'.
There are 1706 rows in 41 pages for object 'so_transactions'.
DBCC results for 'wip_requirement_operations'.
There are 79986 rows in 1955 pages for object 'wip_requirement_operations'.
CHECKDB found 1 allocation errors and 0 consistency errors in table 'wip_requirement_operations' (object ID 1440724185).
DBCC results for 'Mtl_physical_subinventories'.
There are 0 rows in 0 pages for object 'Mtl_physical_subinventories'.
DBCC results for 'mrp_schedule_dates'.
There are 124 rows in 4 pages for object 'mrp_schedule_dates'.
DBCC results for 'mtl_transaction_action'.
There are 14 rows in 1 pages for object 'mtl_transaction_action'.
DBCC results for 'sod_tmp'.
There are 1015 rows in 7 pages for object 'sod_tmp'.
DBCC results for 'bom_operation_sequences'.
There are 1998 rows in 65 pages for object 'bom_operation_sequences'.
DBCC results for 'mrp_schedule_items'.
There are 91 rows in 2 pages for object 'mrp_schedule_items'.
DBCC results for 'mtl_transaction_reasons'.
There are 17 rows in 1 pages for object 'mtl_transaction_reasons'.
DBCC results for 'sod_tmp1'.
There are 0 rows in 2 pages for object 'sod_tmp1'.
DBCC results for 'mtl_transaction_types'.
There are 14 rows in 1 pages for object 'mtl_transaction_types'.
DBCC results for 'mrp_schedule_consumptions'.
There are 0 rows in 0 pages for object 'mrp_schedule_consumptions'.
DBCC results for 'mtl_txn_accounts'.
There are 0 rows in 0 pages for object 'mtl_txn_accounts'.
DBCC results for 'mrp_scheduling_rules'.
There are 0 rows in 0 pages for object 'mrp_scheduling_rules'.
DBCC results for 'mtl_txn_source_types'.
There are 7 rows in 1 pages for object 'mtl_txn_source_types'.
DBCC results for 'mrp_plans'.
There are 2 rows in 1 pages for object 'mrp_plans'.
DBCC results for 'mrp_sub_inventories'.
There are 6 rows in 1 pages for object 'mrp_sub_inventories'.
DBCC results for 'so_order_types_all'.
There are 9 rows in 5 pages for object 'so_order_types_all'.
DBCC results for 'mrp_sugg_rep_schedules'.
There are 0 rows in 0 pages for object 'mrp_sugg_rep_schedules'.
DBCC results for 'po_line_locations_all'.
There are 9359 rows in 850 pages for object 'po_line_locations_all'.
DBCC results for 'per_people_f'.
There are 8 rows in 1 pages for object 'per_people_f'.
DBCC results for 'so_picking_sno'.
There are 1060 rows in 9 pages for object 'so_picking_sno'.
DBCC results for 'Per_position_structures'.
There are 0 rows in 0 pages for object 'Per_position_structures'.
DBCC results for 'Po_action_history'.
There are 0 rows in 0 pages for object 'Po_action_history'.
DBCC results for 'Po_system_parameters_all'.
There are 2 rows in 1 pages for object 'Po_system_parameters_all'.
DBCC results for 'po_agent'.
There are 5 rows in 1 pages for object 'po_agent'.
DBCC results for 'po_headers_all'.
There are 5876 rows in 271 pages for object 'po_headers_all'.
DBCC results for 'po_approval_list_headers'.
There are 0 rows in 0 pages for object 'po_approval_list_headers'.
DBCC results for 'Po_lookup_types'.
There are 243 rows in 5 pages for object 'Po_lookup_types'.
DBCC results for 'po_approval_list_lines'.
There are 0 rows in 0 pages for object 'po_approval_list_lines'.
DBCC results for 'Po_lookup_codes'.
There are 1034 rows in 26 pages for object 'Po_lookup_codes'.
DBCC results for 'po_approved_supplier_list'.
There are 0 rows in 0 pages for object 'po_approved_supplier_list'.
DBCC results for 'po_asl_documents'.
There are 0 rows in 0 pages for object 'po_asl_documents'.
DBCC results for 'po_asl_status'.
There are 0 rows in 0 pages for object 'po_asl_status'.
DBCC results for 'Po_control_functions'.
There are 0 rows in 0 pages for object 'Po_control_functions'.
DBCC results for 'ar_collectors'.
There are 0 rows in 0 pages for object 'ar_collectors'.
DBCC results for 'Po_control_groups_all'.
There are 0 rows in 0 pages for object 'Po_control_groups_all'.
DBCC results for 'po_control_rules'.
There are 0 rows in 0 pages for object 'po_control_rules'.
DBCC results for 'po_distributions_all'.
There are 9358 rows in 364 pages for object 'po_distributions_all'.
DBCC results for 'po_document_types_all'.
There are 0 rows in 0 pages for object 'po_document_types_all'.
DBCC results for 'po_employee_hierarchies_all'.
There are 0 rows in 0 pages for object 'po_employee_hierarchies_all'.
DBCC results for 'po_line_types'.
There are 3 rows in 1 pages for object 'po_line_types'.
DBCC results for 'wip_shop_lines'.
There are 0 rows in 0 pages for object 'wip_shop_lines'.
DBCC results for 'Po_notes'.
There are 0 rows in 0 pages for object 'Po_notes'.
DBCC results for 'po_notification_controls'.
There are 0 rows in 0 pages for object 'po_notification_controls'.
DBCC results for 'Po_notifications_all'.
There are 0 rows in 0 pages for object 'Po_notifications_all'.
DBCC results for 'po_vendor_all'.
There are 246 rows in 42 pages for object 'po_vendor_all'.
DBCC results for 'Po_position_controls_all'.
There are 0 rows in 0 pages for object 'Po_position_controls_all'.
DBCC results for 'po_quality_codes'.
There are 2 rows in 1 pages for object 'po_quality_codes'.
DBCC results for 'onhand_qty'.
There are 2912 rows in 80 pages for object 'onhand_qty'.
DBCC results for 'po_quotation_approvals_all'.
There are 0 rows in 0 pages for object 'po_quotation_approvals_all'.
DBCC results for 'mtl_parameters'.
There are 2 rows in 1 pages for object 'mtl_parameters'.
DBCC results for 'po_lines_all'.
There are 9350 rows in 918 pages for object 'po_lines_all'.
DBCC results for 'po_releases_all'.
There are 0 rows in 0 pages for object 'po_releases_all'.
DBCC results for 'po_req_distributions_all'.
There are 0 rows in 0 pages for object 'po_req_distributions_all'.
DBCC results for 'po_requisition_headers_all'.
There are 0 rows in 0 pages for object 'po_requisition_headers_all'.
DBCC results for 'po_location_associations'.
There are 0 rows in 0 pages for object 'po_location_associations'.
DBCC results for 'wip_discrete_jobs'.
There are 10374 rows in 556 pages for object 'wip_discrete_jobs'.
DBCC results for 'po_requisition_lines_all'.
There are 0 rows in 0 pages for object 'po_requisition_lines_all'.
DBCC results for 'po_rfq_vendors'.
There are 0 rows in 0 pages for object 'po_rfq_vendors'.
DBCC results for 'bom_operation_resources'.
There are 2010 rows in 31 pages for object 'bom_operation_resources'.
CHECKDB found 8 allocation errors and 0 consistency errors in database 'TEST'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (TEST ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

RONNIE

aa_ronnie
Starting Member

10 Posts

Posted - 2005-12-08 : 10:23:24

Should I do dbcc checkalloc? How to analyse and solve these 8 allocation errors?

RONNIE

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-12-08 : 16:42:51

Do you have a backup of this database? If so (the answer is hopefully yes), run the DBCC CHECKDB with the fix options. Make sure you check the system event logs, SQL Server error logs, and your system events that have occurred lately (such as unplanned outages) for other errors that could have possibly led up to this.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

aa_ronnie
Starting Member

10 Posts

Posted - 2005-12-08 : 20:57:08

Yes, but the backup is backed to Nov.21. My colleague used DBCC CHECKDB with the fix options, the errors are gone, but some data are missing. We considered this corruption is caused by hardware problem, are we rigth?

RONNIE

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-12-08 : 22:55:29

It could be. It could be caused by a lot of things. Are you on all the latest service packs? Also, make sure all your drivers are up to the latest. Did you check those error logs?

Backups to Nov. 21 sucks. Sorry to hear that.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

Kristen
Test

22859 Posts

Posted - 2005-12-09 : 02:13:18

"Backups to Nov. 21 sucks. Sorry to hear that."

Sorry Derrick, too much sympathy. They ought to do something about that ...

Kristen

aa_ronnie
Starting Member

10 Posts

Posted - 2005-12-09 : 08:35:06

Yes, you are right, they are definitely doing a very poor job on backup, so I recommand them to have daily backup from now on, and need to change the server to a better one with ups. These error appeared after an electric power was cut off sudenly. BTW, could I get those missing data back from the copy of the corruption database? Or you could guide me a more smart way?

Thanks. :-)

RONNIE

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-12-09 : 15:00:45

It was probably caused specifically be the fact the disk array has write cache enabled and doesn't have UPS. That will kill your databases everytime. If you had a sysadmin group worth anything, they would know better.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

Kristen
Test

22859 Posts

Posted - 2005-12-10 : 00:04:17

"BTW, could I get those missing data back from the copy of the corruption database?"

You have a copy from before "My colleague used DBCC CHECKDB with the fix options"?

I doubt that you will have any joy, but you could could try exporting various index key ranges to see what you can get. But I expect the "FIX" process rescued what it could, and that you will probably get the same result manually.

Kristen

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-12-10 : 13:26:10

If the data lost was before the backup, he should be able to recover and import. That's always a fun compare process. Get the real issues fixed though.

1. I would run a diagnostic on your hardware and search every single log for errors or warnings.
2. You need to get this thing on UPS and find out how the disk array is setup.

There are ways to recover data from a corrupt database. You should probably just contact Microsoft support though. A support ticket will cost you $249 and if anyone can help you, it would be them. They won't run a data recovery, but they might have some good resources for you.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2005-12-10 : 18:35:29

I wouldn't bother contacting PSS - you're looking at manual data recovery now that you've already run repair.

Do you happen to be running in full-recovery mode? If so, you could just take a log backup, restore the Nov 21st backup and then restore the log up to the point you lost power.

Thanks

Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

aa_ronnie
Starting Member

10 Posts

Posted - 2005-12-13 : 07:29:31

Thanks a lot for all of your help, we got this problem solved and got those data recovered too. Do feel happy to communicate here.

RONNIE

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2005-12-13 : 14:17:45

Can you let us know what you did to recover?

Thanks

Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources