Memory issues when profiling large data sets using indicators


When you use the Java engine to run column analyses or column set analyses with indicators on large data sets, your Studio may run out of memory and you may end up with a Java heap error.


Talend Open Studio for Data Quality and all platform Studios with data quality.


You may get a Java heap error when you use certain indicators to run column or column set analyses on large data sets. Executing analyses with the Java engine uses much disk space as all data is retrieved and stored locally using physical memory (MapDB mode). More data needs more memory which will lead to this potential error when profiling large data.

java.vendor=Oracle Corporation
BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=en_US
Framework arguments:  -talendReload false
Command-line arguments:  -talendReload false -os win32 -ws win32 -arch x86_64
Tue Nov 04 10:32:02 CET 2014
An internal error occurred during: "Run Analysis".
java.lang.OutOfMemoryError: Java heap space
at com.mysql.jdbc.MysqlIO.nextRowFast(
at com.mysql.jdbc.MysqlIO.nextRow(
at com.mysql.jdbc.MysqlIO.readSingleRowSet(
at com.mysql.jdbc.MysqlIO.getResultSet(
at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(
at com.mysql.jdbc.MysqlIO.readAllResults(
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(

The indicators that may cause memory issues with the Java engine are:

  • Unique count, duplicate count, distinct count
  • Median and quartiles indicators
  • Pattern (Low) Frequency table indicator
  • Soundex (Low) Frequency table
  • All advanced statistics indicators (frequency tables), depending on the aggregation level (e.g. a year frequency table will fit in memory if the analyzed period does not contain millions of years)


It is advisable to define a maximum memory size threshold for column and column set analyses used on large data sets and executed with the Java engine.
A detail procedure on how to define a memory threshold is outlined in Defining the maximum memory size threshold.
However, if this does not solve the memory problem you must first configure the default Java Virtual Machine (JVM) parameters by setting new values in the <platform>.ini file of your Studio. You can then go back to define the memory size threshold from the Studio Preferences page.
The new JVM values you must set depend on the size of the data set you want to profile and on the available memory on your machine. Below is an example of these parameters:




As JDK1.7 64 needs more memory then JDK 1.6 64, you must even assign more memory to the Xmx value when you use JDK1.7 64 with your Studio. For example:



Version History
Revision #:
1 of 1
Last update:
‎05-11-2017 11:58 PM
Updated by:
Labels (1)