Yemdjih Kaze Nasser created FINERACT-1104: ---------------------------------------------
Summary: 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 {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)