The Internet of Things (IIoT) offers unprecedented possibilities for industries. Stay ahead with EcoStruxure™ Plant and Machine.Learn more
...with the EcoStruxure™ Facility Expert (formerly known as 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
The story behind the Shedd Aquarium, a smart, sustainable facility that connects people to animals, with EcoStruxure™.Discover how
Welcome to the Schneider Electric Global Website×
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.
Sign up for all the latest solutions, offers and best practices straight to your inbox.
We are excited that you have joined the group. You will receive your welcome email soon describing the program and what to expect in the upcoming weeks. Enjoy!