InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 24 May 2012 12:37:19 GMT20http://www.sqlservercentral.com/Forums/Topic852552-265-1.aspx[quote][b]GilaMonster (1/24/2010)[/b][hr]Just an addendum, now that the crisis has passed...From what I saw in the list of indexes, you may have a few too many indexes on that table (though too many is subjective) and, based on the names, duplicate indexes.It may be worth looking into when you have time.[/quote]Interesting observation ... Unfortunately, I have no input to the design of the database. The database was developed by Activant, Inc. and is an integral part of their "Prophet 21" wholesale distribution enterprise software (www.p21.com).The crisis for me isn't [i]quite[/i] over, as I still need to get the I/O Subsystem issues resolved as well as upgrade to SQL 2005. In the meantime, I've been checking out all the great resources at www.sqlskills.com and just listened to Paul's interview re: database corruption. Need to get up to speed on torn page detection, review our backup/restore strategy (can definitely be simplified/improved) and some agent alerts, etc. Baby steps for now ...I can't adequately express my thanks for your time, expertise and willingness to help.Zivio!Karl StyrskySun, 24 Jan 2010 23:49:45 GMTZivio!http://www.sqlservercentral.com/Forums/Topic852552-265-1.aspxJust an addendum, now that the crisis has passed...From what I saw in the list of indexes, you may have a few too many indexes on that table (though too many is subjective) and, based on the names, duplicate indexes.It may be worth looking into when you have time.Sun, 24 Jan 2010 23:29:44 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic852552-265-1.aspxNo problem - beers are on you at PASS :-)Sun, 24 Jan 2010 17:27:12 GMTPaul Randalhttp://www.sqlservercentral.com/Forums/Topic852552-265-1.aspxFound a single duplicate record in inv_period_usage and deleted manually from DB.DBCC DBREINDEX('inv_period_usage') executed without error ...AND, DBCC CHECKDB now comes up clean, no errors!Now I need to investigate the I/O Subsystem errors and also see if I can bring a database from 1/9/2010 all the way thru 1/22/2010 [end of business Friday] ... current test database that now comes up good was only thru 1/21/2010. But even if this is unsuccessful, we'd be faced only with manually re-inputting one day's transactions. I can't thank you enough, Paul!Sun, 24 Jan 2010 16:11:09 GMTZivio!http://www.sqlservercentral.com/Forums/Topic852552-265-1.aspxGreat! I'll see what I can find.Thanks again for all your help! :w00t:Sun, 24 Jan 2010 14:29:25 GMTZivio!http://www.sqlservercentral.com/Forums/Topic852552-265-1.aspxThat would be why the repair_rebuild failed too. You won't be able to fix this until you remove/fix the duplicate key values. Google should give you plenty of scripts to help you with that. Then the rebuild should work.Sun, 24 Jan 2010 14:06:30 GMTPaul Randalhttp://www.sqlservercentral.com/Forums/Topic852552-265-1.aspxGuess we're on to the unpalatable options ... DBCC DBREINDEX ('inv_period_usage') resulted in:Server: Msg 1505, Level 16, State 1, Line 1CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 1. Most significant primary key is '122444'.The statement has been terminated.Sun, 24 Jan 2010 13:59:30 GMTZivio!http://www.sqlservercentral.com/Forums/Topic852552-265-1.aspxYou should be able to manually rebuild the clustered index and it fixes it. Let me know if it doesn't and we can discuss (mostly unpalatable) options.Sun, 24 Jan 2010 12:12:13 GMTPaul Randalhttp://www.sqlservercentral.com/Forums/Topic852552-265-1.aspxThanks for all the troubleshooting help. ... so, there's no hope of fixing the database w/ "only" 1 consistency error?I understand that we need to correct the underlying cause of the error, but once we do, can the restored database be fixed and then brought back up?What other recourse do I have ... I've seen some postings discussing creating fresh new database and importing in all tables/records.Sun, 24 Jan 2010 12:02:44 GMTZivio!http://www.sqlservercentral.com/Forums/Topic852552-265-1.aspxok- the index really is a clustered index. Forget the MAXDOP stuff.The errors in the word doc you attached looks like the I/O subsystem has corrupted an entire extent - i.e. a 64k RAID stripe. This is a classic corruption signature and says you've got an I/O subsystem problem - not a SQL Server bug. You should still go up to SP4, but you need to run I/O subsystem diagnostics to figure out what went wrong.CheersSun, 24 Jan 2010 11:51:47 GMTPaul Randalhttp://www.sqlservercentral.com/Forums/Topic852552-265-1.aspx[quote][b]Paul Randal (1/24/2010)[/b][hr]Sorry - I meant the 13 original errors .....Also, were any index rebuild operations performed on this table since 1/9? Do you have a multi-proc box? Can you try setting MAXDOP=1 and then rebuilding the index - see if that gets rid of it? If it does, that proves that its an index rebuild bug.[/quote]OK, I was ignoring the 13 original because I was thinking the current restore level of the DB went from 1/9/2010 [clean DBCHECK] to 1/22/2010 using tlog restorations, and we're now dealing w/ a DB that "only" has the 1 error. I'll post the extensive list.Multiprocessor? Well, we're running VMWare on ESX's that have 8 CPU's ... but the VM SQL server has only one CPU allocated ..."Can you try setting MAXDOP=1 and then rebuilding the index " ... OK, this is beyond my technical understanding ... how do I do this? BTW: I have both a virtual [i]and[/i] physical SQL server box. I updated the physical to SP4 yesterday and am trying the same restore process from 1/9/2010 just to see if results differ.Since I have a SQL VM, I could set a snapshot to do various testing ...Sun, 24 Jan 2010 11:37:53 GMTZivio!http://www.sqlservercentral.com/Forums/Topic852552-265-1.aspx[quote][b]Paul Randal (1/24/2010)[/b][hr]Can you run:select * from sysindexes where id=318624178and post the results?[/quote]See attached ...Sun, 24 Jan 2010 11:29:32 GMTZivio!http://www.sqlservercentral.com/Forums/Topic852552-265-1.aspxok - now I'm confused. Your last post says its a nonclustered primary key, which would imply the table's a heap after all, which would mean something in metadata is corrupt and telling CHECKDB that it's a clustered index.Can you run:select * from sysindexes where id=318624178and post the results?Sun, 24 Jan 2010 11:07:34 GMTPaul Randalhttp://www.sqlservercentral.com/Forums/Topic852552-265-1.aspxSorry - I meant the 13 original errors. I'm concerned you might have bad memory corrupting pages before they'e written to disk.The keys are out of order between slots 24 and 25. The key on slot 25 should be 2104614 to fit into the sequence on the page. As far as the binary values go:1000100010001100011001 actual value on page1000000001110100100110 what it should be (2104614)There's no obvious bit-flip corruption here, but that doesn't rule out unnoticed memory corruption. Hmm - the way I'd figure out what happened is find the point in the log backups right before this record was inserted, and then see what the insert operation is doing. That record was modified date_last_modified = Jan 18 2010 11:57AM and the surrounding ones weren't. Something corrupted the database around that tine I'd guess.Also, were any index rebuild operations performed on this table since 1/9? Do you have a multi-proc box? Can you try setting MAXDOP=1 and then rebuilding the index - see if that gets rid of it? If it does, that proves that its an index rebuild bug.Sun, 24 Jan 2010 11:02:54 GMTPaul Randalhttp://www.sqlservercentral.com/Forums/Topic852552-265-1.aspx[quote][b]Paul Randal (1/24/2010)[/b][hr]... From the list of columns you posted, which are the index keys? ...[/quote][i]Is this what you're looking for? ...[/i]PRIMARY KEY (non-clustered) pk_inv_period_usage ... inv_period_usage_uidFOREIGN KEY fk_inv_period_usage_dem_period ---> demand_period_uidFOREIGN KEY fk_inv_period_usage_inv_loc location_id ---> inv_mast_uidFOREIGN KEY fk_inv_period_usage_inv_mast ---> inv_mast_uidSun, 24 Jan 2010 10:56:55 GMTZivio!http://www.sqlservercentral.com/Forums/Topic852552-265-1.aspxFull DBCC CHECKDB results are attached ...Sun, 24 Jan 2010 10:45:26 GMTZivio!http://www.sqlservercentral.com/Forums/Topic852552-265-1.aspxHi Paul, very happy to hear from you again! inv_period_usage_uid = primary key for the tableI thought DBCC CHECKDB (“p21-live”) WITH NO_INFOMSGS, ALL_ERRORMSGS would give you all error messages ... What command should I use to get you what's needed?In case you need the full, plain DBCC CHECKDB results, I'll attach as .doc in a moment, but here are the previously posted results from the above command:Server: Msg 2511, Level 16, State 2, Line 1Table error: Object ID 318624178, Index ID 0. Keys out of order on page (1:549057), slots 23 and 24.CHECKDB found 0 allocation errors and 1 consistency errors in table 'inv_period_usage' (object ID 318624178).CHECKDB found 0 allocation errors and 1 consistency errors in database 'p21-live'.repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (p21-live ).Sun, 24 Jan 2010 10:42:42 GMTZivio!http://www.sqlservercentral.com/Forums/Topic852552-265-1.aspxIt depends what the corruptions are and whether they're repairable. I think you're hitting an index rebuild bug but I need some more data from you before I can tell.From the list of columns you posted, which are the index keys?Can you post the list of all the errors that CHECKDB reported?ThanksSun, 24 Jan 2010 10:16:50 GMTPaul Randalhttp://www.sqlservercentral.com/Forums/Topic852552-265-1.aspxSo, we are running SQL Server 2000 8.00.760 SP3.I need to get to at lease SP4 in order to get support from MS on this.Question: Should I attempt to fix the DB corruption before applying SP4 updates or after?Sat, 23 Jan 2010 15:52:21 GMTZivio!http://www.sqlservercentral.com/Forums/Topic852552-265-1.aspx[quote][b]Paul Randal (1/23/2010)[/b][hr]Definitely 2000. from the CHECKDB error messages.[/quote]I know. Wanted to know the flavour (patch/hotfix level)Sat, 23 Jan 2010 15:44:36 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic852552-265-1.aspxColumn Name Data Typedate_created datetimedate_last_modified datetimedemand_period_uid intedited char(1)exceptional_deviation_flag char(1)exceptional_sales_flag char(1)filtered_usage decimal(19,9)forecast_deviation_percentage decimal(19,4)forecast_usage decimal(19,9)inv_mast_uid intinv_period_usage decimal(19,9)inv_period_usage_uid intlast_maintained_by varchar(30)location_id decimal(19,0)mad_percentage decimal(19,4)mean_absolute_percent_error decimal(19,4)number_of_hits decimal(19,0)number_of_orders decimal(19,0)scheduled_usage decimal(19,9)usage_copied char(1)FOREIGN KEY fk_inv_period_usage_dem_period demand_period_uidFOREIGN KEY fk_inv_period_usage_inv_loc location_id, inv_mast_uidFOREIGN KEY fk_inv_period_usage_inv_mast inv_mast_uidPRIMARY KEY (non-clustered) pk_inv_period_usage inv_period_usage_uidSat, 23 Jan 2010 14:57:11 GMTZivio!http://www.sqlservercentral.com/Forums/Topic852552-265-1.aspxYup - there were index key order bugs fixed in SP4 (as well as tons of other stuff).What are the keys for the table? (column name and types)Sat, 23 Jan 2010 14:34:10 GMTPaul Randalhttp://www.sqlservercentral.com/Forums/Topic852552-265-1.aspxBTW, we are licensed for SQL Server 2005 and plan to update as soon as this mess is corrected. Someone may say we need to do this before ... I'm all ears.Production database is running OK, but concerned that it's time is going to be limited before more problems crop up.Sat, 23 Jan 2010 14:30:14 GMTZivio!http://www.sqlservercentral.com/Forums/Topic852552-265-1.aspx@ Gail Shaw:We are running SQL Server 2000 8.00.760 SP3 in a VMWare environment. I only recently found out that this is a no-no. Attempted opening a critical case w/ Microsoft support. They refused the case unless we update to minimum SP4. Currently studying requirements for doing so.In the meantime ...Sat, 23 Jan 2010 14:28:13 GMTZivio!http://www.sqlservercentral.com/Forums/Topic852552-265-1.aspxDefinitely 2000. from the CHECKDB error messages.Sat, 23 Jan 2010 14:26:20 GMTPaul Randalhttp://www.sqlservercentral.com/Forums/Topic852552-265-1.aspxHi Paul - thanks for your interest!Server event log around time of problem shows: 17066 :SQL Server Assertion: File: <p:\sqltdbms\storeng\drs\include\record.inl>, line=1447 Failed Assertion = 'm_SizeRec > 0 && m_SizeRec <= MAXDATAROW'.18052 :Error: 3624, Severity: 20, State: 1.These repeat daily thru 1/16/2010. On 1/17/2010 we started getting a bunch of them which caused me to try to find a database w/ a good CHECKDB, which happened to be 1/9/2010.I don't know what to do w/ the DBCC TRACEON and DBCC PAGE, but here are the results:DBCC execution completed. If DBCC printed error messages, contact your system administrator.PAGE: (1:549057)----------------BUFFER:-------BUF @0x0179F800---------------bpage = 0x69820000 bhash = 0x012A5800 bpageno = (1:549057)bdbid = 10 breferences = 1 bstat = 0x9bspin = 0 bnext = 0x00000000 PAGE HEADER:------------Page @0x69820000----------------m_pageId = (1:549057) m_headerVersion = 1 m_type = 1m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x0m_objId = 318624178 m_indexId = 0 m_prevPage = (1:549056)m_nextPage = (1:549058) pminlen = 140 m_slotCnt = 46m_freeCnt = 582 m_freeData = 7673 m_reservedCnt = 0m_lsn = (464155:27341:215) m_xactReserved = 0m_xdesId = (0:0) m_ghostRecCnt = 0 m_tornBits = 0Allocation Status-----------------GAM (1:511232) = ALLOCATED SGAM (1:511233) = NOT ALLOCATED PFS (1:541896) = 0x40 ALLOCATED 0_PCT_FULL DIFF (1:511238) = NOT CHANGED ML (1:511239) = NOT MIN_LOGGED Slot 0 Offset 0x60------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 69820060: 008c0030 00006a01 00000000 24000000 0....j.........$69820070: 4200eebf 0100009c 00000000 00000000 ...B............69820080: 00000000 00000000 011686bc 00009cfb ................69820090: 00000001 00000000 00000100 00000000 ................698200A0: 00010000 00000000 01000000 00000000 ................698200B0: 00000000 00000001 00000000 00000100 ................698200C0: 00000000 014e0000 00000000 00000000 ......N.........698200D0: 00000079 0001de4c 6f6c6a74 221e504e y...L...tjloNP."698200E0: 00000000 00000000 00000000 00000019 ................698200F0: 000301c0 009a009a 6a6c00a1 61656e75 ..........ljunea69820100: 75 u location_id = 106 inv_period_usage = 0.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Jan 11 2010 4:54PMlast_maintained_by = ljuneau scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 0 edited = N number_of_hits = 0 demand_period_uid = 121 inv_mast_uid = 122444 usage_copied = N inv_period_usage_uid = 2235984 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 1 Offset 0x101-------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 69820101: 008c0030 00006801 00000000 00000000 0....h..........69820111: 00390003 01470040 3b9aca00 00000000 ..9.@.G....;....69820121: 00000000 00000000 00a2e0e2 00009c9b ................69820131: 00000001 00000000 00000100 00000000 ................69820141: 00010000 00000000 01000000 00000000 ................69820151: 00000000 00000001 00000000 00010100 ................69820161: 00000000 014e0000 00000001 00000000 ......N.........69820171: 00000076 0001de4d 00012c00 201ce64e v...M....,..N.. 69820181: 00000000 00000000 00000000 00000019 ................69820191: 000301c0 009a009a 776500a5 69646461 ..........ewaddi698201A1: 6f74676e 6e ngtonlocation_id = 104 inv_period_usage = 1.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 7 2009 9:53AMlast_maintained_by = ewaddington scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 1 demand_period_uid = 118 inv_mast_uid = 122445 usage_copied = N inv_period_usage_uid = 2104550 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 2 Offset 0x1a6-------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 698201A6: 008c0030 00006601 00000000 30616a00 0....f.......ja0698201B6: c8002d00 010000a6 3b9aca00 00000000 .-.........;....698201C6: 00000000 00000000 00a45f7d 00009c9b ........}_......698201D6: 00000001 00000000 00000100 00000000 ................698201E6: 00010000 00000000 01000000 00000000 ................698201F6: 00000000 00000001 00000000 00010100 ................69820206: 00000000 014e0000 00000001 00000000 ......N.........69820216: 00000076 0001de4e 6200009c 201ce74e v...N......bN.. 69820226: 00000000 00000000 00000000 00000019 ................69820236: 000301c0 009a009a 616d00a2 6572646e ..........mandre69820246: 7377 wslocation_id = 102 inv_period_usage = 1.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 7 2009 9:58AMlast_maintained_by = mandrews scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 1 demand_period_uid = 118 inv_mast_uid = 122446 usage_copied = N inv_period_usage_uid = 2104551 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 3 Offset 0x248-------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 69820248: 008c0030 00006701 00000000 00000000 0....g..........69820258: 00000000 010002c0 3b9aca00 00000000 ...........;....69820268: 00000000 00000000 00a65fcc 00009c9b ........._......69820278: 00000001 00000000 00000100 00000000 ................69820288: 00010000 00000000 01000000 00000000 ................69820298: 00000000 00000001 00000000 00010100 ................698202A8: 00000000 014e0000 00000001 00000000 ......N.........698202B8: 00000076 0001de4f 4541456e 201cec4e v...O...nEAEN.. 698202C8: 00000000 00000000 00000000 00000019 ................698202D8: 000301c0 009a009a 434100a1 4554524f ..........ACORTE698202E8: 53 S location_id = 103 inv_period_usage = 1.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 7 2009 10:05AMlast_maintained_by = ACORTES scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 1 demand_period_uid = 118 inv_mast_uid = 122447 usage_copied = N inv_period_usage_uid = 2104556 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 4 Offset 0x2e9-------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 698202E9: 008c0030 00006501 00000000 00000100 0....e..........698202F9: 00000001 01000000 3b9aca00 00000000 ...........;....69820309: 00000000 00000000 00a69950 00009c9b ........P.......69820319: 00000001 00000000 00000100 00000000 ................69820329: 00010000 00000000 01000000 00000000 ................69820339: 00000000 00000001 00000000 00010100 ................69820349: 00000000 014e0000 00000001 00000000 ......N.........69820359: 00000076 0001de50 00390003 201ced4e v...P.....9.N.. 69820369: 00000000 00000000 00000000 00000019 ................69820379: 000301c0 009a009a 647200a2 6e696d6f ..........rdomin69820389: 6369 iclocation_id = 101 inv_period_usage = 1.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 7 2009 10:06AMlast_maintained_by = rdominic scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 1 demand_period_uid = 118 inv_mast_uid = 122448 usage_copied = N inv_period_usage_uid = 2104557 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 5 Offset 0x38b-------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 6982038B: 008c0030 00006601 00000000 009c4200 0....f.......B..6982039B: 16ad6800 019c4201 540be400 00000002 .h...B.....T....698203AB: 00000000 00000000 00b18b2c 00009c9c ........,.......698203BB: 00000001 00000000 00000100 00000000 ................698203CB: 00010000 00000000 01000000 00000000 ................698203DB: 00000000 00000001 00000000 00010100 ................698203EB: 00000000 014e0000 00000000 00000000 ......N.........698203FB: 00000076 0001de51 41534554 201cf84e v...Q...TESAN.. 6982040B: 00000000 00000000 00000000 00000019 ................6982041B: 000301c0 009a009a 544200a0 656c776f ..........BTowlelocation_id = 102 inv_period_usage = 10.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 8 2009 10:46AMlast_maintained_by = BTowle scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 0 demand_period_uid = 118 inv_mast_uid = 122449 usage_copied = N inv_period_usage_uid = 2104568 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 6 Offset 0x42b-------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 6982042B: 008c0030 00006501 00000000 0a000000 0....e..........6982043B: 03000000 01003900 3b9aca00 00000000 .....9.....;....6982044B: 00000000 00000000 00adb333 00009c9b ........3.......6982045B: 00000001 00000000 00000100 00000000 ................6982046B: 00010000 00000000 01000000 00000000 ................6982047B: 00000000 00000001 00000000 00010100 ................6982048B: 00000000 014e0000 00000001 00000000 ......N.........6982049B: 00000076 0001de53 ccf10000 201cfd4e v...S.......N.. 698204AB: 00000000 00000000 00000000 00000019 ................698204BB: 000301c0 009a009a 647200a2 6e696d6f ..........rdomin698204CB: 6369 iclocation_id = 101 inv_period_usage = 1.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 7 2009 10:32AMlast_maintained_by = rdominic scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 1 demand_period_uid = 118 inv_mast_uid = 122451 usage_copied = N inv_period_usage_uid = 2104573 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 7 Offset 0x4cd-------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 698204CD: 008c0030 00006501 00000000 696e6900 0....e.......ini698204DD: 6f647263 016e696d 3b9aca00 00000000 crdomin....;....698204ED: 00000000 00000000 00adb333 00009c9b ........3.......698204FD: 00000001 00000000 00000100 00000000 ................6982050D: 00010000 00000000 01000000 00000000 ................6982051D: 00000000 00000001 00000000 00010100 ................6982052D: 00000000 014e0000 00000001 00000000 ......N.........6982053D: 00000076 0001de54 4c000002 201cfe4e v...T......LN.. 6982054D: 00000000 00000000 00000000 00000019 ................6982055D: 000301c0 009a009a 647200a2 6e696d6f ..........rdomin6982056D: 6369 iclocation_id = 101 inv_period_usage = 1.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 7 2009 10:32AMlast_maintained_by = rdominic scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 1 demand_period_uid = 118 inv_mast_uid = 122452 usage_copied = N inv_period_usage_uid = 2104574 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 8 Offset 0x56f-------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 6982056F: 008c0030 00006701 00000000 2c000100 0....g.........,6982057F: 01000001 01000000 3b9aca00 00000000 ...........;....6982058F: 00000000 00000000 00b19d28 00009c9b ........(.......6982059F: 00000001 00000000 00000100 00000000 ................698205AF: 00010000 00000000 01000000 00000000 ................698205BF: 00000000 00000001 00000000 00010100 ................698205CF: 00000000 014e0000 00000001 00000000 ......N.........698205DF: 00000076 0001de55 03000000 201d004e v...U.......N.. 698205EF: 00000000 00000000 00000000 00000019 ................698205FF: 000301c0 009a009a 4a5a00a2 534e484f ..........ZJOHNS6982060F: 4e4f ONlocation_id = 103 inv_period_usage = 1.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 7 2009 10:46AMlast_maintained_by = ZJOHNSON scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 1 demand_period_uid = 118 inv_mast_uid = 122453 usage_copied = N inv_period_usage_uid = 2104576 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 9 Offset 0x611-------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 69820611: 008c0030 00006501 00000000 007f0400 0....e..........69820621: 00009c45 017f0483 3b9aca00 00000000 E..........;....69820631: 00000000 00000000 00b6624e 00009c9b ........Nb......69820641: 00000001 00000000 00000100 00000000 ................69820651: 00010000 00000000 01000000 00000000 ................69820661: 00000000 00000001 00000000 00010100 ................69820671: 00000000 014e0000 00000001 00000000 ......N.........69820681: 00000076 0001de56 72646e61 201d084e v...V...andrN.. 69820691: 00000000 00000000 00000000 00000019 ................698206A1: 000301c0 009a009a 647200a2 6e696d6f ..........rdomin698206B1: 6369 iclocation_id = 101 inv_period_usage = 1.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 7 2009 11:04AMlast_maintained_by = rdominic scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 1 demand_period_uid = 118 inv_mast_uid = 122454 usage_copied = N inv_period_usage_uid = 2104584 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 10 Offset 0x6b3--------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 698206B3: 008c0030 00006501 00000000 9c450000 0....e........E.698206C3: 000a0000 01030000 3b9aca00 00000000 ...........;....698206D3: 00000000 00000000 00b6624e 00009c9b ........Nb......698206E3: 00000001 00000000 00000100 00000000 ................698206F3: 00010000 00000000 01000000 00000000 ................69820703: 00000000 00000001 00000000 00010100 ................69820713: 00000000 014e0000 00000001 00000000 ......N.........69820723: 00000076 0001de57 00a6da00 201d074e v...W.......N.. 69820733: 00000000 00000000 00000000 00000019 ................69820743: 000301c0 009a009a 647200a2 6e696d6f ..........rdomin69820753: 6369 iclocation_id = 101 inv_period_usage = 1.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 7 2009 11:04AMlast_maintained_by = rdominic scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 1 demand_period_uid = 118 inv_mast_uid = 122455 usage_copied = N inv_period_usage_uid = 2104583 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 11 Offset 0x755--------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 69820755: 008c0030 00006801 00000000 6c756600 0....h.......ful69820765: 6a726566 016c7566 3b9aca00 00000000 ferjful....;....69820775: 00000000 00000000 00b8f0d0 00009c9b ................69820785: 00000001 00000000 00000100 00000000 ................69820795: 00010000 00000000 01000000 00000000 ................698207A5: 00000000 00000001 00000000 00010100 ................698207B5: 00000000 014e0000 00000001 00000000 ......N.........698207C5: 00000076 0001de58 02c00000 201d124e v...X.......N.. 698207D5: 00000000 00000000 00000000 00000019 ................698207E5: 000301c0 009a009a 425300a5 455a4952 ..........SBRIZE698207F5: 4e49444e 45 NDINElocation_id = 104 inv_period_usage = 1.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 7 2009 11:13AMlast_maintained_by = SBRIZENDINE scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 1 demand_period_uid = 118 inv_mast_uid = 122456 usage_copied = N inv_period_usage_uid = 2104594 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 12 Offset 0x7fa--------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 698207FA: 008c0030 00006701 00000000 dd002d00 0....g.......-..6982080A: 050000a6 010001cd 3b9aca00 00000000 ...........;....6982081A: 00000000 00000000 00ba4714 00009c9b .........G......6982082A: 00000001 00000000 00000100 00000000 ................6982083A: 00010000 00000000 01000000 00000000 ................6982084A: 00000000 00000001 00000000 00010100 ................6982085A: 00000000 014e0000 00000001 00000000 ......N.........6982086A: 00000076 0001de59 4500a2cf 201d154e v...Y......EN.. 6982087A: 00000000 00000000 00000000 00000019 ................6982088A: 000301c0 009a009a 4a5a00a2 534e484f ..........ZJOHNS6982089A: 4e4f ONlocation_id = 103 inv_period_usage = 1.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 7 2009 11:18AMlast_maintained_by = ZJOHNSON scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 1 demand_period_uid = 118 inv_mast_uid = 122457 usage_copied = N inv_period_usage_uid = 2104597 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 13 Offset 0x89c--------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 6982089C: 008c0030 00006701 00000000 01000000 0....g..........698208AC: 00000000 01000000 3b9aca00 00000000 ...........;....698208BC: 00000000 00000000 00ba4714 00009c9b .........G......698208CC: 00000001 00000000 00000100 00000000 ................698208DC: 00010000 00000000 01000000 00000000 ................698208EC: 00000000 00000001 00000000 00010100 ................698208FC: 00000000 014e0000 00000001 00000000 ......N.........6982090C: 00000076 0001de5a 39000300 201d144e v...Z......9N.. 6982091C: 00000000 00000000 00000000 00000019 ................6982092C: 000301c0 009a009a 4a5a00a2 534e484f ..........ZJOHNS6982093C: 4e4f ONlocation_id = 103 inv_period_usage = 1.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 7 2009 11:18AMlast_maintained_by = ZJOHNSON scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 1 demand_period_uid = 118 inv_mast_uid = 122458 usage_copied = N inv_period_usage_uid = 2104596 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 14 Offset 0x93e--------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 6982093E: 008c0030 00006601 00000000 00aa5000 0....f.......P..6982094E: 00009c45 01aa50c8 00000000 00000000 E....P..........6982095E: 00000000 00000000 00d0ae44 00009c9b ........D.......6982096E: 00000001 00000000 00000100 00000000 ................6982097E: 00010000 00000000 01000000 00000000 ................6982098E: 00000000 00000001 00000000 00000100 ................6982099E: 00000000 014e0000 00000000 00000000 ......N.........698209AE: 00000076 0001de5b 30747375 201d164e v...[...ust0N.. 698209BE: 00000000 00000000 00000000 00000019 ................698209CE: 000301c0 009a009a 425200a3 41544c41 ..........RBALTA698209DE: 52415a ZARlocation_id = 102 inv_period_usage = 0.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 7 2009 12:39PMlast_maintained_by = RBALTAZAR scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 0 edited = N number_of_hits = 0 demand_period_uid = 118 inv_mast_uid = 122459 usage_copied = N inv_period_usage_uid = 2104598 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 15 Offset 0x9e1--------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 698209E1: 008c0030 00006601 00000000 45003f00 0....f.......?.E698209F1: 6f666a00 01747375 3b9aca00 00000000 .jfoust....;....69820A01: 00000000 00000000 00c10b38 00009c9b ........8.......69820A11: 00000001 00000000 00000100 00000000 ................69820A21: 00010000 00000000 01000000 00000000 ................69820A31: 00000000 00000001 00000000 00010100 ................69820A41: 00000000 014e0000 00000001 00000000 ......N.........69820A51: 00000076 0001de5c 00000000 201d194e v...\.......N.. 69820A61: 00000000 00000000 00000000 00000019 ................69820A71: 000301c0 009a009a 616d00a2 6572646e ..........mandre69820A81: 7377 wslocation_id = 102 inv_period_usage = 1.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 7 2009 11:42AMlast_maintained_by = mandrews scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 1 demand_period_uid = 118 inv_mast_uid = 122460 usage_copied = N inv_period_usage_uid = 2104601 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 16 Offset 0xa83--------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 69820A83: 008c0030 00006601 00000000 00a6e600 0....f..........69820A93: 01cd1200 01012c00 77359400 00000000 .....,....5w....69820AA3: 00000000 00000000 00974370 00009ca0 ........pC......69820AB3: 00000001 00000000 00000100 00000000 ................69820AC3: 00010000 00000000 01000000 00000000 ................69820AD3: 00000000 00000001 00000000 00010100 ................69820AE3: 00000000 014e0000 00000000 00000000 ......N.........69820AF3: 00000076 0001de5d 4500b528 201d414e v...]...(..ENA. 69820B03: 00000000 00000000 00000000 00000019 ................69820B13: 000301c0 009a009a 544200a0 656c776f ..........BTowlelocation_id = 102 inv_period_usage = 2.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 12 2009 9:10AMlast_maintained_by = BTowle scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 0 demand_period_uid = 118 inv_mast_uid = 122461 usage_copied = N inv_period_usage_uid = 2104641 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 17 Offset 0xb23--------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 69820B23: 008c0030 00006601 00000000 00000000 0....f..........69820B33: 00000000 010002c0 3b9aca00 00000000 ...........;....69820B43: 00000000 00000000 00c10b38 00009c9b ........8.......69820B53: 00000001 00000000 00000100 00000000 ................69820B63: 00010000 00000000 01000000 00000000 ................69820B73: 00000000 00000001 00000000 00010100 ................69820B83: 00000000 014e0000 00000001 00000000 ......N.........69820B93: 00000076 0001de5e 49004100 201d1a4e v...^....A.IN.. 69820BA3: 00000000 00000000 00000000 00000019 ................69820BB3: 000301c0 009a009a 616d00a2 6572646e ..........mandre69820BC3: 7377 wslocation_id = 102 inv_period_usage = 1.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 7 2009 11:42AMlast_maintained_by = mandrews scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 1 demand_period_uid = 118 inv_mast_uid = 122462 usage_copied = N inv_period_usage_uid = 2104602 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 18 Offset 0xbc5--------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 69820BC5: 008c0030 00006901 00000000 00009c00 0....i..........69820BD5: 00b65e2b 01009c45 3b9aca00 00000000 +^..E......;....69820BE5: 00000000 00000000 00bf267c 00009c9b ........|&......69820BF5: 00000001 00000000 00000100 00000000 ................69820C05: 00010000 00000000 01000000 00000000 ................69820C15: 00000000 00000001 00000000 00010100 ................69820C25: 00000000 014e0000 00000001 00000000 ......N.........69820C35: 00000076 0001de5f ec002d00 201d174e v..._....-..N.. 69820C45: 00000000 00000000 00000000 00000019 ................69820C55: 000301c0 009a009a 716a00a1 6a617261 ..........jqaraj69820C65: 61 a location_id = 105 inv_period_usage = 1.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 7 2009 11:35AMlast_maintained_by = jqaraja scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 1 demand_period_uid = 118 inv_mast_uid = 122463 usage_copied = N inv_period_usage_uid = 2104599 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 19 Offset 0xc66--------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 69820C66: 008c0030 00006601 00000000 72004900 0....f.......I.r69820C76: 696d6f64 0163696e 3b9aca00 00000000 dominic....;....69820C86: 00000000 00000000 00c10b38 00009c9b ........8.......69820C96: 00000001 00000000 00000100 00000000 ................69820CA6: 00010000 00000000 01000000 00000000 ................69820CB6: 00000000 00000001 00000000 00010100 ................69820CC6: 00000000 014e0000 00000001 00000000 ......N.........69820CD6: 00000076 0001de60 00000000 201d184e v...`.......N.. 69820CE6: 00000000 00000000 00000000 00000019 ................69820CF6: 000301c0 009a009a 616d00a2 6572646e ..........mandre69820D06: 7377 wslocation_id = 102 inv_period_usage = 1.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 7 2009 11:42AMlast_maintained_by = mandrews scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 1 demand_period_uid = 118 inv_mast_uid = 122464 usage_copied = N inv_period_usage_uid = 2104600 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 20 Offset 0xd08--------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 69820D08: 008c0030 00006801 00000000 ef002d00 0....h.......-..69820D18: 1c0000a6 010001cd 3b9aca00 00000000 ...........;....69820D28: 00000000 00000000 00c130a5 00009c9b .........0......69820D38: 00000001 00000000 00000100 00000000 ................69820D48: 00010000 00000000 01000000 00000000 ................69820D58: 00000000 00000001 00000000 00010100 ................69820D68: 00000000 014e0000 00000001 00000000 ......N.........69820D78: 00000076 0001de61 009c4500 201d1b4e v...a....E..N.. 69820D88: 00000000 00000000 00000000 00000019 ................69820D98: 000301c0 009a009a 666a00a0 7473756f ..........jfoustlocation_id = 104 inv_period_usage = 1.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 7 2009 11:43AMlast_maintained_by = jfoust scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 1 demand_period_uid = 118 inv_mast_uid = 122465 usage_copied = N inv_period_usage_uid = 2104603 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 21 Offset 0xda8--------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 69820DA8: 008c0030 00006b01 00000000 02c00000 0....k..........69820DB8: 0c0a0000 014500c4 3b9aca00 00000000 ......E....;....69820DC8: 00000000 00000000 00ad5ae8 00009ca1 .........Z......69820DD8: 00000001 00000000 00000100 00000000 ................69820DE8: 00010000 00000000 01000000 00000000 ................69820DF8: 00000000 00000001 00000000 00000100 ................69820E08: 00000000 014e0000 00000000 00000000 ......N.........69820E18: 00000076 0001de63 6d737765 201d664e v...c...ewsmNf. 69820E28: 00000000 00000000 00000000 00000019 ................69820E38: 000301c0 009a009a 544200a0 656c776f ..........BTowlelocation_id = 107 inv_period_usage = 1.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 13 2009 10:31AMlast_maintained_by = BTowle scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 0 edited = N number_of_hits = 0 demand_period_uid = 118 inv_mast_uid = 122467 usage_copied = N inv_period_usage_uid = 2104678 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 22 Offset 0xe48--------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 69820E48: 008c0030 00006901 00000000 00009c00 0....i..........69820E58: 0000000a 01390003 00000000 00000000 ......9.........69820E68: 00000000 00000000 00cefb3f 00009c9b ........?.......69820E78: 00000001 00000000 00000100 00000000 ................69820E88: 00010000 00000000 01000000 00000000 ................69820E98: 00000000 00000001 00000000 00010100 ................69820EA8: 00000000 014e0000 00000001 00000000 ......N.........69820EB8: 00000076 0001de64 01cd2500 201d264e v...d....%..N&. 69820EC8: 00000000 00000000 00000000 00000019 ................69820ED8: 000301c0 009a009a 716a00a1 6a617261 ..........jqaraj69820EE8: 61 a location_id = 105 inv_period_usage = 0.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 7 2009 12:33PMlast_maintained_by = jqaraja scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 1 demand_period_uid = 118 inv_mast_uid = 122468 usage_copied = N inv_period_usage_uid = 2104614 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 23 Offset 0xee9--------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 69820EE9: 008c0030 00006901 00000000 72656600 0....i.......fer69820EF9: 6c75666a 01726566 3b9aca00 00000000 jfulfer....;....69820F09: 00000000 00000000 00cefb3f 00009c9b ........?.......69820F19: 00000001 00000000 00000100 00000000 ................69820F29: 00010000 00000000 01000000 00000000 ................69820F39: 00000000 00000001 00000000 00010100 ................69820F49: 00000000 014e0000 00000001 00000000 ......N.........69820F59: 00000076 0001de66 92000002 201d254e v...f.......N%. 69820F69: 00000000 00000000 00000000 00000019 ................69820F79: 000301c0 009a009a 716a00a1 6a617261 ..........jqaraj69820F89: 61 a location_id = 105 inv_period_usage = 1.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 7 2009 12:33PMlast_maintained_by = jqaraja scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 1 demand_period_uid = 118 inv_mast_uid = 122470 usage_copied = N inv_period_usage_uid = 2104613 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 24 Offset 0x1d5a---------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 69821D5A: 008c0030 00006a01 00000000 674bd200 0....j........Kg69821D6A: 06dfc910 01807f1b 00000000 00000000 ................69821D7A: 00000000 00000000 00c4fd4c 00009d02 ........L.......69821D8A: 00000001 00000000 00000100 00000000 ................69821D9A: 00010000 00000000 01000000 00000000 ................69821DAA: 00000000 00000001 00000000 00000100 ................69821DBA: 00000000 014e0000 00000000 00000000 ......N.........69821DCA: 00000079 0001de4c 674bd298 2223194e y...L.....KgN.#"69821DDA: 00000000 00000000 00000000 00000019 ................69821DEA: 000301c0 009a009a 6570009f 697070 ..........peppilocation_id = 106 inv_period_usage = 0.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Jan 18 2010 11:57AMlast_maintained_by = peppi scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 0 edited = N number_of_hits = 0 demand_period_uid = 121 inv_mast_uid = 122444 usage_copied = N inv_period_usage_uid = 2237209 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 25 Offset 0xf8a--------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 69820F8A: 008c0030 00006801 00000000 0001cd00 0....h..........69820F9A: 0000012c 01000001 3b9aca00 00000000 ,..........;....69820FAA: 00000000 00000000 00cf11ea 00009c9b ................69820FBA: 00000001 00000000 00000100 00000000 ................69820FCA: 00010000 00000000 01000000 00000000 ................69820FDA: 00000000 00000001 00000000 00010100 ................69820FEA: 00000000 014e0000 00000001 00000000 ......N.........69820FFA: 00000076 0001de67 00030000 201d274e v...g.......N'. 6982100A: 00000000 00000000 00000000 00000019 ................6982101A: 000301c0 009a009a 776500a5 69646461 ..........ewaddi6982102A: 6f74676e 6e ngtonlocation_id = 104 inv_period_usage = 1.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 7 2009 12:33PMlast_maintained_by = ewaddington scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 1 demand_period_uid = 118 inv_mast_uid = 122471 usage_copied = N inv_period_usage_uid = 2104615 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 26 Offset 0x102f---------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 6982102F: 008c0030 00006901 00000000 00009c00 0....i..........6982103F: 00d65712 01009c45 3b9aca00 00000000 .W..E......;....6982104F: 00000000 00000000 00d06de0 00009c9b .........m......6982105F: 00000001 00000000 00000100 00000000 ................6982106F: 00010000 00000000 01000000 00000000 ................6982107F: 00000000 00000001 00000000 00010100 ................6982108F: 00000000 014e0000 00000001 00000000 ......N.........6982109F: 00000076 0001de68 fc002d00 201d2b4e v...h....-..N+. 698210AF: 00000000 00000000 00000000 00000019 ................698210BF: 000301c0 009a009a 686d00a0 6c65646f ..........mhodellocation_id = 105 inv_period_usage = 1.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 7 2009 12:38PMlast_maintained_by = mhodel scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 1 demand_period_uid = 118 inv_mast_uid = 122472 usage_copied = N inv_period_usage_uid = 2104619 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 27 Offset 0x10cf---------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 698210CF: 008c0030 00006901 00000000 00450000 0....i........E.698210DF: 776f5442 0142656c 3b9aca00 00000000 BTowleB....;....698210EF: 00000000 00000000 00d06de0 00009c9b .........m......698210FF: 00000001 00000000 00000100 00000000 ................6982110F: 00010000 00000000 01000000 00000000 ................6982111F: 00000000 00000001 00000000 00010100 ................6982112F: 00000000 014e0000 00000001 00000000 ......N.........6982113F: 00000076 0001de69 02c00000 201d294e v...i.......N). 6982114F: 00000000 00000000 00000000 00000019 ................6982115F: 000301c0 009a009a 686d00a0 6c65646f ..........mhodellocation_id = 105 inv_period_usage = 1.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 7 2009 12:38PMlast_maintained_by = mhodel scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 1 demand_period_uid = 118 inv_mast_uid = 122473 usage_copied = N inv_period_usage_uid = 2104617 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 28 Offset 0x116f---------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 6982116F: 008c0030 00006601 00000000 6e6f7400 0....f.......ton6982117F: 002d0030 0100a6ff 3b9aca00 00000000 0.-........;....6982118F: 00000000 00000000 00d13184 00009c9c .........1......6982119F: 00000001 00000000 00000100 00000000 ................698211AF: 00010000 00000000 01000000 00000000 ................698211BF: 00000000 00000001 00000000 00010100 ................698211CF: 00000000 014e0000 00000000 00000000 ......N.........698211DF: 00000076 0001de6a 00009c45 201da94e v...j...E...N.. 698211EF: 00000000 00000000 00000000 00000019 ................698211FF: 000301c0 009a009a 425200a3 41544c41 ..........RBALTA6982120F: 52415a ZARlocation_id = 102 inv_period_usage = 1.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 8 2009 12:41PMlast_maintained_by = RBALTAZAR scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 0 demand_period_uid = 118 inv_mast_uid = 122474 usage_copied = N inv_period_usage_uid = 2104745 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 29 Offset 0x1212---------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 69821212: 008c0030 00006601 00000000 00000100 0....f..........69821222: 00000000 01c00000 3b9aca00 00000000 ...........;....69821232: 00000000 00000000 00d13184 00009c9c .........1......69821242: 00000001 00000000 00000100 00000000 ................69821252: 00010000 00000000 01000000 00000000 ................69821262: 00000000 00000001 00000000 00010100 ................69821272: 00000000 014e0000 00000000 00000000 ......N.........69821282: 00000076 0001de6b 6a004700 201daa4e v...k....G.jN.. 69821292: 00000000 00000000 00000000 00000019 ................698212A2: 000301c0 009a009a 425200a3 41544c41 ..........RBALTA698212B2: 52415a ZARlocation_id = 102 inv_period_usage = 1.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 8 2009 12:41PMlast_maintained_by = RBALTAZAR scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 0 demand_period_uid = 118 inv_mast_uid = 122475 usage_copied = N inv_period_usage_uid = 2104746 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 30 Offset 0x12b5---------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 698212B5: 008c0030 00006501 00000000 4500ea00 0....e.........E698212C5: 0a00009c 01000000 3b9aca00 00000000 ...........;....698212D5: 00000000 00000000 00deecc1 00009c9b ................698212E5: 00000001 00000000 00000100 00000000 ................698212F5: 00010000 00000000 01000000 00000000 ................69821305: 00000000 00000001 00000000 00010100 ................69821315: 00000000 014e0000 00000001 00000000 ......N.........69821325: 00000076 0001de6c 0000a705 201d334e v...l.......N3. 69821335: 00000000 00000000 00000000 00000019 ................69821345: 000301c0 009a009a 726c00a1 61777361 ..........lraswa69821355: 6e n location_id = 101 inv_period_usage = 1.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 7 2009 1:31PMlast_maintained_by = lraswan scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 1 demand_period_uid = 118 inv_mast_uid = 122476 usage_copied = N inv_period_usage_uid = 2104627 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 31 Offset 0x1356---------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 69821356: 008c0030 00006601 00000000 73617200 0....f.......ras69821366: 6c6e6177 01736172 3b9aca00 00000000 wanlras....;....69821376: 00000000 00000000 00ee1538 00009c9b ........8.......69821386: 00000001 00000000 00000100 00000000 ................69821396: 00010000 00000000 01000000 00000000 ................698213A6: 00000000 00000001 00000000 00010100 ................698213B6: 00000000 014e0000 00000001 00000000 ......N.........698213C6: 00000076 0001de6d 000002c0 201d3e4e v...m.......N>. 698213D6: 00000000 00000000 00000000 00000019 ................698213E6: 000301c0 009a009a 736b00a1 6b726174 ..........kstark698213F6: 73 s location_id = 102 inv_period_usage = 1.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 7 2009 2:26PMlast_maintained_by = kstarks scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 1 demand_period_uid = 118 inv_mast_uid = 122477 usage_copied = N inv_period_usage_uid = 2104638 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 32 Offset 0x13f7---------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 698213F7: 008c0030 00006701 00000000 2c000100 0....g.........,69821407: 01000001 01000000 77359400 00000000 ..........5w....69821417: 00000000 00000000 00e13560 00009c9b ........`5......69821427: 00000001 00000000 00000100 00000000 ................69821437: 00010000 00000000 01000000 00000000 ................69821447: 00000000 00000001 00000000 00010100 ................69821457: 00000000 014e0000 00000001 00000000 ......N.........69821467: 00000076 0001de6e 4500f527 201d364e v...n...'..EN6. 69821477: 00000000 00000000 00000000 00000019 ................69821487: 000301c0 009a009a 666a00a1 65666c75 ..........jfulfe69821497: 72 r location_id = 103 inv_period_usage = 2.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 7 2009 1:39PMlast_maintained_by = jfulfer scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 1 demand_period_uid = 118 inv_mast_uid = 122478 usage_copied = N inv_period_usage_uid = 2104630 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 33 Offset 0x1498---------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 69821498: 008c0030 00006601 00000000 00000100 0....f..........698214A8: 00000001 01000000 77359400 00000000 ..........5w....698214B8: 00000000 00000000 00ee1538 00009c9b ........8.......698214C8: 00000001 00000000 00000100 00000000 ................698214D8: 00010000 00000000 01000000 00000000 ................698214E8: 00000000 00000001 00000000 00010100 ................698214F8: 00000000 014e0000 00000001 00000000 ......N.........69821508: 00000076 0001de6f 003f0039 201d3d4e v...o...9.?.N=. 69821518: 00000000 00000000 00000000 00000019 ................69821528: 000301c0 009a009a 736b00a1 6b726174 ..........kstark69821538: 73 s location_id = 102 inv_period_usage = 2.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 7 2009 2:26PMlast_maintained_by = kstarks scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 1 demand_period_uid = 118 inv_mast_uid = 122479 usage_copied = N inv_period_usage_uid = 2104637 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 34 Offset 0x1539---------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 69821539: 008c0030 00006b01 00000000 9a4f0000 0....k........O.69821549: 9c450103 010a0000 3b9aca00 00000000 ..E........;....69821559: 00000000 00000000 010944fc 00009ca2 .........D......69821569: 00000001 00000000 00000100 00000000 ................69821579: 00010000 00000000 01000000 00000000 ................69821589: 00000000 00000001 00000000 00000100 ................69821599: 00000000 014e0000 00000000 00000000 ......N.........698215A9: 00000076 0001de70 00a70e00 201d684e v...p.......Nh. 698215B9: 00000000 00000000 00000000 00000019 ................698215C9: 000301c0 009a009a 544200a0 656c776f ..........BTowlelocation_id = 107 inv_period_usage = 1.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 14 2009 4:05PMlast_maintained_by = BTowle scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 0 edited = N number_of_hits = 0 demand_period_uid = 118 inv_mast_uid = 122480 usage_copied = N inv_period_usage_uid = 2104680 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 35 Offset 0x15d9---------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 698215D9: 008c0030 00006b01 00000000 77650000 0....k........ew698215E9: 69646461 0174676e 3b9aca00 00000000 addingt....;....698215F9: 00000000 00000000 00d08798 00009c9c ................69821609: 00000001 00000000 00000100 00000000 ................69821619: 00010000 00000000 01000000 00000000 ................69821629: 00000000 00000001 00000000 00000100 ................69821639: 00000000 014e0000 00000000 00000000 ......N.........69821649: 00000076 0001de71 00000100 201d674e v...q.......Ng. 69821659: 00000000 00000000 00000000 00000019 ................69821669: 000301c0 009a009a 544200a0 656c776f ..........BTowlelocation_id = 107 inv_period_usage = 1.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 8 2009 12:39PMlast_maintained_by = BTowle scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 0 edited = N number_of_hits = 0 demand_period_uid = 118 inv_mast_uid = 122481 usage_copied = N inv_period_usage_uid = 2104679 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 36 Offset 0x1679---------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 69821679: 008c0030 00006b01 00000000 6e617700 0....k.......wan69821689: 002d0030 0100a711 b2d05e00 00000000 0.-......^......69821699: 00000000 00000000 00953544 00009cf4 ........D5......698216A9: 00000001 00000000 00000100 00000000 ................698216B9: 00010000 00000000 01000000 00000000 ................698216C9: 00000000 00000001 00000000 00010100 ................698216D9: 00000000 014e0000 00000000 00000000 ......N.........698216E9: 00000079 0001de71 00009c46 221dd04e y...q...F...N.."698216F9: 00000000 00000000 00000000 00000019 ................69821709: 000301c0 009a009a 746200a0 656c776f ..........btowlelocation_id = 107 inv_period_usage = 3.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Jan 4 2010 9:03AMlast_maintained_by = btowle scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 0 demand_period_uid = 121 inv_mast_uid = 122481 usage_copied = N inv_period_usage_uid = 2235856 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 37 Offset 0x1719---------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 69821719: 008c0030 00006601 00000000 00010000 0....f..........69821729: 00000000 01000000 65a0bc00 00000001 ...........e....69821739: 00000000 00000000 00d13184 00009c9c .........1......69821749: 00000001 00000000 00000100 00000000 ................69821759: 00010000 00000000 01000000 00000000 ................69821769: 00000000 00000001 00000000 00010100 ................69821779: 00000000 014e0000 00000000 00000000 ......N.........69821789: 00000076 0001de72 00410039 201dab4e v...r...9.A.N.. 69821799: 00000000 00000000 00000000 00000019 ................698217A9: 000301c0 009a009a 425200a3 41544c41 ..........RBALTA698217B9: 52415a ZARlocation_id = 102 inv_period_usage = 6.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 8 2009 12:41PMlast_maintained_by = RBALTAZAR scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 0 demand_period_uid = 118 inv_mast_uid = 122482 usage_copied = N inv_period_usage_uid = 2104747 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 38 Offset 0x17bc---------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 698217BC: 008c0030 00006b01 00000000 00009c00 0....k..........698217CC: 009bb7bf 01009c46 3b9aca00 00000000 ....F......;....698217DC: 00000000 00000000 00d08798 00009c9c ................698217EC: 00000001 00000000 00000100 00000000 ................698217FC: 00010000 00000000 01000000 00000000 ................6982180C: 00000000 00000001 00000000 00000100 ................6982181C: 00000000 014e0000 00000000 00000000 ......N.........6982182C: 00000076 0001de74 77657264 201d644e v...t...drewNd. 6982183C: 00000000 00000000 00000000 00000019 ................6982184C: 000301c0 009a009a 544200a0 656c776f ..........BTowlelocation_id = 107 inv_period_usage = 1.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 8 2009 12:39PMlast_maintained_by = BTowle scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 0 edited = N number_of_hits = 0 demand_period_uid = 118 inv_mast_uid = 122484 usage_copied = N inv_period_usage_uid = 2104676 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 39 Offset 0x185c---------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 6982185C: 008c0030 00006b01 00000000 00030000 0....k..........6982186C: 00410039 016d0049 b2d05e00 00000000 9.A.I.m..^......6982187C: 00000000 00000000 00953544 00009cf4 ........D5......6982188C: 00000001 00000000 00000100 00000000 ................6982189C: 00010000 00000000 01000000 00000000 ................698218AC: 00000000 00000001 00000000 00010100 ................698218BC: 00000000 014e0000 00000000 00000000 ......N.........698218CC: 00000079 0001de74 2c0001cd 221dd24e y...t......,N.."698218DC: 00000000 00000000 00000000 00000019 ................698218EC: 000301c0 009a009a 746200a0 656c776f ..........btowlelocation_id = 107 inv_period_usage = 3.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Jan 4 2010 9:03AMlast_maintained_by = btowle scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 0 demand_period_uid = 121 inv_mast_uid = 122484 usage_copied = N inv_period_usage_uid = 2235858 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 40 Offset 0x18fc---------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 698218FC: 008c0030 00006b01 00000000 6a616a00 0....k.......jaj6982190C: 61726171 0130616a 3b9aca00 00000000 qaraja0....;....6982191C: 00000000 00000000 00d08798 00009c9c ................6982192C: 00000001 00000000 00000100 00000000 ................6982193C: 00010000 00000000 01000000 00000000 ................6982194C: 00000000 00000001 00000000 00000100 ................6982195C: 00000000 014e0000 00000000 00000000 ......N.........6982196C: 00000076 0001de75 ef2b0000 201d654e v...u.....+.Ne. 6982197C: 00000000 00000000 00000000 00000019 ................6982198C: 000301c0 009a009a 544200a0 656c776f ..........BTowlelocation_id = 107 inv_period_usage = 1.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 8 2009 12:39PMlast_maintained_by = BTowle scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 0 edited = N number_of_hits = 0 demand_period_uid = 118 inv_mast_uid = 122485 usage_copied = N inv_period_usage_uid = 2104677 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 41 Offset 0x199c---------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 6982199C: 008c0030 00006b01 00000000 0001cd00 0....k..........698219AC: 0000012c 01000001 b2d05e00 00000000 ,........^......698219BC: 00000000 00000000 00953544 00009cf4 ........D5......698219CC: 00000001 00000000 00000100 00000000 ................698219DC: 00010000 00000000 01000000 00000000 ................698219EC: 00000000 00000001 00000000 00010100 ................698219FC: 00000000 014e0000 00000000 00000000 ......N.........69821A0C: 00000079 0001de75 000a0000 221dd14e y...u.......N.."69821A1C: 00000000 00000000 00000000 00000019 ................69821A2C: 000301c0 009a009a 746200a0 656c776f ..........btowlelocation_id = 107 inv_period_usage = 3.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Jan 4 2010 9:03AMlast_maintained_by = btowle scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 0 demand_period_uid = 121 inv_mast_uid = 122485 usage_copied = N inv_period_usage_uid = 2235857 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 42 Offset 0x1a3c---------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 69821A3C: 008c0030 00006901 00000000 0002c000 0....i..........69821A4C: b1eec800 019c4600 77359400 00000000 .....F....5w....69821A5C: 00000000 00000000 0118beea 00009c9b ................69821A6C: 00000001 00000000 00000100 00000000 ................69821A7C: 00010000 00000000 01000000 00000000 ................69821A8C: 00000000 00000001 00000000 00010100 ................69821A9C: 00000000 014e0000 00000001 00000000 ......N.........69821AAC: 00000076 0001de76 64726369 201d5b4e v...v...icrdN[. 69821ABC: 00000000 00000000 00000000 00000019 ................69821ACC: 000301c0 009a009a 686d00a0 6c65646f ..........mhodellocation_id = 105 inv_period_usage = 2.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 7 2009 5:02PMlast_maintained_by = mhodel scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 1 demand_period_uid = 118 inv_mast_uid = 122486 usage_copied = N inv_period_usage_uid = 2104667 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 43 Offset 0x1adc---------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 69821ADC: 008c0030 00006601 00000000 0a000000 0....f..........69821AEC: 03000000 01003900 3b9aca00 00000000 .....9.....;....69821AFC: 00000000 00000000 008fd900 00009c9c ................69821B0C: 00000001 00000000 00000100 00000000 ................69821B1C: 00010000 00000000 01000000 00000000 ................69821B2C: 00000000 00000001 00000000 00010100 ................69821B3C: 00000000 014e0000 00000000 00000000 ......N.........69821B4C: 00000076 0001de77 cd5f0000 201d6b4e v...w....._.Nk. 69821B5C: 00000000 00000000 00000000 00000019 ................69821B6C: 000301c0 009a009a 6c6a00a1 7465766f ..........jlovet69821B7C: 74 t location_id = 102 inv_period_usage = 1.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 8 2009 8:43AMlast_maintained_by = jlovett scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 0 demand_period_uid = 118 inv_mast_uid = 122487 usage_copied = N inv_period_usage_uid = 2104683 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 44 Offset 0x1b7d---------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 69821B7D: 008c0030 00006601 00000000 6e696d00 0....f.......min69821B8D: 64726369 01696d6f 77359400 00000000 icrdomi...5w....69821B9D: 00000000 00000000 00ade530 00009cca ........0.......69821BAD: 00000001 00000000 00000100 00000000 ................69821BBD: 00010000 00000000 01000000 00000000 ................69821BCD: 00000000 00000001 00000000 00010100 ................69821BDD: 00000000 014e0000 00000000 00000000 ......N.........69821BED: 00000077 0001de77 00000100 20cd934e w...w.......N.. 69821BFD: 00000000 00000000 00000000 00000019 ................69821C0D: 000301c0 009a009a 6c6a00a1 7465766f ..........jlovet69821C1D: 74 t location_id = 102 inv_period_usage = 2.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Nov 23 2009 10:33AMlast_maintained_by = jlovett scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 0 demand_period_uid = 119 inv_mast_uid = 122487 usage_copied = N inv_period_usage_uid = 2149779 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] Slot 45 Offset 0x1c1e---------------------Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS 69821C1E: 008c0030 00006701 00000000 30534b00 0....g.......KS069821C2E: 25002d00 010000a7 3b9aca00 00000000 .-.%.......;....69821C3E: 00000000 00000000 00e7ea8e 00009c9b ................69821C4E: 00000001 00000000 00000100 00000000 ................69821C5E: 00010000 00000000 01000000 00000000 ................69821C6E: 00000000 00000001 00000000 00010100 ................69821C7E: 00000000 014e0000 00000001 00000000 ......N.........69821C8E: 00000076 0001de78 b9988000 201d384e v...x.......N8. 69821C9E: 00000000 00000000 00000000 00000019 ................69821CAE: 000301c0 009a009a 666a00a1 65666c75 ..........jfulfe69821CBE: 72 r location_id = 103 inv_period_usage = 1.000000000 date_created = Jan 1 1900 12:00AMdate_last_modified = Oct 7 2009 2:04PMlast_maintained_by = jfulfer scheduled_usage = 0.000000000 forecast_usage = 0.000000000 forecast_deviation_percentage = 0.00000000 mad_percentage = 0.00000000 filtered_usage = 0.000000000 number_of_orders = 1 edited = N number_of_hits = 1 demand_period_uid = 118 inv_mast_uid = 122488 usage_copied = N inv_period_usage_uid = 2104632 mean_absolute_percent_error = [NULL] exceptional_sales_flag = [NULL] exceptional_deviation_flag = [NULL] DBCC execution completed. If DBCC printed error messages, contact your system administrator.Sat, 23 Jan 2010 14:25:41 GMTZivio!http://www.sqlservercentral.com/Forums/Topic852552-265-1.aspx[code="sql"]SELECT @@version [/code]?Sat, 23 Jan 2010 14:21:46 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic852552-265-1.aspxAlthough this says index ID = 0, this isn't a heap - it's a clustered index. Depending on the way the indexes were built in 2000, and the way CHECKDB interpreted the metadata, it may report index 0 or index 1 for a clustered index.Do you know what happened to the database between 1/9 and 1/10? IO subsystem problem?Can you post the full set of current errors that can't be repaired? Are you able to do a DBCC PAGE dump of those records to see which keys are out of order?DBCC TRACEON 3604)GODBCC PAGE ('p21-live', 1,549057, 3)GOThere have been several parallel index rebuild bugs in 2000 that can account for sort order errors - you might be hitting one of those.Thanks!Sat, 23 Jan 2010 13:48:30 GMTPaul Randalhttp://www.sqlservercentral.com/Forums/Topic852552-265-1.aspxCHECKDB on my 1/18/2010 version of database found 0 allocation errors and 13 consistency errors in database 'p21-livevm' with repair_allow_data_loss as minimum suggested repair.Restored back to 1/10/2010 and CHECKDB now found 0 allocation, 2 consistency errors still with repair_allow_data_loss as minimum suggested repair.Restored back to 1/9/2010 and CHECKDB came up clean.Restored nonoperational from 1/9/2010 database and began applying transaction log backups up to 1/22/2010 6:00 AM which is where I’m now at. CHECKDB now shows 0 allocation, 1 consistency error with repair_rebuild as minimum suggested repair level. Running repair_rebuild didn’t fix.Can this be resolved?Here are results of DBCC CHECKDB (“p21-live”) WITH NO_INFOMSGS, ALL_ERRORMSGS:Server: Msg 2511, Level 16, State 2, Line 1Table error: Object ID 318624178, Index ID 0. Keys out of order on page (1:549057), slots 23 and 24.CHECKDB found 0 allocation errors and 1 consistency errors in table 'inv_period_usage' (object ID 318624178).CHECKDB found 0 allocation errors and 1 consistency errors in database 'p21-live'.repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (p21-live ).Sat, 23 Jan 2010 09:32:37 GMTZivio!