Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 298 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Adjust Cost - "randomly occurring" error
bbrown
Member Posts: 3,268
We are having a random failure of Adjust Cost. I'm putting out this inquiry to see if anyone has run into this or has advice on tracking down a solution. The process will fail with an error like this:
The item/lot will vary but the basic message is the same.
The item is always a manufactured item.
Run Adjust Cost again and it will work just fine. Error is occurring very randomly. It has occurred 5 times in the past 35 days. First two were 2 days apart. The third was 6 days later. The fourth was 13 days after that. And the last was 14 days after that.
Needless to say, I've had no luck in trapping this with debug. Besides debug adds to the processng time which creates other issues with scheduling.
It is not uncommion to have some inventory activity occuring while Adjust Cost is running. I believe that is the heart of the problem. As this never seems to occur when Adjust Cost is run during downtime. My thought is this is happening someplace during the "prod order" cost updating. I'm usully able to find an outbound transaction that matches the negative qty. in the message. But usually don't find and inbound one that matches the positive qty.
Adjust Cost is run daily as a scheduled process under Job Queue.
The system is a NAV 5.0 SP1 database using NAV 2009 SP1 clients (Build 30609) on SQL 2008 (4279)
Any thoughts/ideas are appreciated.
Qty. to Handle (Base) in Tracking Specification for Item No. ABCD, Serial No.: , Lot No.: 1234 is currently -81. It must be 60.
The item/lot will vary but the basic message is the same.
The item is always a manufactured item.
Run Adjust Cost again and it will work just fine. Error is occurring very randomly. It has occurred 5 times in the past 35 days. First two were 2 days apart. The third was 6 days later. The fourth was 13 days after that. And the last was 14 days after that.
Needless to say, I've had no luck in trapping this with debug. Besides debug adds to the processng time which creates other issues with scheduling.
It is not uncommion to have some inventory activity occuring while Adjust Cost is running. I believe that is the heart of the problem. As this never seems to occur when Adjust Cost is run during downtime. My thought is this is happening someplace during the "prod order" cost updating. I'm usully able to find an outbound transaction that matches the negative qty. in the message. But usually don't find and inbound one that matches the positive qty.
Adjust Cost is run daily as a scheduled process under Job Queue.
The system is a NAV 5.0 SP1 database using NAV 2009 SP1 clients (Build 30609) on SQL 2008 (4279)
Any thoughts/ideas are appreciated.
There are no bugs - only undocumented features.
0
Comments
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
many thanks,
katie
Nav, T-SQL.