What is type of this error?

Channara · 7 October 2014 03:06

Hi DHIS2 dev,
when i run “Data Visualizer” to view data with bar chart, i got the error “ERROR: column “name” doesn not exist” like below:

···

r.java [http-bio-8090-exec-254])

ERROR 2014-10-07 09:53:51,093 ERROR: column “name” does not exist

Position: 119 (SqlExceptionHelper.java [http-bio-8090-exec-254])

WARN 2014-10-07 09:53:51,249 SQL Error: 0, SQLState: 42703 (SqlExceptionHelpe

r.java [http-bio-8090-exec-268])

ERROR 2014-10-07 09:53:51,249 ERROR: column “name” does not exist

Position: 119 (SqlExceptionHelper.java [http-bio-8090-exec-268])

WARN 2014-10-07 09:53:51,405 SQL Error: 0, SQLState: 42703 (SqlExceptionHelpe

r.java [http-bio-8090-exec-253])

ERROR 2014-10-07 09:53:51,405 ERROR: column “name” does not exist

Position: 119 (SqlExceptionHelper.java [http-bio-8090-exec-253])

WARN 2014-10-07 09:53:52,107 SQL Error: 0, SQLState: 42703 (SqlExceptionHelpe

r.java [http-bio-8090-exec-271])

ERROR 2014-10-07 09:53:52,122 ERROR: column “name” does not exist

Position: 119 (SqlExceptionHelper.java [http-bio-8090-exec-271])

WARN 2014-10-07 09:53:52,122 SQL Error: 0, SQLState: 42703 (SqlExceptionHelpe

r.java [http-bio-8090-exec-268])

ERROR 2014-10-07 09:53:52,122 ERROR: column “name” does not exist

Position: 119 (SqlExceptionHelper.java [http-bio-8090-exec-268])

WARN 2014-10-07 09:54:07,411 SQL Error: 0, SQLState: 42703 (SqlExceptionHelpe

r.java [http-bio-8090-exec-261])

ERROR 2014-10-07 09:54:07,411 ERROR: column “name” does not exist

Position: 119 (SqlExceptionHelper.java [http-bio-8090-exec-261])

WARN 2014-10-07 09:54:07,473 SQL Error: 0, SQLState: 42703 (SqlExceptionHelpe

r.java [http-bio-8090-exec-254])

ERROR 2014-10-07 09:54:07,473 ERROR: column “name” does not exist

Position: 119 (SqlExceptionHelper.java [http-bio-8090-exec-254])

Oct 07, 2014 9:54:08 AM com.hazelcast.util.HealthMonitor

INFO: [10.11.56.129]:5701 [dev] [3.2.1] memory.used=245.5M, memory.free=2.0M, me

mory.total=247.5M, memory.max=247.5M, memory.used/total=99.18%, memory.used/max=

99.18%, load.process=9.00%, load.system=28.00%, load.systemAverage=-100.00%, thr

ead.count=58, thread.peakCount=67, event.q.size=0, executor.q.async.size=0, exec

utor.q.client.size=0, executor.q.operation.size=0, executor.q.query.size=0, exec

utor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0, executo

r.q.operation.size=0, executor.q.priorityOperation.size=0, executor.q.response.s

ize=0, operations.remote.size=0, operations.running.size=0, proxy.count=195, cli

entEndpoint.count=0, connection.active.count=0, connection.count=0

WARN 2014-10-07 09:54:12,356 SQL Error: 0, SQLState: 42703 (SqlExceptionHelpe

r.java [http-bio-8090-exec-275])

ERROR 2014-10-07 09:54:12,356 ERROR: column “name” does not exist

Position: 119 (SqlExceptionHelper.java [http-bio-8090-exec-275])

WARN 2014-10-07 09:54:13,183 SQL Error: 0, SQLState: 42703 (SqlExceptionHelpe

r.java [http-bio-8090-exec-276])

