ETL Validator Server is typically deployed in Apache Tomcat 9.x or later. The amount of memory used by ETL Validator Server is thus controlled by the memory allocated to the Tomcat process. Often the default memory settings are not sufficient and it will result in a "Java heap space" error when a test case is executed. Please follow these steps to increase in the tomcat memory:
ETL Validator Complete
If your server is installed using ETL Validator Complete, a Tomcat instance is automatically installed with the product. Please follow these steps to increase the memory setting of the embedded tomcat :
- Open cmd in 'Run as Administrator''
- Change directory to the default installation folder
cd C:\app\Datagaps\ETLValidator\Server\apache- tomcat\bin - Open Tomcat configuration window by typing the below command
tomcat9w.exe //ES/ETLValidatorServer
A popup will be opened as shown in the attached image.
- Go to the Java tab and increase the maximum memory pool. Please remember that the value is in MB. So if you want to set the memory to 8 GB, please give 8192. (you can put up to 75% of RAM installed in Machine