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.
| Author |
Topic |
|
readysetstop
Posting Yak Master
123 Posts |
 Posted - 2007-06-04 : 15:02:52
|
I'm getting the following from DBCC CBECKDB (there are other errors in there, too but this is the one that concerns me at the moment):Msg 8939, Level 16, State 42, Line 1Table error: Object ID 1227270540, index ID 255, page (1:5359776). Test (m_slotCnt <= 1 && m_type == TEXT_TREE_PAGE) failed. Values are 8 and 1.Msg 8944, Level 16, State 12, Line 1Table error: Object ID 1227270540, index ID 255, page (1:5359777), row 0. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 8186 and 220.Msg 8941, Level 16, State 102, Line 1Table error: Object ID 1227270540, index ID 255, page (1:5359778). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 7, offset 0x1 is invalid.Msg 8942, Level 16, State 101, Line 1Table error: Object ID 1227270540, index ID 255, page (1:5359778). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x7 overlaps with the prior row.CHECKDB found 0 allocation errors and 4 consistency errors in table '(Object ID 1227270540)' (object ID 1227270540).However...select objectproperty(object_id('1227270540'),'IsTable')...returns null. I've checked the sysobjects table for this ID, and it doesn't show up. Any ideas on how I can identify what this object is? Let me know if you want more info. This is SQL 2000, sp4, the DB is about 60GB and it's the only one on the system having issues. The issue has been around for a while (more than a month), and is consistent. I can post all of the DBCC output if you really want/need it. I was just hesitant to do so since it's so huge.  Boy, 4th day on the job and the hits just keep coming. :-) (Not complaining. I'm learning a lot!)UPDATE: 2007.06.04_15:44 - Funny: When I ran dbcc checktable(CheckItem), I got all of the error messages displayed below, both for the mystery object ID and for the CheckItem table. I guess that's solved, but I'd still like to know if it's possible to have identified this another way, if anyone has time. Thanks.-D.____________________________________________________________________________________"Believe in those who are seeking the truth. Doubt those who say they have found it." -Andre Gide |
|
|
readysetstop
Posting Yak Master
123 Posts |
Posted - 2007-06-04 : 15:08:55
|
| Actually, I promised to do this last time... Here it is:DBCC results for 'FloridaCCUSA'.DBCC results for 'sysobjects'.There are 2189 rows in 48 pages for object 'sysobjects'.DBCC results for 'sysindexes'.There are 1361 rows in 74 pages for object 'sysindexes'.DBCC results for 'syscolumns'.There are 9694 rows in 550 pages for object 'syscolumns'.DBCC results for 'systypes'.There are 80 rows in 1 pages for object 'systypes'.DBCC results for 'syscomments'.There are 1360 rows in 575 pages for object 'syscomments'.DBCC results for 'sysfiles1'.There are 2 rows in 1 pages for object 'sysfiles1'.DBCC results for 'syspermissions'.There are 1292 rows in 4 pages for object 'syspermissions'.DBCC results for 'sysusers'.There are 26 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 10750 rows in 63 pages for object 'sysdepends'.DBCC results for 'sysreferences'.There are 155 rows in 1 pages for object 'sysreferences'.DBCC results for 'sysfulltextcatalogs'.There are 0 rows in 1 pages for object 'sysfulltextcatalogs'.DBCC results for 'sysfulltextnotify'.There are 0 rows in 0 pages for object 'sysfulltextnotify'.DBCC results for 'sysfilegroups'.There are 1 rows in 1 pages for object 'sysfilegroups'.DBCC results for 'ReportEventReportEvent'.There are 0 rows in 0 pages for object 'ReportEventReportEvent'.DBCC results for 'ItemTypeValue'.There are 1 rows in 1 pages for object 'ItemTypeValue'.DBCC results for 'CustomerNoteType'.There are 0 rows in 0 pages for object 'CustomerNoteType'.DBCC results for 'DeferredImage'.There are 0 rows in 0 pages for object 'DeferredImage'.DBCC results for 'conflict_FloridaCCUSAREG_MakerVerify'.There are 0 rows in 0 pages for object 'conflict_FloridaCCUSAREG_MakerVerify'.DBCC results for 'DebtOtherCostDescription'.There are 7 rows in 1 pages for object 'DebtOtherCostDescription'.DBCC results for 'UserRight'.There are 0 rows in 0 pages for object 'UserRight'.DBCC results for 'sysmergepublications'.There are 2 rows in 2 pages for object 'sysmergepublications'.DBCC results for 'Item'.There are 0 rows in 0 pages for object 'Item'.DBCC results for 'LocationSaleItemType'.There are 19 rows in 1 pages for object 'LocationSaleItemType'.DBCC results for 'CustomerRate'.There are 2977 rows in 26 pages for object 'CustomerRate'.DBCC results for 'conflict_FloridaCCUSAREG_Employer'.There are 0 rows in 0 pages for object 'conflict_FloridaCCUSAREG_Employer'.DBCC results for 'TeleTrackHistory'.There are 0 rows in 0 pages for object 'TeleTrackHistory'.DBCC results for 'CashDenomProposed'.There are 0 rows in 0 pages for object 'CashDenomProposed'.DBCC results for 'DebtPayment'.There are 0 rows in 0 pages for object 'DebtPayment'.DBCC results for 'CustomerReference'.There are 312499 rows in 4551 pages for object 'CustomerReference'.DBCC results for 'conflict_FloridaCCUSAREG_CustomerEmployer'.There are 0 rows in 0 pages for object 'conflict_FloridaCCUSAREG_CustomerEmployer'.DBCC results for 'LocationCash'.There are 1 rows in 1 pages for object 'LocationCash'.DBCC results for 'DebtPaymentDay'.There are 0 rows in 0 pages for object 'DebtPaymentDay'.DBCC results for 'Zipcode'.There are 42827 rows in 313 pages for object 'Zipcode'.DBCC results for 'Vendor'.There are 0 rows in 0 pages for object 'Vendor'.DBCC results for 'CustomerStatement'.There are 0 rows in 0 pages for object 'CustomerStatement'.DBCC results for 'conflict_FloridaCCUSAREG_Turndown'.There are 0 rows in 0 pages for object 'conflict_FloridaCCUSAREG_Turndown'.DBCC results for 'DebtPaymentMethod'.There are 5 rows in 1 pages for object 'DebtPaymentMethod'.DBCC results for 'PurchaseOrderStatus'.There are 6 rows in 1 pages for object 'PurchaseOrderStatus'.DBCC results for 'CustomerVerify'.There are 2139 rows in 29 pages for object 'CustomerVerify'.DBCC results for 'conflict_FloridaCCUSAREG_Bank'.There are 0 rows in 0 pages for object 'conflict_FloridaCCUSAREG_Bank'.DBCC results for 'TextImport'.There are 19 rows in 1 pages for object 'TextImport'.DBCC results for 'DebtPaymentPaid'.There are 0 rows in 0 pages for object 'DebtPaymentPaid'.DBCC results for 'SaveCashUserData'.There are 0 rows in 1 pages for object 'SaveCashUserData'.DBCC results for 'VersionScript'.There are 1 rows in 1 pages for object 'VersionScript'.DBCC results for 'CashHistoryDenom'.There are 688334 rows in 6198 pages for object 'CashHistoryDenom'.DBCC results for 'PurchaseOrder'.There are 0 rows in 0 pages for object 'PurchaseOrder'.DBCC results for 'CashUserData'.There are 0 rows in 0 pages for object 'CashUserData'.DBCC results for 'CustomerVerifyDescription'.There are 0 rows in 0 pages for object 'CustomerVerifyDescription'.DBCC results for 'StoredValueCard'.There are 0 rows in 0 pages for object 'StoredValueCard'.DBCC results for 'conflict_FloridaCCUSAREG_Warning'.There are 0 rows in 0 pages for object 'conflict_FloridaCCUSAREG_Warning'.DBCC results for 'TextImportType'.There are 2 rows in 1 pages for object 'TextImportType'.DBCC results for 'DebtPaymentPaidBy'.There are 4 rows in 1 pages for object 'DebtPaymentPaidBy'.DBCC results for 'NCNRecordTypes'.There are 7 rows in 1 pages for object 'NCNRecordTypes'.DBCC results for 'UserLocation'.There are 1 rows in 1 pages for object 'UserLocation'.DBCC results for 'UpgradeScript'.There are 673 rows in 6 pages for object 'UpgradeScript'.DBCC results for 'CashSessionDenom'.There are 0 rows in 0 pages for object 'CashSessionDenom'.DBCC results for 'CustomerEditOptionExtension'.There are 2 rows in 1 pages for object 'CustomerEditOptionExtension'.DBCC results for 'PurchaseOrderItem'.There are 0 rows in 0 pages for object 'PurchaseOrderItem'.DBCC results for 'NCNIDTypes'.There are 5 rows in 1 pages for object 'NCNIDTypes'.DBCC results for 'Employer'.There are 89374 rows in 1214 pages for object 'Employer'.DBCC results for 'conflict_FloridaCCUSAREG_DeferredTransaction'.There are 0 rows in 0 pages for object 'conflict_FloridaCCUSAREG_DeferredTransaction'.DBCC results for 'UpgradeFile'.There are 3 rows in 1 pages for object 'UpgradeFile'.DBCC results for 'DebtPaymentPlan'.There are 0 rows in 0 pages for object 'DebtPaymentPlan'.DBCC results for 'NCNHoldTypes'.There are 27 rows in 1 pages for object 'NCNHoldTypes'.DBCC results for 'DenomEntryType'.There are 1 rows in 1 pages for object 'DenomEntryType'.DBCC results for 'DataCaptureDevice'.There are 3 rows in 1 pages for object 'DataCaptureDevice'.DBCC results for 'PurchaseOrderTransaction'.There are 0 rows in 0 pages for object 'PurchaseOrderTransaction'.DBCC results for 'NegFileChecks'.There are 0 rows in 0 pages for object 'NegFileChecks'.DBCC results for 'IdentificationType'.There are 1 rows in 1 pages for object 'IdentificationType'.DBCC results for 'conflict_FloridaCCUSAREG_Deferred'.There are 0 rows in 0 pages for object 'conflict_FloridaCCUSAREG_Deferred'.DBCC results for 'DebtPaymentPlanItem'.There are 0 rows in 0 pages for object 'DebtPaymentPlanItem'.DBCC results for 'NegFileHolds'.There are 0 rows in 0 pages for object 'NegFileHolds'.DBCC results for 'Def_305'.There are 313 rows in 11 pages for object 'Def_305'.DBCC results for 'Security'.There are 1 rows in 1 pages for object 'Security'.DBCC results for 'LocationImage'.There are 0 rows in 0 pages for object 'LocationImage'.DBCC results for 'ReportEventTextExport'.There are 3 rows in 1 pages for object 'ReportEventTextExport'.DBCC results for 'NegFileIDs'.There are 0 rows in 0 pages for object 'NegFileIDs'.DBCC results for 'Marketing'.There are 0 rows in 0 pages for object 'Marketing'.DBCC results for 'LocationNetSpend'.There are 0 rows in 0 pages for object 'LocationNetSpend'.DBCC results for 'conflict_FloridaCCUSAREG_CheckItem'.There are 0 rows in 0 pages for object 'conflict_FloridaCCUSAREG_CheckItem'.DBCC results for 'CashTransactionDenom'.There are 0 rows in 0 pages for object 'CashTransactionDenom'.DBCC results for 'DebtSchedule'.There are 0 rows in 0 pages for object 'DebtSchedule'.DBCC results for 'MSmerge_errorlineage'.There are 20374 rows in 113 pages for object 'MSmerge_errorlineage'.DBCC results for 'ForeignItem'.There are 0 rows in 0 pages for object 'ForeignItem'.DBCC results for 'NcnFExcept'.There are 0 rows in 0 pages for object 'NcnFExcept'.DBCC results for 'MSrepl_identity_range'.There are 0 rows in 0 pages for object 'MSrepl_identity_range'.DBCC results for 'NCNPExcept'.There are 0 rows in 0 pages for object 'NCNPExcept'.DBCC results for 'Refund'.There are 0 rows in 0 pages for object 'Refund'.DBCC results for 'NetSpendResponse'.There are 0 rows in 0 pages for object 'NetSpendResponse'.DBCC results for 'conflict_FloridaCCUSAREG_SaleItem'.There are 0 rows in 0 pages for object 'conflict_FloridaCCUSAREG_SaleItem'.DBCC results for 'DataCaptureType'.There are 2 rows in 1 pages for object 'DataCaptureType'.DBCC results for 'DebtScheduleType'.There are 4 rows in 1 pages for object 'DebtScheduleType'.DBCC results for 'LocationForeign'.There are 0 rows in 0 pages for object 'LocationForeign'.DBCC results for 'sysmergearticles'.There are 32 rows in 8 pages for object 'sysmergearticles'.DBCC results for 'conflict_FloridaCCUSAREG_Sale'.There are 0 rows in 0 pages for object 'conflict_FloridaCCUSAREG_Sale'.DBCC results for 'ItemProposed'.There are 0 rows in 0 pages for object 'ItemProposed'.DBCC results for 'LocationSetting'.There are 1 rows in 1 pages for object 'LocationSetting'.DBCC results for 'ComputerDataDevice'.There are 0 rows in 0 pages for object 'ComputerDataDevice'.DBCC results for 'DebtStatus'.There are 17 rows in 1 pages for object 'DebtStatus'.DBCC results for 'Cash'.There are 0 rows in 0 pages for object 'Cash'.DBCC results for 'DeferredDPT'.There are 0 rows in 0 pages for object 'DeferredDPT'.DBCC results for 'ComputerPINPad'.There are 0 rows in 0 pages for object 'ComputerPINPad'.DBCC results for 'ACHProposalEntry'.There are 0 rows in 0 pages for object 'ACHProposalEntry'.DBCC results for 'TempUpgradeFile'.There are 3 rows in 1 pages for object 'TempUpgradeFile'.DBCC results for 'ItemAdjustmentLog'.There are 0 rows in 0 pages for object 'ItemAdjustmentLog'.DBCC results for 'Action'.There are 16 rows in 1 pages for object 'Action'.DBCC results for 'DebtToDo'.There are 0 rows in 0 pages for object 'DebtToDo'.DBCC results for 'LaborPeriod'.There are 0 rows in 0 pages for object 'LaborPeriod'.DBCC results for 'CashHistory'.There are 87022 rows in 798 pages for object 'CashHistory'.DBCC results for 'DeferredTracking'.There are 0 rows in 0 pages for object 'DeferredTracking'.DBCC results for 'TempUpgradeScript'.There are 673 rows in 6 pages for object 'TempUpgradeScript'.DBCC results for 'ReportGroup'.There are 1 rows in 1 pages for object 'ReportGroup'.DBCC results for 'ChangeLog'.There are 5 rows in 1 pages for object 'ChangeLog'.DBCC results for 'DebtWarning'.There are 0 rows in 0 pages for object 'DebtWarning'.DBCC results for 'LaborType'.There are 0 rows in 0 pages for object 'LaborType'.DBCC results for 'LocationP2K'.There are 0 rows in 0 pages for object 'LocationP2K'.DBCC results for 'CashSession'.There are 0 rows in 0 pages for object 'CashSession'.DBCC results for 'LocationDataCapture'.There are 0 rows in 0 pages for object 'LocationDataCapture'.DBCC results for 'Computer'.There are 7 rows in 1 pages for object 'Computer'.DBCC results for 'DebtWitness'.There are 0 rows in 0 pages for object 'DebtWitness'.DBCC results for 'LocationLabor'.There are 0 rows in 0 pages for object 'LocationLabor'.DBCC results for 'CashTransaction'.There are 0 rows in 0 pages for object 'CashTransaction'.DBCC results for 'LocationCertegy'.There are 0 rows in 0 pages for object 'LocationCertegy'.DBCC results for 'ReportUsage'.There are 1 rows in 1 pages for object 'ReportUsage'.DBCC results for 'P2KStateCodes'.There are 66 rows in 1 pages for object 'P2KStateCodes'.DBCC results for 'DayName'.There are 7 rows in 1 pages for object 'DayName'.DBCC results for 'DebtWorkCategory'.There are 3 rows in 1 pages for object 'DebtWorkCategory'.DBCC results for 'sysmergeschemaarticles'.There are 0 rows in 0 pages for object 'sysmergeschemaarticles'.DBCC results for 'ModulePINPad'.There are 0 rows in 0 pages for object 'ModulePINPad'.DBCC results for 'PayFreq'.There are 4 rows in 1 pages for object 'PayFreq'.DBCC results for 'Day'.There are 0 rows in 0 pages for object 'Day'.DBCC results for 'CashTransactionHistory'.There are 354904 rows in 7197 pages for object 'CashTransactionHistory'.DBCC results for 'P2KResponseCode'.There are 105 rows in 1 pages for object 'P2KResponseCode'.DBCC results for 'CertegyDLType'.There are 0 rows in 0 pages for object 'CertegyDLType'.DBCC results for 'GroupType'.There are 7 rows in 1 pages for object 'GroupType'.DBCC results for 'Letter'.There are 0 rows in 0 pages for object 'Letter'.DBCC results for 'sysmergesubscriptions'.There are 50 rows in 2 pages for object 'sysmergesubscriptions'.DBCC results for 'PayType'.There are 2 rows in 1 pages for object 'PayType'.DBCC results for 'CashTransactionType'.There are 13 rows in 1 pages for object 'CashTransactionType'.DBCC results for 'StoredValueCardTranType'.There are 3 rows in 1 pages for object 'StoredValueCardTranType'.DBCC results for 'ACBConsumerInformationIndicators'.There are 19 rows in 1 pages for object 'ACBConsumerInformationIndicators'.DBCC results for 'EBTTransaction'.There are 0 rows in 0 pages for object 'EBTTransaction'.DBCC results for 'LetterMergeConst'.There are 1 rows in 1 pages for object 'LetterMergeConst'.DBCC results for 'UserLabor'.There are 0 rows in 0 pages for object 'UserLabor'.DBCC results for 'ACBDebt'.There are 0 rows in 0 pages for object 'ACBDebt'.DBCC results for 'CashType'.There are 2 rows in 1 pages for object 'CashType'.DBCC results for 'StoredValueCardType'.There are 3 rows in 1 pages for object 'StoredValueCardType'.DBCC results for 'ParamIDList'.There are 0 rows in 0 pages for object 'ParamIDList'.DBCC results for 'P2KCashier'.There are 1 rows in 1 pages for object 'P2KCashier'.DBCC results for 'CertegyTapiDevice'.There are 0 rows in 0 pages for object 'CertegyTapiDevice'.DBCC results for 'Location'.There are 1 rows in 1 pages for object 'Location'.DBCC results for 'LetterTableList'.There are 14 rows in 1 pages for object 'LetterTableList'.DBCC results for 'TimeZone'.There are 74 rows in 2 pages for object 'TimeZone'.DBCC results for 'UserLaborDay'.There are 0 rows in 0 pages for object 'UserLaborDay'.DBCC results for 'DrawerAssignHistory'.There are 0 rows in 0 pages for object 'DrawerAssignHistory'.DBCC results for 'StoredValueCardRateRange'.There are 0 rows in 0 pages for object 'StoredValueCardRateRange'.DBCC results for 'MSmerge_replinfo'.There are 50 rows in 1 pages for object 'MSmerge_replinfo'.DBCC results for 'LetterTemp'.There are 0 rows in 0 pages for object 'LetterTemp'.DBCC results for 'MSmerge_tombstone'.There are 11363 rows in 188 pages for object 'MSmerge_tombstone'.DBCC results for 'UserLaborPeriod'.There are 0 rows in 0 pages for object 'UserLaborPeriod'.DBCC results for 'SafeManager'.There are 0 rows in 0 pages for object 'SafeManager'.DBCC results for 'MSmerge_contents'.There are 319487 rows in 7384 pages for object 'MSmerge_contents'.DBCC results for 'CustomerBank'.There are 0 rows in 0 pages for object 'CustomerBank'.DBCC results for 'Def_321'.There are 756 rows in 26 pages for object 'Def_321'.DBCC results for 'CertegyCheckType'.There are 2 rows in 1 pages for object 'CertegyCheckType'.DBCC results for 'PrinterType'.There are 3 rows in 1 pages for object 'PrinterType'.DBCC results for 'BankAccountType'.There are 2 rows in 1 pages for object 'BankAccountType'.DBCC results for 'MakeContact'.There are 2 rows in 1 pages for object 'MakeContact'.DBCC results for 'MSmerge_genhistory'.There are 204050 rows in 2196 pages for object 'MSmerge_genhistory'.DBCC results for 'UserLaborRate'.There are 0 rows in 0 pages for object 'UserLaborRate'.DBCC results for 'Def_308'.There are 94 rows in 4 pages for object 'Def_308'.DBCC results for 'TextExport'.There are 34 rows in 1 pages for object 'TextExport'.DBCC results for 'LocationStoredValueCardType'.There are 0 rows in 0 pages for object 'LocationStoredValueCardType'.DBCC results for 'MSmerge_delete_conflicts'.There are 0 rows in 1 pages for object 'MSmerge_delete_conflicts'.DBCC results for 'ACBDebtReport'.There are 0 rows in 0 pages for object 'ACBDebtReport'.DBCC results for 'Def_314'.There are 175 rows in 7 pages for object 'Def_314'.DBCC results for 'CertegyCheck'.There are 0 rows in 0 pages for object 'CertegyCheck'.DBCC results for 'Printer'.There are 0 rows in 0 pages for object 'Printer'.DBCC results for 'ACHServiceClassCode'.There are 3 rows in 1 pages for object 'ACHServiceClassCode'.DBCC results for 'MakeContactPlan'.There are 0 rows in 0 pages for object 'MakeContactPlan'.DBCC results for 'UserLaborTransaction'.There are 0 rows in 0 pages for object 'UserLaborTransaction'.DBCC results for 'Def_304'.There are 80 rows in 3 pages for object 'Def_304'.DBCC results for 'sysmergeschemachange'.There are 163 rows in 7 pages for object 'sysmergeschemachange'.DBCC results for 'ACBDebtHistory'.There are 0 rows in 0 pages for object 'ACBDebtHistory'.DBCC results for 'LocationStoredValueCard'.There are 0 rows in 0 pages for object 'LocationStoredValueCard'.DBCC results for 'ACHEntryClassCode'.There are 2 rows in 1 pages for object 'ACHEntryClassCode'.DBCC results for 'MakeContactPlanItem'.There are 0 rows in 0 pages for object 'MakeContactPlanItem'.DBCC results for 'OldSaleItemHistory'.There are 0 rows in 1 pages for object 'OldSaleItemHistory'.DBCC results for 'sysmergesubsetfilters'.There are 0 rows in 0 pages for object 'sysmergesubsetfilters'.DBCC results for 'LocationCheckType'.There are 0 rows in 0 pages for object 'LocationCheckType'.DBCC results for 'LocationEPacific'.There are 0 rows in 0 pages for object 'LocationEPacific'.DBCC results for 'MSdynamicsnapshotviews'.There are 0 rows in 0 pages for object 'MSdynamicsnapshotviews'.DBCC results for 'ComputerMoneyOrder'.There are 0 rows in 0 pages for object 'ComputerMoneyOrder'.DBCC results for 'ACHTransactionCode'.There are 8 rows in 1 pages for object 'ACHTransactionCode'.DBCC results for 'Store'.There are 1 rows in 1 pages for object 'Store'.DBCC results for 'CertegyResponseCode'.There are 22 rows in 1 pages for object 'CertegyResponseCode'.DBCC results for 'ReportEventParam'.There are 0 rows in 0 pages for object 'ReportEventParam'.DBCC results for 'MSdynamicsnapshotjobs'.There are 0 rows in 0 pages for object 'MSdynamicsnapshotjobs'.DBCC results for 'MoneyOrder'.There are 0 rows in 0 pages for object 'MoneyOrder'.DBCC results for 'ACHDestination'.There are 0 rows in 0 pages for object 'ACHDestination'.DBCC results for 'SaleItemInventoryHistory'.There are 30048 rows in 255 pages for object 'SaleItemInventoryHistory'.DBCC results for 'LocationCheckTypeRange'.There are 0 rows in 0 pages for object 'LocationCheckTypeRange'.DBCC results for 'CertegyResponse'.There are 0 rows in 0 pages for object 'CertegyResponse'.DBCC results for 'MSmerge_altsyncpartners'.There are 0 rows in 0 pages for object 'MSmerge_altsyncpartners'.DBCC results for 'LocationCustomer'.There are 1 rows in 1 pages for object 'LocationCustomer'.DBCC results for 'LocationTableIndexSetting'.There are 6 rows in 1 pages for object 'LocationTableIndexSetting'.DBCC results for 'ReportDesign'.There are 64 rows in 2 pages for object 'ReportDesign'.DBCC results for 'ACHDestinationComputer'.There are 0 rows in 0 pages for object 'ACHDestinationComputer'.DBCC results for 'Generator'.There are 14 rows in 1 pages for object 'Generator'.DBCC results for 'TeleTrac'.There are 0 rows in 0 pages for object 'TeleTrac'.DBCC results for 'Sale'.There are 3774426 rows in 43302 pages for object 'Sale'.DBCC results for 'GLHistory'.There are 1431581 rows in 20811 pages for object 'GLHistory'.DBCC results for 'ItemTransaction'.There are 0 rows in 0 pages for object 'ItemTransaction'.DBCC results for 'ACHProposalFile'.There are 0 rows in 0 pages for object 'ACHProposalFile'.DBCC results for 'Teller'.There are 0 rows in 0 pages for object 'Teller'.DBCC results for 'HourlyTransactionTemp'.There are 0 rows in 0 pages for object 'HourlyTransactionTemp'.DBCC results for 'SaleItem'.There are 9788980 rows in 178375 pages for object 'SaleItem'.DBCC results for 'LocationMaker'.There are 1 rows in 1 pages for object 'LocationMaker'.DBCC results for 'SaleApplicationStatus'.There are 6 rows in 1 pages for object 'SaleApplicationStatus'.DBCC results for 'MoneyOrderType'.There are 3 rows in 1 pages for object 'MoneyOrderType'.DBCC results for 'CheckAnalysisCheckTemp'.There are 0 rows in 0 pages for object 'CheckAnalysisCheckTemp'.DBCC results for 'ReportQuery'.There are 169 rows in 2 pages for object 'ReportQuery'.DBCC results for 'ParamMoneyList'.There are 0 rows in 0 pages for object 'ParamMoneyList'.DBCC results for 'WireTransferPending'.There are 0 rows in 0 pages for object 'WireTransferPending'.DBCC results for 'ACHFile'.There are 0 rows in 0 pages for object 'ACHFile'.DBCC results for 'ToDo'.There are 0 rows in 0 pages for object 'ToDo'.DBCC results for 'CheckAnalysisDebtTemp'.There are 0 rows in 0 pages for object 'CheckAnalysisDebtTemp'.DBCC results for 'SaleItemType'.There are 26 rows in 1 pages for object 'SaleItemType'.DBCC results for 'ValidationType'.There are 5 rows in 1 pages for object 'ValidationType'.DBCC results for 'LocationOffsetCheck'.There are 0 rows in 0 pages for object 'LocationOffsetCheck'.DBCC results for 'SaleApplicationOriginatingLocationType'.There are 2 rows in 1 pages for object 'SaleApplicationOriginatingLocationType'.DBCC results for 'CheckAnalysisNetFeesTemp'.There are 0 rows in 0 pages for object 'CheckAnalysisNetFeesTemp'.DBCC results for 'ItemMoveTransaction'.There are 0 rows in 0 pages for object 'ItemMoveTransaction'.DBCC results for 'WireTransferOperatorList'.There are 0 rows in 0 pages for object 'WireTransferOperatorList'.DBCC results for 'ReportDesignSource'.There are 142 rows in 2 pages for object 'ReportDesignSource'.DBCC results for 'ACHProposalBatch'.There are 0 rows in 0 pages for object 'ACHProposalBatch'.DBCC results for 'UserBookmarks'.There are 0 rows in 0 pages for object 'UserBookmarks'.DBCC results for 'Utility'.There are 583128 rows in 11682 pages for object 'Utility'.DBCC results for 'CheckAnalysisTemp'.There are 0 rows in 0 pages for object 'CheckAnalysisTemp'.DBCC results for 'GoodOffsetSetting'.There are 1 rows in 1 pages for object 'GoodOffsetSetting'.DBCC results for 'SaleStatus'.There are 4 rows in 1 pages for object 'SaleStatus'.DBCC results for 'EPacificStatus'.There are 4 rows in 1 pages for object 'EPacificStatus'.DBCC results for 'OffsetCheck'.There are 0 rows in 0 pages for object 'OffsetCheck'.DBCC results for 'LocationPOS'.There are 1 rows in 1 pages for object 'LocationPOS'.DBCC results for 'SaleApplication'.There are 0 rows in 0 pages for object 'SaleApplication'.DBCC results for 'LocationWireTransfer'.There are 0 rows in 0 pages for object 'LocationWireTransfer'.DBCC results for 'UserDebtBrowser'.There are 1 rows in 1 pages for object 'UserDebtBrowser'.DBCC results for 'UtilityAccount'.There are 0 rows in 0 pages for object 'UtilityAccount'.DBCC results for 'SaleItemHistory'.There are 463175 rows in 10348 pages for object 'SaleItemHistory'.DBCC results for 'OffsetEPacific'.There are 0 rows in 0 pages for object 'OffsetEPacific'.DBCC results for 'ReportDesignSourceQuery'.There are 176 rows in 2 pages for object 'ReportDesignSourceQuery'.DBCC results for 'ACHBatch'.There are 0 rows in 0 pages for object 'ACHBatch'.DBCC results for 'OffsetCheckStatus'.There are 4 rows in 1 pages for object 'OffsetCheckStatus'.DBCC results for 'UserSession'.There are 6 rows in 1 pages for object 'UserSession'.DBCC results for 'UtilityCompany'.There are 0 rows in 0 pages for object 'UtilityCompany'.DBCC results for 'ItemComposeTransaction'.There are 0 rows in 0 pages for object 'ItemComposeTransaction'.DBCC results for 'OffsetCheckException'.There are 0 rows in 0 pages for object 'OffsetCheckException'.DBCC results for 'SaleApplicationStatusTransaction'.There are 0 rows in 0 pages for object 'SaleApplicationStatusTransaction'.DBCC results for 'LocationDay'.There are 0 rows in 0 pages for object 'LocationDay'.DBCC results for 'UserSettings'.There are 1 rows in 1 pages for object 'UserSettings'.DBCC results for 'LocationInventory'.There are 1 rows in 1 pages for object 'LocationInventory'.DBCC results for 'UtilityMethod'.There are 0 rows in 0 pages for object 'UtilityMethod'.DBCC results for 'Report'.There are 66 rows in 1 pages for object 'Report'.DBCC results for 'CheckDepositType'.There are 2 rows in 1 pages for object 'CheckDepositType'.DBCC results for 'EPacificTerminalMap'.There are 0 rows in 0 pages for object 'EPacificTerminalMap'.DBCC results for 'UtilityCompanyAccountMask'.There are 0 rows in 0 pages for object 'UtilityCompanyAccountMask'.DBCC results for 'Warnings'.There are 0 rows in 0 pages for object 'Warnings'.DBCC results for 'ReportEventComputerReport'.There are 0 rows in 0 pages for object 'ReportEventComputerReport'.DBCC results for 'ProductLocation'.There are 0 rows in 0 pages for object 'ProductLocation'.DBCC results for 'ACHEntry'.There are 0 rows in 0 pages for object 'ACHEntry'.DBCC results for 'CountryCode'.There are 2 rows in 1 pages for object 'CountryCode'.DBCC results for 'UserDevice'.There are 0 rows in 0 pages for object 'UserDevice'.DBCC results for 'Def_322'.There are 529 rows in 19 pages for object 'Def_322'.DBCC results for 'ReportSource'.There are 175 rows in 3 pages for object 'ReportSource'.DBCC results for 'LocationLocale'.There are 0 rows in 0 pages for object 'LocationLocale'.DBCC results for 'BCCISTTrack'.There are 0 rows in 0 pages for object 'BCCISTTrack'.DBCC results for 'ACHTransaction'.There are 0 rows in 0 pages for object 'ACHTransaction'.DBCC results for 'ACHTransactionStatus'.There are 4 rows in 1 pages for object 'ACHTransactionStatus'.DBCC results for 'TempParam'.There are 0 rows in 0 pages for object 'TempParam'.DBCC results for 'WireTransferFee'.There are 2 rows in 1 pages for object 'WireTransferFee'.DBCC results for 'MoneyOrderRequest'.There are 0 rows in 0 pages for object 'MoneyOrderRequest'.DBCC results for 'LocationCashiersCheck'.There are 0 rows in 0 pages for object 'LocationCashiersCheck'.DBCC results for 'GLMap'.There are 64 rows in 1 pages for object 'GLMap'.DBCC results for 'CheckValidation'.There are 4 rows in 1 pages for object 'CheckValidation'.DBCC results for 'WireTransferFeeBracket'.There are 51 rows in 1 pages for object 'WireTransferFeeBracket'.DBCC results for 'MoneyOrderRequestMoneyOrder'.There are 0 rows in 0 pages for object 'MoneyOrderRequestMoneyOrder'.DBCC results for 'CustomCustomerForm'.There are 1 rows in 1 pages for object 'CustomCustomerForm'.DBCC results for 'LocationCashiersCheckRange'.There are 0 rows in 0 pages for object 'LocationCashiersCheckRange'.DBCC results for 'LoginPoint'.There are 19 rows in 1 pages for object 'LoginPoint'.DBCC results for 'ItemTypeLocation'.There are 1 rows in 1 pages for object 'ItemTypeLocation'.DBCC results for 'LocationUtility'.There are 1 rows in 1 pages for object 'LocationUtility'.DBCC results for 'WireTransferReceive'.There are 0 rows in 0 pages for object 'WireTransferReceive'.DBCC results for 'MoneyOrderRequestManualSerialNumber'.There are 0 rows in 0 pages for object 'MoneyOrderRequestManualSerialNumber'.DBCC results for 'GLData'.There are 0 rows in 0 pages for object 'GLData'.DBCC results for 'ReportEventReport'.There are 1 rows in 1 pages for object 'ReportEventReport'.DBCC results for 'conflict_FloridaCCUSASUM_SaleItemInventoryHistory'.There are 0 rows in 0 pages for object 'conflict_FloridaCCUSASUM_SaleItemInventoryHistory'.DBCC results for 'LocationACH'.There are 0 rows in 0 pages for object 'LocationACH'.DBCC results for 'Product'.There are 21 rows in 1 pages for object 'Product'.DBCC results for 'ProductList'.There are 0 rows in 0 pages for object 'ProductList'.DBCC results for 'CHECKSUMDEF'.There are 15985 rows in 69 pages for object 'CHECKSUMDEF'.DBCC results for 'CashiersCheck'.There are 0 rows in 0 pages for object 'CashiersCheck'.DBCC results for 'TCCSystem'.There are 1 rows in 1 pages for object 'TCCSystem'.DBCC results for 'WireTransferSend'.There are 0 rows in 0 pages for object 'WireTransferSend'.DBCC results for 'MoneyOrderHistory'.There are 0 rows in 0 pages for object 'MoneyOrderHistory'.DBCC results for 'ReportEventComputerTextExport'.There are 0 rows in 0 pages for object 'ReportEventComputerTextExport'.DBCC results for 'conflict_FloridaCCUSASUM_GLHistory'.There are 0 rows in 0 pages for object 'conflict_FloridaCCUSASUM_GLHistory'.DBCC results for 'CHECKSUMDEFTRAN'.There are 31725 rows in 136 pages for object 'CHECKSUMDEFTRAN'.DBCC results for 'ProductLicense'.There are 0 rows in 0 pages for object 'ProductLicense'.DBCC results for 'SyncForeignKeys'.There are 384 rows in 9 pages for object 'SyncForeignKeys'.DBCC results for 'InterceptStatement'.There are 0 rows in 0 pages for object 'InterceptStatement'.DBCC results for 'LocationCreditCard'.There are 1 rows in 1 pages for object 'LocationCreditCard'.DBCC results for 'MoneyOrderPrinted'.There are 0 rows in 0 pages for object 'MoneyOrderPrinted'.DBCC results for 'conflict_FloridaCCUSASUM_DeferredDeposit'.There are 0 rows in 0 pages for object 'conflict_FloridaCCUSASUM_DeferredDeposit'.DBCC results for 'Contact'.There are 0 rows in 0 pages for object 'Contact'. Msg 8939, Level 16, State 42, Line 1Table error: Object ID 1227270540, index ID 255, page (1:5359776). Test (m_slotCnt <= 1 && m_type == TEXT_TREE_PAGE) failed. Values are 8 and 1.Msg 8944, Level 16, State 12, Line 1Table error: Object ID 1227270540, index ID 255, page (1:5359777), row 0. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 8186 and 220.Msg 8941, Level 16, State 102, Line 1Table error: Object ID 1227270540, index ID 255, page (1:5359778). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 7, offset 0x1 is invalid.Msg 8942, Level 16, State 101, Line 1Table error: Object ID 1227270540, index ID 255, page (1:5359778). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x7 overlaps with the prior row.CHECKDB found 0 allocation errors and 4 consistency errors in table '(Object ID 1227270540)' (object ID 1227270540). DBCC results for 'DebtDeleted'.There are 0 rows in 0 pages for object 'DebtDeleted'.DBCC results for 'MoneyOrderError'.There are 0 rows in 0 pages for object 'MoneyOrderError'.DBCC results for 'InterceptReturn'.There are 0 rows in 0 pages for object 'InterceptReturn'.DBCC results for 'conflict_FloridaCCUSASUM_CheckDeposit'.There are 0 rows in 0 pages for object 'conflict_FloridaCCUSASUM_CheckDeposit'.DBCC results for 'Module'.There are 43 rows in 1 pages for object 'Module'.DBCC results for 'DeferredTransactionACH'.There are 0 rows in 0 pages for object 'DeferredTransactionACH'.DBCC results for 'UserSecurity'.There are 1 rows in 1 pages for object 'UserSecurity'.DBCC results for 'ContactAccount'.There are 0 rows in 0 pages for object 'ContactAccount'.DBCC results for 'CreditCard'.There are 0 rows in 0 pages for object 'CreditCard'.DBCC results for 'ImageCaptureDevice'.There are 6 rows in 1 pages for object 'ImageCaptureDevice'.DBCC results for 'dtproperties'.There are 0 rows in 1 pages for object 'dtproperties'.DBCC results for 'MoneyOrderRequestRequeued'.There are 0 rows in 0 pages for object 'MoneyOrderRequestRequeued'.DBCC results for 'conflict_FloridaCCUSASUM_ItemHistory'.There are 0 rows in 0 pages for object 'conflict_FloridaCCUSASUM_ItemHistory'.DBCC results for 'SaleItemTypePayout'.There are 0 rows in 0 pages for object 'SaleItemTypePayout'.DBCC results for 'DeferredTransactionACHHistory'.There are 0 rows in 0 pages for object 'DeferredTransactionACHHistory'.DBCC results for 'LocationMoneyOrder'.There are 1 rows in 1 pages for object 'LocationMoneyOrder'.DBCC results for 'ContactEmployer'.There are 0 rows in 0 pages for object 'ContactEmployer'.DBCC results for 'CreditCardType'.There are 0 rows in 0 pages for object 'CreditCardType'.DBCC results for 'CustomerBankAccountType'.There are 0 rows in 0 pages for object 'CustomerBankAccountType'.DBCC results for 'Class'.There are 263 rows in 2 pages for object 'Class'.DBCC results for 'UserLoginFailure'.There are 36 rows in 1 pages for object 'UserLoginFailure'.DBCC results for 'DeltaTerminalError'.There are 110 rows in 2 pages for object 'DeltaTerminalError'.DBCC results for 'conflict_FloridaCCUSASUM_SaleItemHistory'.There are 0 rows in 0 pages for object 'conflict_FloridaCCUSASUM_SaleItemHistory'.DBCC results for 'SaleItemTypePayoutSaleItemType'.There are 0 rows in 0 pages for object 'SaleItemTypePayoutSaleItemType'.DBCC results for 'ContactHistory'.There are 0 rows in 0 pages for object 'ContactHistory'.DBCC results for 'UserBiometric'.There are 0 rows in 0 pages for object 'UserBiometric'.DBCC results for 'UserPasswordHistory'.There are 0 rows in 0 pages for object 'UserPasswordHistory'.DBCC results for 'CheckReaderType'.There are 2 rows in 1 pages for object 'CheckReaderType'.DBCC results for 'ImageCaptureType'.There are 5 rows in 1 pages for object 'ImageCaptureType'.DBCC results for 'conflict_FloridaCCUSASUM_CashTransactionHistory'.There are 0 rows in 0 pages for object 'conflict_FloridaCCUSASUM_CashTransactionHistory'.DBCC results for 'Closing'.There are 16 rows in 1 pages for object 'Closing'.DBCC results for 'ContactInfo'.There are 0 rows in 0 pages for object 'ContactInfo'.DBCC results for 'ComputerCheck'.There are 0 rows in 0 pages for object 'ComputerCheck'.DBCC results for 'ComputerImageDevice'.There are 0 rows in 0 pages for object 'ComputerImageDevice'.DBCC results for 'conflict_FloridaCCUSASUM_CashHistoryDenom'.There are 0 rows in 0 pages for object 'conflict_FloridaCCUSASUM_CashHistoryDenom'.DBCC results for 'ContactPhone'.There are 0 rows in 0 pages for object 'ContactPhone'.DBCC results for 'Command'.There are 113 rows in 2 pages for object 'Command'.DBCC results for 'DeferredType'.There are 1 rows in 1 pages for object 'DeferredType'.DBCC results for 'LocationCheck'.There are 1 rows in 1 pages for object 'LocationCheck'.DBCC results for 'conflict_FloridaCCUSASUM_CashHistory'.There are 0 rows in 0 pages for object 'conflict_FloridaCCUSASUM_CashHistory'.DBCC results for 'ItemHistory'.There are 656650 rows in 7501 pages for object 'ItemHistory'.DBCC results for 'OffsetACH'.There are 0 rows in 0 pages for object 'OffsetACH'.DBCC results for 'SaleItemTypeOffset'.There are 2 rows in 1 pages for object 'SaleItemTypeOffset'.DBCC results for 'ContactReference'.There are 0 rows in 0 pages for object 'ContactReference'.DBCC results for 'Service'.There are 1 rows in 1 pages for object 'Service'.DBCC results for 'CheckType'.There are 6 rows in 1 pages for object 'CheckType'.DBCC results for 'Menu'.There are 149 rows in 1 pages for object 'Menu'.DBCC results for 'ContactReferenceRelation'.There are 14 rows in 1 pages for object 'ContactReferenceRelation'.DBCC results for 'SwsObjects'.There are 0 rows in 0 pages for object 'SwsObjects'.DBCC results for 'ServiceLog'.There are 0 rows in 0 pages for object 'ServiceLog'.DBCC results for 'LocationImageCapture'.There are 0 rows in 0 pages for object 'LocationImageCapture'.DBCC results for 'CheckTypeRange'.There are 0 rows in 0 pages for object 'CheckTypeRange'.DBCC results for 'LocationDeferred'.There are 1 rows in 1 pages for object 'LocationDeferred'.DBCC results for 'CourtActionAgent'.There are 0 rows in 0 pages for object 'CourtActionAgent'.DBCC results for 'SwsColumns'.There are 0 rows in 0 pages for object 'SwsColumns'.DBCC results for 'DeviceManager'.There are 1 rows in 1 pages for object 'DeviceManager'.DBCC results for 'CollateralCondition'.There are 0 rows in 0 pages for object 'CollateralCondition'.DBCC results for 'RateOrder'.There are 3 rows in 1 pages for object 'RateOrder'.DBCC results for 'DeferredBank'.There are 0 rows in 0 pages for object 'DeferredBank'.DBCC results for 'QuickDate'.There are 10 rows in 1 pages for object 'QuickDate'.DBCC results for 'LocationDeferredType'.There are 0 rows in 0 pages for object 'LocationDeferredType'.DBCC results for 'Debt'.There are 0 rows in 0 pages for object 'Debt'.DBCC results for 'OffsetCash'.There are 0 rows in 0 pages for object 'OffsetCash'.DBCC results for 'CollateralStyle'.There are 0 rows in 0 pages for object 'CollateralStyle'.DBCC results for 'SwsIndexes'.There are 0 rows in 0 pages for object 'SwsIndexes'.DBCC results for 'UserCheckType'.There are 0 rows in 0 pages for object 'UserCheckType'.DBCC results for 'DeviceType'.There are 2 rows in 1 pages for object 'DeviceType'.DBCC results for 'Turndown'.There are 32 rows in 1 pages for object 'Turndown'.DBCC results for 'DeferredBankAccountType'.There are 3 rows in 1 pages for object 'DeferredBankAccountType'.DBCC results for 'RightType'.There are 384 rows in 2 pages for object 'RightType'.DBCC results for 'DebtAssignment'.There are 0 rows in 0 pages for object 'DebtAssignment'.DBCC results for 'LocationDirectDeposit'.There are 0 rows in 0 pages for object 'LocationDirectDeposit'.DBCC results for 'DeferredTypeRateRange'.There are 0 rows in 0 pages for object 'DeferredTypeRateRange'.DBCC results for 'DebtSnapshot'.There are 0 rows in 0 pages for object 'DebtSnapshot'. DBCC results for 'CheckItem'.Msg 8928, Level 16, State 1, Line 1Object ID 1550628567, index ID 255: Page (1:4822489) could not be processed. See other errors for details.Msg 8944, Level 16, State 12, Line 1Table error: Object ID 1550628567, index ID 255, page (1:4822489), row 0. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 8094 and 7604.Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1550628567. The text, ntext, or image node at page (1:4975443), slot 0, text ID 102419791872 is not referenced.Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1550628567. The text, ntext, or image node at page (1:4975444), slot 0, text ID 102419791872 is not referenced.Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1550628567. The text, ntext, or image node at page (1:4975445), slot 0, text ID 102419791872 is not referenced.Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1550628567. The text, ntext, or image node at page (1:4975446), slot 0, text ID 102419791872 is not referenced.Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1550628567. The text, ntext, or image node at page (1:4975447), slot 0, text ID 102419791872 is not referenced.Msg 8928, Level 16, State 1, Line 1Object ID 1550628567, index ID 255: Page (1:4975448) could not be processed. See other errors for details.Msg 8939, Level 16, State 42, Line 1Table error: Object ID 1550628567, index ID 255, page (1:4975448). Test (m_slotCnt <= 1 && m_type == TEXT_TREE_PAGE) failed. Values are 2 and 1.Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1550628567. The text, ntext, or image node at page (1:4975449), slot 0, text ID 102419791872 is not referenced.Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1550628567. The text, ntext, or image node at page (1:4975450), slot 0, text ID 102419791872 is not referenced.Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1550628567. The text, ntext, or image node at page (1:4975451), slot 0, text ID 102419791872 is not referenced.Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1550628567. The text, ntext, or image node at page (1:4975452), slot 0, text ID 102419791872 is not referenced.Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1550628567. The text, ntext, or image node at page (1:5359141), slot 1, text ID 137216786432 is not referenced.Msg 8928, Level 16, State 1, Line 1Object ID 1550628567, index ID 255: Page (1:5359775) could not be processed. See other errors for details.Msg 8944, Level 16, State 12, Line 1Table error: Object ID 1550628567, index ID 255, page (1:5359775), row 0. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 8094 and 8034.Msg 8928, Level 16, State 1, Line 1Object ID 1550628567, index ID 255: Page (1:5359776) could not be processed. See other errors for details.Msg 8928, Level 16, State 1, Line 1Object ID 1550628567, index ID 255: Page (1:5359777) could not be processed. See other errors for details.Msg 8928, Level 16, State 1, Line 1Object ID 1550628567, index ID 255: Page (1:5359778) could not be processed. See other errors for details.Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1550628567. The text, ntext, or image node at page (1:5359779), slot 0, text ID 137216786432 is not referenced.Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1550628567. The text, ntext, or image node at page (1:5359800), slot 0, text ID 137216786432 is not referenced.Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1550628567. The text, ntext, or image node at page (1:5359801), slot 0, text ID 137216786432 is not referenced.Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1550628567. The text, ntext, or image node at page (1:5359802), slot 0, text ID 137216786432 is not referenced.Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1550628567. The text, ntext, or image node at page (1:5359803), slot 0, text ID 137216786432 is not referenced.Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1550628567. The text, ntext, or image node at page (1:5359804), slot 0, text ID 137216786432 is not referenced.Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1550628567. The text, ntext, or image node at page (1:5359805), slot 0, text ID 137216786432 is not referenced.Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1550628567. The text, ntext, or image node at page (1:5359806), slot 0, text ID 137216786432 is not referenced.Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1550628567. The text, ntext, or image node at page (1:5359807), slot 0, text ID 137216786432 is not referenced.There are 1266618 rows in 40028 pages for object 'CheckItem'.CHECKDB found 0 allocation errors and 28 consistency errors in table 'CheckItem' (object ID 1550628567). DBCC results for 'Device'.There are 0 rows in 0 pages for object 'Device'.DBCC results for 'TurndownReason'.There are 1 rows in 1 pages for object 'TurndownReason'.DBCC results for 'StoredValueCardItem'.There are 0 rows in 0 pages for object 'StoredValueCardItem'.DBCC results for 'DebtAutoAssignPlanByReason'.There are 0 rows in 0 pages for object 'DebtAutoAssignPlanByReason'.DBCC results for 'ClientProcess'.There are 0 rows in 0 pages for object 'ClientProcess'.DBCC results for 'SwsIndexKeys'.There are 0 rows in 0 pages for object 'SwsIndexKeys'.DBCC results for 'DeferredBankTransactionType'.There are 2 rows in 1 pages for object 'DeferredBankTransactionType'.DBCC results for 'GroupRight'.There are 0 rows in 0 pages for object 'GroupRight'.DBCC results for 'UnprocessedSaleItem'.There are 0 rows in 1 pages for object 'UnprocessedSaleItem'.DBCC results for 'DirectDepositType'.There are 1 rows in 1 pages for object 'DirectDepositType'.DBCC results for 'CheckDeposit'.There are 15082 rows in 153 pages for object 'CheckDeposit'.DBCC results for 'Warning'.There are 26237 rows in 318 pages for object 'Warning'.DBCC results for 'DeferredTypeTransactionType'.There are 18 rows in 1 pages for object 'DeferredTypeTransactionType'.DBCC results for 'UnprocessedSale'.There are 0 rows in 0 pages for object 'UnprocessedSale'.DBCC results for 'DebtBankruptcy'.There are 0 rows in 0 pages for object 'DebtBankruptcy'.DBCC results for 'DeferredBankAccount'.There are 0 rows in 0 pages for object 'DeferredBankAccount'.DBCC results for 'DirectDepositStateCode'.There are 4 rows in 1 pages for object 'DirectDepositStateCode'.DBCC results for 'PaymentHandler'.There are 0 rows in 0 pages for object 'PaymentHandler'.DBCC results for 'WarningType'.There are 8 rows in 1 pages for object 'WarningType'.DBCC results for 'DebtBrowserFilter'.There are 0 rows in 0 pages for object 'DebtBrowserFilter'.DBCC results for 'SwsConstraints'.There are 0 rows in 0 pages for object 'SwsConstraints'.DBCC results for 'LocationDeferredBank'.There are 0 rows in 0 pages for object 'LocationDeferredBank'.DBCC results for 'GroupAdmin'.There are 0 rows in 0 pages for object 'GroupAdmin'.DBCC results for 'DirectDepositAccountStatus'.There are 5 rows in 1 pages for object 'DirectDepositAccountStatus'.DBCC results for 'PaymentHandlerTerminal'.There are 0 rows in 0 pages for object 'PaymentHandlerTerminal'.DBCC results for 'DebtCheckReason'.There are 11 rows in 1 pages for object 'DebtCheckReason'.DBCC results for 'GroupCheckType'.There are 0 rows in 0 pages for object 'GroupCheckType'.DBCC results for 'DirectDepositAccount'.There are 0 rows in 0 pages for object 'DirectDepositAccount'.DBCC results for 'UtilityCompanyDivision'.There are 0 rows in 0 pages for object 'UtilityCompanyDivision'.DBCC results for 'Bank'.There are 29151 rows in 479 pages for object 'Bank'.DBCC results for 'DebtCheckType'.There are 11 rows in 1 pages for object 'DebtCheckType'.DBCC results for 'SwsForeignKeys'.There are 0 rows in 0 pages for object 'SwsForeignKeys'.DBCC results for 'Deferred'.There are 301044 rows in 10732 pages for object 'Deferred'.DBCC results for 'SocialAreaNumber'.There are 696 rows in 4 pages for object 'SocialAreaNumber'.DBCC results for 'PaymentHandlerType'.There are 2 rows in 1 pages for object 'PaymentHandlerType'.DBCC results for 'UtilityStatus'.There are 4 rows in 1 pages for object 'UtilityStatus'.DBCC results for 'DebtCourtAction'.There are 0 rows in 0 pages for object 'DebtCourtAction'.DBCC results for 'DeferredGroup'.There are 0 rows in 0 pages for object 'DeferredGroup'.DBCC results for 'Maker'.There are 257314 rows in 12394 pages for object 'Maker'.DBCC results for 'SystemStructure'.There are 79 rows in 1 pages for object 'SystemStructure'.DBCC results for 'LetterCommonFields'.There are 22 rows in 1 pages for object 'LetterCommonFields'.DBCC results for 'LocationMoneyOrderRange'.There are 0 rows in 0 pages for object 'LocationMoneyOrderRange'.DBCC results for 'DebtCourtProcessServer'.There are 2 rows in 1 pages for object 'DebtCourtProcessServer'.DBCC results for 'DirectDepositTransactionStatus'.There are 6 rows in 1 pages for object 'DirectDepositTransactionStatus'.DBCC results for 'UserRightSecurity'.There are 0 rows in 0 pages for object 'UserRightSecurity'.DBCC results for 'DeferredDeposit'.There are 13458 rows in 114 pages for object 'DeferredDeposit'.DBCC results for 'MakerEditOption'.There are 2 rows in 1 pages for object 'MakerEditOption'.DBCC results for 'SubscriberConnection'.There are 0 rows in 0 pages for object 'SubscriberConnection'.DBCC results for 'SwsComments'.There are 0 rows in 0 pages for object 'SwsComments'.DBCC results for 'UtilityHostRequest'.There are 0 rows in 0 pages for object 'UtilityHostRequest'.DBCC results for 'conflict_FloridaCCUSAREG_BCCISTTrack'.There are 0 rows in 0 pages for object 'conflict_FloridaCCUSAREG_BCCISTTrack'.DBCC results for 'DebtCourtWitness'.There are 0 rows in 0 pages for object 'DebtCourtWitness'.DBCC results for 'DirectDepositTransaction'.There are 0 rows in 0 pages for object 'DirectDepositTransaction'.DBCC results for 'MakerReference'.There are 8 rows in 1 pages for object 'MakerReference'.DBCC results for 'PUBCHECKSUM'.There are 2155011 rows in 13440 pages for object 'PUBCHECKSUM'.DBCC results for 'TableSetting'.There are 4 rows in 1 pages for object 'TableSetting'.DBCC results for 'RASError'.There are 153 rows in 2 pages for object 'RASError'.DBCC results for 'UserRightLoginFailure'.There are 0 rows in 0 pages for object 'UserRightLoginFailure'.DBCC results for 'UtilityHostResponse'.There are 0 rows in 0 pages for object 'UtilityHostResponse'.DBCC results for 'conflict_FloridaCCUSAREG_Utility'.There are 0 rows in 0 pages for object 'conflict_FloridaCCUSAREG_Utility'.DBCC results for 'DebtGarnishment'.There are 0 rows in 0 pages for object 'DebtGarnishment'.DBCC results for 'DeferredTransaction'.There are 600548 rows in 17203 pages for object 'DeferredTransaction'.DBCC results for 'MakerSignature'.There are 891 rows in 10 pages for object 'MakerSignature'.DBCC results for 'LocationTableSetting'.There are 4 rows in 1 pages for object 'LocationTableSetting'.DBCC results for 'DirectDepositCheck'.There are 0 rows in 0 pages for object 'DirectDepositCheck'.DBCC results for 'CSSBError'.There are 27 rows in 1 pages for object 'CSSBError'.DBCC results for 'TitleLoanTransactionType'.There are 13 rows in 1 pages for object 'TitleLoanTransactionType'.DBCC results for 'conflict_FloridaCCUSAREG_Customer'.There are 30 rows in 6 pages for object 'conflict_FloridaCCUSAREG_Customer'.DBCC results for 'DebtGarnishmentPayment'.There are 0 rows in 0 pages for object 'DebtGarnishmentPayment'.DBCC results for 'DeferredTransactionType'.There are 18 rows in 1 pages for object 'DeferredTransactionType'.DBCC results for 'MakerVerify'.There are 261 rows in 4 pages for object 'MakerVerify'.DBCC results for 'TitleLoanCollateral'.There are 0 rows in 0 pages for object 'TitleLoanCollateral'.DBCC results for 'conflict_FloridaCCUSAREG_CustomerDescription'.There are 0 rows in 0 pages for object 'conflict_FloridaCCUSAREG_CustomerDescription'.DBCC results for 'DebtHistory'.There are 0 rows in 0 pages for object 'DebtHistory'.DBCC results for 'DirectDepositTransactionAudit'.There are 0 rows in 0 pages for object 'DirectDepositTransactionAudit'.DBCC results for 'MakerVerifyType'.There are 0 rows in 0 pages for object 'MakerVerifyType'.DBCC results for 'LocationTableFieldSetting'.There are 194 rows in 2 pages for object 'LocationTableFieldSetting'.DBCC results for 'Good'.There are 0 rows in 0 pages for object 'Good'.DBCC results for 'conflict_FloridaCCUSAREG_CustomerIdentification'.There are 0 rows in 0 pages for object 'conflict_FloridaCCUSAREG_CustomerIdentification'.DBCC results for 'DebtHistoryContact'.There are 11 rows in 1 pages for object 'DebtHistoryContact'.DBCC results for 'QuickMaker'.There are 0 rows in 0 pages for object 'QuickMaker'.DBCC results for 'GoodItem'.There are 0 rows in 0 pages for object 'GoodItem'.DBCC results for 'Toolbar'.There are 11 rows in 1 pages for object 'Toolbar'.DBCC results for 'conflict_FloridaCCUSAREG_CustomerNote'.There are 0 rows in 0 pages for object 'conflict_FloridaCCUSAREG_CustomerNote'.DBCC results for 'DebtHistoryDescription'.There are 15 rows in 1 pages for object 'DebtHistoryDescription'.DBCC results for 'DirectDepositImportError'.There are 0 rows in 0 pages for object 'DirectDepositImportError'.DBCC results for 'State'.There are 59 rows in 1 pages for object 'State'.DBCC results for 'Dispenser'.There are 0 rows in 0 pages for object 'Dispenser'.DBCC results for 'Unit'.There are 0 rows in 0 pages for object 'Unit'.DBCC results for 'Customer'.There are 254809 rows in 15525 pages for object 'Customer'.DBCC results for 'conflict_FloridaCCUSAREG_CustomerRate'.There are 0 rows in 0 pages for object 'conflict_FloridaCCUSAREG_CustomerRate'.DBCC results for 'SaveACHTransactionDeferredLink'.There are 0 rows in 1 pages for object 'SaveACHTransactionDeferredLink'.DBCC results for 'DebtHistoryType'.There are 13 rows in 1 pages for object 'DebtHistoryType'.DBCC results for 'SaveReportEvent'.There are 47 rows in 1 pages for object 'SaveReportEvent'.DBCC results for 'LocationDispenser'.There are 0 rows in 0 pages for object 'LocationDispenser'.DBCC results for 'UserData'.There are 1 rows in 1 pages for object 'UserData'.DBCC results for 'ReportEvent'.There are 56 rows in 1 pages for object 'ReportEvent'.DBCC results for 'ItemGroup'.There are 0 rows in 0 pages for object 'ItemGroup'.DBCC results for 'CustomerDescription'.There are 15 rows in 1 pages for object 'CustomerDescription'.DBCC results for 'Session'.There are 1333 rows in 12 pages for object 'Session'.DBCC results for 'conflict_FloridaCCUSAREG_CustomerReference'.There are 0 rows in 0 pages for object 'conflict_FloridaCCUSAREG_CustomerReference'.DBCC results for 'DebtInterest'.There are 0 rows in 0 pages for object 'DebtInterest'.DBCC results for 'SaleType'.There are 2 rows in 1 pages for object 'SaleType'.DBCC results for 'SaveDeferredBankACHProposal'.There are 0 rows in 0 pages for object 'SaveDeferredBankACHProposal'.DBCC results for 'DebtChangeHistory'.There are 0 rows in 0 pages for object 'DebtChangeHistory'.DBCC results for 'ItemType'.There are 2 rows in 1 pages for object 'ItemType'.DBCC results for 'DeferredBankACHProposal'.There are 0 rows in 0 pages for object 'DeferredBankACHProposal'.DBCC results for 'CustomerEditOption'.There are 2 rows in 1 pages for object 'CustomerEditOption'.DBCC results for 'conflict_FloridaCCUSAREG_CustomerVerify'.There are 0 rows in 0 pages for object 'conflict_FloridaCCUSAREG_CustomerVerify'.DBCC results for 'DebtInterestField'.There are 6 rows in 1 pages for object 'DebtInterestField'.DBCC results for 'DenomType'.There are 11 rows in 1 pages for object 'DenomType'.DBCC results for 'ItemTypePar'.There are 0 rows in 0 pages for object 'ItemTypePar'.DBCC results for 'CustomerEmployer'.There are 166588 rows in 3549 pages for object 'CustomerEmployer'.DBCC results for 'conflict_FloridaCCUSAREG_Maker'.There are 0 rows in 0 pages for object 'conflict_FloridaCCUSAREG_Maker'.DBCC results for 'LocationTeleTrack'.There are 0 rows in 0 pages for object 'LocationTeleTrack'.DBCC results for 'DebtLetter'.There are 0 rows in 0 pages for object 'DebtLetter'.DBCC results for 'BestPrepaidPhone'.There are 0 rows in 0 pages for object 'BestPrepaidPhone'.DBCC results for 'ImageCapturePoint'.There are 5 rows in 1 pages for object 'ImageCapturePoint'.DBCC results for 'CashDenom'.There are 0 rows in 0 pages for object 'CashDenom'.DBCC results for 'ItemTypeComposition'.There are 0 rows in 0 pages for object 'ItemTypeComposition'.DBCC results for 'CustomerIdentification'.There are 221072 rows in 2324 pages for object 'CustomerIdentification'.DBCC results for 'conflict_FloridaCCUSAREG_MakerReference'.There are 0 rows in 0 pages for object 'conflict_FloridaCCUSAREG_MakerReference'.DBCC results for 'Debtor'.There are 0 rows in 0 pages for object 'Debtor'.DBCC results for 'LocationDeferredImage'.There are 0 rows in 0 pages for object 'LocationDeferredImage'.DBCC results for 'BestPrepaidPhoneTransaction'.There are 0 rows in 0 pages for object 'BestPrepaidPhoneTransaction'.DBCC results for 'ItemTypeValueType'.There are 4 rows in 1 pages for object 'ItemTypeValueType'.DBCC results for 'CustomerNote'.There are 260 rows in 3 pages for object 'CustomerNote'.DBCC results for 'UserDisposablePassword'.There are 0 rows in 0 pages for object 'UserDisposablePassword'.DBCC results for 'conflict_FloridaCCUSAREG_MakerSignature'.There are 0 rows in 0 pages for object 'conflict_FloridaCCUSAREG_MakerSignature'.DBCC results for 'DebtOtherCost'.There are 0 rows in 0 pages for object 'DebtOtherCost'.DBCC results for 'LocationImageCapturePoint'.There are 5 rows in 1 pages for object 'LocationImageCapturePoint'.CHECKDB found 0 allocation errors and 32 consistency errors in database 'FloridaCCUSA'.repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (FloridaCCUSA ).DBCC execution completed. If DBCC printed error messages, contact your system administrator.____________________________________________________________________________________"Believe in those who are seeking the truth. Doubt those who say they have found it." -Andre Gide |
 |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2007-06-05 : 08:52:33
