Reports Hanging - Error subscribing to automation object for type EX: ActiveX component can't create object
I am trying to generate reports on Microsoft Excel while using 800xA Scheduling. But after poviding all input parameters in Action Aspect window, I pressed Run Button to generate desired report, it stucks in Running Jobs and give and error as "Error subscribing to automation object for type EX: ActiveX component can't create object".
Please guide how to resolve this isssue so that I may generate reports successfully.
Looking forward prompt and valueable support.
Go through the troubleshooting steps in the "Information Management Data Access and Reports" manual (3BUF001094) Section 5 and also Section 6 - Using the Test Action to test a Job
Ensure that you've loaded Excel correctly onto the server where your Reports are run. Note this may not be the local machine where you designed the report. This is the most likely cause for the error message you're getting.