ERROR 2014-10-07 09:54:13,183 ERROR: column “name” does not exist

Position: 119 (SqlExceptionHelper.java [http-bio-8090-exec-276])

Oct 07, 2014 9:54:38 AM com.hazelcast.util.HealthMonitor

INFO: [10.11.56.129]:5701 [dev] [3.2.1] memory.used=246.1M, memory.free=1.4M, me

mory.total=247.5M, memory.max=247.5M, memory.used/total=99.44%, memory.used/max=

99.44%, load.process=6.00%, load.system=9.00%, load.systemAverage=-100.00%, thre

ad.count=58, thread.peakCount=67, event.q.size=0, executor.q.async.size=0, execu

tor.q.client.size=0, executor.q.operation.size=0, executor.q.query.size=0, execu

tor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0, executor

.q.operation.size=0, executor.q.priorityOperation.size=0, executor.q.response.si

ze=0, operations.remote.size=0, operations.running.size=0, proxy.count=195, clie

ntEndpoint.count=0, connection.active.count=0, connection.count=0

INFO 2014-10-07 09:54:47,191 Time: 4899 micros: Planned query, got: 2 for opt

imal: 2 (Timer.java [http-bio-8090-exec-261])

INFO 2014-10-07 09:54:47,191 Time: 5940 micros: Analytics SQL: select “de”,"q

uarterly",“co”, sum(value) as value from analytics_2014 where “de” in ('r5lK6gKH

VIk’) and “quarterly” in (‘2014Q3’) and ( “uidlevel4” in (‘bnSZVWSL22d’) ) group

by “de”,“quarterly”,“co” (Timer.java [SimpleAsyncTaskExecutor-250])

INFO 2014-10-07 09:54:47,191 Time: 5942 micros: Analytics SQL: select “de”,"q

uarterly",“co”, sum(value) as value from analytics_2014 where “de” in ('fWfA7xwR

TG4’) and “quarterly” in (‘2014Q3’) and ( “uidlevel4” in (‘bnSZVWSL22d’) ) group

by “de”,“quarterly”,“co” (Timer.java [SimpleAsyncTaskExecutor-249])

INFO 2014-10-07 09:54:47,191 Time: 13020 micros: Got aggregated values for qu

ery group (Timer.java [http-bio-8090-exec-261])

INFO 2014-10-07 09:54:47,191 Time: 13350 micros: Got aggregated values (Timer

.java [http-bio-8090-exec-261])

Oct 07, 2014 9:55:08 AM com.hazelcast.util.HealthMonitor

INFO: [10.11.56.129]:5701 [dev] [3.2.1] memory.used=239.0M, memory.free=8.5M, me

mory.total=247.5M, memory.max=247.5M, memory.used/total=96.57%, memory.used/max=

96.57%, load.process=7.00%, load.system=12.00%, load.systemAverage=-100.00%, thr

ead.count=57, thread.peakCount=67, event.q.size=0, executor.q.async.size=0, exec

utor.q.client.size=0, executor.q.operation.size=0, executor.q.query.size=0, exec

utor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0, executo

r.q.operation.size=0, executor.q.priorityOperation.size=0, executor.q.response.s

ize=0, operations.remote.size=0, operations.running.size=0, proxy.count=195, cli

entEndpoint.count=0, connection.active.count=0, connection.count=0

INFO 2014-10-07 09:55:29,326 ‘monirath’ update org.hisp.dhis.user.User, name:

Monirath Vun, uid: GbTx1mS6vDB (AuditLogUtil.java [http-bio-8090-exec-271])

INFO 2014-10-07 09:55:29,326 ‘monirath’ update org.hisp.dhis.user.User, name:

Monirath Vun, uid: GbTx1mS6vDB (AuditLogUtil.java [http-bio-8090-exec-271])

INFO 2014-10-07 09:55:30,153 ‘monirath’ update org.hisp.dhis.user.User, name:

