KB439951: How to set the maximum Java Heap Size value for JDBC source connectivity in MicroStrategy Developer and Web 2021

Product Specialist • Strategy

This article discusses a possible scenario involving JDBC source connectivity where the Java Heap Size needs to be increased, and how to set that new value in MicroStrategy Web and Developer 2021

SUMMARY:
This article discusses a possible scenario involving JDBC source connectivity where the Java Heap Size needs to be increased, and how to set that new value in Strategy Web and Developer 2021.
SYMPTOM:
In Strategy 10.11 and later, an error may appear when running a report or document indicating insufficient Java heap space available for the executed task:


Document Execution Failed: One or more dataset reports returned an error.
Document 1 [1569C9024E15D62F7DC78E8B0DAC8BDB]: (QueryEngine encountered error: JdbcResultWrapper::Fetch failed. Disconnected. Error type: Unknown exception. Jdbc operation attempted: FetchTable. Error Message:Java heap space.. Error in Process method of Component: QueryEngineServer, Project 1, Job 2408, Error Code= -2147212544.)

CAUSE:
Newer databases that predominantly utilize JDBC drivers have a default Java max heap size value for their JDBC connectivity set at 1200M. This value may not be high enough for some cases.

ACTION:
In both Strategy Developer and Web, the maximum heap size can be adjusted by appending the "HeapMaxSize=xxx;" parameter to the JDBC connection string of the data source.

To edit from Strategy Developer:
1.) Navigate to Administration->Configuration Managers->Database Instances
2.) Edit the desired database instance->Modify the existing database connection.
3.) Navigate to the “Advanced” tab, and add the parameter to the “Additional connection string parameters” section.

To edit from Strategy Web:
1.) Navigate to the available data sources for Data Import.
2.) Edit the desired data source, or create a new DSN-less connection and add the parameter to the “Connection String” section.

NOTE: Strategy recommends setting this value slightly higher than the machine’s available physical memory to avoid performance issues.
WORKAROUND:

For Strategy 10.10 and below, edit the below registry setting to increase the available Java heap space. This change will affect all JVM processes:


HKEY_LOCAL_MACHINE\SOFTWARE\Strategy\JNI Bridge\Config for DataServices\32-bit JVM\HeapMaxSize


HKEY_LOCAL_MACHINE\SOFTWARE\Strategy\JNI Bridge\Config for DataServices\64-bit JVM\HeapMaxSize

For LINUX, You change the registry key in MSIReg.reg
1. Stop the Strategy Intelligence Server
2. Open the MSIReg.reg file in a text editor (this file is located in the <MSTR_HOME> folder; /var/opt/Strategy/ by default)
3. Locate the following entry:


HKEY_LOCAL_MACHINE\SOFTWARE\Strategy\JNI Bridge\Config for DataServices\64-bit JVM\HeapMaxSize

4. Increase Heap Max Size

5. Save and close the MSIReg.reg file
6. Start the Strategy Intelligence Server

Comment

0 comments

Details

Knowledge Article

Published:

March 14, 2018

Last Updated:

February 13, 2024

Document Execution Failed: One or more dataset reports returned an error. Document 1 [1569C9024E15D62F7DC78E8B0DAC8BDB]: (QueryEngine encountered error: JdbcResultWrapper::Fetch failed. Disconnected. Error type: Unknown exception. Jdbc operation attempted: FetchTable. Error Message:Java heap space.. Error in Process method of Component: QueryEngineServer, Project 1, Job 2408, Error Code= -2147212544.)