RMS V 1.3 flat
In sequential order:
- Auto-generated WS 401 to store for 12/05/2007 received error in log file, but not on HQ: No response was received for message type 3(Worksheet Status)
- Connection closed and not reopened again until 12/09/2007. Original WS
401 processes from the 5th receives errors (this is just a excerpt from the long list of errors - formatting is guaranteed to be 100% awful - apologies in advance): Error -2147467259: I/O error 23(Data error (cyclic redundancy check).) detected during read at offset 0x0000000083a000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL\DATA\298MI_Data.mdf'. SET NOCOUNT ON SELECT * Error -2147467259: Connection failure SELECT TOP 1 DBTimeStamp FROM [Message] WHERE DBTimeStamp >= ? Error -2147467259: Connection failure SELECT TOP 1 DBTimeStamp FROM [NonTenderTransaction] WHERE DBTimeStamp >= ? Error -2147467259: Connection failure SELECT TOP 1 DBTimeStamp FROM [Order] WHERE DBTimeStamp >= ?
- The above errors go on for awhile against almost all tables, finally processing against the following tables: Batch, Cashier, Configuration, Customer, Daily Sales, Item
- Immediately following processing against above tables, enter the next error: Error -2147467259: Connection failure SELECT ID, 2 AS Status, Title, Message, Style, 298 AS FromStoreID, ToStoreID, AttachmentID, ? As DateSent, DateReceived FROM HQMessage WHERE Error 91: Object variable or With block variable not set (Unhandled Error, state = '9')
- The original worksheet, and corresponding errors continue 3 more times at scheduled connection times, none giving signal of errors to HQ on original WS
401. Then, like magic, the WS processes, no errors received again until the
15th - this time slightly different.
- Enter errors from the 15th' scheduled WS 401: Error -2147467259: I/O error 23(Data error (cyclic redundancy check).) detected during read at offset 0x00000000832000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL\DATA8MI_Data.mdf'. SELECT * INTO #Temp Error -2147467259: Connection failure UPDATE #Temp SET AccountTypeID = ISNULL(AccountType.HQID,0) FROM #Temp LEFT JOIN AccountType ON AccountType.ID = #Temp.AccountTypeID; UPDATE Error -2147467259: Connection failure SELECT * FROM [#Temp] Error 91: Object variable or With block variable not set (Unhandled Error, state = '9')
- The scheduled WS 401 for the 15th continues to attempt to process 4 times receiving errors, until it also just kicks in and goes w/out issue late in the day on the 15th.
- Weirdest part: Items tables The store should have 8,500ish line items. When queried against Item table, results return 1,500 line items (SELECT * FROM Item). Qty report run from SO Mgr (no restrictions) returns results of 8,500 line items. When cross- refing report from SO Mgr against listing from SO Admin, located a line item listed in SO Mgr, but not SO Admin, queried against the ILC in Admin (SELECT * FROM Item WHERE ItemLookupCode = 'xxx'), results returned.
This is just crazy, and I could use any advice and or ideas you might have.
Thank you,