Monirath Vun, uid: GbTx1mS6vDB (AuditLogUtil.java [http-bio-8090-exec-271])

INFO 2014-10-07 09:55:30,153 ‘monirath’ update org.hisp.dhis.user.User, name:

Monirath Vun, uid: GbTx1mS6vDB (AuditLogUtil.java [http-bio-8090-exec-271])

Oct 07, 2014 9:55:38 AM com.hazelcast.util.HealthMonitor

INFO: [10.11.56.129]:5701 [dev] [3.2.1] memory.used=245.7M, memory.free=1.8M, me

mory.total=247.5M, memory.max=247.5M, memory.used/total=99.26%, memory.used/max=

99.26%, load.process=4.00%, load.system=4.00%, load.systemAverage=-100.00%, thre

ad.count=58, thread.peakCount=67, event.q.size=0, executor.q.async.size=0, execu

tor.q.client.size=0, executor.q.operation.size=0, executor.q.query.size=0, execu

tor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0, executor

.q.operation.size=0, executor.q.priorityOperation.size=0, executor.q.response.si

ze=0, operations.remote.size=0, operations.running.size=0, proxy.count=195, clie

ntEndpoint.count=0, connection.active.count=0, connection.count=0

INFO 2014-10-07 09:55:44,895 ‘monirath’ update org.hisp.dhis.user.User, name:

Monirath Vun, uid: GbTx1mS6vDB (AuditLogUtil.java [http-bio-8090-exec-271])

INFO 2014-10-07 09:55:44,895 ‘monirath’ update org.hisp.dhis.user.User, name:

Monirath Vun, uid: GbTx1mS6vDB (AuditLogUtil.java [http-bio-8090-exec-271])

Oct 07, 2014 9:56:08 AM com.hazelcast.util.HealthMonitor

INFO: [10.11.56.129]:5701 [dev] [3.2.1] memory.used=246.7M, memory.free=817.4K,

memory.total=247.5M, memory.max=247.5M, memory.used/total=99.68%, memory.used/ma

x=99.68%, load.process=4.00%, load.system=5.00%, load.systemAverage=-100.00%, th

read.count=58, thread.peakCount=67, event.q.size=0, executor.q.async.size=0, exe

cutor.q.client.size=0, executor.q.operation.size=0, executor.q.query.size=0, exe

cutor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0, execut

or.q.operation.size=0, executor.q.priorityOperation.size=0, executor.q.response.

size=0, operations.remote.size=0, operations.running.size=0, proxy.count=195, cl

ientEndpoint.count=0, connection.active.count=0, connection.count=0

INFO 2014-10-07 09:56:11,493 ‘monirath’ update org.hisp.dhis.message.MessageC

onversation, name: Form registered as complete, uid: Y0dztZ4G9h3 (AuditLogUtil.j

ava [http-bio-8090-exec-274])

Oct 07, 2014 9:56:38 AM com.hazelcast.util.HealthMonitor

INFO: [10.11.56.129]:5701 [dev] [3.2.1] memory.used=243.6M, memory.free=3.9M, me

mory.total=247.5M, memory.max=247.5M, memory.used/total=98.41%, memory.used/max=

98.41%, load.process=4.00%, load.system=7.00%, load.systemAverage=-100.00%, thre

ad.count=59, thread.peakCount=67, event.q.size=0, executor.q.async.size=0, execu

tor.q.client.size=0, executor.q.operation.size=0, executor.q.query.size=0, execu

tor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0, executor

.q.operation.size=0, executor.q.priorityOperation.size=0, executor.q.response.si

ze=0, operations.remote.size=0, operations.running.size=0, proxy.count=195, clie

ntEndpoint.count=0, connection.active.count=0, connection.count=0

INFO 2014-10-07 09:56:41,102 ‘monirath’ update org.hisp.dhis.message.MessageC

onversation, name: Form registered as complete, uid: OaNaZJvhc42 (AuditLogUtil.j

ava [http-bio-8090-exec-277])

