------------------------------------------------------------ revno: 17774 committer: Halvdan Hoem Grelland <halvda...@gmail.com> branch nick: dhis2 timestamp: Mon 2014-12-22 14:02:42 +0100 message: Fix bug 1404691: wrongly named audit table in orgunit merge query causes merge to fail. modified: dhis-2/dhis-services/dhis-service-administration/src/main/java/org/hisp/dhis/datamerge/jdbc/JdbcDataMergeStore.java
-- 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-administration/src/main/java/org/hisp/dhis/datamerge/jdbc/JdbcDataMergeStore.java' --- dhis-2/dhis-services/dhis-service-administration/src/main/java/org/hisp/dhis/datamerge/jdbc/JdbcDataMergeStore.java 2014-10-16 06:17:19 +0000 +++ dhis-2/dhis-services/dhis-service-administration/src/main/java/org/hisp/dhis/datamerge/jdbc/JdbcDataMergeStore.java 2014-12-22 13:02:42 +0000 @@ -89,8 +89,8 @@ jdbcTemplate.execute( sql ); // Delete remaining source data value audits - - sql = "DELETE FROM datavalue_audit WHERE dataelementid=" + sourceDataElementId + " AND categoryoptioncomboid=" + sourceCategoryOptionComboId + ";"; + + sql = "DELETE FROM datavalueaudit WHERE dataelementid=" + sourceDataElementId + " AND categoryoptioncomboid=" + sourceCategoryOptionComboId + ";"; log.info( sql ); jdbcTemplate.execute( sql ); @@ -125,7 +125,7 @@ // Delete remaining source data value audits - sql = "DELETE FROM datavalue_audit WHERE sourceid=" + sourceId + ";"; + sql = "DELETE FROM datavalueaudit WHERE organisationunitid=" + sourceId + ";"; log.info( sql ); jdbcTemplate.execute( sql );
_______________________________________________ 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