[ https://issues.apache.org/jira/browse/FINERACT-1104?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yemdjih Kaze Nasser reassigned FINERACT-1104: --------------------------------------------- Assignee: Yemdjih Kaze Nasser > Adjust JPQL query in likelihood repository > ------------------------------------------ > > Key: FINERACT-1104 > URL: https://issues.apache.org/jira/browse/FINERACT-1104 > Project: Apache Fineract > Issue Type: Sub-task > Affects Versions: 1.4.0 > Reporter: Yemdjih Kaze Nasser > Assignee: Yemdjih Kaze Nasser > Priority: Blocker > > {code:java} > Caused by: org.eclipse.persistence.exceptions.JPQLException: > Exception Description: Problem compiling [select liklihood FROM Likelihood > liklihood WHERE ppi_name =:ppiName AND id <>:id]. > [49, 57] The identification variable 'ppi_name' is not defined in the FROM > clause. > [73, 75] The identification variable 'id' is not defined in the FROM clause. > at > org.eclipse.persistence.internal.jpa.jpql.HermesParser.buildException(HermesParser.java:157) > ~[org.eclipse.persistence.core-2.7.7.jar:na] > at > org.eclipse.persistence.internal.jpa.jpql.HermesParser.validate(HermesParser.java:349) > ~[org.eclipse.persistence.core-2.7.7.jar:na] > at > org.eclipse.persistence.internal.jpa.jpql.HermesParser.populateQueryImp(HermesParser.java:280) > ~[org.eclipse.persistence.core-2.7.7.jar:na] > at > org.eclipse.persistence.internal.jpa.jpql.HermesParser.buildQuery(HermesParser.java:165) > ~[org.eclipse.persistence.core-2.7.7.jar:na] > at > org.eclipse.persistence.internal.jpa.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:142) > ~[org.eclipse.persistence.jpa-2.7.7.jar:na] > at > org.eclipse.persistence.internal.jpa.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:118) > ~[org.eclipse.persistence.jpa-2.7.7.jar:na] > at > org.eclipse.persistence.internal.jpa.EJBQueryImpl.<init>(EJBQueryImpl.java:104) > ~[org.eclipse.persistence.jpa-2.7.7.jar:na] > at > org.eclipse.persistence.internal.jpa.EJBQueryImpl.<init>(EJBQueryImpl.java:88) > ~[org.eclipse.persistence.jpa-2.7.7.jar:na] > at > org.eclipse.persistence.internal.jpa.EntityManagerImpl.createQuery(EntityManagerImpl.java:1749) > ~[org.eclipse.persistence.jpa-2.7.7.jar:na]{code} -- This message was sent by Atlassian Jira (v8.3.4#803005)