dhis2-users team mailing list archive

[Yemi Awe <j2yemi@xxxxxxxxx>]

Dear Developers,
This error is on dhis2.16

*1. Program Stage Completeness*
*Running Program stage completeness returns this error*

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You
have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near 'by ou.name, ps.name,
psi.completeduser, psi.completeddate, psi.status having psi' at line 1



*2. Manual Aggregation (On 2.15 and 2.16)*

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You
have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near 'DOUBLE PRECISION ) )
FROM trackedentitydatavalue pdv     INNER JOIN programstage' at line 1

*3. Error ON Individual Records (2.16)*
ProgramStageInstace Table with column 'STATUS' has a datatype 'INT' but
inserts 'String' like 'ACTIVE', 'COMPLETED'
Workaround is to change the data type to of 'STATUS' column.
With this you data type mismatch getInt(1) error is thrown when running
Program Stage Completeness.


Any quick fix for the above?