[
https://issues.apache.org/jira/browse/AIRAVATA-2814?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Marcus Christie resolved AIRAVATA-2814.
---------------------------------------
Resolution: Fixed
> Error: "PersistenceException: Table "PROJECT" has a foreign key to table
> "USERS" that has not been generated."
> --------------------------------------------------------------------------------------------------------------
>
> Key: AIRAVATA-2814
> URL: https://issues.apache.org/jira/browse/AIRAVATA-2814
> Project: Airavata
> Issue Type: Bug
> Reporter: Marcus Christie
> Assignee: Marcus Christie
> Priority: Major
>
> This error occurs in the logs when the API server starts up.
> Stacktrace:
> {noformat}
> 2018-06-06 16:22:34,167 [pool-9-thread-2] ERROR
> o.a.a.r.a.s.h.RegistryServerHandler - default
> java.lang.RuntimeException: Failed to get Experiment Catalog EntityManager
> at
> org.apache.airavata.registry.core.repositories.expcatalog.ExpCatAbstractRepository.execute(ExpCatAbstractRepository.java:95)
> at
> org.apache.airavata.registry.core.repositories.expcatalog.ExpCatAbstractRepository.get(ExpCatAbstractRepository.java:49)
> at
> org.apache.airavata.registry.core.repositories.expcatalog.ExpCatAbstractRepository.isExists(ExpCatAbstractRepository.java:87)
> at
> org.apache.airavata.registry.core.repositories.expcatalog.GatewayRepository.isGatewayExist(GatewayRepository.java:99)
> at
> org.apache.airavata.registry.api.service.handler.RegistryServerHandler.isGatewayExistInternal(RegistryServerHandler.java:4165)
> at
> org.apache.airavata.registry.api.service.handler.RegistryServerHandler.getGatewayResourceProfile(RegistryServerHandler.java:1966)
> at
> org.apache.airavata.registry.api.RegistryService$Processor$getGatewayResourceProfile.getResult(RegistryService.java:17795)
> at
> org.apache.airavata.registry.api.RegistryService$Processor$getGatewayResourceProfile.getResult(RegistryService.java:17779)
> at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
> at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
> at
> org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:748)
> Caused by: org.apache.openjpa.persistence.PersistenceException: Table
> "PROJECT" has a foreign key to table "USERS" that has not been generated.
> You must run the schema generator on all inter-related tables at once.
> at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:559)
> at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:455)
> at
> org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:160)
> at
> org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:164)
> at
> org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:122)
> at
> org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:209)
> at
> org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:156)
> at
> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:227)
> at
> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:154)
> at
> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:60)
> at
> org.apache.airavata.registry.core.utils.JPAUtil.ExpCatalogJPAUtils.getEntityManager(ExpCatalogJPAUtils.java:71)
> at
> org.apache.airavata.registry.core.repositories.expcatalog.ExpCatAbstractRepository.execute(ExpCatAbstractRepository.java:93)
> ... 13 common frames omitted
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