|
| This is a complicated one. There are two sets of corruptions here. One is for pages (1:4822489) and (1:4975448), which both have corrupt row sizes, and are both part of a text tree (hence the following errors that pages lower in the text tree weren't referenced). It's strange that both pages have the same wrong row size - unlikely to be a bug since the correct row sizes are quite different. My guess would be in-memory or on-disk corruption.The second set of errors is more insidious and is the one involving the pages that have a non-existent object ID stamped on them, even though an existing table thinks it has them allocated. At first glance, my guess is that they really should be allocated to the existing table, but that something corrupted an IAM page in the previously existing table (i.e. the extent was allocated to two tables at once), both tables partied on the pages, and then the first table was dropped. Again, doesn't sound like any bug I've heard of - more likely a random bit flip in an IAM page.Have you had any IO subsystem issues, any other CHECKDB problems prior to you starting the job 4 day ago, anything in the error log or Windows event logs?(I'm at TechEd so may not see any reply until this evening/tomorrow morning - call Product Support if this is urgent)Paul RandalPrincipal Lead Program Manager, Microsoft SQL Server Core Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)http://blogs.msdn.com/sqlserverstorageengine/default.aspx |
|
|
|
readysetstop
Posting Yak Master
123 Posts |
Posted - 2007-06-05 : 13:56:15
|
| Paul, thank you, once again for coming to the rescue. What I have in here is from maintenance plans. The weekly integrity checks job started failing a LONG time ago. We're talking months, here. It ran for 4h41m one night instead of it's usual 55m. It went back to 55m, and has been taking steadily longer and longer to run, since then. It's up to an hour and 22 now. Does this mean the number of errors has been increasing, I wonder?The Windows Event Log a couple of days before that shows a disk failure at 10:30 AM and a power failure at 4:30 PM. Not a good day for that box. Here's the oldest plan log I can find on the issue, again from about a month ago:[3] Database FloridaCCUSA: Check Data and Index Linkage...[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 8939: [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1227270540, index ID 255, page (1:5359776). Test (m_slotCnt <= 1 && m_type == TEXT_TREE_PAGE) failed. Values are 8 and 1. The following errors were found:[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1227270540, index ID 255, page (1:5359776). Test (m_slotCnt <= 1 && m_type == TEXT_TREE_PAGE) failed. Values are 8 and 1.[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1550628567, index ID 255, page (1:4975448). Test (m_slotCnt <= 1 && m_type == TEXT_TREE_PAGE) failed. Values are 2 and 1.[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1550628567. The text, ntext, or image node at page (1:5359802), slot 0, text ID 137216786432 is not referenced.[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1550628567. The text, ntext, or image node at page (1:5359803), slot 0, text ID 137216786432 is not referenced.[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1550628567. The text, ntext, or image node at page (1:5359804), slot 0, text ID 137216786432 is not referenced.[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1550628567. The text, ntext, or image node at page (1:5359805), slot 0, text ID 137216786432 is not referenced.[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1550628567. The text, ntext, or image node at page (1:5359806), slot 0, text ID 137216786432 is not referenced.[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1550628567. The text, ntext, or image node at page (1:5359807), slot 0, text ID 137216786432 is not referenced.[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 28 consistency errors in table 'CheckItem' (object ID 1550628567).[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 32 consistency errors in database 'FloridaCCUSA'.[Microsoft][ODBC SQL Server Driver][SQL Server]repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (FloridaCCUSA ). ** Execution Time: 0 hrs, 20 mins, 46 secs **So here's what I did next:dbcc page (FloridaCCUSA, 1, 5359776, 3)Server: Msg 7987, Level 22, State 1, Line 1A possible database consistency problem has been detected on database 'FloridaCCUSA'. DBCC CHECKDB and DBCC CHECKCATALOG should be run on database 'FloridaCCUSA'.Connection Brokendbcc checkcatalog FloridaCCUSADBCC results for 'FloridaCCUSA'.DBCC execution completed. If DBCC printed error messages, contact your system administrator.We acutally have a backup from the day of the hardware failures, just before the disk issue. This is already way outside the scope of the tape backup retention policy here. Talk about lucky.I read your post on the IAM pages. If I understand correctly, the way to fix this is either repair it with DBCC, or failing that, get what data out that we can, and truncate the table, deleting the IAM pages. About 1.2M rows to get out... Sound about right? I'm in the process of restoring a recent backup, to play with. I'll let you know what goes on with that. Anything in particular I should try?UPDATE: 2007.06.06_16:33 - DBCC with repair seems to have worked fine. As soon as I can find some quiet time on that server, I'll get it fixed.____________________________________________________________________________________"Believe in those who are seeking the truth. Doubt those who say they have found it." -Andre Gide |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2007-06-11 : 17:37:43
|
| Glad your repair worked out. You should download and run SQLIOSim to get confirmation or not of IO subsystem issues before it happens again. The CHECKDB runtimes you described are consistent with transient corruption errors.Let me know if anything else unusual happens.Paul RandalPrincipal Lead Program Manager, Microsoft SQL Server Core Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)http://blogs.msdn.com/sqlserverstorageengine/default.aspx |
|
|
|
|
|
|
|
|
Identifying the problem object by ID.