dhis2-users team mailing list archive

[Manaf Abthul <drmanaf79@xxxxxxxxx>]

Hi,

Still continuing this analytic and data mart problem. Still I could not
solve. Please look it......
I am doing customization of DHIS2 for chest clinic on Tracker. Personal
data and manual aggregation are running well. But Report getting
exceptional

*- Process failed: Exception during execution.*

*Please Help me to SOLVE this problem.*

OS - Windows 7
DHIS2 version -2.15
build version-  15143

MySQL, Tomcat

Database Name : edid20nov


 '2014-01-01' and psi.executiondate
 <= '2014-12-31' and pr.programid=2 and psi.organisationunitid is not null
and p
si.executiondate is not null]; nested exception is
com.mysql.jdbc.exceptions.jdb
c4.MySQLSyntaxErrorException: Table 'edit20nov.
*analytics_event_temp_2014_o4umb2rzwlg*' doesn't exist
        at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.d
oTranslate(SQLErrorCodeSQLExceptionTranslator.java:237)



*I have gone through all steps as below,*
update resource tables
data administration >> resource tables

then generate report tables.
CHECKed data mart table update
Data Mart
 Data mart tables update

also, under general settings, set no cache.
also under Data Administration >> Maintenance check all these and press
Perform maintenance,
Maintenance

 Clear analytics tables

 Clear data mart

 Rebuild data mart index

 Clear zero values

 Clear data set completeness

 Prune periods

 Update category option combinations


Thank you

Manaf

