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
- 262 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
Problem with scheduling reports in NAV 2017
lzr
Member Posts: 264
We have an issue where users are able to schedule reports without any error but nothing is executed. Everything looks correctly in the job queue entry but the job is never run and is just stuck in the Job queue entry. Any idea about where to look for errors?
Navision developer
0
Best Answers
-
Options
Slawek_Guzek
Member Posts: 1,690
Check in the NST configuration if Task Scheduler (NAV 2017 only) or NAS services are enabled, and configured.
You may need to add the account used to run the NST as a user to the database and configure its permissions. Look into Application Event Log on the box where the NST service is run, you may see access errors logged there.
SlawekSlawek Guzek
Dynamics NAV, MS SQL Server, Wherescape RED;
PRINCE2 Practitioner - License GR657010572SG
GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-035 -
Options
SilverX
Member Posts: 134
It looks like this was fixed in CU11: https://support.microsoft.com/de-de/help/4045671/cumulative-update-11-for-microsoft-dynamics-nav-2017-build-18609Cheers
Carsten
==> How To Ask Questions The Smart Way
This post is my own opinion and does not necessarily reflect the opinion or view of my employer.5
Answers
You may need to add the account used to run the NST as a user to the database and configure its permissions. Look into Application Event Log on the box where the NST service is run, you may see access errors logged there.
Slawek
Dynamics NAV, MS SQL Server, Wherescape RED;
PRINCE2 Practitioner - License GR657010572SG
GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
I have found it. Seems to be a bug in NAV 2017. All our users belong to AD groups which are setup with different roles. All users are setup empty in the Users table and get all permissions from the groups they belong to.
In order to get the reports executed I need to add the same roles to the specific user. Not very convenient but then not that many users will schedule their reports.
Carsten
==> How To Ask Questions The Smart Way
This post is my own opinion and does not necessarily reflect the opinion or view of my employer.