Table dropped from cache, structure search fails

User 4140faeba5

24-04-2007 07:55:29

Hi.


JCHEM_CORE_PKG.GETENVIRONMENT()


--------------------------------------------------------------------------------


Oracle Database 10g Release 10.2.0.1.0 - 64bit Production


PL/SQL Release 10.2.0.1.0 - Production


CORE 10.2.0.1.0 Production


TNS for Linux: Version 10.2.0.1.0 - Production


NLSRTL Version 10.2.0.1.0 - Production


NLSRTL Version 10.2.0.1.0 - Production


JChem version in the database: 3.1.5


JChem version in the Tomcat server: 3.1.5


java.vm.version: 1.5.0_06-b05


java.vm.vendor: Sun Microsystems Inc.


Apache Tomcat/5.5.15





JCHEM_CORE_PKG.GETENVIRONMENT()


--------------------------------------------------------------------------------


Major JDBC version in Tomcat: 10


Minor JDBC version in Tomcat: 2





When I try to do a structure search the search fails and I get the following


in the log from the apache (catalina.out)





WARNING: Due to lack of memory the following table had to be dropped from the cache: BCS2.COMPOUND








What memory is it that is low ?





Help please,


Regards,


Mikael

ChemAxon aa7c50abf8

24-04-2007 08:37:27

Hi Mikael,





What error message does the database client get for the failed search?





The warning in the log from the apache (catalina.out) refers to the Java heap pool used by Tomcat, which can be set with -Xmx option. Please, see http://www.chemaxon.com/jchem/FAQ.html#outofmemory for determining the heap pool size for a given data set.





Thanks


Peter

User 4140faeba5

24-04-2007 09:11:43

Hi.


I've increased the pool size to see if the problem goes away.


Thanks


Mikael