Here’s what more than 2,500 business decision-makers around the world say.Download the report
...with the Facility Hero app in hand! Discover how you can optimize your maintenance efforts today.Learn more
Access tailored services, 24/7 self-service and expert help. Anywhere, anytime, any project.Discover now
Everything you need to know about our IoT technology backbone.Learn more
Explore our global offerings or select your country from one of our five regions.Global
Découvrez nos offres globales ou sélectionnez votre pays dans l’une de nos cinq régions.
Goals and Symptoms
Reporter can generate the reports manually but fails when a report is requested via Windows Scheduled Tasks. The report fails right around the Post Report Macro returning the "Error 2147417851". Scheduling the reports using either of the repgen.exe and the reportgen.exe returns the same result.
Additionally, the error message "Automation error: The server threw an exception has occurred in pmlRepGenScheduling" pops up following the details:
Error is thrown at line in PerformPostProcessing procedure:
Value for ReportWorkbook.Worksheets.count in Watch window is:
The remote server machine does not exist or is unavailable
Causes and Fixes
The problem is a security-related issue, since the error is coming from code that tries to run an Excel macro. Make sure the "Log on as" account that the "Task Scheduler" service is running under is the same account that Reporter uses to successfully run manual reports.
Additionally, a stray EXCEL process is not left open when a report is generated through the normal Reporter interface. Please make sure that there is not an orphaned EXCEL process present and running on the server.