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
- 266 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 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
Scheduled Reports crash Job Queue (BC14 on Prem)
rkaufmann
Member Posts: 71
Hello,
I have a problem with BC14 on Prem and scheduling Reports.
Scheduling reports via the task queue works in principle.
However, there are always problems when the reports processes large amounts of data and produce many pages.
For example, we have an invoice journal that lists all posted invoice headers with invoice lines for a selected posting date and then calculates some additional information.
Several hundred headers and a few thousand items are read for one day. If you were to print this on paper, you would end up with between 300 and 400 pages.
If I run the report interactively, whether as a print preview or with the option to create a PDF, it runs for about 1 minute and then shows me the preview or the PDF. If I schedule it and I want it to create a PDF, it crashes the service that is processing the job queue.
Does anyone know that the job queue processing has problems with such reports?
Greetings Rolf
I have a problem with BC14 on Prem and scheduling Reports.
Scheduling reports via the task queue works in principle.
However, there are always problems when the reports processes large amounts of data and produce many pages.
For example, we have an invoice journal that lists all posted invoice headers with invoice lines for a selected posting date and then calculates some additional information.
Several hundred headers and a few thousand items are read for one day. If you were to print this on paper, you would end up with between 300 and 400 pages.
If I run the report interactively, whether as a print preview or with the option to create a PDF, it runs for about 1 minute and then shows me the preview or the PDF. If I schedule it and I want it to create a PDF, it crashes the service that is processing the job queue.
Does anyone know that the job queue processing has problems with such reports?
Greetings Rolf
0
Answers