Urgent - Cannot run newly created indicators

[subodhamanoj]

Cannot run newly created indicators. But previously created indicators seem to rum properly.

HTTP Status 500 - Internal Server Error

type Exception report

messageInternal Server Error

descriptionThe server encountered an internal error that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: javax.ejb.EJBException: An exception occurred while creating a query in EntityManager:
Exception Description: Syntax error parsing [ select count(distinct c) from Client c, ClientEncounterComponentItem i1, ClientEncounterComponentItem i2 where c.id=i1.itemClient.id and c.id=i2.itemClient.id and i1.item=:v1 and and i2.item=:v2 and i2.itemValue=:d2 and c.retired=:f and c.createdAt between :date1 and :date2 and c.person.district=:area ].
[185, 185] The right expression is missing from the logical expression.

root cause

javax.faces.el.EvaluationException: javax.ejb.EJBException: An exception occurred while creating a query in EntityManager:
Exception Description: Syntax error parsing [ select count(distinct c) from Client c, ClientEncounterComponentItem i1, ClientEncounterComponentItem i2 where c.id=i1.itemClient.id and c.id=i2.itemClient.id and i1.item=:v1 and and i2.item=:v2 and i2.itemValue=:d2 and c.retired=:f and c.createdAt between :date1 and :date2 and c.person.district=:area ].
[185, 185] The right expression is missing from the logical expression.

root cause

javax.ejb.EJBException: An exception occurred while creating a query in EntityManager:
Exception Description: Syntax error parsing [ select count(distinct c) from Client c, ClientEncounterComponentItem i1, ClientEncounterComponentItem i2 where c.id=i1.itemClient.id and c.id=i2.itemClient.id and i1.item=:v1 and and i2.item=:v2 and i2.itemValue=:d2 and c.retired=:f and c.createdAt between :date1 and :date2 and c.person.district=:area ].
[185, 185] The right expression is missing from the logical expression.

root cause

java.lang.IllegalArgumentException: An exception occurred while creating a query in EntityManager:
Exception Description: Syntax error parsing [ select count(distinct c) from Client c, ClientEncounterComponentItem i1, ClientEncounterComponentItem i2 where c.id=i1.itemClient.id and c.id=i2.itemClient.id and i1.item=:v1 and and i2.item=:v2 and i2.itemValue=:d2 and c.retired=:f and c.createdAt between :date1 and :date2 and c.person.district=:area ].
[185, 185] The right expression is missing from the logical expression.

root cause

Exception [EclipseLink-0] (Eclipse Persistence Services - 2.7.6.payara-p1): org.eclipse.persistence.exceptions.JPQLException
Exception Description: Syntax error parsing [ select count(distinct c) from Client c, ClientEncounterComponentItem i1, ClientEncounterComponentItem i2 where c.id=i1.itemClient.id and c.id=i2.itemClient.id and i1.item=:v1 and and i2.item=:v2 and i2.itemValue=:d2 and c.retired=:f and c.createdAt between :date1 and :date2 and c.person.district=:area ].
[185, 185] The right expression is missing from the logical expression.

note The full stack traces of the exception and its root causes are available in the Payara Server 5.2020.4 #badassfish logs.
Payara Server 5.2020.4 #badassfish

[diniduhewage]

Can you please add the necessary info to re-create this issue in the application? Like the indicator code.

[subodhamanoj]

Number of male participants with BMI between 18-22.9 Kg/m2 | bmi_17.99to23_male |   |

[subodhamanoj]

Analysis > queries > counts > bmi > Number of male participants with BMI between 18-22.9 Kg/m2

Period: 4th quarter 2020

district: Gampaha

[dilrush14]

Did You upload the file?

[subodhamanoj]

Dr. Buddhika will teach you today !