Oct 07, 2014 9:57:08 AM com.hazelcast.util.HealthMonitor

INFO: [10.11.56.129]:5701 [dev] [3.2.1] memory.used=243.6M, memory.free=3.9M, me

mory.total=247.5M, memory.max=247.5M, memory.used/total=98.42%, memory.used/max=

98.42%, load.process=6.00%, load.system=7.00%, load.systemAverage=-100.00%, thre

ad.count=58, thread.peakCount=67, event.q.size=0, executor.q.async.size=0, execu

tor.q.client.size=0, executor.q.operation.size=0, executor.q.query.size=0, execu

tor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0, executor

.q.operation.size=0, executor.q.priorityOperation.size=0, executor.q.response.si

ze=0, operations.remote.size=0, operations.running.size=0, proxy.count=195, clie

ntEndpoint.count=0, connection.active.count=0, connection.count=0

Oct 07, 2014 9:57:38 AM com.hazelcast.util.HealthMonitor

INFO: [10.11.56.129]:5701 [dev] [3.2.1] memory.used=246.5M, memory.free=998.3K,

memory.total=247.5M, memory.max=247.5M, memory.used/total=99.61%, memory.used/ma

x=99.61%, load.process=3.00%, load.system=5.00%, load.systemAverage=-100.00%, th

read.count=59, thread.peakCount=67, event.q.size=0, executor.q.async.size=0, exe

cutor.q.client.size=0, executor.q.operation.size=0, executor.q.query.size=0, exe

cutor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0, execut

or.q.operation.size=0, executor.q.priorityOperation.size=0, executor.q.response.

size=0, operations.remote.size=0, operations.running.size=0, proxy.count=195, cl

ientEndpoint.count=0, connection.active.count=0, connection.count=0

Oct 07, 2014 9:58:08 AM com.hazelcast.util.HealthMonitor

INFO: [10.11.56.129]:5701 [dev] [3.2.1] memory.used=241.5M, memory.free=6.0M, me

mory.total=247.5M, memory.max=247.5M, memory.used/total=97.60%, memory.used/max=

97.60%, load.process=3.00%, load.system=5.00%, load.systemAverage=-100.00%, thre

ad.count=58, thread.peakCount=67, event.q.size=0, executor.q.async.size=0, execu

tor.q.client.size=0, executor.q.operation.size=0, executor.q.query.size=0, execu

tor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0, executor

.q.operation.size=0, executor.q.priorityOperation.size=0, executor.q.response.si

ze=0, operations.remote.size=0, operations.running.size=0, proxy.count=195, clie

ntEndpoint.count=0, connection.active.count=0, connection.count=0

Oct 07, 2014 9:58:38 AM com.hazelcast.util.HealthMonitor

INFO: [10.11.56.129]:5701 [dev] [3.2.1] memory.used=246.7M, memory.free=824.1K,

memory.total=247.5M, memory.max=247.5M, memory.used/total=99.67%, memory.used/ma

x=99.67%, load.process=1.00%, load.system=2.00%, load.systemAverage=-100.00%, th

read.count=55, thread.peakCount=67, event.q.size=0, executor.q.async.size=0, exe

cutor.q.client.size=0, executor.q.operation.size=0, executor.q.query.size=0, exe

cutor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0, execut

or.q.operation.size=0, executor.q.priorityOperation.size=0, executor.q.response.

size=0, operations.remote.size=0, operations.running.size=0, proxy.count=195, cl

ientEndpoint.count=0, connection.active.count=0, connection.count=0

Oct 07, 2014 9:59:08 AM com.hazelcast.util.HealthMonitor

INFO: [10.11.56.129]:5701 [dev] [3.2.1] memory.used=243.6M, memory.free=3.9M, me

mory.total=247.5M, memory.max=247.5M, memory.used/total=98.42%, memory.used/max=

