Hi Saurav, I suspect that the database didn’t get initialized correctly, but then you said you only get this for experiment statistics api calls.
The error is a little misleading, experiment_catalog.EXPERIMENT_SUMMARY is a view, not an actual table. You can try creating it manually with this script: https://github.com/apache/airavata/blob/master/modules/registry/registry-core/src/main/resources/expcatalog-mysql.sql#L232-L238 <https://github.com/apache/airavata/blob/master/modules/registry/registry-core/src/main/resources/expcatalog-mysql.sql#L232-L238> Thanks, Marcus From: saurav kumar jha <imsauravgaurav...@gmail.com> Date: Thursday, July 13, 2023 at 2:26 AM To: Christie, Marcus Aaron <machr...@iu.edu> Cc: dev@airavata.apache.org <dev@airavata.apache.org> Subject: Error while running Airavata locally 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
smime.p7s
Description: S/MIME cryptographic signature