Open Spreadsheet out of memory

recorder-wf_studio_s
question_s
#1

How can I increase the Java Heap memory?

Thanks

#2

Hi @gonzalomelov.
When do you receive this exception? During playing recording?

#3

Yes, when I hit play.

I will be trying using the background bot right now in order to check that is a different java process running

1 Like
#4

Thanks. Let me know whether you find it. Also screenshot of the exception will help :slight_smile:

1 Like
#5

Same error using the background bot runner

Attached follows the exception of the runner

exc.txt (7.9 KB)

#6

I forgot to point that the Excel file is like 200mb

#7

Thanks. So 200mb is enough big file. You can read about max Excel file size in this thread: Max files size for RPA Express Excel function

In your case, there are 2 possible solutions.
The first is to use small Excel files. You can try to divide your original file to several files and process them in loop.
The second option is to increase memory for Java machine, but it can affect performance of other applications and whole performance of your PC. To do it, you can go to the file “start-node0.bat” and edit option Xmx512m to Xmx1024m, for example.
If you want to try with the second option, please stop RPA Express and then edit this file.

Hope this information helps you.

4 Likes
Unable to read Large excel file getting Reading timeout Error
Out of memory Error: GC overhead limit exceeded
#8

Awesome!!! I will try the 2nd approach and come back to you with the results!!

Thanks

3 Likes
#9

Hi,

I am trying to process excel file having 10 lacs records and 60 columns.
While loading that file for reading, it is giving me error : OutOfMemoryError: GC overhead limit exceeded”.
I don’t want to use external jars.
Is there any way to process such large files by using existing workfusion jars?
Is there any better way to handle these types of files?

Thanks,
Shubhangi

#10

Hi @smalavi.
Did you try some of approaches described in post above?

#11

Finally I had to use a Python script to use the Excel file

Thanks

2 Likes
#12

Hi Lera,
Thank you for your quick response.
1)To divide your original file to several files, we have to load the file first and it is failing at that step only.
2)We are running from control tower. Will second option of increasing java memory work here?

Thanks and Regards,
Shubhangi Malavi

#13

Hi gonzalomelov,

Thank you for your response.
Can we use Python in Workfusion with existing jars? I don’t want to use external jars. Can you send me useful links to do that?

Thanks and Regards,
Shubhangi Malavi

#14

Yes, that should work, but you need to update all start-node[X].bat files in case of multiple bots.

#15

Not Recording.
I am trying to run script.

#16

We have executed the Python script using Win + R

I don’t think you can execute it using existing jars