Return
-
Title
Unable to fetch AR customers in order to archive. -
Description
When trying to add one of the AR customer from object type the following issues are met while fetching:1. Get error java.lang.OutOfMemoryError2. As the Query returns over a million rows (approx.. growth 600 seen in one hour) the fetch never ends. The result is that we are dealing with what looks more like a transactional table. -
Cause
Specific to this customer. -
Resolution
Solution to fix the Out of Memory:
1. Modify the CA run.conf like this:if [ "x$JAVA_OPTS" = "x" ]; thenJAVA_OPTS="-server -Xms512m -Xmx1024m -XX:MaxPermSize=512m -Dorg.jboss.resolver.warning=true -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000"Delete from $STAT_HOME/app/server/default/log/server.log fileDelete from $STAT_HOME/app/server/default/tmp folder and sub-folders. Cache filesDelete from $STAT_HOME/app/server/default/work folder and sub-folders . Cache filesDelete from $STAT_HOME/app/server/default/data/hypersonic folder. Cache filesOR at client side to set parameter below in the registry:In your registry, locate the following key and add or edit the 3 values as below:[HKEY_LOCAL_MACHINE\SOFTWARE\Sybase\PowerBuilder\11.0\Java\PBRTConfig\PBJVMConfig]"0"="-verbose:jni,class""1"="-Xmx512m""Count"="2"2. To fix the Million rows retrieved by the query, you have to setup the object type to retrieve less data. For this follow the instruction in the document attached "How to Setup Object Types for Oracle Applications". -
Attachments