dhis2-users team mailing list archive

Thread
Date

Analytics and data mart tables management ERROR

To: dhis2 <dhis2-users@xxxxxxxxxxxxxxxxxxx>, dhis_bmi4@xxxxxxxxxxxxxxxx, Roshan Hewapathirana <roshanhewapathirana@xxxxxxxxx>, Dr Sumudu BMI <sumuduw00@xxxxxxxxx>, Gayan Yasantha <gayanyp@xxxxxxxxx>, Janaka Wickramarathne <drjanakacw@xxxxxxxxx>
From: Manaf Abthul <drmanaf79@xxxxxxxxx>
Date: Tue, 6 May 2014 17:55:19 +0530

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.*OS - Windows 7
DHIS2 version -2.14
build version-  13859

MySQL, Tomcat

Database Name : ccd

Catalina........

*4-01-01' and pe.startdate <= '2014-12-31' and dv.value is not null and
dv.value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$' and ( dv.value != '0' or
de.aggregationtype = 'average' or de.zeroissignificant = true ) ]; nested
exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
Table 'ccd.analytics_temp_2014' doesn't exist     at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:237)at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)*

What is the table called *'ccd.analytics_temp_2014'*




*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

* INFO  2014-05-06 17:27:00,651 Indicator group set table generated (DefaultResourceTableService.jav
a [taskScheduler-1])
* INFO  2014-05-06 17:27:00,663 Create organisation unit group set table SQL: CREATE TABLE _organisa
tionunitgroupsetstructure ( organisationunitid INTEGER NOT NULL, organisationunitname VARCHAR (250),
 PRIMARY KEY ( organisationunitid ) ) (CreateOrganisationUnitGroupSetTableStatement.java [taskSchedu
ler-1])
* INFO  2014-05-06 17:27:00,811 Organisation unit group set table generated (DefaultResourceTableSer
vice.java [taskScheduler-1])
* INFO  2014-05-06 17:27:00,828 Create category structure table SQL: CREATE TABLE _categorystructure
 ( categoryoptioncomboid INTEGER NOT NULL, categoryoptioncomboname VARCHAR (250), `B Col topic` VARC
HAR (250), `WvNFDG5pBMT` CHARACTER(11), `B Row topic` VARCHAR (250), `bcs7hyi7f3E` CHARACTER(11), `d
efault` VARCHAR (250), `gUs78yDHiln` CHARACTER(11), `DOT Row` VARCHAR (250), `h29alPJQqlq` CHARACTER
(11), `DOT Type of facility` VARCHAR (250), `e058cViWxQM` CHARACTER(11), `Number of attendance` VARC
HAR (250), `Hjvita2Oo2h` CHARACTER(11), `Symptoms` VARCHAR (250), `db9FrNsl2oP` CHARACTER(11), `TB4-
Col Data` VARCHAR (250), `BuDkTOfzJp1` CHARACTER(11), `TB4-Row Data` VARCHAR (250), `WXb3lTtRI23` CH
ARACTER(11), `Type of facility` VARCHAR (250), `jek13zBNmMv` CHARACTER(11), PRIMARY KEY ( categoryop
tioncomboid ) ) (CreateCategoryTableStatement.java [taskScheduler-1])
* INFO  2014-05-06 17:27:00,890 Category table generated (DefaultResourceTableService.java [taskSche
duler-1])
* INFO  2014-05-06 17:27:00,924 Create data element structure SQL: CREATE TABLE _dataelementstructur
e ( dataelementid INTEGER NOT NULL PRIMARY KEY, dataelementname VARCHAR(250), periodtypeid INTEGER,
periodtypename VARCHAR(250) ) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2014-05-06 17:27:01,287 Data element table generated (DefaultResourceTableService.java [task
Scheduler-1])
* INFO  2014-05-06 17:27:01,307 Create period structure SQL: CREATE TABLE _periodstructure (periodid
 INTEGER NOT NULL PRIMARY KEY, iso VARCHAR(10) NOT NULL, daysno INTEGER NOT NULL, `daily` VARCHAR(10
), `weekly` VARCHAR(10), `monthly` VARCHAR(10), `bimonthly` VARCHAR(10), `quarterly` VARCHAR(10), `s
ixmonthly` VARCHAR(10), `yearly` VARCHAR(10), `financialapril` VARCHAR(10), `financialjuly` VARCHAR(
10), `financialoct` VARCHAR(10)) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2014-05-06 17:27:01,338 Date period table generated (DefaultResourceTableService.java [taskS
cheduler-1])
* INFO  2014-05-06 17:27:01,372 Create date period structure SQL: CREATE TABLE _dateperiodstructure
(dateperiod DATE NOT NULL PRIMARY KEY, `daily` VARCHAR(10), `weekly` VARCHAR(10), `monthly` VARCHAR(
10), `bimonthly` VARCHAR(10), `quarterly` VARCHAR(10), `sixmonthly` VARCHAR(10), `yearly` VARCHAR(10
), `financialapril` VARCHAR(10), `financialjuly` VARCHAR(10), `financialoct` VARCHAR(10)) (JdbcResou
rceTableStore.java [taskScheduler-1])
* INFO  2014-05-06 17:27:17,617 Period table generated (DefaultResourceTableService.java [taskSchedu
ler-1])
* INFO  2014-05-06 17:27:17,689 Create data element category option combo SQL: CREATE TABLE _dataele
mentcategoryoptioncombo (dataelementuid VARCHAR(11) NOT NULL, categoryoptioncombouid VARCHAR(11) NOT
 NULL) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2014-05-06 17:27:17,691 Insert data element category option combo SQL: insert into _dataelem