98.42%, load.process=2.00%, load.system=3.00%, load.systemAverage=-100.00%, thre

ad.count=57, thread.peakCount=67, event.q.size=0, executor.q.async.size=0, execu

tor.q.client.size=0, executor.q.operation.size=0, executor.q.query.size=0, execu

tor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0, executor

.q.operation.size=0, executor.q.priorityOperation.size=0, executor.q.response.si

ze=0, operations.remote.size=0, operations.running.size=0, proxy.count=195, clie

ntEndpoint.count=0, connection.active.count=0, connection.count=0

INFO 2014-10-07 09:59:21,657 ‘monirath’ update org.hisp.dhis.user.User, name:

Monirath Vun, uid: GbTx1mS6vDB (AuditLogUtil.java [http-bio-8090-exec-273])

INFO 2014-10-07 09:59:21,657 ‘monirath’ update org.hisp.dhis.user.User, name:

Monirath Vun, uid: GbTx1mS6vDB (AuditLogUtil.java [http-bio-8090-exec-273])

INFO 2014-10-07 09:59:37,632 ‘monirath’ update org.hisp.dhis.user.User, name:

Monirath Vun, uid: GbTx1mS6vDB (AuditLogUtil.java [http-bio-8090-exec-273])

INFO 2014-10-07 09:59:37,632 ‘monirath’ update org.hisp.dhis.user.User, name:

Monirath Vun, uid: GbTx1mS6vDB (AuditLogUtil.java [http-bio-8090-exec-273])

INFO 2014-10-07 09:59:37,850 ‘monirath’ update org.hisp.dhis.user.User, name:

Monirath Vun, uid: GbTx1mS6vDB (AuditLogUtil.java [http-bio-8090-exec-273])

INFO 2014-10-07 09:59:37,850 ‘monirath’ update org.hisp.dhis.user.User, name:

Monirath Vun, uid: GbTx1mS6vDB (AuditLogUtil.java [http-bio-8090-exec-273])

INFO 2014-10-07 09:59:38,490 ‘monirath’ update org.hisp.dhis.user.User, name:

Monirath Vun, uid: GbTx1mS6vDB (AuditLogUtil.java [http-bio-8090-exec-273])

INFO 2014-10-07 09:59:38,505 ‘monirath’ update org.hisp.dhis.user.User, name:

Monirath Vun, uid: GbTx1mS6vDB (AuditLogUtil.java [http-bio-8090-exec-273])

Oct 07, 2014 9:59:38 AM com.hazelcast.util.HealthMonitor

INFO: [10.11.56.129]:5701 [dev] [3.2.1] memory.used=247.4M, memory.free=104.1K,

memory.total=247.5M, memory.max=247.5M, memory.used/total=99.96%, memory.used/ma

x=99.96%, load.process=6.00%, load.system=7.00%, load.systemAverage=-100.00%, th

read.count=63, thread.peakCount=67, event.q.size=0, executor.q.async.size=0, exe

cutor.q.client.size=0, executor.q.operation.size=0, executor.q.query.size=0, exe

cutor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0, execut

or.q.operation.size=0, executor.q.priorityOperation.size=0, executor.q.response.

size=0, operations.remote.size=0, operations.running.size=0, proxy.count=195, cl

ientEndpoint.count=0, connection.active.count=0, connection.count=0

INFO 2014-10-07 09:59:41,563 ‘monirath’ update org.hisp.dhis.user.User, name:

Monirath Vun, uid: GbTx1mS6vDB (AuditLogUtil.java [http-bio-8090-exec-273])

INFO 2014-10-07 09:59:41,563 ‘monirath’ update org.hisp.dhis.user.User, name:

Monirath Vun, uid: GbTx1mS6vDB (AuditLogUtil.java [http-bio-8090-exec-273])

Oct 07, 2014 10:00:08 AM com.hazelcast.util.HealthMonitor

