Question

Out of memory error in excel as database

  • 7 February 2023
  • 6 replies
  • 707 views

Badge +5

Hi Guys,

I am using csv file as database having approximately 9 lakh records.

After the connection is successful, bot executes the select query having some conditions, which runs for like an hour or so and then throws an error - Out of Memory.

 

Is it because of huge dataset or using CSV as database?

 

Any help will be really appreciated!!


6 replies

Userlevel 5
Badge +14

@Abhi25  Increase your jave heap memory and RAM size 

Userlevel 5
Badge +9

Hi, @Abhi25 

Kindly check the follow KB in order to increase the java heap memory.

https://apeople.automationanywhere.com/s/article/Java-heap

Solution 1 :
Steps to follow : 

  1. Edit the “nodemanager.properties” file under “C:\Program Files\Automation Anywhere\Bot Agent\config” 
  2. Add this line to configure more heap memory  bot.launcher.jvm.options=-Xmx4096m  
  3. Restart the bot agent service.

 

Solution 2: 
Steps to follow :
1. Login with admin user in A360 Control Room.
2. Go to Administration > Settings > Devices > Advanced Options and click edit.
3. Add the below string under "Bot launcher JVM options" including double quotes :
"-Xmx8192m"
Refer below Screenshot :

 

 

The increased Heap size needs to be customized according to the environmental needs. The value above is just for reference.

Let us know the result.

 

Regards

Userlevel 6
Badge +16

Hi @Raul Jaimes 

What does -Xmx4096m, -Xmx8192m mean?

Userlevel 5
Badge +9

Hi @Raul Jaimes 

What does -Xmx4096m, -Xmx8192m mean?

Hi. It  specifies the maximum memory allocation pool for a Java Virtual Machine (JVM) This means that the JVM will be able to use a maximum of Xmx  amount of memory. In this case, it will be able to use 4096 MB or 8192MB depending of VM resources. 

Userlevel 6
Badge +16

Hi @Raul Jaimes 

What does -Xmx4096m, -Xmx8192m mean?

Hi. It  specifies the maximum memory allocation pool for a Java Virtual Machine (JVM) This means that the JVM will be able to use a maximum of Xmx  amount of memory. In this case, it will be able to use 4096 MB or 8192MB depending of VM resources. 

Thanks @Raul Jaimes 📝

Badge +5

Hi, @Abhi25 

Kindly check the follow KB in order to increase the java heap memory.

https://apeople.automationanywhere.com/s/article/Java-heap

Solution 1 :
Steps to follow : 

  1. Edit the “nodemanager.properties” file under “C:\Program Files\Automation Anywhere\Bot Agent\config” 
  2. Add this line to configure more heap memory  bot.launcher.jvm.options=-Xmx4096m  
  3. Restart the bot agent service.

 

Solution 2: 
Steps to follow :
1. Login with admin user in A360 Control Room.
2. Go to Administration > Settings > Devices > Advanced Options and click edit.
3. Add the below string under "Bot launcher JVM options" including double quotes :
"-Xmx8192m"
Refer below Screenshot :

 

 

The increased Heap size needs to be customized according to the environmental needs. The value above is just for reference.

Let us know the result.

 

Regards

Thanks for sharing the solution Rahul.. Unfortunately I do not have the admin access and I don't know if they will be convinced to make the changes... Surely will try it out and share the results.

Reply