When trying to open DB Query Tool from MSTR i kept getting the following error message:
"Not enough memory to create the JVM"
Yes i know, my laptop currently only has 4GB of memory and running MSTR desktop and other tools my memory is quickly allocated and thus not available to start the JVM process.
One way to restrict the amount of memory Java can use from the available memory is by passing the -Xmx option in the command line when initializing the command.
In Windows go to Start->Search for DB query tool or navigate to "All Programs" -> "MicroStrategy Tools" and right click in the "DB Query Tool"and select properties.
Under the Shortcuts tab at the end of the Target command add -Xmx512M where 512 can be any value multiple of 1024 greater than 2MB.
"C:\Program Files (x86)\Common Files\MicroStrategy\MADBQueryTool.exe" -Xmx512M
More on -Xmx
I set mine to -Xmx512M and the application started correctly.

Thanks for sharing valuable information. Your blogs were helpful to learners. Microstrategy Online Training
ReplyDelete