Hi Marcus,
I am getting this error while running airavata locally when an api call for
experiment statistics is made ,
*Table 'experiment_catalog.EXPERIMENT_SUMMARY' doesn't exist*
Here is the full stack trace,
*124 [TThreadPoolServer WorkerProcess-0] ERROR
org.apache.airavata.registry.core.repositories.AbstractRepository {} -
Failed to execute transaction*
*org.apache.openjpa.persistence.ArgumentException: Failed to execute query
"SELECT count(ES.experimentId) FROM ExperimentSummaryEntity ES WHERE
ES.gatewayId = :gatewayId AND ES.creationTime BETWEEN :fromDate AND
:toDate". Check the query syntax for correctness. See nested exception for
details.*
* at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:921)
~[openjpa-3.1.0.jar:3.1.0]*
* at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:843)
~[openjpa-3.1.0.jar:3.1.0]*
* at
org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601)
~[openjpa-3.1.0.jar:3.1.0]*
* at
org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297)
~[openjpa-3.1.0.jar:3.1.0]*
* at
org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314)
~[openjpa-3.1.0.jar:3.1.0]*
* at
org.apache.openjpa.persistence.QueryImpl.getSingleResult(QueryImpl.java:343)
~[openjpa-3.1.0.jar:3.1.0]*
* at
org.apache.airavata.registry.core.repositories.expcatalog.ExperimentSummaryRepository.lambda$getExperimentStatisticsCountForState$0(ExperimentSummaryRepository.java:362)
~[classes/:?]*
* at
org.apache.airavata.registry.core.repositories.AbstractRepository.execute(AbstractRepository.java:141)
~[classes/:?]*
* at
org.apache.airavata.registry.core.repositories.expcatalog.ExperimentSummaryRepository.getExperimentStatisticsCountForState(ExperimentSummaryRepository.java:356)
~[classes/:?]*
* at
org.apache.airavata.registry.core.repositories.expcatalog.ExperimentSummaryRepository.getAccessibleExperimentStatistics(ExperimentSummaryRepository.java:280)
~[classes/:?]*
* at
org.apache.airavata.registry.api.service.handler.RegistryServerHandler.getExperimentStatistics(RegistryServerHandler.java:433)
~[classes/:?]*
* at
org.apache.airavata.registry.api.RegistryService$Processor$getExperimentStatistics.getResult(RegistryService.java:17739)
~[classes/:?]*
* at
org.apache.airavata.registry.api.RegistryService$Processor$getExperimentStatistics.getResult(RegistryService.java:1)
~[classes/:?]*
* at
org.apache.thrift.ProcessFunction.process(ProcessFunction.java:40)
~[libthrift-0.18.1.jar:0.18.1]*
* at
org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:40)
~[libthrift-0.18.1.jar:0.18.1]*
* at
org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:257)
~[libthrift-0.18.1.jar:0.18.1]*
* at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
~[?:?]*
* at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
~[?:?]*
* at java.lang.Thread.run(Thread.java:829) ~[?:?]*
*Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: (conn:268)
Table 'experiment_catalog.EXPERIMENT_SUMMARY' doesn't exist {prepstmnt
900574728 *
Can you please help me in getting it resolved?
Thanks & Regards,
Saurav Kumar Jha
