dhis2-users team mailing list archive

[Yemi Awe <j2yemi@xxxxxxxxx>]

I am adding to the above...

Running Analytics Report
Data truncation for column messagetext..
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@xxxxxxxxx> 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.
>
>
> Any quick fix for the above?
>
>