instanceid=psi.programstageinstanceid and dataelementid=140 and value regexp '^(
-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `yzVtGos7prA`,(select cast(value as decimal(26
,1)) from trackedentitydatavalue where programstageinstanceid=psi.programstagein
stanceid and dataelementid=123 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$'
) as `cNHOibpXG9i`,(select cast(value as decimal(26,1)) from trackedentitydatava
lue where programstageinstanceid=psi.programstageinstanceid and dataelementid=26
3 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `cQIUx7NRaMV`,(select va
lue from trackedentitydatavalue where programstageinstanceid=psi.programstageins
tanceid and dataelementid=159) as `jcI9kTJRGBf`,(select value from trackedentity
datavalue where programstageinstanceid=psi.programstageinstanceid and dataelemen
tid=273) as `KNMrNwTfZC0`,(select value from trackedentitydatavalue where progra
mstageinstanceid=psi.programstageinstanceid and dataelementid=165) as `C35omLSDy
I0`,(select value from trackedentitydatavalue where programstageinstanceid=psi.p
rogramstageinstanceid and dataelementid=280) as `VJVcyO5r5RP`,(select cast(value
 as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.
programstageinstanceid and dataelementid=91 and value regexp '^(-?[0-9]+)(\.[0-9
]+)?(E\d+)?$') as `ryU6YCXKNYm`,(select value from trackedentitydatavalue where
programstageinstanceid=psi.programstageinstanceid and dataelementid=185) as `otJ
yE8sENqB`,(select value from trackedentitydatavalue where programstageinstanceid
=psi.programstageinstanceid and dataelementid=274) as `wpVdZR9wbJk`,(select valu
e from trackedentitydatavalue where programstageinstanceid=psi.programstageinsta
nceid and dataelementid=269) as `xV22oI1pUU6`,(select value from trackedentityda
tavalue where programstageinstanceid=psi.programstageinstanceid and dataelementi
d=240) as `n5pQDZ7eemQ`,(select value from trackedentitydatavalue where programs
tageinstanceid=psi.programstageinstanceid and dataelementid=169) as `kZA1WP7zgZL
`,(select value from trackedentitydatavalue where programstageinstanceid=psi.pro
gramstageinstanceid and dataelementid=168) as `Fdx2Y5cENJy`,(select cast(value a
s decimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.pr
ogramstageinstanceid and dataelementid=147 and value regexp '^(-?[0-9]+)(\.[0-9]
+)?(E\d+)?$') as `jQ1iQICabmw`,(select value from trackedentitydatavalue where p
rogramstageinstanceid=psi.programstageinstanceid and dataelementid=132) as `dNN0
QwU4xgD`,(select value from trackedentitydatavalue where programstageinstanceid=
psi.programstageinstanceid and dataelementid=266) as `abBIY8NM562`,(select cast(
value as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid
=psi.programstageinstanceid and dataelementid=294 and value regexp '^(-?[0-9]+)(
\.[0-9]+)?(E\d+)?$') as `OLTrKt6aR9l`,(select cast(value as decimal(26,1)) from
trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid a
nd dataelementid=59 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `hNZzR
uMmWey`,(select value from trackedentitydatavalue where programstageinstanceid=p
si.programstageinstanceid and dataelementid=66) as `Iyt4pGBlYMA`,(select value f
rom trackedentitydatavalue where programstageinstanceid=psi.programstageinstance
id and dataelementid=172) as `G4GK3cFwGYl`,(select value from trackedentitydatav
alue where programstageinstanceid=psi.programstageinstanceid and dataelementid=4
28) as `wdDl5V6d1mS`,(select value from trackedentitydatavalue where programstag
einstanceid=psi.programstageinstanceid and dataelementid=53) as `hJQNaIC5z30`,(s
elect value from trackedentitydatavalue where programstageinstanceid=psi.program
stageinstanceid and dataelementid=247) as `mp58Kvm586v`,(select value from track
edentitydatavalue where programstageinstanceid=psi.programstageinstanceid and da
taelementid=260) as `n3i7uA7ZQU5`,(select cast(value as decimal(26,1)) from trac
kedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and d
ataelementid=288 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `B2CqUtKG
ltM`,(select value from trackedentitydatavalue where programstageinstanceid=psi.
programstageinstanceid and dataelementid=61) as `dRg3HFVlzuj`,(select value from
 trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid
and dataelementid=63) as `XjDbbOtfcPu`,(select cast(value as decimal(26,1)) from
 trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid
and dataelementid=143 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `Ie6
Y0i5vUQ3`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where
 programstageinstanceid=psi.programstageinstanceid and dataelementid=110 and val
ue regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `CC5MM0tSLhC`,(select value from
trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid a
nd dataelementid=64) as `JBMlrKmFb0E`,(select value from trackedentitydatavalue
where programstageinstanceid=psi.programstageinstanceid and dataelementid=202) a
s `PegSuAheIzT`,(select value from trackedentitydatavalue where programstageinst
anceid=psi.programstageinstanceid and dataelementid=107) as `BVFShYdAjQq`,(selec
t cast(value as decimal(26,1)) from trackedentitydatavalue where programstageins
tanceid=psi.programstageinstanceid and dataelementid=122 and value regexp '^(-?[
0-9]+)(\.[0-9]+)?(E\d+)?$') as `nbbFmjGD3RW`,(select value from trackedentitydat
avalue where programstageinstanceid=psi.programstageinstanceid and dataelementid
=213) as `hTvGokXDdnf`,(select value from trackedentitydatavalue where programst
ageinstanceid=psi.programstageinstanceid and dataelementid=272) as `Y4fUEVLoK77`
,(select cast(value as decimal(26,1)) from trackedentitydatavalue where programs
tageinstanceid=psi.programstageinstanceid and dataelementid=105 and value regexp
 '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `v2QdJJzLsSE`,(select value from trackeden
titydatavalue where programstageinstanceid=psi.programstageinstanceid and datael
ementid=182) as `oWbQnR59FPD`,(select value from trackedentitydatavalue where pr
ogramstageinstanceid=psi.programstageinstanceid and dataelementid=170) as `uFFWT
BfvK5Z`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where p
rogramstageinstanceid=psi.programstageinstanceid and dataelementid=126 and value
 regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `N87pYfnjJqI`,(select value from tr
ackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and
 dataelementid=259) as `Z8vFfbWWkFi`,(select cast(value as decimal(26,1)) from t
rackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid an
d dataelementid=199 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `q9hKX
gZ4jyA`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where p
rogramstageinstanceid=psi.programstageinstanceid and dataelementid=264 and value
 regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `zeFzoQCl5kj`,(select value from tr
ackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and
 dataelementid=271) as `MverfHXImyQ`,(select value from trackedentitydatavalue w
here programstageinstanceid=psi.programstageinstanceid and dataelementid=208) as
 `zIiGX7Ghj5C`,(select cast(value as decimal(26,1)) from trackedentitydatavalue
where programstageinstanceid=psi.programstageinstanceid and dataelementid=201 an
d value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `aFSUpAkhmrq`,(select value
from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanc
eid and dataelementid=56) as `dvyuLCxYILm`,(select value from trackedentitydatav
alue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2
58) as `IvmpY4rDwdM`,(select cast(value as decimal(26,1)) from trackedentitydata
value where programstageinstanceid=psi.programstageinstanceid and dataelementid=
108 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `aMQPJp9czWr`,(select
cast(value as decimal(26,1)) from trackedentitydatavalue where programstageinsta
nceid=psi.programstageinstanceid and dataelementid=230 and value regexp '^(-?[0-
9]+)(\.[0-9]+)?(E\d+)?$') as `UAN9P2w0LAn`,(select value from trackedentitydatav
alue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2
06) as `Cu4RrO2My0v`,(select value from trackedentitydatavalue where programstag
einstanceid=psi.programstageinstanceid and dataelementid=286) as `KZ27ys4qvNs`,(
select value from trackedentitydatavalue where programstageinstanceid=psi.progra
mstageinstanceid and dataelementid=281) as `asMNb8QPcqa`,(select cast(value as d
ecimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.progr
amstageinstanceid and dataelementid=113 and value regexp '^(-?[0-9]+)(\.[0-9]+)?
(E\d+)?$') as `ZoqXPfCcStl`,(select cast(value as decimal(26,1)) from trackedent
itydatavalue where programstageinstanceid=psi.programstageinstanceid and dataele
mentid=94 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `GBdktmsqeG8`,(s
elect value from trackedentitydatavalue where programstageinstanceid=psi.program
stageinstanceid and dataelementid=291) as `yM0FlWaBvoU`,(select cast(value as de
cimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.progra
mstageinstanceid and dataelementid=100 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(
E\d+)?$') as `RZRneDuWH3b`,(select cast(value as decimal(26,1)) from trackedenti
tydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelem
entid=96 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `AdVH3OEC62X`,(se
lect value from trackedentitydatavalue where programstageinstanceid=psi.programs
tageinstanceid and dataelementid=210) as `Z7Bk20Zkq70`,(select value from tracke
dentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dat
aelementid=207) as `XY386BvsPx1`,(select value from trackedentitydatavalue where
 programstageinstanceid=psi.programstageinstanceid and dataelementid=60) as `oF1
q0UBrycx`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where
 programstageinstanceid=psi.programstageinstanceid and dataelementid=295 and val
ue regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `Qu6Ug6U22k2`,(select value from
trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid a
nd dataelementid=254) as `JduNvjNYOT1`,(select value from trackedentitydatavalue
 where programstageinstanceid=psi.programstageinstanceid and dataelementid=166)
as `LcYuQqAYcOq`,(select value from trackedentitydatavalue where programstageins
tanceid=psi.programstageinstanceid and dataelementid=134) as `ueYrmiRdcGY`,(sele
ct cast(value as decimal(26,1)) from trackedentitydatavalue where programstagein
stanceid=psi.programstageinstanceid and dataelementid=97 and value regexp '^(-?[
0-9]+)(\.[0-9]+)?(E\d+)?$') as `JaGpZBrls7F`,(select cast(value as decimal(26,1)
) from trackedentitydatavalue where programstageinstanceid=psi.programstageinsta
nceid and dataelementid=298 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') a
s `kNcAgQVIqln`,(select cast(value as decimal(26,1)) from trackedentitydatavalue
 where programstageinstanceid=psi.programstageinstanceid and dataelementid=289 a
nd value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `MEfb6GAvF8K`,(select cast(
value as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid
=psi.programstageinstanceid and dataelementid=184 and value regexp '^(-?[0-9]+)(
\.[0-9]+)?(E\d+)?$') as `Is7lOCutYfD`,(select value from trackedentitydatavalue
where programstageinstanceid=psi.programstageinstanceid and dataelementid=186) a
s `WTlKT69Vd9k`,(select value from trackedentitydatavalue where programstageinst
anceid=psi.programstageinstanceid and dataelementid=167) as `ABhSmeme4Pq`,(selec
t cast(value as decimal(26,1)) from trackedentitydatavalue where programstageins
tanceid=psi.programstageinstanceid and dataelementid=142 and value regexp '^(-?[
0-9]+)(\.[0-9]+)?(E\d+)?$') as `ijwvm0pWtLI`,(select cast(value as decimal(26,1)
) from trackedentitydatavalue where programstageinstanceid=psi.programstageinsta
nceid and dataelementid=228 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') a
s `mZlY8Ri3hVG`,(select value from trackedentitydatavalue where programstageinst
anceid=psi.programstageinstanceid and dataelementid=284) as `A8AaLrVexsy`,(selec
t value from trackedentitydatavalue where programstageinstanceid=psi.programstag
einstanceid and dataelementid=69) as `MxxtuWCX43r`,(select value from trackedent
itydatavalue where programstageinstanceid=psi.programstageinstanceid and dataele
mentid=164) as `Faa6dOySgvx`,(select value from trackedentitydatavalue where pro
gramstageinstanceid=psi.programstageinstanceid and dataelementid=51) as `wNsnD7R
cZnA`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where pro
gramstageinstanceid=psi.programstageinstanceid and dataelementid=112 and value r
egexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `WzMcoC8S8j8`,(select cast(value as d
ecimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.progr
amstageinstanceid and dataelementid=127 and value regexp '^(-?[0-9]+)(\.[0-9]+)?
(E\d+)?$') as `Yv9SzhYwCnO`,(select value from trackedentitydatavalue where prog
ramstageinstanceid=psi.programstageinstanceid and dataelementid=212) as `cRXG2eR
FLpd`,(select value from trackedentitydatavalue where programstageinstanceid=psi
.programstageinstanceid and dataelementid=86) as `eWibyDiOry7`,(select cast(valu
e as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi
.programstageinstanceid and dataelementid=200 and value regexp '^(-?[0-9]+)(\.[0
-9]+)?(E\d+)?$') as `pxNlxuLCUzH`,(select cast(value as decimal(26,1)) from trac
kedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and d
ataelementid=99 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `VS6Jp7xBo
b8`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where progr
amstageinstanceid=psi.programstageinstanceid and dataelementid=267 and value reg
exp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `rH1uOSbD8z2`,(select value from tracke
dentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dat
aelementid=426) as `kMCNaQU6njD`,(select value from trackedentitydatavalue where
 programstageinstanceid=psi.programstageinstanceid and dataelementid=278) as `EL
XR55CmpBX`,(select value from trackedentitydatavalue where programstageinstancei
d=psi.programstageinstanceid and dataelementid=283) as `HYDajegbPhF`,(select val
ue from trackedentitydatavalue where programstageinstanceid=psi.programstageinst
anceid and dataelementid=181) as `B8uff5DuLeG`,(select cast(value as decimal(26,
1)) from trackedentitydatavalue where programstageinstanceid=psi.programstageins
tanceid and dataelementid=125 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$')
 as `vAgxd8BYuf4`,(select value from trackedentitydatavalue where programstagein
stanceid=psi.programstageinstanceid and dataelementid=187) as `qThSi7kDP6O`,(sel
ect cast(value as decimal(26,1)) from trackedentitydatavalue where programstagei
nstanceid=psi.programstageinstanceid and dataelementid=144 and value regexp '^(-
?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `waKI0ehvjbO`,(select cast(value as decimal(26,
1)) from trackedentitydatavalue where programstageinstanceid=psi.programstageins
tanceid and dataelementid=90 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$')
as `SRIfNWBFNxh`,(select value from trackedentitydatavalue where programstageins
tanceid=psi.programstageinstanceid and dataelementid=67) as `ekX3a3QkT7O`,(selec
t value from trackedentitydatavalue where programstageinstanceid=psi.programstag
einstanceid and dataelementid=55) as `W8r4E0Kc0Cr`,(select value from trackedent
itydatavalue where programstageinstanceid=psi.programstageinstanceid and dataele
mentid=270) as `NyXbBqcX4fP`,(select value from trackedentitydatavalue where pro
gramstageinstanceid=psi.programstageinstanceid and dataelementid=427) as `h18J0S
aJ2pr`,(select value from trackedentitydatavalue where programstageinstanceid=ps
i.programstageinstanceid and dataelementid=268) as `pNtAUlwEJ5l`,(select value f
rom trackedentitydatavalue where programstageinstanceid=psi.programstageinstance
id and dataelementid=204) as `Pk6SEIAMR2U`,(select cast(value as decimal(26,1))
from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanc
eid and dataelementid=229 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as
`qTSmMLXBggR`,(select value from trackedentitydatavalue where programstageinstan
ceid=psi.programstageinstanceid and dataelementid=261) as `Jkr7UH18LC8`,(select
value from trackedentitydatavalue where programstageinstanceid=psi.programstagei
nstanceid and dataelementid=101) as `zOC0jsw8lqz`,(select value from trackedenti
tydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelem
entid=287) as `PTuJ6PCxIhO`,(select value from trackedentitydatavalue where prog
ramstageinstanceid=psi.programstageinstanceid and dataelementid=209) as `EJIMDmV
esWY`,(select value from trackedentitydatavalue where programstageinstanceid=psi
.programstageinstanceid and dataelementid=214) as `soaXKWYgDBU`,(select value fr
om trackedentitydatavalue where programstageinstanceid=psi.programstageinstancei
d and dataelementid=121) as `odFdaiySJrv`,(select cast(value as decimal(26,1)) f
rom trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityin
stanceid and trackedentityattributeid=10 and value regexp '^(-?[0-9]+)(\.[0-9]+)
?(E\d+)?$') as `cxSW0iD1cDU`,(select value from trackedentityattributevalue wher
e trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributei
d=12) as `wcb7OUyLvcZ`,(select value from trackedentityattributevalue where trac
kedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=1) a
s `Foox7cA7Tuc`,(select cast(value as decimal(26,1)) from trackedentityattribute
value where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentity
attributeid=2 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `qYbJPRKhJDe
`,(select value from trackedentityattributevalue where trackedentityinstanceid=p
i.trackedentityinstanceid and trackedentityattributeid=3) as `WTs2VDclExa`,(sele
ct value from trackedentityattributevalue where trackedentityinstanceid=pi.track
edentityinstanceid and trackedentityattributeid=4) as `ddGoCjE3laS`,(select valu
e from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentit
yinstanceid and trackedentityattributeid=5) as `LpeAxiS7R4P`,(select value from
trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstan
ceid and trackedentityattributeid=6) as `V4psVGc7rQO`,(select value from tracked
entityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid an
d trackedentityattributeid=8) as `TyGGOcqSRV2`,(select value from trackedentitya
ttributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and track
edentityattributeid=7) as `a020e93Z2sS`,(select value from trackedentityattribut
evalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentit
yattributeid=9) as `rsS2OCbBT34`,psi.uid,ps.uid,psi.executiondate,psi.longitude,
psi.latitude,ou.uid,ou.name,ou.code from programstageinstance psi left join prog
raminstance pi on psi.programinstanceid=pi.programinstanceid left join programst
age ps on psi.programstageid=ps.programstageid left join program pr on pi.progra
mid=pr.programid left join trackedentityinstance pa on pi.trackedentityinstancei
d=pa.trackedentityinstanceid left join organisationunit ou on psi.organisationun
itid=ou.organisationunitid left join _orgunitstructure ous on psi.organisationun
itid=ous.organisationunitid left join _dateperiodstructure dps on psi.executiond
ate=dps.dateperiod where psi.executiondate >= '2014-01-01' and psi.executiondate
 <= '2014-12-31' and pr.programid=2 and psi.organisationunitid is not null and p
si.executiondate is not null]; nested exception is com.mysql.jdbc.exceptions.jdb
c4.MySQLSyntaxErrorException: Table 'edit20nov.analytics_event_temp_2014_o4umb2r
zwlg' doesn't exist
        at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.d
oTranslate(SQLErrorCodeSQLExceptionTranslator.java:237)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslat
or.translate(AbstractFallbackSQLExceptionTranslator.java:72)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:
407)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:
428)
        at org.hisp.dhis.analytics.table.JdbcEventAnalyticsTableManager.populate
TableAsync(JdbcEventAnalyticsTableManager.java:184)
        at sun.reflect.GeneratedMethodAccessor717.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:317)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:183)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:150)
        at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(
AsyncExecutionInterceptor.java:95)
        at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        ... 1 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'edi
t20nov.analytics_event_temp_2014_o4umb2rzwlg' doesn't exist
        at sun.reflect.GeneratedConstructorAccessor72.newInstance(Unknown Source
)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
        at com.mysql.jdbc.Util.getInstance(Util.java:386)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:894)
        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:732)
        at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.
java:1006)
        at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.
doInStatement(JdbcTemplate.java:421)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:
396)
        ... 12 more

Attachment: analytic error.jpg
Description: JPEG image