Post Inventory Cost to GL more than 19hours and still run

sadana

Hi All,

Up to now, seem the vendor never successful when running batch job Post Inventory Cost to GL on our environment. They run from User PC with RTC version.
Could you please take a look on my information below and give me some help?
Thanks so much,

Our server spec:
MS SQL Database Primary Server
IBM BladeCenter HS22
CPU: 2*Xeon 4C X5570 95W 2.93GHz/1333MHz/8MB L2
RAM: 2*2GB + 4*8GB = 36GB
HDD: 2*146 GB 2.5in SFF Slim-HS 15K 6Gbps SAS
Windows Server 2008 R2 Enterprise Edition x64
SQL Server 2008 R2 Enterprise Edition x64
And MS Dynamic NAV Primary Server have same spec as SQL Server.

Some statistic from tables in NAV (data of Feb 2011 only) - Get from SQL Server report Disk Usage by Top Tables:
Table Name # Records Reserved (KB) Data (KB) Indexes (KB) Unused (KB)
dbo.DB$Ledger Entry Dimension 13,168,170 1,368,032 764,976 602,640 416
dbo.DB$G_L Entry 622,529 1,234,800 345,128 888,408 1,264
dbo.DB$Posted Document Dimension 5,873,900 833,888 438,512 395,160 216
dbo.DB$Value Entry 271,653 732,008 234,512 492,448 5,048
dbo.DB$Item Ledger Entry 244,339 668,480 156,696 509,304 2,480
dbo.DB$Warehouse Entry 268,055 295,120 94,656 199,544 920
dbo.DB$Sales Invoice Line 168,068 192,320 124,312 67,728 280
dbo.DB$VAT Entry 178,856 177,488 102,888 74,224 376
dbo.DB$Sales Shipment Line 168,069 175,520 123,400 51,912 208
dbo.DB$Detailed Cust_ Ledg_ Entry 192,767 161,552 65,592 95,528 432
dbo.DB$Cust_ Ledger Entry 103,633 158,512 75,192 82,688 632
dbo.DB$Item Application Entry 255,117 88,224 29,016 58,952 256
dbo.DB$Bank Account Ledger Entry 61,183 63,312 28,816 34,352 144
dbo.DB$Sales Invoice Header 51,942 62,448 39,032 23,224 192
dbo.DB$Sales Shipment Header 51,943 57,680 39,424 18,064 192
dbo.DB$Item 24,092 48,880 28,096 17,824 2,960
dbo.DB$FA Ledger Entry 27,350 41,168 14,760 25,264 1,144
dbo.Object 7,283 40,608 39,480 624 504
dbo.Object Metadata 4,436 36,384 34,048 24 2,312
dbo.DB$Post Value Entry to G_L 8,109 29,856 14,712 15,072 72

Some of configuration information not match with expert suggestion here is:
- RAID: 5
- DB LOG file not on dedicate Physical Disk

All Transaction report from SQL Server:
State # Transactions
Active 1
Session ID Host Name Program Name Login Name Login Time Host Process ID
62 USER Microsoft Dynamics NAV RTC XUSER 3/18/2011 11:58:37 AM 4468
Transaction ID Transaction Name # Total Locks Transaction Type Transaction Start Time Isolation Level
959167909* implicit_transaction 470,219 Full Transaction 3/18/2011 11:59:45 AM Unknown
Resource Name
DB$G_L Entry
Lock Type Request Mode # Locks Granted # Locking Requests Waiting
KEY Unknown Locking Request Mode 2 0
PAGE Intent Update 1 0
DB$Post Value Entry to G_L
Lock Type Request Mode # Locks Granted # Locking Requests Waiting
KEY Unknown Locking Request Mode 8,110 0
KEY Unknown Locking Request Mode 229,203 0
KEY Update 52 0
KEY Exclusive 229,203 0
PAGE Intent Update 55 0
PAGE Intent Exclusive 3,589 0
Other resources
Lock Type Request Mode # Locks Granted # Locking Requests Waiting
METADATA Schema stability 1 0
OBJECT Intent Exclusive 2 0
OBJECT Exclusive 1 0

violeta

Maybe you have different kind of problem. Check status box while running this batch job. Does it stop on one item and stays on it for more than 5 minutes. If does, then check what is wrong with cost calculation on that item. If, for some reason, cost can't be calculated for some items, your batch job will never finish

If this is your case I can help you

kine

And check the PPartnerSource article about never-ending loops in the adj. cost batch and possible solutions. THere are some hotfixes for different kind of problem and NAV versions.

sadana

Thanks you all,

We asked our vendor change to use Classic for doing Post Inventory Cost to GL and its took 6hours and 30minutes to finish.
Then we decided to use Classic version for running batch-job, and RTC just for user to input data.

Cheers,