Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K 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
- 305 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Scheduled report run on job queue goes on error with no detail in windows logs
Kisu
Member Posts: 381
I've stumbled upon an error where I try to run Status by product groups -report scheduled.
Job Queue is working and the Task triggers, but within few minutes it goes on Error.
Error message just says "The user process has terminated unexpectedly. Check the Windows Event Viewer for more information.."
But on the Event Viewer, it only says the Status must be In process and the current value is Error..
Well the Status was ready and it went In process when it triggered and after that it went Error so, the Event Viewer message is quite pointless o.O???
I tried to print same report in pdf manually, it takes around 15mins but it does that no problem. Also normal printout works too.
I'm a bit stuck why it does this. There is 3 reports that do the same error, all reports are a bit long to be printed through out the day.
Job Queue is working and the Task triggers, but within few minutes it goes on Error.
Error message just says "The user process has terminated unexpectedly. Check the Windows Event Viewer for more information.."
But on the Event Viewer, it only says the Status must be In process and the current value is Error..
Well the Status was ready and it went In process when it triggered and after that it went Error so, the Event Viewer message is quite pointless o.O???
I tried to print same report in pdf manually, it takes around 15mins but it does that no problem. Also normal printout works too.
I'm a bit stuck why it does this. There is 3 reports that do the same error, all reports are a bit long to be printed through out the day.
K.S.
0
Answers
im just working on the same issue @tm.
Here some Links for you:
https://community.dynamics.com/nav/f/34/t/186619
dynamicsnavconsultant.com/2014/04/restarting-job-queue-hits-error-dynamics-nav-2013/
Maybe it will help you.
I figured out, that the Problem is caused by the Locktables which are made by the Job Queue. So when Job is finished, it has to be deleted. Caused by the Locktable, the Dispatcher is not able to delete the Job Queue Entry. So the Job will recurre every time till it can be deleted.
A nice feature is also, when the Job is "Finished" but the Job Queue cant delete it and you will restart your RTC the Job will restart and you get your report again in your Report Inbox.