dhis2.16 SQLSyntax Error

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?

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@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.

Any quick fix for the above?

Hi Yemi,

The 1st and 2st bugs are fixed. Please test them again in your side.

For the 3rd, please stop your web-server and run the statement below in your database directly. And then start your server again.

ALTER TABLE programstageinstance MODIFY status varchar(25);

···

Best regards,


Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com

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.

Any quick fix for the above?


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp