[Branch ~dhis2-devs-core/dhis2/trunk] Rev 11453: 1.4 file import, fixed bug related to checking for routine data values out of range.

DHIS_2_Users · 19 July 2013 17:47

revision-diff.txt (667 Bytes)

jason · 25 July 2013 19:10

Hi Lars,
I think you introduced a new bug here as the UNION statement is now incomplete and throws this.

Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:

— The error occurred in sqlmap/routineDataValue.sqlmap.xml.

— The error occurred while executing query.

— Check the SELECT COUNT(*) FROM RoutineData WHERE EntryNumber > 2147483647 UNION .

— Check the SQL Statement (preparation failed).

— Cause: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in query. Incomplete query clause.

Caused by: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in query. Incomplete query clause.

Best regards,

Jason

···

On Fri, Jul 19, 2013 at 7:47 PM, noreply@launchpad.net wrote:

revno: 11453

committer: Lars Helge Øverland larshelge@gmail.com

branch nick: dhis2

timestamp: Fri 2013-07-19 19:47:03 +0200

message:

1.4 file import, fixed bug related to checking for routine data values out of range.

modified:

dhis-2/dhis-services/dhis-service-importexport/src/main/resources/sqlmap/routineDataValue.sqlmap.xml

–

lp:dhis2

https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk

Your team DHIS 2 developers is subscribed to branch lp:dhis2.

To unsubscribe from this branch go to https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription

=== modified file ‘dhis-2/dhis-services/dhis-service-importexport/src/main/resources/sqlmap/routineDataValue.sqlmap.xml’

— dhis-2/dhis-services/dhis-service-importexport/src/main/resources/sqlmap/routineDataValue.sqlmap.xml 2013-02-04 17:48:14 +0000

+++ dhis-2/dhis-services/dhis-service-importexport/src/main/resources/sqlmap/routineDataValue.sqlmap.xml 2013-07-19 17:47:03 +0000

@@ -40,7 +40,6 @@
    <select id="getRoutineDataValuesOutOfRange" resultClass="java.lang.Integer">

            SELECT COUNT(*) FROM RoutineData WHERE EntryNumber > 2147483647 UNION
          SELECT COUNT(*) FROM RoutineDataArchive WHERE EntryNumber > 2147483647

  </select>
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

Lars · 26 July 2013 06:25

Ouch. Fixed in 2.12 and 2.11 now.

Lars

···

On Thu, Jul 25, 2013 at 9:10 PM, Jason Pickering jason.p.pickering@gmail.com wrote: