=== modified file 'dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcEventAnalyticsTableManager.java' --- dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcEventAnalyticsTableManager.java 2013-09-28 11:32:11 +0000 +++ dhis-2/dhis-services/dhis-service-analytics/src/main/java/org/hisp/dhis/analytics/table/JdbcEventAnalyticsTableManager.java 2013-09-30 12:38:29 +0000 @@ -164,7 +164,8 @@ "left join _dateperiodstructure dps on psi.executiondate=dps.dateperiod " + "where psi.executiondate >= '" + start + "' " + "and psi.executiondate <= '" + end + "' " + - "and pr.programid=" + table.getProgram().getId() + ";"; + "and pr.programid=" + table.getProgram().getId() + " " + + "and psi.organisationunitid is not null"; log.info( "Populate SQL: "+ sql );