27
Dec2012
NAV Job Queue says “In Process” but job has crashed
by Steve
in Technical
If the job encounters an error the Job Queue Entries page will continue to say the job is "In Process". In fact ist not and it will never run again until the job is reset.
If you are running NAV 2009SP1 or NAV2009R2 then apply the following code change to Code Unit 448 - Job Queue Dispactcher.
The change is made in the Handle Request trigger
Replace code
WasSuccess := CODEUNIT.RUN(CODEUNIT::"Job Queue Start Codeunit",JobQueueEntry);
IF WasSuccess THEN BEGIN
IF JobQueueEntry."Recurring Job" THEN BEGIN
JobQueueEntry."No. of Attempts to Run" := 0;
JobQueueEntry.Status := JobQueueEntry.Status::Ready;
IF NOT JobQueueEntry.MODIFY THEN
JobQueueEntry.INSERT;
END;
END
ELSE BEGIN
IF JobQueueEntry."Maximum No. of Attempts to Run" > JobQueueEntry."No. of Attempts to Run" THEN BEGIN
JobQueueEntry."No. of Attempts to Run" := JobQueueEntry."No. of Attempts to Run" + 1;
JobQueueEntry.Status := JobQueueEntry.Status::Ready;
IF NOT JobQueueEntry.INSERT THEN
JobQueueEntry.MODIFY;
END;
END;
With this code
WasSuccess := CODEUNIT.RUN(CODEUNIT::"Job Queue Start Codeunit",JobQueueEntry);
IF WasSuccess THEN BEGIN
IF JobQueueEntry."Recurring Job" THEN BEGIN
JobQueueEntry."No. of Attempts to Run" := 0;
JobQueueEntry.Status := JobQueueEntry.Status::Ready;
IF NOT JobQueueEntry.MODIFY THEN
JobQueueEntry.INSERT;
END;
END
ELSE BEGIN
IF JobQueueEntry."Maximum No. of Attempts to Run" > JobQueueEntry."No. of Attempts to Run" THEN BEGIN
JobQueueEntry."No. of Attempts to Run" := JobQueueEntry."No. of Attempts to Run" + 1;
JobQueueEntry.Status := JobQueueEntry.Status::Ready
// Add the following lines.
END
ELSE
JobQueueEntry.Status := JobQueueEntry.Status::Error;
// End of the added lines.
IF NOT JobQueueEntry.INSERT THEN
JobQueueEntry.MODIFY;
END;
It does not fix your error but at least the job will continue to run.
For more detail see:
Categories
Recent Posts
Archives
- 2019
- 2015
- 2014
- 2013
- December
- November
- October
- Downsizing Dangers - 28th October 2013
- Dynamics NAV NAS/Job Queue - Excel SaveAs method failed - 18th October 2013
- New in XLCubed 7.5 - 16th October 2013
- How to suspend and resume SQL database mirroring - 15th October 2013
- XLCubed: Excel Dashboards - 11th October 2013
- Analytical Applications of Business Intelligence Reporting - 10th October 2013
- What is Microcharts? How can it clarify data? - 10th October 2013
- Can’t print from XLCubed Web Edition - 2nd October 2013
- September
- June
- February
- January
- 2012
- 2011
- November
- August
- July
- May
- A call to SSPI failed in NAV 2009 R2 - 31st May 2011
- Can’t send BizTalk documents from NAV2009 Role Tailored Client - 23rd May 2011
- Unique External Document No. on Sales Order - 23rd May 2011
- CRM 2011 – NAV 2009 R2 Synchronisation – tips and tricks - 10th May 2011
- Manually Create NAV Service Instances - 3rd May 2011
- April
- March
- February
- January
- 2010
- December
- November
- SQL Maintenance plan won't run, modify or delete - 24th November 2010
- Miscellaneous NAV RTC Development Tips - 21st November 2010
- NAV RTC Development training tools - 18th November 2010
- Microsoft Dynamics NAV Application Objects - 15th November 2010
- Delete a rogue Conur Expense Report - 12th November 2010
- CRM - 9th November 2010
- October
- September
- February
Tags
- 2009
- 64bit
- antivirus
- application objects
- BI
- BizTalk
- blocking
- Business
- Business Intelligence
- c#
- C#
- cached password
- calculation
- CGRS
- Cloud
- Commerce Gateway
- concur
- CRM 2011
- CRM 2013
- Crystal Reports
- csv
- Data Type
- date and time
- deadlock
- delete
- DotNet
- Downsizing
- Dynamics
- Dynamics NAV
- EDI
- ERP
- Excel Buffer
- External Document No.
- Generate xsd from SQL table
- impersonation
- Jigsaw
- Job Queue
- MDX
- Microsoft Excel
- NAS
- NAV
- NAV 2009
- NAV 2009 R2
- NAV Application Server
- NAV Development
- NAV Upgrade
- NAV2009
- NAV2013R2
- NAV2015
- Navision
- new version
- no delimiter
- NST
- OLAP
- Permissions
- printing
- regsvr32
- right-click
- security
- Security
- service broker
- SMTP
- SQL
- SSPI
- SSRS
- sync
- synchronisation
- umbraco
- upgrade
- User Setup
- Web Service
- xlcubed
- xmlport
- xp_ndo
- xp_ndo_enumusergroups
- xp_ndo_enumuserids