Excel Reports Hang in Scheduler
Problem:
A user has a report that gets scheduled in the Scheduler. The ouput of the report gets exported to a .pdf file - either as configured in the Scheduler itself, or via use of VB code in the Excel report itself.
The report runs in a successful and timely manner outside of the Scheduler. However, inside the Scheduler, the report starts to execute, but never completes.
If the report output is NOT exported to PDF, the report in the Scheduler WILL complete.
Symptoms:- Report can run and complete outside of the schedulerExcel report exports output to PDF file via VB code or Scheduler is configured to export output to PDF fileReport starts running in the Scheduler, but does not complete
Answers
Cause: The lack of a configured 'default' printer will cause the creation and export of the PDF output to hang the report while running in the Scheduler. Resolution: Configure a default printer on the PC running the reports. This should allow the reports to complete and the PDFs to be generated successfully.
Add new comment