Error

Dear

I updated my OS to win10 ,and IJC to 15.7.27.

When I query structures ,error occured.

I attached the details.

Best regards,

Huang

org.springframework.dao.InvalidDataAccessResourceUsageException: Exception occurred when executing JChem search; nested exception is chemaxon.jchem.db.DatabaseSearchException: ERROR: Table "APP.PRODUCTS_AND_OFFERS" could not fit into structure cache (out of memory).

Please visit http://www.chemaxon.com/jchem/doc/admin/Performance.html#cacheSize and

http://www.chemaxon.com/jchem/javaFAQ.html#outofmemory

 

at com.im.ijcs.impl.query.JChemExecutor.executeJChemSearch(JChemExecutor.java:244)

at com.im.ijcs.impl.query.JChemExecutor.execute(JChemExecutor.java:125)

at com.im.ijcs.impl.query.JChemExecutor.run(JChemExecutor.java:309)

at com.im.ijcs.impl.query.Executor.executeStructureQuery(Executor.java:155)

at com.im.ijcs.impl.query.Executor.executeNonSqlQuery(Executor.java:316)

at com.im.ijcs.impl.query.Executor.executeImpl(Executor.java:193)

at com.im.ijcs.impl.query.Executor.execute(Executor.java:145)

at com.im.ijcs.impl.query.LocalQueryExecutor.access$001(LocalQueryExecutor.java:26)

at com.im.ijcs.impl.query.LocalQueryExecutor$1.doInTransaction(LocalQueryExecutor.java:64)

at com.im.ijcs.impl.query.LocalQueryExecutor$1.doInTransaction(LocalQueryExecutor.java:60)

at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:131)

at com.im.ijcs.impl.query.LocalQueryExecutor.execute(LocalQueryExecutor.java:60)

at com.im.ijcs.impl.query.DefaultQueryService.find(DefaultQueryService.java:71)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)

at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

at com.sun.proxy.$Proxy22.find(Unknown Source)

at com.im.df.impl.db.DBSchemaDataProviderImpl.queryForDistinctValues(DBSchemaDataProviderImpl.java:478)

at com.im.df.impl.db.DBSchemaDataProviderImpl.queryForIdsImpl(DBSchemaDataProviderImpl.java:531)

at com.im.df.impl.db.DBSchemaDataProviderImpl.queryForIds(DBSchemaDataProviderImpl.java:191)

at com.im.df.impl.db.DBSchemaDataProviderImpl.queryForIds(DBSchemaDataProviderImpl.java:179)

at com.im.df.impl.db.resultset.ResultSetImpl$2.executeQuery(ResultSetImpl.java:324)

at com.im.df.util.earlyresults.EarlyResultsBatcher.runQuery(EarlyResultsBatcher.java:38)

at com.im.df.impl.db.resultset.ResultSetImpl.applyQueryInternal(ResultSetImpl.java:330)

at com.im.df.impl.db.resultset.ResultSetImpl.applyWorkingQuery(ResultSetImpl.java:256)

at com.im.ijc.core.api.actions.ExecuteWorkingQueryAction.phase1(ExecuteWorkingQueryAction.java:52)

at com.im.ijc.core.api.actions.AbstractExecuteQueryAction$1.phase1InRequestProcessor(AbstractExecuteQueryAction.java:47)

at com.im.commons.progress.BackgroundRunner.processTheTask(BackgroundRunner.java:140)

at com.im.commons.progress.BackgroundRunner$1.run(BackgroundRunner.java:102)

at com.im.commons.base.ThreadContext$2.run(ThreadContext.java:193)

at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:1411)

at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:1991)

Caused by: chemaxon.jchem.db.DatabaseSearchException: ERROR: Table "APP.PRODUCTS_AND_OFFERS" could not fit into structure cache (out of memory).

Please visit http://www.chemaxon.com/jchem/doc/admin/Performance.html#cacheSize and

http://www.chemaxon.com/jchem/javaFAQ.html#outofmemory

 

at chemaxon.jchem.base.storage.impl.CacheTargetCollection.loadCache(CacheTargetCollection.java:253)

at chemaxon.jchem.base.storage.impl.CacheTargetCollection.updateBeforeSearchIfNeeded(CacheTargetCollection.java:298)

at chemaxon.jchem.base.storage.impl.sql.search.MixedTargetCollection.updateBeforeSearchIfNeeded(MixedTargetCollection.java:319)

at chemaxon.jchem.db.SimpleJChemSearch.updateCache(SimpleJChemSearch.java:550)

at chemaxon.jchem.db.SimpleJChemSearch.searchCore(SimpleJChemSearch.java:222)

at chemaxon.jchem.db.FilteringJChemSearch.searchCore(FilteringJChemSearch.java:204)

at chemaxon.jchem.db.FilteringJChemSearch.filteredSearch(FilteringJChemSearch.java:168)

at chemaxon.jchem.db.filterquery.AbstractFilteringCallable.call(AbstractFilteringCallable.java:41)

at chemaxon.jchem.db.filterquery.PreFilteringCallable.call(PreFilteringCallable.java:24)

at chemaxon.jchem.db.filterquery.PreFilteringCallable.call(PreFilteringCallable.java:13)

at chemaxon.jchem.db.InterruptSQLHandler.handleInterrupt(InterruptSQLHandler.java:32)

at chemaxon.jchem.db.InterruptSQLHandler.access$000(InterruptSQLHandler.java:22)

at chemaxon.jchem.db.InterruptSQLHandler$1.call(InterruptSQLHandler.java:60)

at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at com.google.common.util.concurrent.MoreExecutors$SameThreadExecutorService.execute(MoreExecutors.java:297)

at java.util.concurrent.ExecutorCompletionService.submit(Unknown Source)

at chemaxon.jchem.db.JChemSearch.search(JChemSearch.java:1440)

at chemaxon.jchem.db.JChemSearch.searchLimitConcurrency(JChemSearch.java:1379)

at chemaxon.jchem.db.JChemSearch.access$000(JChemSearch.java:121)

at chemaxon.jchem.db.JChemSearch$AsynchronExecutionThread.run(JChemSearch.java:337)

Dear Huang, 

we do not support Windows 10 yet as it is still a fresh release of Windows (last Wednesday) and therefore it is not tested. The only platforms that we support are mentioned in the System Requirements page here.

However, in theory, there should not be any reason why IJC would suddenly stop working because of Windows update. Based on your error, it seems that JChem part of IJC ends up without memory. I would suggest increasing the maximum memory settings for IJC, either by our preference menu (described here) or by adding a J-Xmx parameter to default startup parameters in instantjchem.conf file. For example, I would suggest increasing the memory to 2 GB. In that case the parameter would look like this -J-Xmx2048m

 

I hope this helps

Wishing all the best

David