Kbase P143983: Running a SQL query in SQL Explorer gives Insufficient space error
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/09/2009 |
|
Status: Unverified
SYMPTOM(s):
Running a SQL query in SQL Explorer gives Insufficient space error
JVMST109: Insufficient space in Javaheap to satisfy allocation request
Fatal error encountered. Exiting program. (CMNMsg026)
FACT(s) (Environment):
Running a SQL query in SQL Explorer
IBM AIX 6.1
OpenEdge 10.1B03 Service Pack
CAUSE:
The java heap size is set too low for the server to allow the server to build the result set for the query.
FIX:
Increase the java heap size in the JavaTools.properties file (located in <Progress install directory>/properties):
[Common]
classpath=/usr/java14/lib/tools.jar,/agility/progress/10.1b64/java/progress.jar,/agility/progress/10.1b64/java/messages.jar
jvmargs=-ms512m -mx2048m <<<-----new value in megabytes
#jvmargs=-ms8m -mx25m<<<----old value in megabytes
policyfile=/agility/progress/10.1b64/java/java.policy
NOTE:This is only a suggested value and only trial and error with your specific SQL query will determine the best setting here.