Thanks Marcus for the help. I forgot to update you about this. Running the script you mentioned manually created the view with uppercase (EXPERIMENT_SUMMARY) and then error was fixed.
By default the view was getting created but it was in lowercase (experiment_summary) . Thanks & Regards, Saurav Kumar Jha On Tue, Jul 18, 2023 at 12:54 AM Christie, Marcus Aaron <machr...@iu.edu> wrote: > 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 > > > > 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 >
