Hello-
I am running into an issue with Query Jobs in which no matter what I do when I set up a Job to run a query it always fails. I have opened the OS log file and found this error:
2024-02-21 16:26:47 [pool-2-thread-5] WARN net.sf.ehcache.Cache- An API change between ehcache-1.1 and ehcache-1.2 results in the persistence path being set to java.io.tmp when the ehcachehcache-1.1 constructor is used. Please change to the 1.2 constructor
2024-02-21 16:26:49 [pool-2-thread-5] ERROR com.krishagni.catissueplus.core.de.services.impl.QueryServiceImpl- Error compressing the query result to ZIP file. Deleting the file
java.io.FileNotFoundException: Source '/openspecimen/data/query-exported-data/scheduled_query_86_146059.csv.zip' does not exist
at org.apache.commons.io.FileUtils.validateMoveParameters(FileUtils.java:3124) ~[commons-io-2.11.0.jar:2.11.0-migrated-1.0.7]
at org.apache.commons.io.FileUtils.moveFile(FileUtils.java:2303) ~[commons-io-2.11.0.jar:2.11.0-migrated-1.0.7]
at org.apache.commons.io.FileUtils.moveFile(FileUtils.java:2283) ~[commons-io-2.11.0.jar:2.11.0-migrated-1.0.7]
at com.krishagni.catissueplus.core.de.services.impl.QueryServiceImpl$ExportQueryDataTask.zipExportedDataFile(QueryServiceImpl.java:1873) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.de.services.impl.QueryServiceImpl$ExportQueryDataTask.call_aroundBody0(QueryServiceImpl.java:1839) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.de.services.impl.QueryServiceImpl$ExportQueryDataTask$AjcClosure1.run(QueryServiceImpl.java:1) ~[classes/:master-migrated-1.0.7]
at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:179) ~[aspectjrt-1.9.19.jar:?]
at com.krishagni.catissueplus.core.common.TransactionalInterceptor$1.doInTransaction(TransactionalInterceptor.java:115) ~[classes/:master-migrated-1.0.7]
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) ~[spring-tx-5.3.22.jar:5.3.22-migrated-1.0.7]
at com.krishagni.catissueplus.core.common.TransactionalInterceptor.doWork0(TransactionalInterceptor.java:107) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.common.TransactionalInterceptor.doWork(TransactionalInterceptor.java:83) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.common.TransactionalInterceptor.ajc$inlineAccessMethod$com_krishagni_catissueplus_core_common_TransactionalInterceptor$com_krishagni_catissueplus_>
at com.krishagni.catissueplus.core.common.TransactionalInterceptor.startTransaction(TransactionalInterceptor.java:69) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.de.services.impl.QueryServiceImpl$ExportQueryDataTask.call(QueryServiceImpl.java:1803) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.de.services.impl.QueryServiceImpl.exportData(QueryServiceImpl.java:1760) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.de.services.impl.QueryServiceImpl.exportQueryData_aroundBody48(QueryServiceImpl.java:1061) ~[classes/:master-migrated-1.0.7]
at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:179) ~[aspectjrt-1.9.19.jar:?]
at com.krishagni.catissueplus.core.common.TransactionalInterceptor$1.doInTransaction(TransactionalInterceptor.java:115) ~[classes/:master-migrated-1.0.7]
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) ~[spring-tx-5.3.22.jar:5.3.22-migrated-1.0.7]
at com.krishagni.catissueplus.core.common.TransactionalInterceptor.doWork0(TransactionalInterceptor.java:107) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.common.TransactionalInterceptor.doWork(TransactionalInterceptor.java:83) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.common.TransactionalInterceptor.ajc$inlineAccessMethod$com_krishagni_catissueplus_core_common_TransactionalInterceptor$com_krishagni_catissueplus_> at com.krishagni.catissueplus.core.common.TransactionalInterceptor.startTransaction(TransactionalInterceptor.java:69) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.de.services.impl.QueryServiceImpl.exportQueryData(QueryServiceImpl.java:1056) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.administrative.services.impl.ScheduledQueryTask.runQuery_aroundBody0(ScheduledQueryTask.java:64) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.administrative.services.impl.ScheduledQueryTask$AjcClosure1.run(ScheduledQueryTask.java:1) ~[classes/:master-migrated-1.0.7]
at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:179) ~[aspectjrt-1.9.19.jar:?]
at com.krishagni.catissueplus.core.common.TransactionalInterceptor$1.doInTransaction(TransactionalInterceptor.java:115) ~[classes/:master-migrated-1.0.7]
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) ~[spring-tx-5.3.22.jar:5.3.22-migrated-1.0.7]
at com.krishagni.catissueplus.core.common.TransactionalInterceptor.doWork0(TransactionalInterceptor.java:107) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.common.TransactionalInterceptor.doWork(TransactionalInterceptor.java:83) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.common.TransactionalInterceptor.ajc$inlineAccessMethod$com_krishagni_catissueplus_core_common_TransactionalInterceptor$com_krishagni_catissueplus_> at com.krishagni.catissueplus.core.common.TransactionalInterceptor.startTransaction(TransactionalInterceptor.java:69) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.administrative.services.impl.ScheduledQueryTask.runQuery(ScheduledQueryTask.java:39) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.administrative.services.impl.ScheduledQueryTask.doJob(ScheduledQueryTask.java:35) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.administrative.services.impl.ScheduledTaskWrapper.run(ScheduledTaskWrapper.java:38) ~[classes/:master-migrated-1.0.7]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572) ~[?:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:317) ~[?:?]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304) ~[?:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) ~[?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) ~[?:?]
at java.lang.Thread.run(Thread.java:1583) [?:?]
2024-02-21 16:26:49 [pool-2-thread-5] ERROR com.krishagni.catissueplus.core.administrative.services.impl.ScheduledTaskWrapper- Error running scheduled job: Test Job Example
com.krishagni.catissueplus.core.common.errors.OpenSpecimenException: Query result data export file scheduled_query_86_146059.csv.zip is invalid or does not exist.
at com.krishagni.catissueplus.core.common.errors.OpenSpecimenException.userError(OpenSpecimenException.java:139) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.common.events.ResponseEvent.userError(ResponseEvent.java:106) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.de.services.impl.QueryServiceImpl.getExportDataFile_aroundBody18(QueryServiceImpl.java:580) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.de.services.impl.QueryServiceImpl$AjcClosure19.run(QueryServiceImpl.java:1) ~[classes/:master-migrated-1.0.7]
at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:179) ~[aspectjrt-1.9.19.jar:?]
at com.krishagni.catissueplus.core.common.TransactionalInterceptor$1.doInTransaction(TransactionalInterceptor.java:115) ~[classes/:master-migrated-1.0.7]
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) ~[spring-tx-5.3.22.jar:5.3.22-migrated-1.0.7]
at com.krishagni.catissueplus.core.common.TransactionalInterceptor.doWork0(TransactionalInterceptor.java:107) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.common.TransactionalInterceptor.doWork(TransactionalInterceptor.java:83) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.common.TransactionalInterceptor.ajc$inlineAccessMethod$com_krishagni_catissueplus_core_common_TransactionalInterceptor$com_krishagni_catissueplus_> at com.krishagni.catissueplus.core.common.TransactionalInterceptor.startTransaction(TransactionalInterceptor.java:69) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.de.services.impl.QueryServiceImpl.getExportDataFile(QueryServiceImpl.java:566) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.administrative.services.impl.ScheduledQueryTask.runQuery_aroundBody0(ScheduledQueryTask.java:66) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.administrative.services.impl.ScheduledQueryTask$AjcClosure1.run(ScheduledQueryTask.java:1) ~[classes/:master-migrated-1.0.7]
at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:179) ~[aspectjrt-1.9.19.jar:?]
at com.krishagni.catissueplus.core.common.TransactionalInterceptor$1.doInTransaction(TransactionalInterceptor.java:115) ~[classes/:master-migrated-1.0.7]
com.krishagni.catissueplus.core.common.errors.OpenSpecimenException: Query result data export file scheduled_query_86_146059.csv.zip is invalid or does not exist.
at com.krishagni.catissueplus.core.common.errors.OpenSpecimenException.userError(OpenSpecimenException.java:139) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.common.events.ResponseEvent.userError(ResponseEvent.java:106) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.de.services.impl.QueryServiceImpl.getExportDataFile_aroundBody18(QueryServiceImpl.java:580) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.de.services.impl.QueryServiceImpl$AjcClosure19.run(QueryServiceImpl.java:1) ~[classes/:master-migrated-1.0.7]
at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:179) ~[aspectjrt-1.9.19.jar:?]
at com.krishagni.catissueplus.core.common.TransactionalInterceptor$1.doInTransaction(TransactionalInterceptor.java:115) ~[classes/:master-migrated-1.0.7]
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) ~[spring-tx-5.3.22.jar:5.3.22-migrated-1.0.7]
at com.krishagni.catissueplus.core.common.TransactionalInterceptor.doWork0(TransactionalInterceptor.java:107) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.common.TransactionalInterceptor.doWork(TransactionalInterceptor.java:83) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.common.TransactionalInterceptor.ajc$inlineAccessMethod$com_krishagni_catissueplus_core_common_TransactionalInterceptor$com_krishagni_catissueplus_>
at com.krishagni.catissueplus.core.common.TransactionalInterceptor.startTransaction(TransactionalInterceptor.java:69) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.de.services.impl.QueryServiceImpl.getExportDataFile(QueryServiceImpl.java:566) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.administrative.services.impl.ScheduledQueryTask.runQuery_aroundBody0(ScheduledQueryTask.java:66) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.administrative.services.impl.ScheduledQueryTask$AjcClosure1.run(ScheduledQueryTask.java:1) ~[classes/:master-migrated-1.0.7]
at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:179) ~[aspectjrt-1.9.19.jar:?]
at com.krishagni.catissueplus.core.common.TransactionalInterceptor$1.doInTransaction(TransactionalInterceptor.java:115) ~[classes/:master-migrated-1.0.7]
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) ~[spring-tx-5.3.22.jar:5.3.22-migrated-1.0.7]
at com.krishagni.catissueplus.core.common.TransactionalInterceptor.doWork0(TransactionalInterceptor.java:107) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.common.TransactionalInterceptor.doWork(TransactionalInterceptor.java:83) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.common.TransactionalInterceptor.ajc$inlineAccessMethod$com_krishagni_catissueplus_core_common_TransactionalInterceptor$com_krishagni_catissueplus_>
at com.krishagni.catissueplus.core.common.TransactionalInterceptor.startTransaction(TransactionalInterceptor.java:69) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.administrative.services.impl.ScheduledQueryTask.runQuery(ScheduledQueryTask.java:39) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.administrative.services.impl.ScheduledQueryTask.doJob(ScheduledQueryTask.java:35) ~[classes/:master-migrated-1.0.7]
at com.krishagni.catissueplus.core.administrative.services.impl.ScheduledTaskWrapper.run(ScheduledTaskWrapper.java:38) ~[classes/:master-migrated-1.0.7]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572) ~[?:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:317) ~[?:?]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304) ~[?:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) ~[?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) ~[?:?]
at java.lang.Thread.run(Thread.java:1583) [?:?]