Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 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
Options
Job Queue Category Locked error when running JobQueuePosting
jordi79
Member Posts: 272
Hi,
Do any one of you face any errors with Scheduled Tasks/Job Queues/JobQueueSalesPosting? This is on NAV2017 CU29.
The error is -->
The operation could not complete because a record in the Job Queue Category table was locked by another user. Please retry the activity.
This error is traced to Codeunit 448.
I have even tried LOCKTABLE(TRUE) to wait for the record to be unlocked, but I still get this error.
Jordi
Do any one of you face any errors with Scheduled Tasks/Job Queues/JobQueueSalesPosting? This is on NAV2017 CU29.
The error is -->
The operation could not complete because a record in the Job Queue Category table was locked by another user. Please retry the activity.
This error is traced to Codeunit 448.
LOCAL WaitForOthersWithSameCategory(VAR JobQueueEntry : Record "Job Queue Entry") : Boolean IF JobQueueEntry."Job Queue Category Code" = '' THEN EXIT(FALSE); // Use the Job Queue Category as a semaphore so only one checks at the time. [b]JobQueueCategory.LOCKTABLE;[/b] IF NOT JobQueueCategory.GET(JobQueueEntry."Job Queue Category Code") THEN EXIT(FALSE);
I have even tried LOCKTABLE(TRUE) to wait for the record to be unlocked, but I still get this error.
Jordi
0
Answers
Hi gcysiak,
I solved this a long time ago. But, I upgraded to the latest CU, and this solved the issue. Please review the documentation of released cumulative updates for your Dynamics NAV version. And you should see one of the CUs having solved the issue with JobQueueCategory locking.
Jordi