January 23, 2010 at 9:32 am
CHECKDB 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 1
Table 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 ).
January 23, 2010 at 1:48 pm
Although 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)
GO
DBCC PAGE ('p21-live', 1,549057, 3)
GO
There have been several parallel index rebuild bugs in 2000 that can account for sort order errors - you might be hitting one of those.
Thanks!
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
January 23, 2010 at 2:21 pm
SELECT @@version
?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 23, 2010 at 2:25 pm
Hi 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 = 0x9
bspin = 0 bnext = 0x00000000
PAGE HEADER:
------------
Page @0x69820000
----------------
m_pageId = (1:549057) m_headerVersion = 1 m_type = 1
m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x0
m_objId = 318624178 m_indexId = 0 m_prevPage = (1:549056)
m_nextPage = (1:549058) pminlen = 140 m_slotCnt = 46
m_freeCnt = 582 m_freeData = 7673 m_reservedCnt = 0
m_lsn = (464155:27341:215) m_xactReserved = 0
m_xdesId = (0:0) m_ghostRecCnt = 0 m_tornBits = 0
Allocation 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 ..........ljunea
69820100: 75 u
location_id = 106
inv_period_usage = 0.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Jan 11 2010 4:54PM
last_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 ..........ewaddi
698201A1: 6f74676e 6e ngton
location_id = 104
inv_period_usage = 1.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 7 2009 9:53AM
last_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.......ja0
698201B6: 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 ..........mandre
69820246: 7377 ws
location_id = 102
inv_period_usage = 1.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 7 2009 9:58AM
last_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 ..........ACORTE
698202E8: 53 S
location_id = 103
inv_period_usage = 1.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 7 2009 10:05AM
last_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 ..........rdomin
69820389: 6369 ic
location_id = 101
inv_period_usage = 1.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 7 2009 10:06AM
last_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 ..........BTowle
location_id = 102
inv_period_usage = 10.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 8 2009 10:46AM
last_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 ..........rdomin
698204CB: 6369 ic
location_id = 101
inv_period_usage = 1.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 7 2009 10:32AM
last_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.......ini
698204DD: 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 ..........rdomin
6982056D: 6369 ic
location_id = 101
inv_period_usage = 1.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 7 2009 10:32AM
last_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 ..........ZJOHNS
6982060F: 4e4f ON
location_id = 103
inv_period_usage = 1.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 7 2009 10:46AM
last_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 ..........rdomin
698206B1: 6369 ic
location_id = 101
inv_period_usage = 1.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 7 2009 11:04AM
last_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 ..........rdomin
69820753: 6369 ic
location_id = 101
inv_period_usage = 1.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 7 2009 11:04AM
last_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.......ful
69820765: 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 ..........SBRIZE
698207F5: 4e49444e 45 NDINE
location_id = 104
inv_period_usage = 1.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 7 2009 11:13AM
last_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 ..........ZJOHNS
6982089A: 4e4f ON
location_id = 103
inv_period_usage = 1.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 7 2009 11:18AM
last_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 ..........ZJOHNS
6982093C: 4e4f ON
location_id = 103
inv_period_usage = 1.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 7 2009 11:18AM
last_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 ..........RBALTA
698209DE: 52415a ZAR
location_id = 102
inv_period_usage = 0.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 7 2009 12:39PM
last_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.......?.E
698209F1: 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 ..........mandre
69820A81: 7377 ws
location_id = 102
inv_period_usage = 1.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 7 2009 11:42AM
last_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 ..........BTowle
location_id = 102
inv_period_usage = 2.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 12 2009 9:10AM
last_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 ..........mandre
69820BC3: 7377 ws
location_id = 102
inv_period_usage = 1.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 7 2009 11:42AM
last_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 ..........jqaraj
69820C65: 61 a
location_id = 105
inv_period_usage = 1.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 7 2009 11:35AM
last_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.r
69820C76: 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 ..........mandre
69820D06: 7377 ws
location_id = 102
inv_period_usage = 1.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 7 2009 11:42AM
last_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 ..........jfoust
location_id = 104
inv_period_usage = 1.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 7 2009 11:43AM
last_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 ..........BTowle
location_id = 107
inv_period_usage = 1.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 13 2009 10:31AM
last_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 ..........jqaraj
69820EE8: 61 a
location_id = 105
inv_period_usage = 0.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 7 2009 12:33PM
last_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.......fer
69820EF9: 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 ..........jqaraj
69820F89: 61 a
location_id = 105
inv_period_usage = 1.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 7 2009 12:33PM
last_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........Kg
69821D6A: 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 ..........peppi
location_id = 106
inv_period_usage = 0.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Jan 18 2010 11:57AM
last_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 ..........ewaddi
6982102A: 6f74676e 6e ngton
location_id = 104
inv_period_usage = 1.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 7 2009 12:33PM
last_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 ..........mhodel
location_id = 105
inv_period_usage = 1.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 7 2009 12:38PM
last_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 ..........mhodel
location_id = 105
inv_period_usage = 1.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 7 2009 12:38PM
last_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.......ton
6982117F: 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 ..........RBALTA
6982120F: 52415a ZAR
location_id = 102
inv_period_usage = 1.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 8 2009 12:41PM
last_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 ..........RBALTA
698212B2: 52415a ZAR
location_id = 102
inv_period_usage = 1.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 8 2009 12:41PM
last_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.........E
698212C5: 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 ..........lraswa
69821355: 6e n
location_id = 101
inv_period_usage = 1.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 7 2009 1:31PM
last_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.......ras
69821366: 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 ..........kstark
698213F6: 73 s
location_id = 102
inv_period_usage = 1.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 7 2009 2:26PM
last_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 ..........jfulfe
69821497: 72 r
location_id = 103
inv_period_usage = 2.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 7 2009 1:39PM
last_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 ..........kstark
69821538: 73 s
location_id = 102
inv_period_usage = 2.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 7 2009 2:26PM
last_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 ..........BTowle
location_id = 107
inv_period_usage = 1.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 14 2009 4:05PM
last_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........ew
698215E9: 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 ..........BTowle
location_id = 107
inv_period_usage = 1.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 8 2009 12:39PM
last_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.......wan
69821689: 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 ..........btowle
location_id = 107
inv_period_usage = 3.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Jan 4 2010 9:03AM
last_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 ..........RBALTA
698217B9: 52415a ZAR
location_id = 102
inv_period_usage = 6.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 8 2009 12:41PM
last_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 ..........BTowle
location_id = 107
inv_period_usage = 1.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 8 2009 12:39PM
last_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 ..........btowle
location_id = 107
inv_period_usage = 3.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Jan 4 2010 9:03AM
last_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.......jaj
6982190C: 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 ..........BTowle
location_id = 107
inv_period_usage = 1.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 8 2009 12:39PM
last_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 ..........btowle
location_id = 107
inv_period_usage = 3.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Jan 4 2010 9:03AM
last_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 ..........mhodel
location_id = 105
inv_period_usage = 2.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 7 2009 5:02PM
last_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 ..........jlovet
69821B7C: 74 t
location_id = 102
inv_period_usage = 1.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 8 2009 8:43AM
last_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.......min
69821B8D: 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 ..........jlovet
69821C1D: 74 t
location_id = 102
inv_period_usage = 2.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Nov 23 2009 10:33AM
last_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.......KS0
69821C2E: 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 ..........jfulfe
69821CBE: 72 r
location_id = 103
inv_period_usage = 1.000000000
date_created = Jan 1 1900 12:00AM
date_last_modified = Oct 7 2009 2:04PM
last_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.
January 23, 2010 at 2:26 pm
Definitely 2000. from the CHECKDB error messages.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
January 23, 2010 at 2:28 pm
@ 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 ...
January 23, 2010 at 2:30 pm
BTW, 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.
January 23, 2010 at 2:34 pm
Yup - 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)
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
January 23, 2010 at 2:57 pm
Column NameData Type
date_createddatetime
date_last_modifieddatetime
demand_period_uidint
editedchar(1)
exceptional_deviation_flagchar(1)
exceptional_sales_flagchar(1)
filtered_usagedecimal(19,9)
forecast_deviation_percentagedecimal(19,4)
forecast_usagedecimal(19,9)
inv_mast_uidint
inv_period_usagedecimal(19,9)
inv_period_usage_uidint
last_maintained_byvarchar(30)
location_iddecimal(19,0)
mad_percentagedecimal(19,4)
mean_absolute_percent_errordecimal(19,4)
number_of_hitsdecimal(19,0)
number_of_ordersdecimal(19,0)
scheduled_usagedecimal(19,9)
usage_copiedchar(1)
FOREIGN KEYfk_inv_period_usage_dem_perioddemand_period_uid
FOREIGN KEYfk_inv_period_usage_inv_loclocation_id, inv_mast_uid
FOREIGN KEYfk_inv_period_usage_inv_mastinv_mast_uid
PRIMARY KEY (non-clustered)pk_inv_period_usageinv_period_usage_uid
January 23, 2010 at 3:44 pm
Paul Randal (1/23/2010)
Definitely 2000. from the CHECKDB error messages.
I know. Wanted to know the flavour (patch/hotfix level)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 23, 2010 at 3:52 pm
So, 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?
January 24, 2010 at 10:16 am
It 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?
Thanks
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
January 24, 2010 at 10:42 am
Hi Paul, very happy to hear from you again!
inv_period_usage_uid = primary key for the table
I 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 1
Table 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 ).
January 24, 2010 at 10:45 am
Full DBCC CHECKDB results are attached ...
January 24, 2010 at 10:56 am
Paul Randal (1/24/2010)
... From the list of columns you posted, which are the index keys? ...
Is this what you're looking for? ...
PRIMARY KEY (non-clustered) pk_inv_period_usage ... inv_period_usage_uid
FOREIGN KEY fk_inv_period_usage_dem_period ---> demand_period_uid
FOREIGN KEY fk_inv_period_usage_inv_loc location_id ---> inv_mast_uid
FOREIGN KEY fk_inv_period_usage_inv_mast ---> inv_mast_uid
Viewing 15 posts - 1 through 15 (of 28 total)
You must be logged in to reply to this topic. Login to reply