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?
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