INFO: [10.11.56.129]:5701 [dev] [3.2.1] memory.used=244.1M, memory.free=3.4M, me

mory.total=247.5M, memory.max=247.5M, memory.used/total=98.63%, memory.used/max=

98.63%, load.process=5.00%, load.system=8.00%, load.systemAverage=-100.00%, thre

ad.count=61, thread.peakCount=67, event.q.size=0, executor.q.async.size=0, execu

tor.q.client.size=0, executor.q.operation.size=0, executor.q.query.size=0, execu

tor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0, executor

.q.operation.size=0, executor.q.priorityOperation.size=0, executor.q.response.si

ze=0, operations.remote.size=0, operations.running.size=0, proxy.count=195, clie

ntEndpoint.count=0, connection.active.count=0, connection.count=0

Oct 07, 2014 10:00:38 AM com.hazelcast.util.HealthMonitor

INFO: [10.11.56.129]:5701 [dev] [3.2.1] memory.used=243.2M, memory.free=4.3M, me

mory.total=247.5M, memory.max=247.5M, memory.used/total=98.28%, memory.used/max=

98.28%, load.process=3.00%, load.system=23.00%, load.systemAverage=-100.00%, thr

ead.count=57, thread.peakCount=67, event.q.size=0, executor.q.async.size=0, exec

utor.q.client.size=0, executor.q.operation.size=0, executor.q.query.size=0, exec

utor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0, executo

r.q.operation.size=0, executor.q.priorityOperation.size=0, executor.q.response.s

ize=0, operations.remote.size=0, operations.running.size=0, proxy.count=195, cli

entEndpoint.count=0, connection.active.count=0, connection.count=0

INFO 2014-10-07 10:00:56,568 Time: 169056 micros: Planned query, got: 2 for o

ptimal: 2 (Timer.java [http-bio-8090-exec-281])

INFO 2014-10-07 10:00:57,239 Time: 671012 micros: Analytics SQL: select “de”,

“quarterly”,“co”, count(value) as value from analytics_2013 where “de” in ('ICeY

pwt7W5t’, ‘JXDqUWrV5sD’) and “quarterly” in (‘2013Q4’) and ( “uidlevel4” in ('CK

Gb2dyPIJo’, ‘dOfq5Zel7JX’, ‘UaUc8I3yulh’, ‘bnSZVWSL22d’, ‘wHnxr0phFAW’, 'viDS7KX

BI9C’, ‘kENhsoPS3Qx’, ‘m4T7WgRZMwU’, ‘ueuTAu08VFm’, ‘NcA7HpabeAG’, ‘pqiEmgwvCBH’

) ) group by “de”,“quarterly”,“co” (Timer.java [SimpleAsyncTaskExecutor-251])

INFO 2014-10-07 10:00:57,239 Time: 5340 micros: Analytics SQL: select “de”,"q

uarterly",“co”, count(value) as value from analytics_2014 where “de” in ('ICeYpw

t7W5t’, ‘JXDqUWrV5sD’) and “quarterly” in (‘2014Q1’, ‘2014Q2’, ‘2014Q3’) and ( "

uidlevel4" in (‘CKGb2dyPIJo’, ‘dOfq5Zel7JX’, ‘UaUc8I3yulh’, ‘bnSZVWSL22d’, 'wHnx

r0phFAW’, ‘viDS7KXBI9C’, ‘kENhsoPS3Qx’, ‘m4T7WgRZMwU’, ‘ueuTAu08VFm’, 'NcA7Hpabe

AG’, ‘pqiEmgwvCBH’) ) group by “de”,“quarterly”,“co” (Timer.java [SimpleAsyncTas

kExecutor-252])

INFO 2014-10-07 10:00:57,239 Time: 845567 micros: Got aggregated values for q

uery group (Timer.java [http-bio-8090-exec-281])

INFO 2014-10-07 10:00:57,254 Time: 10313 micros: Analytics SQL: select “de”,"

