Scheduled DataDirect reports fail if Add-in "Analysis ToolPack" installed
Problem:DataDirect based reports run interactively from within Excel but fail to run from the Scheduler and the following error is in the log: 'Error Subscribing to Automation Object for Type EX:Open Method of Workbooks Failed'Symptoms:
- Excel Add-in 'Analysis ToolPack' causes scheduled DataDirect reports to failScheduled DataDirect reports fail to execute and log 'Error Subscribing to Automation Object for Type EX:Open Method of Workbooks Failed'
Answers
Cause: The scheduled reports are failing because the "Analysis ToolPak" Excel Add-in is installed for the 800xA Service account. This Add-in is for "Interactive Use" only! Since the Scheduler runs Excel in the background as the 800xA Service account, when the scheduler tries to load/open this Addin while opening excel, the Excel API "Workbooks.Open" will fail.
Resolution: The discussed Excel add-in must be disabled for the 800xA Service account for the scheduler to open the workbook in the background. For a customer who must have this feature in Excel for the 800xA service account user on the IM, the "Analysis ToolPak - VBA" Add-in should be used instead.
Resolution: The discussed Excel add-in must be disabled for the 800xA Service account for the scheduler to open the workbook in the background. For a customer who must have this feature in Excel for the 800xA service account user on the IM, the "Analysis ToolPak - VBA" Add-in should be used instead.
Add new comment