[ 
https://issues.apache.org/jira/browse/AIRAVATA-2814?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16522756#comment-16522756
 ] 

Marcus Christie commented on AIRAVATA-2814:
-------------------------------------------

The reason this is failing is because we haven't migrated User in 
registry-refactoring. See registry-core Users entity class: 
[https://github.com/apache/airavata/blob/d82842ddcf8ae3a57e74db6fb48e872da8df0a27/modules/registry/registry-core/src/main/java/org/apache/airavata/registry/core/experiment/catalog/model/Users.java#L41-L40]

 

 

> 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 int he 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)

Reply via email to