Troubleshooting
Problem
When running a Dynamic Cube report, it fails with the following error :
"XQE error encountered: DPR-ERR-2002 Unable to execute the request because there were no connections to the process available within the configured time limit."
And checking the XQE log files, you find errors similar to the followings :
INFO startup.Audit.RTUsage.qs.XQE.V5DataServer [Thread-42] NA 9300 __ XQE 2608 StartService QueryService failed to start with the following command-line arguments: [D:\apps\ibm\cognos\analytics11\jre\bin\java.exe, -Xms4096m, -Xmx16384m, -Xmnx6144m, -Xmns4096m, -server, -Xscmx100m, -Xshareclasses:cachedir=../javasharedresources,name=cognos10%u,nonfatal, -Xmso512K, -XX:+HeapManagementMXBeanCompatibility, -Xjit:dontInline={gnu/trove/*},{gnu/trove/*}(disableLoopVersioner), -Dcom.ibm.jsse2.overrideDefaultTLS=true, -Xcompressedrefs, -verbose:gc, -Xverbosegclog:D:\apps\ibm\cognos\analytics11\logs\XQE\dq_verbosegc_%Y%m%d.%H%M%S.%pid.log,1,1000, -Xgcpolicy:gencon, -Xdump:tool:events=systhrow,filter=java/lang/OutOfMemoryError,exec=cmd.exe /c del /f /s D:\apps\ibm\cognos\analytics11\data\.xqe.%pid > nul, -DCOG_ROOT=D:/apps/ibm/cognos/analytics11, -DParentProcessID=2608, -Dcubingservices_home=D:/apps/ibm/cognos/analytics11/v5dataserver, -Dcubingservices_data=D:\apps\ibm\cognos\analytics11\data, -DParentProcessPort=59536, -Djava.library.path=D:/apps/ibm/cognos/analytics11/bin64;, -Djava.rmi.server.hostname=BDR-PRCBI01.dc.corp.local, -DenableTraceServer, -ea, -Dorg.dom4j.QName.singleton.strategy=org.dom4j.util.PerThreadSingleton, -Dorg.dom4j.DocumentFactory.singleton.strategy=org.dom4j.util.PerThreadSingleton, -javaagent:bin/tools/ws-javaagent.jar, -jar, bin/tools/ws-server.jar, dataset-service] with console output: JVMJ9GC019E -Xmns too large for -Xms JVMJ9VM015W Initialization error for library j9gc28(2): Failed to initialize Error: Could not create the Java Virtual Machine. Error: A fatal exception has occurred. Program will exit.
Cause
The "Initial JVM nursery size" parameter's value is too large.
Diagnosing The Problem
Check the Query Service JVM settings to confirm that the "Initial JVM nursery size" value is too large compared to the "Initial JVM heap size" value
Resolving The Problem
Basically, the "Initial JVM nursery size" should be lower than the "Initial JVM heap size" .
Try to set the "Initial JVM nursery size" to 0, or to half of the "Initial JVM heap size" .
Try to set the "Initial JVM nursery size" to 0, or to half of the "Initial JVM heap size" .
Example:
If "Initial JVM heap size" = 4096 MB, set "Initial JVM nursery size" to a value <= 2048MB
After modifying these settings, you need to restart the Query Service service.
Document Location
Worldwide
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl4nAAC","label":"Administration->Dynamic Cubes"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"11.1.6"}]
Was this topic helpful?
Document Information
Modified date:
26 December 2020
UID
ibm16394380