Hi dear,
Iam new to DHSI2. I cannot download event report. below is the error log from tomcat. The version that I am using is 2.37.11. Appreciate your support.
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select psi.uid as event, psi.created as created, psi.lastupdated as lastUpdated, psi.storedby as storedBy, psi.createdbyuserinfo as createdbyuserinfo, psi.lastupdatedbyuserinfo as lastUpdatedbyuserinfo, psi.completedby as completedBy, psi.completeddate as completedDate, psi.duedate as dueDate, psi.executiondate as eventDate, ou.uid as orgUnit, ou.name as orgUnitName, psi.status as status, pi.uid as enrollment, ps.uid as programStage, p.uid as program, coc.uid as attributeOptionCombo, psi.deleted as deleted, psi.geometry as geometry, psi.eventdatavalues #>> ‘{pJfOInn3mdo, value}’ as pJfOInn3mdo, psi.eventdatavalues #>> ‘{JiFSd9aS0oQ, value}’ as JiFSd9aS0oQ, psi.eventdatavalues #>> ‘{guOVENoeGLE, value}’ as guOVENoeGLE, psi.eventdatavalues #>> ‘{d5cYxhQtqQN, value}’ as d5cYxhQtqQN, psi.eventdatavalues #>> ‘{LQSn73kU3GU, value}’ as LQSn73kU3GU from programstageinstance psi inner join programinstance pi on pi.programinstanceid = psi.programinstanceid inner join program p on p.programid = pi.programid inner join programstage ps on ps.programstageid = psi.programstageid left join users auc on (psi.assigneduserid=auc.userid) left join userinfo au on (auc.userid=au.userinfoid) inner join organisationunit ou on psi.organisationunitid=ou.organisationunitid where ou.organisationunitid = 67 and ps.programstageid = 69 and psi.attributeoptioncomboid = 24 and psi.deleted is false order by eventDate DESC ]; nested exception is org.postgresql.util.PSQLException: ERROR: missing FROM-clause entry for table “coc”
Regards,
Walid
