Troubleshooting Out-of-Memory Issues

When building an ElastiCube with the following connectors, you might receive an "out of memory" error: BigQuery, Excel, Google Sheets, MemSQL, Salesforce, Snowflake.

Follow the steps below to add more memory.

To add memory:

  1. Open C:\Program Files\Sisense\DataConnectors\JVMContainer\bin\configuration.json as an administrator.
  2. In the line that starts with "jvmParameters:" , look for a parameter concatenated to '-Xmx', such as '-Xmx2G' or '-Xmx500M'. This parameter indicates the maximal heap size of the JVM. For example:
    "jvmParameters": ["-Xmx8g", "-server", "-Dfile.encoding=UTF-8"],
    If this parameter does not exist, the heap size is the default 1/3 of the machine's RAM. To modify the default size, paste the above line into your configuration.json file.
  3. Modify the -Xmx value according to your needs.
    For additional description about this parameter, click here.
  4. Restart the JVM service.
  5. To verify that the JVM parameters you specified were taken by the machine, open the Details tab in the Task Manager, right-click a heading of any of the columns and select to display the "Command Line" column. In the Command Line column for the Java processes you will see the JVM parameter values.