dhis2-users team mailing list archive

["Elmarie Claasen" <elmarie@xxxxxxxx>]

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:elmarie@xxxxxxxx> elmarie@xxxxxxxx

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