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.
The table message defaults messagetext to 255 char.
The column not given a length value in the jpa entity…please check.
2.16 will not throw any error in the log but will continue to update event table endlessly without terminating.
···
On Fri, Aug 29, 2014 at 9:35 PM, Yemi Awe j2yemi@gmail.com wrote:
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.
On Sat, Aug 30, 2014 at 3:35 AM, Yemi Awe j2yemi@gmail.com wrote:
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.