Question
PT Asuransi Simas Jiwa
ID
Last activity: 26 Apr 2017 2:51 EDT
ORA-29532: Java call terminated by uncaught Java exception: java.lang.OutOfMemoryError When Run Report Definition
Hi,
I have an error ORA-29532: Java call terminated by uncaught Java exception: java.lang.OutOfMemoryError when i run report definition.
This my application server (JVM memory) setting and server have free memory ~8Gb after prweb.war deployed.
JAVA_OPTS="-Xms16g -Xmx18g -XX:PermSize=16g -XX:MaxPermSize=18g"
I use Oracle Database 11g Enterprise Edition Release Proprietary information hidden.0 - 64bit Production, JDBC driver Proprietary information hidden.0 and lastest Tomcat 7.
What can i do for solving this problem?
Thank you
Pegasystems Inc.
US
You are most likely running out of heap memory for the JVM inside Oracle database while running UDF, not to be confused with the JVM on the app server side which you quoted above. UDF should NOT be used in production. Are you retrieving large amount of data in the report definition? How often do you see this error in your environment?
PT Asuransi Simas Jiwa
ID
Total data record 987 without filter, with filter 1-20 record. I see this error 4 times of 5 attempt.
Why other report definition (different class, with large amount of data) not showing this error?
I will try to increase Oracle memory base on reference (http://docs.oracle.com/cd/E11882_01/java.112/e10588/chfour.htm#JJDEV13219)
Thank you
Pegasystems Inc.
US
Adding Oracle reference on the memory configuration: http://docs.oracle.com/cd/E11882_01/java.112/e10588/chfour.htm#JJDEV13221