Hello!
I'm sorry for my bad english language, i've no time to write it correctly and I get helped by a traslator.
While we were building a process, we had no problems during the execution of MS Excel, when the process was executed by debug, excel worked correctly and at the expected speed.
During the development stage there was a version upgrade to 6.10, and when running the process with a Schedule from Control Room, Excel works excessively slow. Then, as some steps take more than 30 seconds, a timeout error occurs, causing the process to fail and abort.
We do not relate this to the excel file being in a shared network location, as an attempt was made to move the files to a local location and the result was the same.
The file format is xlsm, because it has macros included, although we don't think that is the cause since it processes them correctly by debug.
Attached is a screenshot of the excessive delay in the process, and the timeout failure:
Does anyone know how to get this back to work with a normal speed? it is unusual that to read 4 excel forms it takes 1 hour.
I clarify that it is running on a dedicated server, which does not run any other program or process in parallel.
Thank you very much!
------------------------------
Evangelina Curró
------------------------------
I'm sorry for my bad english language, i've no time to write it correctly and I get helped by a traslator.
While we were building a process, we had no problems during the execution of MS Excel, when the process was executed by debug, excel worked correctly and at the expected speed.
During the development stage there was a version upgrade to 6.10, and when running the process with a Schedule from Control Room, Excel works excessively slow. Then, as some steps take more than 30 seconds, a timeout error occurs, causing the process to fail and abort.
We do not relate this to the excel file being in a shared network location, as an attempt was made to move the files to a local location and the result was the same.
The file format is xlsm, because it has macros included, although we don't think that is the cause since it processes them correctly by debug.
Attached is a screenshot of the excessive delay in the process, and the timeout failure:
Does anyone know how to get this back to work with a normal speed? it is unusual that to read 4 excel forms it takes 1 hour.
I clarify that it is running on a dedicated server, which does not run any other program or process in parallel.
Thank you very much!
------------------------------
Evangelina Curró
------------------------------
Hi Evangelina
The timeout issue can be resolved by simply extending the wait period for the file to open no the open action stage, update the data item Timeout to what period would be suitable. See screenshot below. As for the cause of the timeout I could say for certain but its likely more to do with the file and that it includes macros, things will generally work a little differently in debug when compared to the scheduler.There are a couple of things that might help, make sure you are using Create Instance action before the action Open Workbook, you can also try setting the Enable Events value on the Open workbook action to false. If auto calculation is enabled on excel you can change this to Manual calculation to prevent the file attempting to calculate when opening or if you have experience in coding you can create a new action to set auto calculation on or off. I created something similar as I was working with very large files with lots of links and formulas, this sped up the interaction with the file greatly.
Let me know if you would like the code for doing this and I will sent it on to you.
------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------
The timeout issue can be resolved by simply extending the wait period for the file to open no the open action stage, update the data item Timeout to what period would be suitable. See screenshot below. As for the cause of the timeout I could say for certain but its likely more to do with the file and that it includes macros, things will generally work a little differently in debug when compared to the scheduler.There are a couple of things that might help, make sure you are using Create Instance action before the action Open Workbook, you can also try setting the Enable Events value on the Open workbook action to false. If auto calculation is enabled on excel you can change this to Manual calculation to prevent the file attempting to calculate when opening or if you have experience in coding you can create a new action to set auto calculation on or off. I created something similar as I was working with very large files with lots of links and formulas, this sped up the interaction with the file greatly.
Let me know if you would like the code for doing this and I will sent it on to you.
------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------
