dhis2-users team mailing list archive

[Marta Vila <martavila@xxxxxxxxx>]

Dear all,

    when I open a chart from the dashboard, it goes to the visualizer, and
loads the chart, but gets blocked loading (please check image attached)

     Also when I try to force it uploading it says one dimension is not
defined because is not picking the org units.

      If I select the orgunit and update, then it´s ok.

Could you please tell me how to avoid this? thanks!

Marta

Working in chrome incognito window with:
Version:
2.13 Build revision:12848 Build date:2013-11-11 02:02

d uidlevel5 in ('f1DjXJZyF5z') and (SixMonthly in ('2011S1')) group by de,co,uid
level5 (Timer.java [SimpleAsyncTaskExecutor-24])
* INFO  2013-11-15 10:36:44,869 Time: 5874 micros: Analytics SQL: select de,co,u
idlevel6, sum(value) as value from analytics_2011 where de in ('gUvSpUrTCCH') an
d uidlevel6 in ('SEhcjvE8IE4', 'd40MODc9TH9') and (SixMonthly in ('2011S1')) gro
up by de,co,uidlevel6 (Timer.java [SimpleAsyncTaskExecutor-26])
* INFO  2013-11-15 10:36:44,871 Time: 8039 micros: Analytics SQL: select de,co,u
idlevel6, sum(value) as value from analytics_2011 where de in ('gUvSpUrTCCH') an
d uidlevel6 in ('SEhcjvE8IE4', 'd40MODc9TH9') and (SixMonthly in ('2011S1')) gro
up by de,co,uidlevel6 (Timer.java [SimpleAsyncTaskExecutor-27])
* INFO  2013-11-15 10:36:44,877 Time: 13401 micros: Analytics SQL: select de,co,
uidlevel5, sum(value) as value from analytics_2011 where de in ('gUvSpUrTCCH') a
nd uidlevel5 in ('f1DjXJZyF5z') and (SixMonthly in ('2011S1')) group by de,co,ui
dlevel5 (Timer.java [SimpleAsyncTaskExecutor-25])
* INFO  2013-11-15 10:36:44,878 Time: 38957 micros: Got aggregated values for qu
ery group (Timer.java [http-bio-8080-exec-9])
* INFO  2013-11-15 10:36:44,880 Time: 40732 micros: Got aggregated values (Timer
.java [http-bio-8080-exec-9])
* INFO  2013-11-15 10:36:44,999 Time: 448 micros: Planned query, got: 4 for opti
mal: 4 (Timer.java [http-bio-8080-exec-3])
* INFO  2013-11-15 10:36:45,005 Time: 4626 micros: Analytics SQL: select de,uidl
evel4, sum(value) as value from analytics_2011 where de in ('gUvSpUrTCCH') and u
idlevel4 in ('k4EyVM131IT', 'hQ44nHlIhW8', 'vabBh5ZqPIs', 'C6hzmaFaH88', 'rqoTrQ
3g388') and (Yearly in ('2011')) group by de,uidlevel4 (Timer.java [SimpleAsyncT
askExecutor-30])
* INFO  2013-11-15 10:36:45,005 Time: 4879 micros: Analytics SQL: select de,uidl
evel4, sum(value) as value from analytics_2011 where de in ('gUvSpUrTCCH') and u
idlevel4 in ('RTDN8Yte0jQ', 'cKbG35hbHwC') and (Yearly in ('2011')) group by de,
uidlevel4 (Timer.java [SimpleAsyncTaskExecutor-31])
* INFO  2013-11-15 10:36:45,005 Time: 4997 micros: Analytics SQL: select de,uidl
evel4, sum(value) as value from analytics_2011 where de in ('gUvSpUrTCCH') and u
idlevel4 in ('u4Idnn89LtY', 'XGPQ2WduCfW', 'S4cPuE2d3dv', 'OCtV1PUshto', 'pBihSf
fHkhT') and (Yearly in ('2011')) group by de,uidlevel4 (Timer.java [SimpleAsyncT
askExecutor-28])
* INFO  2013-11-15 10:36:45,008 Time: 8102 micros: Analytics SQL: select de,uidl
evel4, sum(value) as value from analytics_2011 where de in ('gUvSpUrTCCH') and u
idlevel4 in ('zXcr52pysDR', 'dOfLwJp4HCR', 'ZZ2j0yKuZu8', 'xTki3rdk7cd', 'Y5pHHO
o6Omn') and (Yearly in ('2011')) group by de,uidlevel4 (Timer.java [SimpleAsyncT
askExecutor-29])
* INFO  2013-11-15 10:36:45,008 Time: 9917 micros: Got aggregated values for que
ry group (Timer.java [http-bio-8080-exec-3])
* INFO  2013-11-15 10:36:45,009 Time: 10815 micros: Got aggregated values (Timer
.java [http-bio-8080-exec-3])
* INFO  2013-11-15 10:37:23,363 Login success for user: 'mvila', ip: '0:0:0:0:0:
0:0:1' (DefaultUserAuditService.java [http-bio-8080-exec-8])
* INFO  2013-11-15 10:37:25,004 Time: 3588 micros: Planned query, got: 4 for opt
imal: 4 (Timer.java [http-bio-8080-exec-6])
* INFO  2013-11-15 10:37:25,059 Time: 10354 micros: Analytics SQL: select uidlev
el6,Monthly, sum(value) as value from analytics_2011 where uidlevel6 in ('oceLy4
Ot5fq') and Monthly in ('201101', '201102', '201103', '201104', '201105', '20110
6') and (de in ('pu3Y0KaTHvK')) group by uidlevel6,Monthly (Timer.java [SimpleAs
yncTaskExecutor-34])
* INFO  2013-11-15 10:37:25,064 Time: 15196 micros: Analytics SQL: select uidlev
el6,Monthly, sum(value) as value from analytics_2011 where uidlevel6 in ('BkRAoH
aejFd') and Monthly in ('201101', '201102', '201103', '201104', '201105', '20110
6') and (de in ('pu3Y0KaTHvK')) group by uidlevel6,Monthly (Timer.java [SimpleAs
yncTaskExecutor-32])
* INFO  2013-11-15 10:37:25,070 Time: 7788 micros: Analytics SQL: select uidleve
l6,Monthly, sum(value) as value from analytics_2011 where uidlevel6 in ('npYYzBW
JhC5') and Monthly in ('201101', '201102', '201103', '201104', '201105', '201106
') and (de in ('pu3Y0KaTHvK')) group by uidlevel6,Monthly (Timer.java [SimpleAsy
ncTaskExecutor-35])
* INFO  2013-11-15 10:37:25,070 Time: 15515 micros: Analytics SQL: select uidlev
el6,Monthly, sum(value) as value from analytics_2011 where uidlevel6 in ('JvitVh
tliPb') and Monthly in ('201101', '201102', '201103', '201104', '201105', '20110
6') and (de in ('pu3Y0KaTHvK')) group by uidlevel6,Monthly (Timer.java [SimpleAs
yncTaskExecutor-33])
* INFO  2013-11-15 10:37:25,071 Time: 70572 micros: Got aggregated values for qu
ery group (Timer.java [http-bio-8080-exec-6])
* INFO  2013-11-15 10:37:25,079 Time: 78982 micros: Got aggregated values (Timer
.java [http-bio-8080-exec-6])
* INFO  2013-11-15 10:37:25,638 Time: 4627 micros: Planned query, got: 3 for opt
imal: 4 (Timer.java [http-bio-8080-exec-8])
* INFO  2013-11-15 10:37:25,640 Time: 1752 micros: Planned query, got: 2 for opt
imal: 4 (Timer.java [http-bio-8080-exec-10])
* INFO  2013-11-15 10:37:25,641 Time: 528107 micros: Planned query, got: 2 for o
ptimal: 4 (Timer.java [http-bio-8080-exec-7])
* INFO  2013-11-15 10:37:25,645 Time: 3672 micros: Planned query, got: 4 for opt
imal: 4 (Timer.java [http-bio-8080-exec-3])
* INFO  2013-11-15 10:37:25,646 Time: 4734 micros: Analytics SQL: select uidleve
l6,Monthly, sum(value) as value from analytics_2011 where uidlevel6 in ('BkRAoHa
ejFd') and Monthly in ('201101', '201102', '201103', '201104', '201105', '201106
') and (de in ('N9ZGnqcAACc')) group by uidlevel6,Monthly (Timer.java [SimpleAsy
ncTaskExecutor-36])
* INFO  2013-11-15 10:37:25,653 Time: 5583 micros: Analytics SQL: select uidleve
l5,de, sum(value) as value from analytics_2011 where uidlevel5 in ('f1DjXJZyF5z'
) and de in ('AJ3wRB5Z5O5', 'pu3Y0KaTHvK', 'WmQ87k5TJDA') and (Yearly in ('2011'
)) group by uidlevel5,de (Timer.java [SimpleAsyncTaskExecutor-41])
* INFO  2013-11-15 10:37:25,652 Time: 4582 micros: Analytics SQL: select uidleve
l6,Monthly, sum(value) as value from analytics_2011 where uidlevel6 in ('npYYzBW
JhC5') and Monthly in ('201101', '201102', '201103', '201104', '201105', '201106
') and (de in ('hSnsCblLM8f')) group by uidlevel6,Monthly (Timer.java [SimpleAsy
ncTaskExecutor-43])
* INFO  2013-11-15 10:37:25,662 Time: 6365 micros: Analytics SQL: select uidleve
l5,de, sum(value) as value from analytics_2011 where uidlevel5 in ('f1DjXJZyF5z'
) and de in ('N9ZGnqcAACc', 'rO3iJ1dmuhV', 'gUvSpUrTCCH') and (Yearly in ('2011'
)) group by uidlevel5,de (Timer.java [SimpleAsyncTaskExecutor-45])
* INFO  2013-11-15 10:37:25,661 Time: 14359 micros: Analytics SQL: select de,Mon
thly, sum(value) as value from analytics_2011 where de in ('WmQ87k5TJDA') and Mo
nthly in ('201101', '201102', '201103', '201104', '201105', '201106') and (uidle
vel5 in ('f1DjXJZyF5z')) group by de,Monthly (Timer.java [SimpleAsyncTaskExecuto
r-39])
* INFO  2013-11-15 10:37:25,667 Time: 4933 micros: Analytics SQL: select de,Mont
hly, sum(value) as value from analytics_2011 where de in ('oX7srAXiZyr') and Mon
thly in ('201101', '201102', '201103', '201104', '201105', '201106') and (uidlev
el5 in ('f1DjXJZyF5z')) group by de,Monthly (Timer.java [SimpleAsyncTaskExecutor
-42])
* INFO  2013-11-15 10:37:25,666 Time: 19042 micros: Analytics SQL: select uidlev
el6,Monthly, sum(value) as value from analytics_2011 where uidlevel6 in ('oceLy4
Ot5fq') and Monthly in ('201101', '201102', '201103', '201104', '201105', '20110
6') and (de in ('N9ZGnqcAACc')) group by uidlevel6,Monthly (Timer.java [SimpleAs
yncTaskExecutor-40])
* INFO  2013-11-15 10:37:25,666 Time: 13270 micros: Analytics SQL: select uidlev
el5,de, sum(value) as value from analytics_2011 where uidlevel5 in ('f1DjXJZyF5z
') and de in ('oX7srAXiZyr', 'hhQO2JIX4gM', 'hSnsCblLM8f') and (Yearly in ('2011
')) group by uidlevel5,de (Timer.java [SimpleAsyncTaskExecutor-46])
* INFO  2013-11-15 10:37:25,673 Time: 560243 micros: Got aggregated values for q
uery group (Timer.java [http-bio-8080-exec-7])
* INFO  2013-11-15 10:37:25,672 Time: 15507 micros: Analytics SQL: select uidlev
el5,de, sum(value) as value from analytics_2011 where uidlevel5 in ('f1DjXJZyF5z
') and de in ('UDKS1RWlIKr', 'EfyC8WLPi8S', 'D32s01wHiik') and (Yearly in ('2011
')) group by uidlevel5,de (Timer.java [SimpleAsyncTaskExecutor-44])
* INFO  2013-11-15 10:37:25,667 Time: 10758 micros: Analytics SQL: select uidlev
el6,Monthly, sum(value) as value from analytics_2011 where uidlevel6 in ('BkRAoH
aejFd') and Monthly in ('201101', '201102', '201103', '201104', '201105', '20110
6') and (de in ('hSnsCblLM8f')) group by uidlevel6,Monthly (Timer.java [SimpleAs
yncTaskExecutor-38])
* INFO  2013-11-15 10:37:25,674 Time: 561173 micros: Got aggregated values (Time
r.java [http-bio-8080-exec-7])
* INFO  2013-11-15 10:37:25,673 Time: 5294 micros: Analytics SQL: select uidleve
l6,Monthly, sum(value) as value from analytics_2011 where uidlevel6 in ('JvitVht
liPb') and Monthly in ('201101', '201102', '201103', '201104', '201105', '201106
') and (de in ('N9ZGnqcAACc')) group by uidlevel6,Monthly (Timer.java [SimpleAsy
ncTaskExecutor-37])
* INFO  2013-11-15 10:37:25,675 Time: 36271 micros: Got aggregated values for qu
ery group (Timer.java [http-bio-8080-exec-10])
* INFO  2013-11-15 10:37:25,676 Time: 37163 micros: Got aggregated values (Timer
.java [http-bio-8080-exec-10])
* INFO  2013-11-15 10:37:25,675 Time: 32893 micros: Got aggregated values for qu
ery group (Timer.java [http-bio-8080-exec-3])
* INFO  2013-11-15 10:37:25,676 Time: 42215 micros: Got aggregated values for qu
ery group (Timer.java [http-bio-8080-exec-8])
* INFO  2013-11-15 10:37:25,686 Time: 52962 micros: Got aggregated values (Timer
.java [http-bio-8080-exec-8])
* INFO  2013-11-15 10:37:25,697 Time: 3794 micros: Planned query, got: 2 for opt
imal: 4 (Timer.java [http-bio-8080-exec-5])
* INFO  2013-11-15 10:37:25,686 Time: 44158 micros: Got aggregated values (Timer
.java [http-bio-8080-exec-3])
* INFO  2013-11-15 10:37:25,714 Time: 5440 micros: Analytics SQL: select de,co,M
onthly, sum(value) as value from analytics_2011 where de in ('UDKS1RWlIKr') and
Monthly in ('201101', '201102', '201103', '201104', '201105', '201106') and (uid
level5 in ('f1DjXJZyF5z')) group by de,co,Monthly (Timer.java [SimpleAsyncTaskEx
ecutor-48])
* INFO  2013-11-15 10:37:25,722 Time: 4629 micros: Analytics SQL: select de,co,M
onthly, sum(value) as value from analytics_2011 where de in ('UDKS1RWlIKr') and
Monthly in ('201101', '201102', '201103', '201104', '201105', '201106') and (uid
level5 in ('f1DjXJZyF5z')) group by de,co,Monthly (Timer.java [SimpleAsyncTaskEx
ecutor-47])
* INFO  2013-11-15 10:37:25,761 Time: 67329 micros: Got aggregated values for qu
ery group (Timer.java [http-bio-8080-exec-5])
* INFO  2013-11-15 10:37:25,762 Time: 68226 micros: Got aggregated values (Timer
.java [http-bio-8080-exec-5])
* INFO  2013-11-15 10:37:29,207 Time: 577 micros: Planned query, got: 4 for opti
mal: 4 (Timer.java [http-bio-8080-exec-3])
* INFO  2013-11-15 10:37:29,215 Time: 6160 micros: Analytics SQL: select de,uidl
evel4, sum(value) as value from analytics_2011 where de in ('gUvSpUrTCCH') and u
idlevel4 in ('k4EyVM131IT', 'hQ44nHlIhW8', 'vabBh5ZqPIs', 'C6hzmaFaH88', 'rqoTrQ
3g388') and (Yearly in ('2011')) group by de,uidlevel4 (Timer.java [SimpleAsyncT
askExecutor-51])
* INFO  2013-11-15 10:37:29,222 Time: 9826 micros: Analytics SQL: select de,uidl
evel4, sum(value) as value from analytics_2011 where de in ('gUvSpUrTCCH') and u
idlevel4 in ('zXcr52pysDR', 'dOfLwJp4HCR', 'ZZ2j0yKuZu8', 'xTki3rdk7cd', 'Y5pHHO
o6Omn') and (Yearly in ('2011')) group by de,uidlevel4 (Timer.java [SimpleAsyncT
askExecutor-50])
* INFO  2013-11-15 10:37:29,220 Time: 5545 micros: Analytics SQL: select de,uidl
evel4, sum(value) as value from analytics_2011 where de in ('gUvSpUrTCCH') and u
idlevel4 in ('u4Idnn89LtY', 'XGPQ2WduCfW', 'S4cPuE2d3dv', 'OCtV1PUshto', 'pBihSf
fHkhT') and (Yearly in ('2011')) group by de,uidlevel4 (Timer.java [SimpleAsyncT
askExecutor-49])
* INFO  2013-11-15 10:37:29,218 Time: 8558 micros: Analytics SQL: select de,uidl
evel4, sum(value) as value from analytics_2011 where de in ('gUvSpUrTCCH') and u
idlevel4 in ('RTDN8Yte0jQ', 'cKbG35hbHwC') and (Yearly in ('2011')) group by de,
uidlevel4 (Timer.java [SimpleAsyncTaskExecutor-52])
* INFO  2013-11-15 10:37:29,244 Time: 37336 micros: Got aggregated values for qu
ery group (Timer.java [http-bio-8080-exec-3])
* INFO  2013-11-15 10:37:29,245 Time: 38209 micros: Got aggregated values (Timer
.java [http-bio-8080-exec-3])
* INFO  2013-11-15 10:37:29,282 Split on org unit level: 3 (DefaultQueryPlanner.
java [http-bio-8080-exec-5])
* INFO  2013-11-15 10:37:29,284 Time: 9020 micros: Planned query, got: 3 for opt
imal: 4 (Timer.java [http-bio-8080-exec-5])
* INFO  2013-11-15 10:37:29,285 Time: 6264 micros: Planned query, got: 3 for opt
imal: 4 (Timer.java [http-bio-8080-exec-7])
* INFO  2013-11-15 10:37:29,784 Split on org unit level: 2 (DefaultQueryPlanner.
java [http-bio-8080-exec-8])
* INFO  2013-11-15 10:37:29,800 Time: 17752 micros: Planned query, got: 4 for op
timal: 4 (Timer.java [http-bio-8080-exec-8])
* INFO  2013-11-15 10:37:29,788 Time: 3764 micros: Analytics SQL: select uidleve
l5,Monthly, sum(value) as value from analytics_2011 where uidlevel5 in ('LOG3eqt
wKSI') and Monthly in ('201101', '201102', '201103', '201104', '201105', '201106
') and (de in ('gUvSpUrTCCH')) group by uidlevel5,Monthly (Timer.java [SimpleAsy
ncTaskExecutor-58])
* INFO  2013-11-15 10:37:29,793 Time: 3865 micros: Analytics SQL: select uidleve
l5,Monthly, sum(value) as value from analytics_2011 where uidlevel5 in ('f1DjXJZ
yF5z') and Monthly in ('201101', '201102', '201103', '201104', '201105', '201106
') and (de in ('gUvSpUrTCCH')) group by uidlevel5,Monthly (Timer.java [SimpleAsy
ncTaskExecutor-54])
* INFO  2013-11-15 10:37:29,790 Time: 5472 micros: Analytics SQL: select uidleve
l5,Monthly, sum(value) as value from analytics_2011 where uidlevel5 in ('xXrxdn3
72vb') and Monthly in ('201101', '201102', '201103', '201104', '201105', '201106
') and (de in ('gUvSpUrTCCH')) group by uidlevel5,Monthly (Timer.java [SimpleAsy
ncTaskExecutor-57])
* INFO  2013-11-15 10:37:29,816 Time: 3789 micros: Analytics SQL: select de,co,u
idlevel6, sum(value) as value from analytics_2011 where de in ('gUvSpUrTCCH') an
d uidlevel6 in ('SEhcjvE8IE4', 'd40MODc9TH9') and (SixMonthly in ('2011S1')) gro
up by de,co,uidlevel6 (Timer.java [SimpleAsyncTaskExecutor-62])
* INFO  2013-11-15 10:37:29,789 Time: 3545 micros: Analytics SQL: select uidleve
l6,Monthly, sum(value) as value from analytics_2011 where uidlevel6 in ('SEhcjvE
8IE4', 'd40MODc9TH9') and Monthly in ('201101', '201102', '201103', '201104', '2
01105', '201106') and (de in ('gUvSpUrTCCH')) group by uidlevel6,Monthly (Timer.
java [SimpleAsyncTaskExecutor-55])
* INFO  2013-11-15 10:37:29,813 Time: 4360 micros: Analytics SQL: select de,co,u
idlevel5, sum(value) as value from analytics_2011 where de in ('gUvSpUrTCCH') an
d uidlevel5 in ('f1DjXJZyF5z') and (SixMonthly in ('2011S1')) group by de,co,uid
level5 (Timer.java [SimpleAsyncTaskExecutor-60])
* INFO  2013-11-15 10:37:29,819 Time: 6431 micros: Analytics SQL: select de,co,u
idlevel6, sum(value) as value from analytics_2011 where de in ('gUvSpUrTCCH') an
d uidlevel6 in ('SEhcjvE8IE4', 'd40MODc9TH9') and (SixMonthly in ('2011S1')) gro
up by de,co,uidlevel6 (Timer.java [SimpleAsyncTaskExecutor-61])
* INFO  2013-11-15 10:37:29,812 Time: 5661 micros: Analytics SQL: select de,co,u
idlevel5, sum(value) as value from analytics_2011 where de in ('gUvSpUrTCCH') an
d uidlevel5 in ('f1DjXJZyF5z') and (SixMonthly in ('2011S1')) group by de,co,uid
level5 (Timer.java [SimpleAsyncTaskExecutor-59])
* INFO  2013-11-15 10:37:29,809 Time: 522368 micros: Analytics SQL: select uidle
vel4,Monthly, sum(value) as value from analytics_2011 where uidlevel4 in ('dOfLw
Jp4HCR') and Monthly in ('201101', '201102', '201103', '201104', '201105', '2011
06') and (de in ('gUvSpUrTCCH')) group by uidlevel4,Monthly (Timer.java [SimpleA
syncTaskExecutor-53])
* INFO  2013-11-15 10:37:29,807 Time: 5462 micros: Analytics SQL: select uidleve
l5,Monthly, sum(value) as value from analytics_2011 where uidlevel5 in ('f1DjXJZ
yF5z') and Monthly in ('201101', '201102', '201103', '201104', '201105', '201106
') and (de in ('gUvSpUrTCCH')) group by uidlevel5,Monthly (Timer.java [SimpleAsy
ncTaskExecutor-56])
* INFO  2013-11-15 10:37:29,819 Time: 37060 micros: Got aggregated values for qu
ery group (Timer.java [http-bio-8080-exec-8])
* INFO  2013-11-15 10:37:29,820 Time: 541285 micros: Got aggregated values for q
uery group (Timer.java [http-bio-8080-exec-7])
* INFO  2013-11-15 10:37:29,821 Time: 541731 micros: Got aggregated values (Time
r.java [http-bio-8080-exec-7])
* INFO  2013-11-15 10:37:29,820 Time: 545410 micros: Got aggregated values for q
uery group (Timer.java [http-bio-8080-exec-5])
* INFO  2013-11-15 10:37:29,821 Time: 546601 micros: Got aggregated values (Time
r.java [http-bio-8080-exec-5])
* INFO  2013-11-15 10:37:29,820 Time: 37988 micros: Got aggregated values (Timer
.java [http-bio-8080-exec-8])
* INFO  2013-11-15 10:37:33,279 Time: 4778 micros: Planned query, got: 3 for opt
imal: 4 (Timer.java [http-bio-8080-exec-6])
* INFO  2013-11-15 10:37:33,287 Time: 5316 micros: Analytics SQL: select uidleve
l5,Monthly, sum(value) as value from analytics_2011 where uidlevel5 in ('LOG3eqt
wKSI') and Monthly in ('201101', '201102', '201103', '201104', '201105', '201106
') and (de in ('gUvSpUrTCCH')) group by uidlevel5,Monthly (Timer.java [SimpleAsy
ncTaskExecutor-63])
* INFO  2013-11-15 10:37:33,287 Time: 5213 micros: Analytics SQL: select uidleve
l5,Monthly, sum(value) as value from analytics_2011 where uidlevel5 in ('xXrxdn3
72vb') and Monthly in ('201101', '201102', '201103', '201104', '201105', '201106
') and (de in ('gUvSpUrTCCH')) group by uidlevel5,Monthly (Timer.java [SimpleAsy
ncTaskExecutor-65])
* INFO  2013-11-15 10:37:33,289 Time: 7324 micros: Analytics SQL: select uidleve
l5,Monthly, sum(value) as value from analytics_2011 where uidlevel5 in ('f1DjXJZ
yF5z') and Monthly in ('201101', '201102', '201103', '201104', '201105', '201106
') and (de in ('gUvSpUrTCCH')) group by uidlevel5,Monthly (Timer.java [SimpleAsy
ncTaskExecutor-64])
* INFO  2013-11-15 10:37:33,289 Time: 15100 micros: Got aggregated values for qu
ery group (Timer.java [http-bio-8080-exec-6])
* INFO  2013-11-15 10:37:33,290 Time: 15490 micros: Got aggregated values (Timer
.java [http-bio-8080-exec-6])
* INFO  2013-11-15 10:38:42,943 Split on org unit level: 3 (DefaultQueryPlanner.
java [http-bio-8080-exec-4])
* INFO  2013-11-15 10:38:42,944 Time: 5635 micros: Planned query, got: 3 for opt
imal: 4 (Timer.java [http-bio-8080-exec-4])
* INFO  2013-11-15 10:38:42,950 Time: 4861 micros: Analytics SQL: select uidleve
l5,Monthly, sum(value) as value from analytics_2011 where uidlevel5 in ('f1DjXJZ
yF5z') and Monthly in ('201101', '201102', '201103', '201104', '201105', '201106
') and (de in ('gUvSpUrTCCH')) group by uidlevel5,Monthly (Timer.java [SimpleAsy
ncTaskExecutor-67])
* INFO  2013-11-15 10:38:42,950 Time: 5093 micros: Analytics SQL: select uidleve
l6,Monthly, sum(value) as value from analytics_2011 where uidlevel6 in ('SEhcjvE
8IE4', 'd40MODc9TH9') and Monthly in ('201101', '201102', '201103', '201104', '2
01105', '201106') and (de in ('gUvSpUrTCCH')) group by uidlevel6,Monthly (Timer.
java [SimpleAsyncTaskExecutor-68])
* INFO  2013-11-15 10:38:42,950 Time: 4905 micros: Analytics SQL: select uidleve
l4,Monthly, sum(value) as value from analytics_2011 where uidlevel4 in ('dOfLwJp
4HCR') and Monthly in ('201101', '201102', '201103', '201104', '201105', '201106
') and (de in ('gUvSpUrTCCH')) group by uidlevel4,Monthly (Timer.java [SimpleAsy
ncTaskExecutor-66])
* INFO  2013-11-15 10:38:42,951 Time: 12527 micros: Got aggregated values for qu
ery group (Timer.java [http-bio-8080-exec-4])
* INFO  2013-11-15 10:38:42,951 Time: 12896 micros: Got aggregated values (Timer
.java [http-bio-8080-exec-4])

Attachment: loading chart.jpg
Description: JPEG image