Error on creating event analytics aggregated report

Support - Assistance technique
1

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: elmarie@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 . 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 disclaimer@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.