Scheduled Reports crash Job Queue (BC14 on Prem)

rkaufmann
rkaufmann Member Posts: 71
in NAV Three Tier
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

Answers

  • KTA8
    KTA8 Member Posts: 399
    When you mean it's crashes, the status of the job return fails and prompts and error or what?
  • rkaufmann
    rkaufmann Member Posts: 71
    No, the job stays in the state "running" forever and der Service processes no other job. The service uses the default value for 10 simultanious jobs.

Categories