Report generation shows error(& stopped) after 15 days successful run
I am facing an issue with report generation. I had created a report template to log the power consumption for 24 hours basis. This report is supposed to run upto next year july as per my end time. for 15 days all reports were generated & values are ok but from last 2 days reports are not being generating.
when I checked the job logs, it shows : "Job Action:Action Aspect Completed (Failure), error subscribing to automation object for type EX: ActiveX Component Cant create object", which I have no idea what it is. Please see the attachement
Can any one please explain why this error occured & how it can be rectified to continue the report generation.
One method which I tried is by creating a new report template & then creating a new job description. It started working. But what i think it should be the last option.
Can someone explain if they faced similar issue.
Thanks & regards
You have not mentioned the system version and office using ensure 5.1 supports office 2010 except 5.1 FP4 revE/Rev E supports office 2013.
generally the ActiveX Component Cant create object will be appear when you are trying to use the macros,
Be sure that macros are disabled "Disable all Macros Except Digitally Signed Macros" via excel trust center settings.
And ensure VBA features are allowed in the office to run.