Error: Insufficient memory to continue the execution of the program.
There are two main causes of this issue:
- If Studio was not installed by right clicking the setup file and selecting "Run as Administrator", the software may not have gained all of the necessary rights to run and can cause this issue.
- If the 32-bit version of Microsoft Excel and Studio are installed, this error can indicate a limitation in the 32-bit version of our software.
This issue can be resolved by re-installing Studio, making sure to right click the setup file and select "Run as Administrator". If that does not resolve the issue, and the 32-bit versions of Studio and Excel are installed, request that your IT team install the 64-bit version of Office/Excel and then re-install Studio. Studio should install as the 64-bit version after recognizing your new Excel version.
There is a third cause to the Insufficient Memory to run programme error box -
Your excel file is too large.
I had created two scripts, almost identical, one for VA01 and one for VA02. Both scripts had conditions within conditions and were around the 6.5MB mark.
VA01 ran smoothly. VA02 return Insufficient Memory error.
I then noticed that the Excel file I ran VA01 on was 58KB in size, whilst the VA02 Excel file was 48MB!
The culprit ended up being sheet 2, which I was using as reference for a query script. I deleted the sheet, re-inputted the column header and retested. Ran smoothly. I had no idea why this single sheet was holding so much data as only two cells were populated (column header and one test input).
Winshuttle Studio 32x, Excel 32x.
Please sign in to leave a comment.