2022
Issue:
There are scenarios or cases where the application might run out of java heap space and the sync would break mostly due to very large data sync or large set of data that sync between applications, in such cases we can force the tomcat application to use dedicated java heap memory so the sync won’t break.
Solution:
This can be done by following the steps below,
Windows:
1. Edit the file catalina.bat file located in <<install-directory>>/bin and add the following property
set JAVA_OPTS=-Xms512m -Xmx4096m before or after the line, set JRE_HOME=..\jre
After adding the property restart the tomcat service or the tomcat application.
(512 is the minimum and 4096 is the maximum heap memory that is allotted to this application, please set the values according to the available RAM memory on your server machine)
2. Also edit service.bat and change the heap size as shown below to certain value based on the RAM available,
Once you increase the size in service.bat then you have to re-register the tomcat service for the changes to take effect.
Go to Windows services, check for the tomcat service usually which would be as shown below,
To un-register the service, execute the below command by opening a command prompt as administrator
service.bat uninstall DBSync
To re-register the service again execute the command
service.bat install DBSync
To re-register the service again execute the command
service.bat install DBSync