=== modified file 'dhis-2/dhis-services/dhis-service-tracker/src/main/java/org/hisp/dhis/trackedentity/hibernate/HibernateTrackedEntityInstanceStore.java' --- dhis-2/dhis-services/dhis-service-tracker/src/main/java/org/hisp/dhis/trackedentity/hibernate/HibernateTrackedEntityInstanceStore.java 2014-06-11 14:32:45 +0000 +++ dhis-2/dhis-services/dhis-service-tracker/src/main/java/org/hisp/dhis/trackedentity/hibernate/HibernateTrackedEntityInstanceStore.java 2014-06-11 15:36:16 +0000 @@ -477,7 +477,8 @@ criteria.createAlias( "programInstance.program", "program" ); criteria.add( Restrictions.eq( "program", program ) ); } - + + criteria.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY); Number rs = (Number) criteria.setProjection(Projections.rowCount()).uniqueResult(); return ( rs != null && rs.intValue() > 0 ) ? rs.intValue() : 0;