quarterly",“co”, sum(value) as value from analytics_2013 where “de” in ('ASE0LsK

W5yx’, ‘AdxXFiuT4ds’, ‘B6p7ZNxgHxX’, ‘BvQ9ct1BR9i’, ‘EagukoGVYRx’, ‘Egvu3JhgZ9r’

, ‘Et6FyKI17tb’, ‘FpXFSK0z1dV’, ‘Frx2wCQ0RZ2’, ‘GS1vpkwJyKF’, ‘GTEDgGAYgi3’, 'He

XWKbx3xM5’, ‘IGCk1kicxd2’, ‘JxXQqqC6nHJ’, ‘KmCxPICselB’, ‘KnC6r5Jx9MH’, 'KpXrktb

pIPZ’, ‘KrF22w0QLOg’, ‘MLBX3LNp4BW’, ‘NlOYmuaFXhA’, ‘ORy65ZftRl7’, ‘OavkximffAT’

, ‘OfN7SyKwl6F’, ‘Q4fH8Ov0qBt’, ‘SCUxZJa8s1M’, ‘SHB83dnAXon’, ‘SwlzUkEwybz’, 'TP

c9REyjhdF’, ‘VZAOnp7tn2M’, ‘VedULjSQITK’, ‘Vm4MXcAtkNn’, ‘Vx62oP4B62Y’, 'Yk37wIK

PeYL’, ‘Z9xaFOIPis7’, ‘ZAWQzoSeWeu’, ‘ZTn7rMjYyjL’, ‘a4uMRdX4SC5’, ‘awQjo0yweto’

, ‘b9JbYwXroJQ’, ‘cGIuOhoZLgT’, ‘e4RYfrqQNtH’, ‘eKvnnHplSW4’, ‘eUgwd3eNeBz’, 'fW

fA7xwRTG4’, ‘ftSpVssjwq5’, ‘gDXNp6PIec6’, ‘gKwRVc5UoPS’, ‘gZqMsTLrVYV’, 'jNPSW9q

aOqn’, ‘jjIm1pZDbxJ’, ‘k13DzYw5tkc’, ‘k58e28uaZpp’, ‘knttBc4QYLG’, ‘lH0abYcMY4y’

, ‘lsTdXf9QS9U’, ‘m1wS2Sxfhms’, ‘odx86VOvLqu’, ‘os6Zcumjuwu’, ‘qGzKX4dceXT’, 'r5

lK6gKHVIk’, ‘s1RMwbGvvmv’, ‘sWhIjX0qBih’, ‘t5twhkjlwat’, ‘tO3yjpnvgru’, 'tUygFmp

vFTR’, ‘tYH9IFLI1SP’, ‘tawurdhoN2l’, ‘ubN8Qd3GaLU’, ‘wUDSzbKNZjK’, ‘wbEXAQRyXQk’

, ‘x56tt8GvJcm’, ‘y79651p6nRH’, ‘yHPDSpuFc8J’, ‘yxE75KH3smz’, ‘zH0mWe4ZcsG’, 'zZ

ZHoeeYVg0’) and “quarterly” in (‘2013Q4’) and ( “uidlevel4” in (‘CKGb2dyPIJo’, ’

dOfq5Zel7JX’, ‘UaUc8I3yulh’, ‘bnSZVWSL22d’, ‘wHnxr0phFAW’, ‘viDS7KXBI9C’, 'kENhs

oPS3Qx’, ‘m4T7WgRZMwU’, ‘ueuTAu08VFm’, ‘NcA7HpabeAG’, ‘pqiEmgwvCBH’) ) group by

“de”,“quarterly”,“co” (Timer.java [SimpleAsyncTaskExecutor-253])

INFO 2014-10-07 10:00:57,254 Time: 14741 micros: Analytics SQL: select “de”,"

quarterly",“co”, sum(value) as value from analytics_2014 where “de” in ('ASE0LsK