[Oliver Leslie]

Good morning!

We have a Report in NAV 2013 R2 which calls the Inventory to G/L Reconcile report (10138) to run in the background, then email the results to user as a PDF sent by SMTP in NAV:

We are having an issue where – depending on the date range provided to the report – the report does not complete. In turn, this leaves a hanging NAV user session which can only be killed by deleting from the Active Session table, and leaves a file handle open to the PDF it attempted to create on the service tier machine. The only way to release the open file and try the report again, is to restart the NAV service.

Is there a limit to how much data the REPORT.SAVEASPDF command can handle? The other possibility I am considering is a piece of bad data somewhere in the result set.

The steps the report goes through every time seem reliable to measure:

> NAV begins running the report and processes for around 8 minutes (Screenshot 1, attached)
> After 8 minutes, a PDF file is created in the specified folder on the service tier (Screenshot 2, attached) and begins writing (Screenshot 3, attached)
> After a further 4 minutes from the date/timestamp of the file on the server, the process will either complete or fail
> If completes successfully, CPU activity drops off, the PDF file is closed, and the size updates from 0 KB to, say, 900 KB (Screenshot 4, attached)
> If it fails, the file remains open, file size 0 KB, and the CPU and memory beginning ‘bobbing’ up and down – this will continue until the server is restarted (Screenshots 4 & 5, attached)

Any advice would be greatly appreciated – thank you!

Olly

——————————
Oliver Leslie
HOLLY HUNT Enterprises
Chicago IL
——————————

[Jon Long]

I would try eliminating all fields from the report except one. Then keep running it and adding fields back until it crashes. Quite often, when a report hangs, to PDF, or otherwise, there are RAM ramifications (no pun intended) where several hundred Calcfields chew up resources to the point it freezes. 

If it is a flowfield, you can remove it if you don’t need it in the output, or, create a better key in the dependent table.

——————————
Jon Long
Director of ArcherPoint-Upgrades
ArcherPoint Inc.
GA
——————————
——————————————-

[Jeroen Bennink]

I suggest to look at the Service config-file the paramater “NetFx40_LegacySecurityPolicy enabled”.
We experienced bad perfomance with this paramater set to “false”. The performance increases when updating it to “true”.

——————————
Jeroen Bennink
Nedap N.V.
Groenlo
——————————
——————————————-

[Ron Ketterling]

I have seen this report fail because of the old 2GB temporary file limit in Windows. Or, you may be filling your OS drive. This report can create huge files.

——————————
Ron Ketterling
President
Business Automation Specialists of MN, Inc.
Minneapolis MN
——————————
——————————————-

[Ron Ketterling]

A further thought. There may be a fix for this report for 2013 R2, if I recall correctly.

——————————
Ron Ketterling
President
Business Automation Specialists of MN, Inc.
Minneapolis MN
——————————
——————————————-

[Geovanny Fuentes]

Try a few steps to narrow the run time,

One is limit the options selected.
Avoid popup displays on the report.
Run it manually and see how long it takes, then run it without sending the email, time it and see why the server is longer.

Try next a SLEEP(6000) or what ever seconds before sending the email and see if it gives it enough time.

Try saving it in a different server/folder (Where the service tier is running).
Good luck.

——————————
Geovanny Fuentes
San Diego CA
——————————
——————————————-