CA Vantage Windows Client - scheduler not working properly

Products

• Vantage Storage Resource Manager
• GRAPHICAL MANAGEMENT INTERFACE

Issue/Introduction

Getting the following error from OAscheduler log:
3/20/20 2:07:36 AM - OAExec. • Export into Excel failed.
COAExcel: CloseExcel
SaveAs method of Workbook class failed
Probably the output file 
C:\BRIGHTSTOR SRM DATA\DATABASE\Doc\FHB Storage Groups GT 85%.XLSX
is locked for editing by another application or there is security problem.

 

Environment

Release : 14.0

Component : CA Vantage Storage Resource Manager

Resolution

Microsoft Excel component that WC uses, exporting data into .XLSX (Excel Workbook) file cannot be made reliable when WC Scheduler is running as a service.  Unfortunately, Microsoft changed their restriction in Excel.  
 
With respect to this fact we recommend the following circumvention:  
 
You should update your scheduled tasks to export data into CSV format, not xlsx format.  
The recipient then will import the CSV format as an excel file  

To make it more easier for you, we recommend to update windows setting (list separator) to character ";"  
List separator settings is under settings -> region $ language -> additional date, time, & regional settings -> change date, time, or number formats -> additional settings  

Permanent fix for this limitation is planned for future release of WebUI.  
This solution is for the Scheduler running as a Service.  

Otherwise, if you just need the excel file, you still can use scheduler as application but then there is a need of a logged in user on the machine.