entcategoryoptioncombo (dataelementuid, categoryoptioncombouid) select de.uid as dataelementuid, coc
.uid as categoryoptioncombouid from dataelement de join categorycombos_optioncombos cc on de.categor
ycomboid = cc.categorycomboid join categoryoptioncombo coc on cc.categoryoptioncomboid = coc.categor
yoptioncomboid (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2014-05-06 17:27:17,730 Create data element category option combo index SQL: CREATE INDEX da
taelement_categoryoptioncombo ON _dataelementcategoryoptioncombo (dataelementuid, categoryoptioncomb
ouid) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2014-05-06 17:27:17,764 Data element category option combo table generated (DefaultResourceT
ableService.java [taskScheduler-1])
* INFO  2014-05-06 17:27:17,767 [Level: INFO, category: DATAMART, time: Tue May 06 17:27:17 IST 2014
, message: Updating resource tables] (InMemoryNotifier.java [taskScheduler-1])
* INFO  2014-05-06 17:27:17,774 Create organisation unit structure table SQL: CREATE TABLE _orgunits
tructure ( organisationunitid INTEGER NOT NULL PRIMARY KEY, level INTEGER, `idlevel1` INTEGER, `uidl
evel1` CHARACTER(11), `idlevel2` INTEGER, `uidlevel2` CHARACTER(11), `idlevel3` INTEGER, `uidlevel3`
 CHARACTER(11), `idlevel4` INTEGER, `uidlevel4` CHARACTER(11)); (JdbcResourceTableStore.java [taskSc
heduler-1])
* INFO  2014-05-06 17:27:17,826 Organisation unit structure table generated (DefaultResourceTableSer
vice.java [taskScheduler-1])
* INFO  2014-05-06 17:27:17,833 Create category option combo name table SQL: CREATE TABLE _categoryo
ptioncomboname ( categoryoptioncomboid INTEGER NOT NULL PRIMARY KEY, categoryoptioncomboname VARCHAR
(250) ) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2014-05-06 17:27:17,901 Category option combo name table generated (DefaultResourceTableServ
ice.java [taskScheduler-1])
* INFO  2014-05-06 17:27:17,941 Create data element group set table SQL: CREATE TABLE _dataelementgr
oupsetstructure ( dataelementid INTEGER NOT NULL, dataelementname VARCHAR (250), `A-Atopic co-morbid
ities` VARCHAR (250), `bTpwOBGvRW8` CHARACTER(11), `A-Clinic visit records` VARCHAR (250), `AvWDtKXN
3wt` CHARACTER(11), `A-Investigation` VARCHAR (250), `NB6f3JSFVkd` CHARACTER(11), `A-Medication Hist
ory` VARCHAR (250), `ZIHLjkJxPqs` CHARACTER(11), `A-Non atopic co-morbiditis` VARCHAR (250), `ogBMb2
HyNAs` CHARACTER(11), `A-ObjAssessment & Examination` VARCHAR (250), `dxnZrikZ0xl` CHARACTER(11), `A
-Other History` VARCHAR (250), `sjzYRXaK0vG` CHARACTER(11), `A-Respiratory History` VARCHAR (250), `
jEZhI6OlWx8` CHARACTER(11), `A-Treatment Plan` VARCHAR (250), `gl38UqmR94H` CHARACTER(11), `C-COPD C
linic Visit` VARCHAR (250), `XIHWcZTHR8f` CHARACTER(11), `C-COPD First Registration` VARCHAR (250),
`rTVAhHnxQ3R` CHARACTER(11), PRIMARY KEY ( dataelementid ) ) (CreateDataElementGroupSetTableStatemen
t.java [taskScheduler-1])
* INFO  2014-05-06 17:27:18,238 Data element group set table generated (DefaultResourceTableService.
java [taskScheduler-1])
* INFO  2014-05-06 17:27:18,258 Create indicator group set table SQL: CREATE TABLE _indicatorgroupse
tstructure ( indicatorid INTEGER NOT NULL, indicatorname VARCHAR (250), PRIMARY KEY ( indicatorid )
) (CreateIndicatorGroupSetTableStatement.java [taskScheduler-1])
* INFO  2014-05-06 17:27:18,277 Indicator group set table generated (DefaultResourceTableService.jav
a [taskScheduler-1])
* INFO  2014-05-06 17:27:18,288 Create organisation unit group set table SQL: CREATE TABLE _organisa
tionunitgroupsetstructure ( organisationunitid INTEGER NOT NULL, organisationunitname VARCHAR (250),
 PRIMARY KEY ( organisationunitid ) ) (CreateOrganisationUnitGroupSetTableStatement.java [taskSchedu
ler-1])
* INFO  2014-05-06 17:27:18,332 Organisation unit group set table generated (DefaultResourceTableSer
vice.java [taskScheduler-1])
* INFO  2014-05-06 17:27:18,342 Create category structure table SQL: CREATE TABLE _categorystructure
 ( categoryoptioncomboid INTEGER NOT NULL, categoryoptioncomboname VARCHAR (250), `B Col topic` VARC
HAR (250), `WvNFDG5pBMT` CHARACTER(11), `B Row topic` VARCHAR (250), `bcs7hyi7f3E` CHARACTER(11), `d
efault` VARCHAR (250), `gUs78yDHiln` CHARACTER(11), `DOT Row` VARCHAR (250), `h29alPJQqlq` CHARACTER
(11), `DOT Type of facility` VARCHAR (250), `e058cViWxQM` CHARACTER(11), `Number of attendance` VARC
HAR (250), `Hjvita2Oo2h` CHARACTER(11), `Symptoms` VARCHAR (250), `db9FrNsl2oP` CHARACTER(11), `TB4-
Col Data` VARCHAR (250), `BuDkTOfzJp1` CHARACTER(11), `TB4-Row Data` VARCHAR (250), `WXb3lTtRI23` CH
ARACTER(11), `Type of facility` VARCHAR (250), `jek13zBNmMv` CHARACTER(11), PRIMARY KEY ( categoryop
tioncomboid ) ) (CreateCategoryTableStatement.java [taskScheduler-1])
* INFO  2014-05-06 17:27:18,385 Category table generated (DefaultResourceTableService.java [taskSche
duler-1])
* INFO  2014-05-06 17:27:18,436 Create data element structure SQL: CREATE TABLE _dataelementstructur
e ( dataelementid INTEGER NOT NULL PRIMARY KEY, dataelementname VARCHAR(250), periodtypeid INTEGER,
periodtypename VARCHAR(250) ) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2014-05-06 17:27:18,675 Data element table generated (DefaultResourceTableService.java [task
Scheduler-1])
* INFO  2014-05-06 17:27:18,694 Create period structure SQL: CREATE TABLE _periodstructure (periodid
 INTEGER NOT NULL PRIMARY KEY, iso VARCHAR(10) NOT NULL, daysno INTEGER NOT NULL, `daily` VARCHAR(10
), `weekly` VARCHAR(10), `monthly` VARCHAR(10), `bimonthly` VARCHAR(10), `quarterly` VARCHAR(10), `s
ixmonthly` VARCHAR(10), `yearly` VARCHAR(10), `financialapril` VARCHAR(10), `financialjuly` VARCHAR(
10), `financialoct` VARCHAR(10)) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2014-05-06 17:27:18,707 Date period table generated (DefaultResourceTableService.java [taskS
cheduler-1])
* INFO  2014-05-06 17:27:18,716 Create date period structure SQL: CREATE TABLE _dateperiodstructure
(dateperiod DATE NOT NULL PRIMARY KEY, `daily` VARCHAR(10), `weekly` VARCHAR(10), `monthly` VARCHAR(
10), `bimonthly` VARCHAR(10), `quarterly` VARCHAR(10), `sixmonthly` VARCHAR(10), `yearly` VARCHAR(10
), `financialapril` VARCHAR(10), `financialjuly` VARCHAR(10), `financialoct` VARCHAR(10)) (JdbcResou
rceTableStore.java [taskScheduler-1])
* INFO  2014-05-06 17:27:36,327 Period table generated (DefaultResourceTableService.java [taskSchedu
ler-1])
* INFO  2014-05-06 17:27:36,341 Create data element category option combo SQL: CREATE TABLE _dataele
mentcategoryoptioncombo (dataelementuid VARCHAR(11) NOT NULL, categoryoptioncombouid VARCHAR(11) NOT
 NULL) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2014-05-06 17:27:36,343 Insert data element category option combo SQL: insert into _dataelem
entcategoryoptioncombo (dataelementuid, categoryoptioncombouid) select de.uid as dataelementuid, coc
.uid as categoryoptioncombouid from dataelement de join categorycombos_optioncombos cc on de.categor
ycomboid = cc.categorycomboid join categoryoptioncombo coc on cc.categoryoptioncomboid = coc.categor
yoptioncomboid (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2014-05-06 17:27:36,434 Create data element category option combo index SQL: CREATE INDEX da
taelement_categoryoptioncombo ON _dataelementcategoryoptioncombo (dataelementuid, categoryoptioncomb
ouid) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2014-05-06 17:27:36,466 Data element category option combo table generated (DefaultResourceT
ableService.java [taskScheduler-1])
* INFO  2014-05-06 17:27:36,469 [Level: INFO, category: DATAMART, time: Tue May 06 17:27:36 IST 2014
, message: Updating analytics tables] (InMemoryNotifier.java [taskScheduler-1])
* INFO  2014-05-06 17:27:36,471 Starting update, no of processes: 2: 0:00:00.000 (Clock.java [taskSc
heduler-1])
* INFO  2014-05-06 17:27:36,473 Get tables using earliest: 2014-04-01 00:00:00.0, latest: 2014-05-31
 00:00:00.0 (AbstractJdbcTableManager.java [taskScheduler-1])
* INFO  2014-05-06 17:27:36,478 Partition tables: [analytics_2014], last 3 years: false: 0:00:00.007
 (Clock.java [taskScheduler-1])
* INFO  2014-05-06 17:27:36,479 [Level: INFO, category: DATAMART, time: Tue May 06 17:27:36 IST 2014
, message: Creating analytics tables] (InMemoryNotifier.java [taskScheduler-1])
* INFO  2014-05-06 17:27:36,504 Create SQL: create table analytics_temp_2014 (`bTpwOBGvRW8` characte
r(11),`jEZhI6OlWx8` character(11),`ogBMb2HyNAs` character(11),`sjzYRXaK0vG` character(11),`ZIHLjkJxP
qs` character(11),`dxnZrikZ0xl` character(11),`NB6f3JSFVkd` character(11),`gl38UqmR94H` character(11
),`AvWDtKXN3wt` character(11),`rTVAhHnxQ3R` character(11),`XIHWcZTHR8f` character(11),`uidlevel1` ch
aracter(11),`uidlevel1` character(11),`uidlevel2` character(11),`uidlevel2` character(11),`uidlevel3
` character(11),`uidlevel4` character(11),`daily` character varying(10),`weekly` character varying(1
0),`monthly` character varying(10),`bimonthly` character varying(10),`quarterly` character varying(1
0),`sixmonthly` character varying(10),`yearly` character varying(10),`financialapril` character vary
ing(10),`financialjuly` character varying(10),`financialoct` character varying(10),`de` character(11
) not null,`co` character(11) not null,`level` integer,daysxvalue decimal(26,1), daysno integer not
null, value decimal(26,1))  (JdbcAnalyticsTableManager.java [taskScheduler-1])
* INFO  2014-05-06 17:27:36,514 Created analytics tables: 0:00:00.043 (Clock.java [taskScheduler-1])

* INFO  2014-05-06 17:27:36,516 [Level: INFO, category: DATAMART, time: Tue May 06 17:27:36 IST 2014
, message: Populating analytics tables] (InMemoryNotifier.java [taskScheduler-1])
* INFO  2014-05-06 17:27:36,517 Populate table task number: 1 (DefaultAnalyticsTableService.java [ta
skScheduler-1])
* INFO  2014-05-06 17:27:36,540 Populate SQL: insert into analytics_temp_2014 (`bTpwOBGvRW8`,`jEZhI6
OlWx8`,`ogBMb2HyNAs`,`sjzYRXaK0vG`,`ZIHLjkJxPqs`,`dxnZrikZ0xl`,`NB6f3JSFVkd`,`gl38UqmR94H`,`AvWDtKXN
3wt`,`rTVAhHnxQ3R`,`XIHWcZTHR8f`,`uidlevel1`,`uidlevel1`,`uidlevel2`,`uidlevel2`,`uidlevel3`,`uidlev
el4`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`yearly`,`financialapril`,`fina
ncialjuly`,`financialoct`,`de`,`co`,`level`,daysxvalue, daysno, value) select degs.`bTpwOBGvRW8`,deg
s.`jEZhI6OlWx8`,degs.`ogBMb2HyNAs`,degs.`sjzYRXaK0vG`,degs.`ZIHLjkJxPqs`,degs.`dxnZrikZ0xl`,degs.`NB
6f3JSFVkd`,degs.`gl38UqmR94H`,degs.`AvWDtKXN3wt`,degs.`rTVAhHnxQ3R`,degs.`XIHWcZTHR8f`,ous.`uidlevel
1`,ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel2`,ous.`uidlevel3`,ous.`uidlevel4`,ps.`daily`,ps.`we
ekly`,ps.`monthly`,ps.`bimonthly`,ps.`quarterly`,ps.`sixmonthly`,ps.`yearly`,ps.`financialapril`,ps.
`financialjuly`,ps.`financialoct`,de.uid,co.uid,ous.level,cast(dv.value as decimal(26,1)) * ps.daysn
o as daysxvalue, ps.daysno as daysno, cast(dv.value as decimal(26,1)) as value from datavalue dv lef
t join _dataelementgroupsetstructure degs on dv.dataelementid=degs.dataelementid left join _organisa
tionunitgroupsetstructure ougs on dv.sourceid=ougs.organisationunitid left join _categorystructure d
cs on dv.categoryoptioncomboid=dcs.categoryoptioncomboid left join _categorystructure acs on dv.attr
ibuteoptioncomboid=acs.categoryoptioncomboid left join _orgunitstructure ous on dv.sourceid=ous.orga
nisationunitid left join _periodstructure ps on dv.periodid=ps.periodid left join dataelement de on
dv.dataelementid=de.dataelementid left join categoryoptioncombo co on dv.categoryoptioncomboid=co.ca
tegoryoptioncomboid left join period pe on dv.periodid=pe.periodid where de.valuetype = 'int' and de
.domaintype = 'aggregate' and pe.startdate >= '2014-01-01' and pe.startdate <= '2014-12-31' and dv.v
alue is not null and dv.value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$' and ( dv.value != '0' or de.ag
gregationtype = 'average' or de.zeroissignificant = true )  (JdbcAnalyticsTableManager.java [SimpleA
syncTaskExecutor-65])
* INFO  2014-05-06 17:27:36,553 [Level: ERROR, category: DATAMART, time: Tue May 06 17:27:36 IST 201
4, message: Process failed: Exception during execution] (InMemoryNotifier.java [taskScheduler-1])
* ERROR 2014-05-06 17:27:36,569 Unexpected error occurred in scheduled task. (TaskUtils.java [taskSc
heduler-1])
java.lang.RuntimeException: Exception during execution
        at org.hisp.dhis.system.util.ConcurrentUtils.waitForCompletion(ConcurrentUtils.java:55)
        at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.populateTables(DefaultAnalytic
sTableService.java:198)
        at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.update(DefaultAnalyticsTableSe
rvice.java:113)
        at org.hisp.dhis.analytics.scheduling.AnalyticsTableTask.run(AnalyticsTableTask.java:120)
        at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)
        at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErro
rHandlingRunnable.java:53)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown S
ource)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
Caused by: java.util.concurrent.ExecutionException: org.springframework.jdbc.BadSqlGrammarException:
 StatementCallback; bad SQL grammar [insert into analytics_temp_2014 (`bTpwOBGvRW8`,`jEZhI6OlWx8`,`o
gBMb2HyNAs`,`sjzYRXaK0vG`,`ZIHLjkJxPqs`,`dxnZrikZ0xl`,`NB6f3JSFVkd`,`gl38UqmR94H`,`AvWDtKXN3wt`,`rTV
AhHnxQ3R`,`XIHWcZTHR8f`,`uidlevel1`,`uidlevel1`,`uidlevel2`,`uidlevel2`,`uidlevel3`,`uidlevel4`,`dai
ly`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`yearly`,`financialapril`,`financialjuly
`,`financialoct`,`de`,`co`,`level`,daysxvalue, daysno, value) select degs.`bTpwOBGvRW8`,degs.`jEZhI6
OlWx8`,degs.`ogBMb2HyNAs`,degs.`sjzYRXaK0vG`,degs.`ZIHLjkJxPqs`,degs.`dxnZrikZ0xl`,degs.`NB6f3JSFVkd
`,degs.`gl38UqmR94H`,degs.`AvWDtKXN3wt`,degs.`rTVAhHnxQ3R`,degs.`XIHWcZTHR8f`,ous.`uidlevel1`,ous.`u
idlevel1`,ous.`uidlevel2`,ous.`uidlevel2`,ous.`uidlevel3`,ous.`uidlevel4`,ps.`daily`,ps.`weekly`,ps.
`monthly`,ps.`bimonthly`,ps.`quarterly`,ps.`sixmonthly`,ps.`yearly`,ps.`financialapril`,ps.`financia
ljuly`,ps.`financialoct`,de.uid,co.uid,ous.level,cast(dv.value as decimal(26,1)) * ps.daysno as days
xvalue, ps.daysno as daysno, cast(dv.value as decimal(26,1)) as value from datavalue dv left join _d
ataelementgroupsetstructure degs on dv.dataelementid=degs.dataelementid left join _organisationunitg
roupsetstructure ougs on dv.sourceid=ougs.organisationunitid left join _categorystructure dcs on dv.
categoryoptioncomboid=dcs.categoryoptioncomboid left join _categorystructure acs on dv.attributeopti
oncomboid=acs.categoryoptioncomboid left join _orgunitstructure ous on dv.sourceid=ous.organisationu
nitid left join _periodstructure ps on dv.periodid=ps.periodid left join dataelement de on dv.datael
ementid=de.dataelementid left join categoryoptioncombo co on dv.categoryoptioncomboid=co.categoryopt
ioncomboid left join period pe on dv.periodid=pe.periodid where de.valuetype = 'int' and de.domainty
pe = 'aggregate' and pe.startdate >= '2014-01-01' and pe.startdate <= '2014-12-31' and dv.value is n
ot null and dv.value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$' and ( dv.value != '0' or de.aggregation
type = 'average' or de.zeroissignificant = true ) ]; nested exception is com.mysql.jdbc.exceptions.j
dbc4.MySQLSyntaxErrorException: Table 'ccd.analytics_temp_2014' doesn't exist
        at java.util.concurrent.FutureTask.report(Unknown Source)
        at java.util.concurrent.FutureTask.get(Unknown Source)
        at org.hisp.dhis.system.util.ConcurrentUtils.waitForCompletion(ConcurrentUtils.java:51)
        ... 12 more
Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [inse
rt into analytics_temp_2014 (`bTpwOBGvRW8`,`jEZhI6OlWx8`,`ogBMb2HyNAs`,`sjzYRXaK0vG`,`ZIHLjkJxPqs`,`
dxnZrikZ0xl`,`NB6f3JSFVkd`,`gl38UqmR94H`,`AvWDtKXN3wt`,`rTVAhHnxQ3R`,`XIHWcZTHR8f`,`uidlevel1`,`uidl
evel1`,`uidlevel2`,`uidlevel2`,`uidlevel3`,`uidlevel4`,`daily`,`weekly`,`monthly`,`bimonthly`,`quart
erly`,`sixmonthly`,`yearly`,`financialapril`,`financialjuly`,`financialoct`,`de`,`co`,`level`,daysxv
alue, daysno, value) select degs.`bTpwOBGvRW8`,degs.`jEZhI6OlWx8`,degs.`ogBMb2HyNAs`,degs.`sjzYRXaK0
vG`,degs.`ZIHLjkJxPqs`,degs.`dxnZrikZ0xl`,degs.`NB6f3JSFVkd`,degs.`gl38UqmR94H`,degs.`AvWDtKXN3wt`,d
egs.`rTVAhHnxQ3R`,degs.`XIHWcZTHR8f`,ous.`uidlevel1`,ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel2`
,ous.`uidlevel3`,ous.`uidlevel4`,ps.`daily`,ps.`weekly`,ps.`monthly`,ps.`bimonthly`,ps.`quarterly`,p
s.`sixmonthly`,ps.`yearly`,ps.`financialapril`,ps.`financialjuly`,ps.`financialoct`,de.uid,co.uid,ou
s.level,cast(dv.value as decimal(26,1)) * ps.daysno as daysxvalue, ps.daysno as daysno, cast(dv.valu
e as decimal(26,1)) as value from datavalue dv left join _dataelementgroupsetstructure degs on dv.da
taelementid=degs.dataelementid left join _organisationunitgroupsetstructure ougs on dv.sourceid=ougs
.organisationunitid left join _categorystructure dcs on dv.categoryoptioncomboid=dcs.categoryoptionc
omboid left join _categorystructure acs on dv.attributeoptioncomboid=acs.categoryoptioncomboid left
join _orgunitstructure ous on dv.sourceid=ous.organisationunitid left join _periodstructure ps on dv
.periodid=ps.periodid left join dataelement de on dv.dataelementid=de.dataelementid left join catego
ryoptioncombo co on dv.categoryoptioncomboid=co.categoryoptioncomboid left join period pe on dv.peri
odid=pe.periodid where de.valuetype = 'int' and de.domaintype = 'aggregate' and pe.startdate >= '201
4-01-01' and pe.startdate <= '2014-12-31' and dv.value is not null and dv.value regexp '^(-?[0-9]+)(
\.[0-9]+)?(E\d+)?$' and ( dv.value != '0' or de.aggregationtype = 'average' or de.zeroissignificant
= true ) ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'cc
d.analytics_temp_2014' doesn't exist
        at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorC
odeSQLExceptionTranslator.java:237)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(Abstrac
tFallbackSQLExceptionTranslator.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.JdbcAnalyticsTableManager.populateTable(JdbcAnalyticsTableM
anager.java:184)
        at org.hisp.dhis.analytics.table.JdbcAnalyticsTableManager.populateTableAsync(JdbcAnalyticsT
ableManager.java:130)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317
)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMe
thodInvocation.java:183)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvo
cation.java:150)
        at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterc
eptor.java:95)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        ... 1 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ccd.analytics_temp_2014
' doesn't exist
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
        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(JdbcTe
mplate.java:421)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
        ... 13 more

Attachment: error.jpg
Description: JPEG image