Excel file empty-no content
I have a process that exports an Excel file (successfully for months). Recently (and intermittently) the Excel export is empty on the first attempt to run the process. When we rerun the process the Excel export is correct and has content. What could cause this? Is there a fix?
Answers
-
HI John,
You can checked the Monarch server Automator logs within the configurator or event viewer on the server (you need to RDP to the Monarch Server to check logs).
What version of the Automator are you using?
Is it possible that the Excel file is open by a process or another user while the process is running?
Are you using the Visual Process or standard process? If for example the process is a standard process, you may migrate it to the visual process and try it or the other way around (convert it to the standard process).
Was there any error in the job log?
Are you exporting to xls or xlsx? If xls, try changing it to the xlsx..
Regards
Mo
0