Hi all,
Can you please advise. I am getting an error when generating an aggregate event analytics report that no orgunit is selected but I have selected OULevel2 or specific orgunit. Version: 2.19 Build revision: 19193 Build date: 2015-06-08 02:03 Is this a bug? Here is the log: * INFO 2015-07-02 18:00:53,983 Analytics event aggregate SQL: select count(psi) as value,"uidlevel2","yearly","nTedIw01zlo" from analytics_event_2014_u9fzum7kn38 where Yearly in ('2014') and (uidlevel2 = 'HpotDYGlHB5' ) and ps = 'JyE620hqivI' group by "uidlevel2","yearly","nTedIw01zlo" limit 200001 (JdbcEventAnalyticsManager.java [http-nio-8080-exec-7]) 222 * INFO 2015-07-02 18:00:53,994 Analytics event aggregate SQL: select count(psi) as value,"uidlevel2","yearly","nTedIw01zlo" from analytics_event_2005_u9fzum7kn38 where Yearly in ('2005') and (uidlevel2 = 'HpotDYGlHB5' ) and ps = 'JyE620hqivI' group by "uidlevel2","yearly","nTedIw01zlo" limit 200001 (JdbcEventAnalyticsManager.java [http-nio-8080-exec-7]) 223 * INFO 2015-07-02 18:00:54,003 Analytics event aggregate SQL: select count(psi) as value,"uidlevel2","yearly","nTedIw01zlo" from analytics_event_2009_u9fzum7kn38 where Yearly in ('2009') and (uidlevel2 = 'HpotDYGlHB5' ) and ps = 'JyE620hqivI' group by "uidlevel2","yearly","nTedIw01zlo" limit 200001 (JdbcEventAnalyticsManager.java [http-nio-8080-exec-7]) 224 * INFO 2015-07-02 00:00:01,392 Create category option combo name table SQL: CREATE TABLE _categoryoptioncomboname ( categoryoptioncomboid INTEGER NOT NULL PRIMARY KEY, categoryoptioncomboname VARCHAR(250), approvallevel INTEGER ) (JdbcResourceTableStore.java [taskScheduler-8]) 225 * INFO 2015-07-02 00:00:05,338 Create organisation unit structure table SQL: CREATE TABLE _orgunitstructure ( organisationunitid INTEGER NOT NULL PRIMARY KEY, organisationunituid CHARACTER(11), level INTEGER, "idlevel1" INTEGER, "uidlevel1" CHARACTER(11), "idlevel2" INTEGER, "uidlevel2" CHARACTER(11), "idlevel3" INTEGER, "uidlevel3" CHARACTER(11), "idlevel4" INTEGER, "uidlevel4" CHARACTER(11), "idlevel5" INTEGER, "uidlevel5" CHARACTER(11)); (JdbcResourceTableStore.java [taskScheduler-8]) 226 * INFO 2015-07-02 18:00:54,010 Analytics event aggregate SQL: select count(psi) as value,"uidlevel2","yearly","nTedIw01zlo" from analytics_event_2006_u9fzum7kn38 where Yearly in ('2006') and (uidlevel2 = 'HpotDYGlHB5' ) and ps = 'JyE620hqivI' group by "uidlevel2","yearly","nTedIw01zlo" limit 200001 (JdbcEventAnalyticsManager.java [http-nio-8080-exec-7]) 227 * INFO 2015-07-02 18:00:54,016 Analytics event aggregate SQL: select count(psi) as value,"uidlevel2","yearly","nTedIw01zlo" from analytics_event_2010_u9fzum7kn38 where Yearly in ('2010') and (uidlevel2 = 'HpotDYGlHB5' ) and ps = 'JyE620hqivI' group by "uidlevel2","yearly","nTedIw01zlo" limit 200001 (JdbcEventAnalyticsManager.java [http-nio-8080-exec-7]) 228 * INFO 2015-07-02 18:00:54,091 Analytics event aggregate SQL: select count(psi) as value,"uidlevel2","yearly","nTedIw01zlo" from analytics_event_2015_u9fzum7kn38 where Yearly in ('2015') and (uidlevel2 = 'HpotDYGlHB5' ) and ps = 'JyE620hqivI' group by "uidlevel2","yearly","nTedIw01zlo" limit 200001 (JdbcEventAnalyticsManager.java [http-nio-8080-exec-7]) 229 * INFO 2015-07-02 18:02:48,070 Analytics event aggregate SQL: select count(psi) as value,"quarterly","hSNPdQfyen0" from analytics_event_2015_u9fzum7kn38 where Quarterly in ('2015Q1', '2015Q2') and (uidlevel2 = 'ZtggqMhDag8' or uidlevel2 = 'FJmdnq1nvpE' or uidlevel2 = 'qtVL8gOPChy' or uidlevel2 = 'NNUprRnQh8n' or uidlevel2 = 'WeeW3tgF69f' or uidlevel2 = 'HpotDYGlHB5' or uidlevel2 = 'mjpkDVVnYpi' or uidlevel2 = 'hhdLMd7rMJh' or uidlevel2 = 'qyZArFNP07h' ) and ps = 'JyE620hqivI' group by "quarterly","hSNPdQfyen0" limit 200001 (JdbcEventAnalyticsManager.java [http-nio-8080-exec-11]) 230 * WARN 2015-07-02 18:03:42,831 Validation failed: At least one organisation unit must be specified (DefaultEventQueryPlanner.java [http-nio-8080-exec-9]) 231 * WARN 2015-07-02 18:03:55,446 Validation failed: At least one organisation unit must be specified (DefaultEventQueryPlanner.java [http-nio-8080-exec-1]) 232 * WARN 2015-07-02 18:04:10,715 Validation failed: At least one organisation unit must be specified (DefaultEventQueryPlanner.java [http-nio-8080-exec-6]) 233 * WARN 2015-07-02 18:04:25,775 Validation failed: At least one organisation unit must be specified (DefaultEventQueryPlanner.java [http-nio-8080-exec-12]) Regards, Elmarie Claasen Hisp logo Project Manager Health Information Systems Program Tel: 041-367 1027 Cell: 082 374 2209 E-mail: <mailto:elma...@hisp.org> elma...@hisp.org Skype: elmarie.claasen52 This message and any attachments are subject to a disclaimer published at <http://www.hisp.org/policies.html#comms_disclaimer> http://www.hisp.org/policies.html#comms_disclaimer . Please read the disclaimer before opening any attachment or taking any other action in terms of this electronic transmission. If you cannot access the disclaimer, kindly send an email to <mailto:disclai...@hisp.org> disclai...@hisp.org and a copy will be provided to you. By replying to this e-mail or opening any attachment you agree to be bound by the provisions of the disclaimer.
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp