dhis2-users team mailing list archive
-
dhis2-users team
-
Mailing list archive
-
Message #04559
Data Mart-Process failed:Exception during execution
Hi,
We are trying to customize DHIS2 for the Cancer Early Detection Clinic at
the National Cancer Control programme-Sri Lanka. The primary objective is
to record *patient data* and generate some essential reports.
We have customized the patient side (Program/Individual records) and
successfully run 2 test aggregation queries by manual aggregation. Such
data is saved.
But when we want to generate reports, following error appears and no
records are shown on pivot tables.
2014-06-05 06:06:37Process failed: Exception during execution
I have attached the screen-print and the caltalina log file.
Version:2.15Build revision:15112Build date:2014-06-02 02:04User
agent:Mozilla/5.0
(X11; Ubuntu; Linux x86_64; rv:29.0) Gecko/20100101 Firefox/29.0
Your help will be appreciated.
Thanks in advance.
*L.A. Neranga Prabhath*
*Trainee - MSc in Medical Informatics*
*Postgraduate Institute of Medicine*
*University of Colombo-Sri Lanka.*
*Telephone: +94772531559*
* INFO 2014-06-05 11:36:08,240 [Level: INFO, category: RESOURCETABLE_UPDATE, time: Thu Jun 05 11:36:08 IST 2014, message: Generating resource tables] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:08,290 Create organisation unit structure table SQL: CREATE TABLE _orgunitstructure ( organisationunitid INTEGER NOT NULL PRIMARY KEY, organisationunituid CHARACTER(11), level INTEGER, `idlevel1` INTEGER, `uidlevel1` CHARACTER(11), `idlevel2` INTEGER, `uidlevel2` CHARACTER(11), `idlevel3` INTEGER, `uidlevel3` CHARACTER(11)); (JdbcResourceTableStore.java [taskScheduler-2])
* INFO 2014-06-05 11:36:08,541 Organisation unit structure table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO 2014-06-05 11:36:08,629 Create category option combo name table SQL: CREATE TABLE _categoryoptioncomboname ( categoryoptioncomboid INTEGER NOT NULL PRIMARY KEY, categoryoptioncomboname VARCHAR(250) ) (JdbcResourceTableStore.java [taskScheduler-2])
* INFO 2014-06-05 11:36:08,720 Category option combo name table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO 2014-06-05 11:36:08,797 Create category option group set table SQL: CREATE TABLE _categoryoptiongroupsetstructure ( categoryoptioncomboid INTEGER NOT NULL, PRIMARY KEY ( categoryoptioncomboid ) ) (CreateCategoryOptionGroupSetTableStatement.java [taskScheduler-2])
* INFO 2014-06-05 11:36:08,874 Category option group set table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO 2014-06-05 11:36:08,943 Create data element group set table SQL: CREATE TABLE _dataelementgroupsetstructure ( dataelementid INTEGER NOT NULL, dataelementname VARCHAR (250), PRIMARY KEY ( dataelementid ) ) (CreateDataElementGroupSetTableStatement.java [taskScheduler-2])
* INFO 2014-06-05 11:36:09,011 Populate data element group set structure SQL: insert into _dataelementgroupsetstructure select d.dataelementid as dataelementid, d.name as dataelementname from dataelement d (JdbcResourceTableStore.java [taskScheduler-2])
* INFO 2014-06-05 11:36:09,013 Data element group set table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO 2014-06-05 11:36:09,078 Create indicator group set table SQL: CREATE TABLE _indicatorgroupsetstructure ( indicatorid INTEGER NOT NULL, indicatorname VARCHAR (250), PRIMARY KEY ( indicatorid ) ) (CreateIndicatorGroupSetTableStatement.java [taskScheduler-2])
* INFO 2014-06-05 11:36:09,145 Populate indicator group set structure SQL: insert into _indicatorgroupsetstructure select i.indicatorid as indicatorid, i.name as indicatorname from indicator i (JdbcResourceTableStore.java [taskScheduler-2])
* INFO 2014-06-05 11:36:09,147 Indicator group set table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO 2014-06-05 11:36:09,212 Create organisation unit group set table SQL: CREATE TABLE _organisationunitgroupsetstructure ( organisationunitid INTEGER NOT NULL, organisationunitname VARCHAR (250), PRIMARY KEY ( organisationunitid ) ) (CreateOrganisationUnitGroupSetTableStatement.java [taskScheduler-2])
* INFO 2014-06-05 11:36:09,280 Populate organisation unit group set structure SQL: insert into _organisationunitgroupsetstructure select ou.organisationunitid as organisationunitid, ou.name as organisationunitname from organisationunit ou (JdbcResourceTableStore.java [taskScheduler-2])
* INFO 2014-06-05 11:36:09,282 Organisation unit group set table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO 2014-06-05 11:36:09,372 Create category structure table SQL: CREATE TABLE _categorystructure ( categoryoptioncomboid INTEGER NOT NULL, categoryoptioncomboname VARCHAR (250), `Cat_Ethnic Group` VARCHAR (250), `HRVq6qlaeHY` CHARACTER(11), `Cat_Gender` VARCHAR (250), `RRAIa0vvGIY` CHARACTER(11), `default` VARCHAR (250), `bWUTwDhPHdp` CHARACTER(11), PRIMARY KEY ( categoryoptioncomboid ) ) (CreateCategoryTableStatement.java [taskScheduler-2])
* INFO 2014-06-05 11:36:09,463 Category table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO 2014-06-05 11:36:09,562 Create data element structure SQL: CREATE TABLE _dataelementstructure ( dataelementid INTEGER NOT NULL PRIMARY KEY, dataelementuid CHARACTER(11), dataelementname VARCHAR(250), datasetid INTEGER, datasetuid CHARACTER(11), datasetname VARCHAR(250), periodtypeid INTEGER, periodtypename VARCHAR(250) ) (JdbcResourceTableStore.java [taskScheduler-2])
* INFO 2014-06-05 11:36:10,368 Data element table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO 2014-06-05 11:36:10,435 Create period structure SQL: CREATE TABLE _periodstructure (periodid INTEGER NOT NULL PRIMARY KEY, iso VARCHAR(15) NOT NULL, daysno INTEGER NOT NULL, `daily` VARCHAR(15), `weekly` VARCHAR(15), `monthly` VARCHAR(15), `bimonthly` VARCHAR(15), `quarterly` VARCHAR(15), `sixmonthly` VARCHAR(15), `sixmonthlyapril` VARCHAR(15), `yearly` VARCHAR(15), `financialapril` VARCHAR(15), `financialjuly` VARCHAR(15), `financialoct` VARCHAR(15)) (JdbcResourceTableStore.java [taskScheduler-2])
* INFO 2014-06-05 11:36:10,639 Date period table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO 2014-06-05 11:36:10,727 Create date period structure SQL: CREATE TABLE _dateperiodstructure (dateperiod DATE NOT NULL PRIMARY KEY, `daily` VARCHAR(15), `weekly` VARCHAR(15), `monthly` VARCHAR(15), `bimonthly` VARCHAR(15), `quarterly` VARCHAR(15), `sixmonthly` VARCHAR(15), `sixmonthlyapril` VARCHAR(15), `yearly` VARCHAR(15), `financialapril` VARCHAR(15), `financialjuly` VARCHAR(15), `financialoct` VARCHAR(15)) (JdbcResourceTableStore.java [taskScheduler-2])
* INFO 2014-06-05 11:36:13,766 Period table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO 2014-06-05 11:36:13,978 Create data element category option combo SQL: CREATE TABLE _dataelementcategoryoptioncombo (dataelementuid VARCHAR(11) NOT NULL, categoryoptioncombouid VARCHAR(11) NOT NULL) (JdbcResourceTableStore.java [taskScheduler-2])
* INFO 2014-06-05 11:36:13,979 Insert data element category option combo SQL: insert into _dataelementcategoryoptioncombo (dataelementuid, categoryoptioncombouid) select de.uid as dataelementuid, coc.uid as categoryoptioncombouid from dataelement de join categorycombos_optioncombos cc on de.categorycomboid = cc.categorycomboid join categoryoptioncombo coc on cc.categoryoptioncomboid = coc.categoryoptioncomboid (JdbcResourceTableStore.java [taskScheduler-2])
* INFO 2014-06-05 11:36:13,983 Create data element category option combo index SQL: CREATE INDEX dataelement_categoryoptioncombo ON _dataelementcategoryoptioncombo (dataelementuid, categoryoptioncombouid) (JdbcResourceTableStore.java [taskScheduler-2])
* INFO 2014-06-05 11:36:14,180 Data element category option combo table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO 2014-06-05 11:36:14,184 [Level: INFO, category: RESOURCETABLE_UPDATE, time: Thu Jun 05 11:36:14 IST 2014, message: Resource tables generated] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:14,185 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:14 IST 2014, message: Analytics table update process started] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:14,185 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:14 IST 2014, message: Updating resource tables] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:14,237 Create organisation unit structure table SQL: CREATE TABLE _orgunitstructure ( organisationunitid INTEGER NOT NULL PRIMARY KEY, organisationunituid CHARACTER(11), level INTEGER, `idlevel1` INTEGER, `uidlevel1` CHARACTER(11), `idlevel2` INTEGER, `uidlevel2` CHARACTER(11), `idlevel3` INTEGER, `uidlevel3` CHARACTER(11)); (JdbcResourceTableStore.java [taskScheduler-2])
* INFO 2014-06-05 11:36:14,588 Organisation unit structure table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO 2014-06-05 11:36:14,655 Create category option combo name table SQL: CREATE TABLE _categoryoptioncomboname ( categoryoptioncomboid INTEGER NOT NULL PRIMARY KEY, categoryoptioncomboname VARCHAR(250) ) (JdbcResourceTableStore.java [taskScheduler-2])
* INFO 2014-06-05 11:36:14,735 Category option combo name table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO 2014-06-05 11:36:14,823 Create data element group set table SQL: CREATE TABLE _dataelementgroupsetstructure ( dataelementid INTEGER NOT NULL, dataelementname VARCHAR (250), PRIMARY KEY ( dataelementid ) ) (CreateDataElementGroupSetTableStatement.java [taskScheduler-2])
* INFO 2014-06-05 11:36:14,901 Populate data element group set structure SQL: insert into _dataelementgroupsetstructure select d.dataelementid as dataelementid, d.name as dataelementname from dataelement d (JdbcResourceTableStore.java [taskScheduler-2])
* INFO 2014-06-05 11:36:14,903 Data element group set table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO 2014-06-05 11:36:14,991 Create indicator group set table SQL: CREATE TABLE _indicatorgroupsetstructure ( indicatorid INTEGER NOT NULL, indicatorname VARCHAR (250), PRIMARY KEY ( indicatorid ) ) (CreateIndicatorGroupSetTableStatement.java [taskScheduler-2])
* INFO 2014-06-05 11:36:15,070 Populate indicator group set structure SQL: insert into _indicatorgroupsetstructure select i.indicatorid as indicatorid, i.name as indicatorname from indicator i (JdbcResourceTableStore.java [taskScheduler-2])
* INFO 2014-06-05 11:36:15,071 Indicator group set table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO 2014-06-05 11:36:15,160 Create organisation unit group set table SQL: CREATE TABLE _organisationunitgroupsetstructure ( organisationunitid INTEGER NOT NULL, organisationunitname VARCHAR (250), PRIMARY KEY ( organisationunitid ) ) (CreateOrganisationUnitGroupSetTableStatement.java [taskScheduler-2])
* INFO 2014-06-05 11:36:15,227 Populate organisation unit group set structure SQL: insert into _organisationunitgroupsetstructure select ou.organisationunitid as organisationunitid, ou.name as organisationunitname from organisationunit ou (JdbcResourceTableStore.java [taskScheduler-2])
* INFO 2014-06-05 11:36:15,229 Organisation unit group set table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO 2014-06-05 11:36:15,364 Create category structure table SQL: CREATE TABLE _categorystructure ( categoryoptioncomboid INTEGER NOT NULL, categoryoptioncomboname VARCHAR (250), `Cat_Ethnic Group` VARCHAR (250), `HRVq6qlaeHY` CHARACTER(11), `Cat_Gender` VARCHAR (250), `RRAIa0vvGIY` CHARACTER(11), `default` VARCHAR (250), `bWUTwDhPHdp` CHARACTER(11), PRIMARY KEY ( categoryoptioncomboid ) ) (CreateCategoryTableStatement.java [taskScheduler-2])
* INFO 2014-06-05 11:36:15,468 Category table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO 2014-06-05 11:36:15,563 Create data element structure SQL: CREATE TABLE _dataelementstructure ( dataelementid INTEGER NOT NULL PRIMARY KEY, dataelementuid CHARACTER(11), dataelementname VARCHAR(250), datasetid INTEGER, datasetuid CHARACTER(11), datasetname VARCHAR(250), periodtypeid INTEGER, periodtypename VARCHAR(250) ) (JdbcResourceTableStore.java [taskScheduler-2])
* INFO 2014-06-05 11:36:16,289 Data element table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO 2014-06-05 11:36:16,408 Create period structure SQL: CREATE TABLE _periodstructure (periodid INTEGER NOT NULL PRIMARY KEY, iso VARCHAR(15) NOT NULL, daysno INTEGER NOT NULL, `daily` VARCHAR(15), `weekly` VARCHAR(15), `monthly` VARCHAR(15), `bimonthly` VARCHAR(15), `quarterly` VARCHAR(15), `sixmonthly` VARCHAR(15), `sixmonthlyapril` VARCHAR(15), `yearly` VARCHAR(15), `financialapril` VARCHAR(15), `financialjuly` VARCHAR(15), `financialoct` VARCHAR(15)) (JdbcResourceTableStore.java [taskScheduler-2])
* INFO 2014-06-05 11:36:16,626 Date period table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO 2014-06-05 11:36:16,714 Create date period structure SQL: CREATE TABLE _dateperiodstructure (dateperiod DATE NOT NULL PRIMARY KEY, `daily` VARCHAR(15), `weekly` VARCHAR(15), `monthly` VARCHAR(15), `bimonthly` VARCHAR(15), `quarterly` VARCHAR(15), `sixmonthly` VARCHAR(15), `sixmonthlyapril` VARCHAR(15), `yearly` VARCHAR(15), `financialapril` VARCHAR(15), `financialjuly` VARCHAR(15), `financialoct` VARCHAR(15)) (JdbcResourceTableStore.java [taskScheduler-2])
* INFO 2014-06-05 11:36:19,723 Period table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO 2014-06-05 11:36:19,944 Create data element category option combo SQL: CREATE TABLE _dataelementcategoryoptioncombo (dataelementuid VARCHAR(11) NOT NULL, categoryoptioncombouid VARCHAR(11) NOT NULL) (JdbcResourceTableStore.java [taskScheduler-2])
* INFO 2014-06-05 11:36:19,944 Insert data element category option combo SQL: insert into _dataelementcategoryoptioncombo (dataelementuid, categoryoptioncombouid) select de.uid as dataelementuid, coc.uid as categoryoptioncombouid from dataelement de join categorycombos_optioncombos cc on de.categorycomboid = cc.categorycomboid join categoryoptioncombo coc on cc.categoryoptioncomboid = coc.categoryoptioncomboid (JdbcResourceTableStore.java [taskScheduler-2])
* INFO 2014-06-05 11:36:19,948 Create data element category option combo index SQL: CREATE INDEX dataelement_categoryoptioncombo ON _dataelementcategoryoptioncombo (dataelementuid, categoryoptioncombouid) (JdbcResourceTableStore.java [taskScheduler-2])
* INFO 2014-06-05 11:36:20,135 Data element category option combo table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO 2014-06-05 11:36:20,139 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:20 IST 2014, message: Updating analytics tables] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:20,140 Starting update, no of processes: 3: 0:00:00.000 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:20,145 Get tables using earliest: 2014-06-01 00:00:00.0, latest: 2014-06-08 00:00:00.0 (AbstractJdbcTableManager.java [taskScheduler-2])
* INFO 2014-06-05 11:36:20,151 Partition tables: [analytics_2014], last years: null: 0:00:00.012 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:20,151 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:20 IST 2014, message: Creating analytics tables] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:20,168 Create SQL: create table analytics_temp_2014 (`uidlevel1` character(11),`uidlevel2` character(11),`uidlevel3` character(11),`daily` character varying(15),`weekly` character varying(15),`monthly` character varying(15),`bimonthly` character varying(15),`quarterly` character varying(15),`sixmonthly` character varying(15),`sixmonthlyapril` character varying(15),`yearly` character varying(15),`financialapril` character varying(15),`financialjuly` character varying(15),`financialoct` character varying(15),`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-2])
* INFO 2014-06-05 11:36:20,470 Created analytics tables: 0:00:00.331 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:20,471 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:20 IST 2014, message: Populating analytics tables] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:20,471 Populate table task number: 1 (DefaultAnalyticsTableService.java [taskScheduler-2])
* INFO 2014-06-05 11:36:20,487 Populate SQL: insert into analytics_temp_2014 (`uidlevel1`,`uidlevel2`,`uidlevel3`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`sixmonthlyapril`,`yearly`,`financialapril`,`financialjuly`,`financialoct`,`de`,`co`,`level`,daysxvalue, daysno, value) select ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,ps.`daily`,ps.`weekly`,ps.`monthly`,ps.`bimonthly`,ps.`quarterly`,ps.`sixmonthly`,ps.`sixmonthlyapril`,ps.`yearly`,ps.`financialapril`,ps.`financialjuly`,ps.`financialoct`,de.uid,co.uid,ous.level,cast(dv.value as decimal(26,1)) * ps.daysno as daysxvalue, ps.daysno as daysno, cast(dv.value as decimal(26,1)) as value from datavalue dv left join _dataelementgroupsetstructure degs on dv.dataelementid=degs.dataelementid left join _organisationunitgroupsetstructure ougs on dv.sourceid=ougs.organisationunitid left join _categoryoptiongroupsetstructure cogs on dv.attributeoptioncomboid=cogs.categoryoptioncomboid left join _categorystructure dcs on dv.categoryoptioncomboid=dcs.categoryoptioncomboid 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 categoryoptioncombo co on dv.categoryoptioncomboid=co.categoryoptioncomboid 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.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 ) (JdbcAnalyticsTableManager.java [SimpleAsyncTaskExecutor-125])
* INFO 2014-06-05 11:36:20,554 Populate SQL: insert into analytics_temp_2014 (`uidlevel1`,`uidlevel2`,`uidlevel3`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`sixmonthlyapril`,`yearly`,`financialapril`,`financialjuly`,`financialoct`,`de`,`co`,`level`,daysxvalue, daysno, value) select ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,ps.`daily`,ps.`weekly`,ps.`monthly`,ps.`bimonthly`,ps.`quarterly`,ps.`sixmonthly`,ps.`sixmonthlyapril`,ps.`yearly`,ps.`financialapril`,ps.`financialjuly`,ps.`financialoct`,de.uid,co.uid,ous.level,1 * ps.daysno as daysxvalue, ps.daysno as daysno, 1 as value from datavalue dv left join _dataelementgroupsetstructure degs on dv.dataelementid=degs.dataelementid left join _organisationunitgroupsetstructure ougs on dv.sourceid=ougs.organisationunitid left join _categoryoptiongroupsetstructure cogs on dv.attributeoptioncomboid=cogs.categoryoptioncomboid left join _categorystructure dcs on dv.categoryoptioncomboid=dcs.categoryoptioncomboid 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 categoryoptioncombo co on dv.categoryoptioncomboid=co.categoryoptioncomboid left join period pe on dv.periodid=pe.periodid where de.valuetype = 'bool' and de.domaintype = 'aggregate' and pe.startdate >= '2014-01-01' and pe.startdate <= '2014-12-31' and dv.value is not null and dv.value = 'true' (JdbcAnalyticsTableManager.java [SimpleAsyncTaskExecutor-125])
* INFO 2014-06-05 11:36:20,569 Populate SQL: insert into analytics_temp_2014 (`uidlevel1`,`uidlevel2`,`uidlevel3`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`sixmonthlyapril`,`yearly`,`financialapril`,`financialjuly`,`financialoct`,`de`,`co`,`level`,daysxvalue, daysno, value) select ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,ps.`daily`,ps.`weekly`,ps.`monthly`,ps.`bimonthly`,ps.`quarterly`,ps.`sixmonthly`,ps.`sixmonthlyapril`,ps.`yearly`,ps.`financialapril`,ps.`financialjuly`,ps.`financialoct`,de.uid,co.uid,ous.level,0 * ps.daysno as daysxvalue, ps.daysno as daysno, 0 as value from datavalue dv left join _dataelementgroupsetstructure degs on dv.dataelementid=degs.dataelementid left join _organisationunitgroupsetstructure ougs on dv.sourceid=ougs.organisationunitid left join _categoryoptiongroupsetstructure cogs on dv.attributeoptioncomboid=cogs.categoryoptioncomboid left join _categorystructure dcs on dv.categoryoptioncomboid=dcs.categoryoptioncomboid 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 categoryoptioncombo co on dv.categoryoptioncomboid=co.categoryoptioncomboid left join period pe on dv.periodid=pe.periodid where de.valuetype = 'bool' and de.domaintype = 'aggregate' and pe.startdate >= '2014-01-01' and pe.startdate <= '2014-12-31' and dv.value is not null and dv.value = 'false' (JdbcAnalyticsTableManager.java [SimpleAsyncTaskExecutor-125])
* INFO 2014-06-05 11:36:20,589 Populate SQL: insert into analytics_temp_2014 (`uidlevel1`,`uidlevel2`,`uidlevel3`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`sixmonthlyapril`,`yearly`,`financialapril`,`financialjuly`,`financialoct`,`de`,`co`,`level`,daysxvalue, daysno, value) select ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,ps.`daily`,ps.`weekly`,ps.`monthly`,ps.`bimonthly`,ps.`quarterly`,ps.`sixmonthly`,ps.`sixmonthlyapril`,ps.`yearly`,ps.`financialapril`,ps.`financialjuly`,ps.`financialoct`,de.uid,co.uid,ous.level,1 * ps.daysno as daysxvalue, ps.daysno as daysno, 1 as value from datavalue dv left join _dataelementgroupsetstructure degs on dv.dataelementid=degs.dataelementid left join _organisationunitgroupsetstructure ougs on dv.sourceid=ougs.organisationunitid left join _categoryoptiongroupsetstructure cogs on dv.attributeoptioncomboid=cogs.categoryoptioncomboid left join _categorystructure dcs on dv.categoryoptioncomboid=dcs.categoryoptioncomboid 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 categoryoptioncombo co on dv.categoryoptioncomboid=co.categoryoptioncomboid left join period pe on dv.periodid=pe.periodid where de.valuetype = 'trueOnly' and de.domaintype = 'aggregate' and pe.startdate >= '2014-01-01' and pe.startdate <= '2014-12-31' and dv.value is not null and dv.value = 'true' (JdbcAnalyticsTableManager.java [SimpleAsyncTaskExecutor-125])
* INFO 2014-06-05 11:36:20,592 Populated analytics tables: 0:00:00.453 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:20,592 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:20 IST 2014, message: Pruned analytics tables] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:20,632 Pruned analytics tables: 0:00:00.493 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:20,633 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:20 IST 2014, message: Applying aggregation levels] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:20,662 Applied aggregation levels: 0:00:00.523 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:20,663 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:20 IST 2014, message: Creating indexes] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:20,663 No of indexes: 17 (DefaultAnalyticsTableService.java [taskScheduler-2])
* INFO 2014-06-05 11:36:20,824 Created index: `in_uidlevel1_analytics_temp_2014_LnB5d` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-129])
* INFO 2014-06-05 11:36:20,959 Created index: `in_uidlevel2_analytics_temp_2014_nAPcK` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-128])
* INFO 2014-06-05 11:36:21,096 Created index: `in_uidlevel3_analytics_temp_2014_I3w9b` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-130])
* INFO 2014-06-05 11:36:21,231 Created index: `in_daily_analytics_temp_2014_SUk9p` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-129])
* INFO 2014-06-05 11:36:21,456 Created index: `in_weekly_analytics_temp_2014_Wj5m1` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-128])
* INFO 2014-06-05 11:36:21,603 Created index: `in_monthly_analytics_temp_2014_bK5H6` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-130])
* INFO 2014-06-05 11:36:21,738 Created index: `in_bimonthly_analytics_temp_2014_WUvFM` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-129])
* INFO 2014-06-05 11:36:21,897 Created index: `in_quarterly_analytics_temp_2014_dKuvx` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-128])
* INFO 2014-06-05 11:36:22,055 Created index: `in_sixmonthly_analytics_temp_2014_BE4gb` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-130])
* INFO 2014-06-05 11:36:22,212 Created index: `in_sixmonthlyapril_analytics_temp_2014_wUqiz` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-129])
* INFO 2014-06-05 11:36:22,393 Created index: `in_yearly_analytics_temp_2014_ZeJiS` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-128])
* INFO 2014-06-05 11:36:22,550 Created index: `in_financialapril_analytics_temp_2014_AYq8w` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-130])
* INFO 2014-06-05 11:36:22,697 Created index: `in_financialjuly_analytics_temp_2014_kglqy` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-129])
* INFO 2014-06-05 11:36:22,867 Created index: `in_financialoct_analytics_temp_2014_x37Fi` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-128])
* INFO 2014-06-05 11:36:23,014 Created index: `in_de_analytics_temp_2014_Josp9` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-130])
* INFO 2014-06-05 11:36:23,149 Created index: `in_co_analytics_temp_2014_NLJoq` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-129])
* INFO 2014-06-05 11:36:23,304 Created index: `in_level_analytics_temp_2014_SRIkU` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-128])
* INFO 2014-06-05 11:36:23,305 Created indexes: 0:00:03.166 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:23,305 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:23 IST 2014, message: Vacuuming tables] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:23,306 Vacuum SQL: optimize table analytics_temp_2014; (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-131])
* INFO 2014-06-05 11:36:23,307 Vacuumed tables: 0:00:03.168 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:23,308 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:23 IST 2014, message: Swapping analytics tables] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:23,860 Table update done: 0:00:03.721 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:23,861 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:23 IST 2014, message: Table update done] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:23,861 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:23 IST 2014, message: Updating completeness table] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:23,862 Starting update, no of processes: 3: 0:00:00.000 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:23,863 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:23 IST 2014, message: Table not valid, aborted update] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:23,864 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:23 IST 2014, message: Updating completeness target table] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:23,864 Starting update, no of processes: 3: 0:00:00.000 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:23,867 Partition tables: [analytics_completenesstarget], last years: null: 0:00:00.003 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:23,867 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:23 IST 2014, message: Creating analytics tables] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:23,873 Create SQL: create table analytics_completenesstarget_temp (`uidlevel1` character(11),`uidlevel2` character(11),`uidlevel3` character(11),`ds` character(11) not null,value double precision) (JdbcCompletenessTargetTableManager.java [taskScheduler-2])
* INFO 2014-06-05 11:36:23,998 Created analytics tables: 0:00:00.134 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:23,998 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:23 IST 2014, message: Populating analytics tables] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:23,999 Populate table task number: 1 (DefaultAnalyticsTableService.java [taskScheduler-2])
* INFO 2014-06-05 11:36:24,005 Populate SQL: insert into analytics_completenesstarget_temp (`uidlevel1`,`uidlevel2`,`uidlevel3`,`ds`,value) select ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,ds.uid,1 as value from datasetsource dss left join dataset ds on dss.datasetid=ds.datasetid left join _orgunitstructure ous on dss.sourceid=ous.organisationunitid left join _organisationunitgroupsetstructure ougs on dss.sourceid=ougs.organisationunitid (JdbcCompletenessTargetTableManager.java [SimpleAsyncTaskExecutor-134])
* INFO 2014-06-05 11:36:24,083 Populated analytics tables: 0:00:00.219 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:24,084 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:24 IST 2014, message: Pruned analytics tables] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:24,092 Pruned analytics tables: 0:00:00.228 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:24,093 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:24 IST 2014, message: Applying aggregation levels] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:24,098 Applied aggregation levels: 0:00:00.234 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:24,099 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:24 IST 2014, message: Creating indexes] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:24,099 No of indexes: 4 (DefaultAnalyticsTableService.java [taskScheduler-2])
* INFO 2014-06-05 11:36:24,328 Created index: `in_uidlevel1_analytics_completenesstarget_temp_DC1Fy` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-137])
* INFO 2014-06-05 11:36:24,553 Created index: `in_uidlevel2_analytics_completenesstarget_temp_FUYzR` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-138])
* INFO 2014-06-05 11:36:24,688 Created index: `in_uidlevel3_analytics_completenesstarget_temp_HeSMe` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-139])
* INFO 2014-06-05 11:36:24,857 Created index: `in_ds_analytics_completenesstarget_temp_bj9H4` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-137])
* INFO 2014-06-05 11:36:24,857 Created indexes: 0:00:00.993 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:24,858 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:24 IST 2014, message: Vacuuming tables] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:24,858 Vacuum SQL: optimize table analytics_completenesstarget_temp; (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-140])
* INFO 2014-06-05 11:36:24,859 Vacuumed tables: 0:00:00.995 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:24,859 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:24 IST 2014, message: Swapping analytics tables] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,128 Table update done: 0:00:01.264 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,129 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:25 IST 2014, message: Table update done] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,129 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:25 IST 2014, message: Updating organisation unit target table] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,130 Starting update, no of processes: 3: 0:00:00.000 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,132 Partition tables: [analytics_orgunittarget], last years: null: 0:00:00.002 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,133 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:25 IST 2014, message: Creating analytics tables] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,137 Create SQL: create table analytics_orgunittarget_temp (`uidlevel1` character(11),`uidlevel2` character(11),`uidlevel3` character(11),`oug` character(11) not null,value double precision) (JdbcOrgUnitTargetTableManager.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,207 Created analytics tables: 0:00:00.077 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,207 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:25 IST 2014, message: Populating analytics tables] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,208 Populate table task number: 1 (DefaultAnalyticsTableService.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,212 Populate SQL: insert into analytics_orgunittarget_temp (`uidlevel1`,`uidlevel2`,`uidlevel3`,`oug`,value) select ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,oug.uid,1 as value from orgunitgroupmembers ougm left join orgunitgroup oug on ougm.orgunitgroupid=oug.orgunitgroupid left join _orgunitstructure ous on ougm.organisationunitid=ous.organisationunitid left join _organisationunitgroupsetstructure ougs on ougm.organisationunitid=ougs.organisationunitid (JdbcOrgUnitTargetTableManager.java [SimpleAsyncTaskExecutor-143])
* INFO 2014-06-05 11:36:25,213 Populated analytics tables: 0:00:00.083 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,213 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:25 IST 2014, message: Pruned analytics tables] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,263 Drop SQL: drop table analytics_orgunittarget_temp (AbstractJdbcTableManager.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,264 Pruned analytics tables: 0:00:00.134 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,264 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:25 IST 2014, message: Applying aggregation levels] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,269 Applied aggregation levels: 0:00:00.139 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,270 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:25 IST 2014, message: Creating indexes] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,270 No of indexes: 0 (DefaultAnalyticsTableService.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,271 Created indexes: 0:00:00.141 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,271 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:25 IST 2014, message: Vacuuming tables] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,272 Vacuumed tables: 0:00:00.142 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,272 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:25 IST 2014, message: Swapping analytics tables] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,272 Table update done: 0:00:00.142 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,273 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:25 IST 2014, message: Table update done] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,273 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:25 IST 2014, message: Updating event analytics table] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,273 Starting update, no of processes: 3: 0:00:00.0002014-06-05 06:06:37 Process failed: Exception during execution (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,276 Get tables using earliest: 2014-06-04 00:00:00.0, latest: 2014-06-04 00:00:00.0 (JdbcEventAnalyticsTableManager.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,314 Partition tables: [analytics_event_2014_N1vNV1bQajX, analytics_event_2014_PuI4zk5MjcM], last years: null: 0:00:00.041 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,315 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:25 IST 2014, message: Creating analytics tables] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,317 Create SQL: create table analytics_event_temp_2014_N1vNV1bQajX (`uidlevel1` character(11),`uidlevel2` character(11),`uidlevel3` character(11),`daily` character varying(15),`weekly` character varying(15),`monthly` character varying(15),`bimonthly` character varying(15),`quarterly` character varying(15),`sixmonthly` character varying(15),`sixmonthlyapril` character varying(15),`yearly` character varying(15),`financialapril` character varying(15),`financialjuly` character varying(15),`financialoct` character varying(15),`GqgcmzgHQXt` character varying(255),`c2l0paX05kh` decimal(26,1),`CnC8sb2n1VZ` decimal(26,1),`fGahYAjRkZQ` decimal(26,1),`bUrbjpJa8EC` character varying(255),`l99dMZByxwA` decimal(26,1),`yHEdFtWhrgQ` character varying(255),`LDBgHTyoArb` character varying(255),`ZGY6AsIs6hT` character varying(255),`jFrDhbnfbXk` character varying(255),`zT1xmebG22q` decimal(26,1),`aKYCqJoIODU` character varying(255),`J1gjv4X5isz` character varying(255),`nuI61F7eGY8` character varying(255),`OVD6Pr5BJ9a` character varying(255),`MhgY1Hd1XLP` character varying(255),`XLQJ7fE1QdQ` character varying(255),`YYc3ygpLjt1` character varying(255),`y9DcSfWuObO` character varying(255),`ubjiJ7PLMCI` character varying(255),`k0qTCTSRyCf` character varying(255),`pDPGMpgew6y` character varying(255),`jykNnXYHpZr` decimal(26,1),`xeUjAMCHJnZ` decimal(26,1),`nHHqStYs5C0` character varying(255),`Y3SA8rQQICg` character varying(255),`thsSPQngCJs` decimal(26,1),`FbD2bjCyfSV` character varying(255),`VlDv3n4CWoo` character varying(255),`ztRRR3Xx3CI` character varying(255),`oB2EZNAAKdH` character varying(255),`O3XH16kXAhG` character varying(255),`NCmbNi8UC8U` character varying(255),`OZmm5VSBZ94` character varying(255),`Wn9dJQovCEq` character varying(255),`TWX9SGCA7aO` character varying(255),`v7YRJhSYLCO` character varying(255),`Xg4tA0i7mAh` character varying(255),`Ksoq7YJoij8` character varying(255),`H0iY8iy55XY` character varying(255),`iBgLoG57OY0` character varying(255),`F9RGslVQIKr` decimal(26,1),`jwr6Ba6BI7U` decimal(26,1),`x6YOnc9cq9j` character varying(255),`YUciCU57O70` character varying(255),`xfAqwpm0SzZ` character varying(255),`aUR8tzHDiD7` character varying(255),`MfJzyIv3duo` character varying(255),`NZBfuIYRcu6` character varying(255),`zExtGFIDiDo` character varying(255),`uMSOw5udp1L` character varying(255),`DUSUrQh1DER` character varying(255),`zL2OEumJbUB` character varying(255),`WJwfpgI07jR` character varying(255),`Z7IrXvgBARZ` decimal(26,1),`beEFugLyFQN` decimal(26,1),`LIxlBc9CHWE` character varying(255),`MJORRMzmtEO` character varying(255),`vsQO1bgG0hV` decimal(26,1),`cVB9xNMLqFB` character varying(255),`xhG0NetnOiC` character varying(255),`C10tJNGrUUV` character varying(255),`UmNpRtSaWlu` character varying(255),`erxRiWMqlpz` character varying(255),`eJxJeXimmOB` decimal(26,1),`gBvirIeI4kQ` decimal(26,1),`SChj2rF71Zn` character varying(255),`QhTUIzQ2Cro` character varying(255),`ncN7oZJFXH1` character varying(255),`aSX0p24Q3Ws` character varying(255),`FuJAP0LgtBF` character varying(255),`iv3wrjHYFdh` character varying(255),`CRMOR7eXKjA` character varying(255),`yd21kSQDgPm` character varying(255),`Q3k6ZYLOZW4` character varying(255),`RgJIOoQ2TNL` character varying(255),`o5SnxY1h1YM` character varying(255),`OUunJaNbnUi` character varying(255),`psi` character(11) not null,`ps` character(11) not null,`executiondate` timestamp,`longitude` decimal(26,1),`latitude` decimal(26,1),`ou` character(11) not null,`ouname` character varying(230) not null,`oucode` character varying(50)) (JdbcEventAnalyticsTableManager.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,494 Create SQL: create table analytics_event_temp_2014_PuI4zk5MjcM (`uidlevel1` character(11),`uidlevel2` character(11),`uidlevel3` character(11),`daily` character varying(15),`weekly` character varying(15),`monthly` character varying(15),`bimonthly` character varying(15),`quarterly` character varying(15),`sixmonthly` character varying(15),`sixmonthlyapril` character varying(15),`yearly` character varying(15),`financialapril` character varying(15),`financialjuly` character varying(15),`financialoct` character varying(15),`WZA8gXVUeIJ` character varying(255),`ESGzNcksTS3` character varying(255),`CnC8sb2n1VZ` decimal(26,1),`fGahYAjRkZQ` decimal(26,1),`bUrbjpJa8EC` character varying(255),`l99dMZByxwA` decimal(26,1),`nhmCr7qUosu` decimal(26,1),`yHEdFtWhrgQ` character varying(255),`LDBgHTyoArb` character varying(255),`rHyH122ENsq` character varying(255),`ZGY6AsIs6hT` character varying(255),`aR1bC4yzzvR` character varying(255),`jFrDhbnfbXk` character varying(255),`UbCpUHRlAgD` character varying(255),`VcVIlgAdMad` character varying(255),`zT1xmebG22q` decimal(26,1),`aKYCqJoIODU` character varying(255),`Xn2ydGLDEfW` character varying(255),`TdJFv8wd43Y` character varying(255),`J1gjv4X5isz` character varying(255),`sKwec64Jqq6` character varying(255),`nuI61F7eGY8` character varying(255),`OVD6Pr5BJ9a` character varying(255),`EsmzM5QNqTh` character varying(255),`cH99y6jVEFH` decimal(26,1),`MhgY1Hd1XLP` character varying(255),`hKy66QQjpJ3` character varying(255),`XLQJ7fE1QdQ` character varying(255),`YYc3ygpLjt1` character varying(255),`y9DcSfWuObO` character varying(255),`NNOeK8Au5pi` character varying(255),`ZIjrsPlodZp` character varying(255),`ubjiJ7PLMCI` character varying(255),`MXCRVR8yco8` character varying(255),`k0qTCTSRyCf` character varying(255),`UxlqRfwnsQh` character varying(255),`G71wUs7CpWw` decimal(26,1),`jykNnXYHpZr` decimal(26,1),`xeUjAMCHJnZ` decimal(26,1),`nHHqStYs5C0` character varying(255),`SsKE2WvK1Sl` character varying(255),`thsSPQngCJs` decimal(26,1),`UpcDVyEyYgm` character varying(255),`FbD2bjCyfSV` character varying(255),`VlDv3n4CWoo` character varying(255),`ztRRR3Xx3CI` character varying(255),`Pt7EWWvQhlv` decimal(26,1),`oB2EZNAAKdH` character varying(255),`O3XH16kXAhG` character varying(255),`JF8rUAIsXsX` character varying(255),`NCmbNi8UC8U` character varying(255),`OZmm5VSBZ94` character varying(255),`Wn9dJQovCEq` character varying(255),`ihnPpeWKEHi` character varying(255),`v7YRJhSYLCO` character varying(255),`Xg4tA0i7mAh` character varying(255),`Jxi2epLKU6v` character varying(255),`YIeOGkfOV1W` character varying(255),`Ksoq7YJoij8` character varying(255),`H0iY8iy55XY` character varying(255),`Yc0R5dnns55` character varying(255),`F9RGslVQIKr` decimal(26,1),`jwr6Ba6BI7U` decimal(26,1),`iBgLoG57OY0` character varying(255),`x6YOnc9cq9j` character varying(255),`FArjQYqK4c3` character varying(255),`YUciCU57O70` character varying(255),`xfAqwpm0SzZ` character varying(255),`aUR8tzHDiD7` character varying(255),`MfJzyIv3duo` character varying(255),`yzn4a8lR3ZH` character varying(255),`NZBfuIYRcu6` character varying(255),`zExtGFIDiDo` character varying(255),`T6cqkKYlYly` character varying(255),`uMSOw5udp1L` character varying(255),`wfLP2Ih8Ihf` character varying(255),`cX9iWJngdn6` character varying(255),`DUSUrQh1DER` character varying(255),`zL2OEumJbUB` character varying(255),`AkS4kt55nwh` character varying(255),`yVnbNlIh3ou` decimal(26,1),`WJwfpgI07jR` character varying(255),`Z7IrXvgBARZ` decimal(26,1),`tk8uARt3eFY` decimal(26,1),`U11sOEDOPyO` character varying(255),`beEFugLyFQN` decimal(26,1),`LIxlBc9CHWE` character varying(255),`MJORRMzmtEO` character varying(255),`vsQO1bgG0hV` decimal(26,1),`cVB9xNMLqFB` character varying(255),`xhG0NetnOiC` character varying(255),`C10tJNGrUUV` character varying(255),`UmNpRtSaWlu` character varying(255),`eJxJeXimmOB` decimal(26,1),`QhTUIzQ2Cro` character varying(255),`ncN7oZJFXH1` character varying(255),`aSX0p24Q3Ws` character varying(255),`FuJAP0LgtBF` character varying(255),`erxRiWMqlpz` character varying(255),`gBvirIeI4kQ` decimal(26,1),`SChj2rF71Zn` character varying(255),`iv3wrjHYFdh` character varying(255),`CRMOR7eXKjA` character varying(255),`yd21kSQDgPm` character varying(255),`RgJIOoQ2TNL` character varying(255),`Q3k6ZYLOZW4` character varying(255),`o5SnxY1h1YM` character varying(255),`OUunJaNbnUi` character varying(255),`psi` character(11) not null,`ps` character(11) not null,`executiondate` timestamp,`longitude` decimal(26,1),`latitude` decimal(26,1),`ou` character(11) not null,`ouname` character varying(230) not null,`oucode` character varying(50)) (JdbcEventAnalyticsTableManager.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,577 Created analytics tables: 0:00:00.304 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,578 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:25 IST 2014, message: Populating analytics tables] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,578 Populate table task number: 2 (DefaultAnalyticsTableService.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,591 Populate SQL: insert into analytics_event_temp_2014_N1vNV1bQajX (`uidlevel1`,`uidlevel2`,`uidlevel3`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`sixmonthlyapril`,`yearly`,`financialapril`,`financialjuly`,`financialoct`,`GqgcmzgHQXt`,`c2l0paX05kh`,`CnC8sb2n1VZ`,`fGahYAjRkZQ`,`bUrbjpJa8EC`,`l99dMZByxwA`,`yHEdFtWhrgQ`,`LDBgHTyoArb`,`ZGY6AsIs6hT`,`jFrDhbnfbXk`,`zT1xmebG22q`,`aKYCqJoIODU`,`J1gjv4X5isz`,`nuI61F7eGY8`,`OVD6Pr5BJ9a`,`MhgY1Hd1XLP`,`XLQJ7fE1QdQ`,`YYc3ygpLjt1`,`y9DcSfWuObO`,`ubjiJ7PLMCI`,`k0qTCTSRyCf`,`pDPGMpgew6y`,`jykNnXYHpZr`,`xeUjAMCHJnZ`,`nHHqStYs5C0`,`Y3SA8rQQICg`,`thsSPQngCJs`,`FbD2bjCyfSV`,`VlDv3n4CWoo`,`ztRRR3Xx3CI`,`oB2EZNAAKdH`,`O3XH16kXAhG`,`NCmbNi8UC8U`,`OZmm5VSBZ94`,`Wn9dJQovCEq`,`TWX9SGCA7aO`,`v7YRJhSYLCO`,`Xg4tA0i7mAh`,`Ksoq7YJoij8`,`H0iY8iy55XY`,`iBgLoG57OY0`,`F9RGslVQIKr`,`jwr6Ba6BI7U`,`x6YOnc9cq9j`,`YUciCU57O70`,`xfAqwpm0SzZ`,`aUR8tzHDiD7`,`MfJzyIv3duo`,`NZBfuIYRcu6`,`zExtGFIDiDo`,`uMSOw5udp1L`,`DUSUrQh1DER`,`zL2OEumJbUB`,`WJwfpgI07jR`,`Z7IrXvgBARZ`,`beEFugLyFQN`,`LIxlBc9CHWE`,`MJORRMzmtEO`,`vsQO1bgG0hV`,`cVB9xNMLqFB`,`xhG0NetnOiC`,`C10tJNGrUUV`,`UmNpRtSaWlu`,`erxRiWMqlpz`,`eJxJeXimmOB`,`gBvirIeI4kQ`,`SChj2rF71Zn`,`QhTUIzQ2Cro`,`ncN7oZJFXH1`,`aSX0p24Q3Ws`,`FuJAP0LgtBF`,`iv3wrjHYFdh`,`CRMOR7eXKjA`,`yd21kSQDgPm`,`Q3k6ZYLOZW4`,`RgJIOoQ2TNL`,`o5SnxY1h1YM`,`OUunJaNbnUi`,`psi`,`ps`,`executiondate`,`longitude`,`latitude`,`ou`,`ouname`,`oucode`) select ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,dps.`daily`,dps.`weekly`,dps.`monthly`,dps.`bimonthly`,dps.`quarterly`,dps.`sixmonthly`,dps.`sixmonthlyapril`,dps.`yearly`,dps.`financialapril`,dps.`financialjuly`,dps.`financialoct`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=77) as `GqgcmzgHQXt`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=63 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `c2l0paX05kh`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=34 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `CnC8sb2n1VZ`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=28 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `fGahYAjRkZQ`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=97) as `bUrbjpJa8EC`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=36 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `l99dMZByxwA`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=86) as `yHEdFtWhrgQ`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=22) as `LDBgHTyoArb`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=82) as `ZGY6AsIs6hT`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=42) as `jFrDhbnfbXk`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=44 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `zT1xmebG22q`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=27) as `aKYCqJoIODU`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=83) as `J1gjv4X5isz`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=46) as `nuI61F7eGY8`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=62) as `OVD6Pr5BJ9a`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=91) as `MhgY1Hd1XLP`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=76) as `XLQJ7fE1QdQ`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=5) as `YYc3ygpLjt1`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=81) as `y9DcSfWuObO`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=16) as `ubjiJ7PLMCI`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=93) as `k0qTCTSRyCf`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=64) as `pDPGMpgew6y`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=40 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `jykNnXYHpZr`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=45 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `xeUjAMCHJnZ`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=84) as `nHHqStYs5C0`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=79) as `Y3SA8rQQICg`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=35 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `thsSPQngCJs`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=24) as `FbD2bjCyfSV`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=75) as `VlDv3n4CWoo`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=41) as `ztRRR3Xx3CI`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1) as `oB2EZNAAKdH`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=23) as `O3XH16kXAhG`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=92) as `NCmbNi8UC8U`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=66) as `OZmm5VSBZ94`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=25) as `Wn9dJQovCEq`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=78) as `TWX9SGCA7aO`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=96) as `v7YRJhSYLCO`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=14) as `Xg4tA0i7mAh`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=10) as `Ksoq7YJoij8`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=58) as `H0iY8iy55XY`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2) as `iBgLoG57OY0`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=11 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `F9RGslVQIKr`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=15 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `jwr6Ba6BI7U`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=65) as `x6YOnc9cq9j`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=38) as `YUciCU57O70`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=85) as `xfAqwpm0SzZ`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=59) as `aUR8tzHDiD7`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=37) as `MfJzyIv3duo`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=74) as `NZBfuIYRcu6`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=95) as `zExtGFIDiDo`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=43) as `uMSOw5udp1L`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=80) as `DUSUrQh1DER`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=94) as `zL2OEumJbUB`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=26) as `WJwfpgI07jR`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=29 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `Z7IrXvgBARZ`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=39 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `beEFugLyFQN`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=47) as `LIxlBc9CHWE`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=1) as `MJORRMzmtEO`,(select cast(value as decimal(26,1)) from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=2 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `vsQO1bgG0hV`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=4) as `cVB9xNMLqFB`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=5) as `xhG0NetnOiC`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=7) as `C10tJNGrUUV`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=6) as `UmNpRtSaWlu`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=9) as `erxRiWMqlpz`,(select cast(value as decimal(26,1)) from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=8 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `eJxJeXimmOB`,(select cast(value as decimal(26,1)) from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=10 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `gBvirIeI4kQ`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=11) as `SChj2rF71Zn`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=12) as `QhTUIzQ2Cro`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=13) as `ncN7oZJFXH1`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=14) as `aSX0p24Q3Ws`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=15) as `FuJAP0LgtBF`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=16) as `iv3wrjHYFdh`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=17) as `CRMOR7eXKjA`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=18) as `yd21kSQDgPm`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=20) as `Q3k6ZYLOZW4`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=19) as `RgJIOoQ2TNL`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=21) as `o5SnxY1h1YM`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=22) as `OUunJaNbnUi`,psi.uid,ps.uid,psi.executiondate,psi.longitude,psi.latitude,ou.uid,ou.name,ou.code from programstageinstance psi left join programinstance pi on psi.programinstanceid=pi.programinstanceid left join programstage ps on psi.programstageid=ps.programstageid left join program pr on pi.programid=pr.programid left join trackedentityinstance pa on pi.trackedentityinstanceid=pa.trackedentityinstanceid left join organisationunit ou on psi.organisationunitid=ou.organisationunitid left join _orgunitstructure ous on psi.organisationunitid=ous.organisationunitid left join _dateperiodstructure dps on psi.executiondate=dps.dateperiod where psi.executiondate >= '2014-01-01' and psi.executiondate <= '2014-12-31' and pr.programid=1 and psi.organisationunitid is not null and psi.executiondate is not null (JdbcEventAnalyticsTableManager.java [SimpleAsyncTaskExecutor-152])
* INFO 2014-06-05 11:36:25,593 Populate SQL: insert into analytics_event_temp_2014_PuI4zk5MjcM (`uidlevel1`,`uidlevel2`,`uidlevel3`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`sixmonthlyapril`,`yearly`,`financialapril`,`financialjuly`,`financialoct`,`WZA8gXVUeIJ`,`ESGzNcksTS3`,`CnC8sb2n1VZ`,`fGahYAjRkZQ`,`bUrbjpJa8EC`,`l99dMZByxwA`,`nhmCr7qUosu`,`yHEdFtWhrgQ`,`LDBgHTyoArb`,`rHyH122ENsq`,`ZGY6AsIs6hT`,`aR1bC4yzzvR`,`jFrDhbnfbXk`,`UbCpUHRlAgD`,`VcVIlgAdMad`,`zT1xmebG22q`,`aKYCqJoIODU`,`Xn2ydGLDEfW`,`TdJFv8wd43Y`,`J1gjv4X5isz`,`sKwec64Jqq6`,`nuI61F7eGY8`,`OVD6Pr5BJ9a`,`EsmzM5QNqTh`,`cH99y6jVEFH`,`MhgY1Hd1XLP`,`hKy66QQjpJ3`,`XLQJ7fE1QdQ`,`YYc3ygpLjt1`,`y9DcSfWuObO`,`NNOeK8Au5pi`,`ZIjrsPlodZp`,`ubjiJ7PLMCI`,`MXCRVR8yco8`,`k0qTCTSRyCf`,`UxlqRfwnsQh`,`G71wUs7CpWw`,`jykNnXYHpZr`,`xeUjAMCHJnZ`,`nHHqStYs5C0`,`SsKE2WvK1Sl`,`thsSPQngCJs`,`UpcDVyEyYgm`,`FbD2bjCyfSV`,`VlDv3n4CWoo`,`ztRRR3Xx3CI`,`Pt7EWWvQhlv`,`oB2EZNAAKdH`,`O3XH16kXAhG`,`JF8rUAIsXsX`,`NCmbNi8UC8U`,`OZmm5VSBZ94`,`Wn9dJQovCEq`,`ihnPpeWKEHi`,`v7YRJhSYLCO`,`Xg4tA0i7mAh`,`Jxi2epLKU6v`,`YIeOGkfOV1W`,`Ksoq7YJoij8`,`H0iY8iy55XY`,`Yc0R5dnns55`,`F9RGslVQIKr`,`jwr6Ba6BI7U`,`iBgLoG57OY0`,`x6YOnc9cq9j`,`FArjQYqK4c3`,`YUciCU57O70`,`xfAqwpm0SzZ`,`aUR8tzHDiD7`,`MfJzyIv3duo`,`yzn4a8lR3ZH`,`NZBfuIYRcu6`,`zExtGFIDiDo`,`T6cqkKYlYly`,`uMSOw5udp1L`,`wfLP2Ih8Ihf`,`cX9iWJngdn6`,`DUSUrQh1DER`,`zL2OEumJbUB`,`AkS4kt55nwh`,`yVnbNlIh3ou`,`WJwfpgI07jR`,`Z7IrXvgBARZ`,`tk8uARt3eFY`,`U11sOEDOPyO`,`beEFugLyFQN`,`LIxlBc9CHWE`,`MJORRMzmtEO`,`vsQO1bgG0hV`,`cVB9xNMLqFB`,`xhG0NetnOiC`,`C10tJNGrUUV`,`UmNpRtSaWlu`,`eJxJeXimmOB`,`QhTUIzQ2Cro`,`ncN7oZJFXH1`,`aSX0p24Q3Ws`,`FuJAP0LgtBF`,`erxRiWMqlpz`,`gBvirIeI4kQ`,`SChj2rF71Zn`,`iv3wrjHYFdh`,`CRMOR7eXKjA`,`yd21kSQDgPm`,`RgJIOoQ2TNL`,`Q3k6ZYLOZW4`,`o5SnxY1h1YM`,`OUunJaNbnUi`,`psi`,`ps`,`executiondate`,`longitude`,`latitude`,`ou`,`ouname`,`oucode`) select ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,dps.`daily`,dps.`weekly`,dps.`monthly`,dps.`bimonthly`,dps.`quarterly`,dps.`sixmonthly`,dps.`sixmonthlyapril`,dps.`yearly`,dps.`financialapril`,dps.`financialjuly`,dps.`financialoct`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=68) as `WZA8gXVUeIJ`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=51) as `ESGzNcksTS3`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=34 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `CnC8sb2n1VZ`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=28 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `fGahYAjRkZQ`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=97) as `bUrbjpJa8EC`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=36 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `l99dMZByxwA`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=32 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `nhmCr7qUosu`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=86) as `yHEdFtWhrgQ`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=22) as `LDBgHTyoArb`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=72) as `rHyH122ENsq`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=82) as `ZGY6AsIs6hT`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=70) as `aR1bC4yzzvR`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=42) as `jFrDhbnfbXk`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=55) as `UbCpUHRlAgD`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=60) as `VcVIlgAdMad`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=44 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `zT1xmebG22q`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=27) as `aKYCqJoIODU`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=89) as `Xn2ydGLDEfW`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=87) as `TdJFv8wd43Y`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=83) as `J1gjv4X5isz`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=57) as `sKwec64Jqq6`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=46) as `nuI61F7eGY8`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=62) as `OVD6Pr5BJ9a`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=88) as `EsmzM5QNqTh`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=18 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `cH99y6jVEFH`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=91) as `MhgY1Hd1XLP`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=69) as `hKy66QQjpJ3`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=76) as `XLQJ7fE1QdQ`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=5) as `YYc3ygpLjt1`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=81) as `y9DcSfWuObO`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=56) as `NNOeK8Au5pi`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=61) as `ZIjrsPlodZp`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=16) as `ubjiJ7PLMCI`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=54) as `MXCRVR8yco8`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=93) as `k0qTCTSRyCf`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=52) as `UxlqRfwnsQh`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=7 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `G71wUs7CpWw`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=40 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `jykNnXYHpZr`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=45 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `xeUjAMCHJnZ`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=84) as `nHHqStYs5C0`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=48) as `SsKE2WvK1Sl`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=35 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `thsSPQngCJs`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=8) as `UpcDVyEyYgm`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=24) as `FbD2bjCyfSV`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=75) as `VlDv3n4CWoo`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=41) as `ztRRR3Xx3CI`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=19 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `Pt7EWWvQhlv`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=1) as `oB2EZNAAKdH`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=23) as `O3XH16kXAhG`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=53) as `JF8rUAIsXsX`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=92) as `NCmbNi8UC8U`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=66) as `OZmm5VSBZ94`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=25) as `Wn9dJQovCEq`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=50) as `ihnPpeWKEHi`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=96) as `v7YRJhSYLCO`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=14) as `Xg4tA0i7mAh`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=6) as `Jxi2epLKU6v`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=17) as `YIeOGkfOV1W`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=10) as `Ksoq7YJoij8`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=58) as `H0iY8iy55XY`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=67) as `Yc0R5dnns55`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=11 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `F9RGslVQIKr`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=15 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `jwr6Ba6BI7U`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=2) as `iBgLoG57OY0`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=65) as `x6YOnc9cq9j`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=49) as `FArjQYqK4c3`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=38) as `YUciCU57O70`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=85) as `xfAqwpm0SzZ`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=59) as `aUR8tzHDiD7`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=37) as `MfJzyIv3duo`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=33) as `yzn4a8lR3ZH`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=74) as `NZBfuIYRcu6`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=95) as `zExtGFIDiDo`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=31) as `T6cqkKYlYly`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=43) as `uMSOw5udp1L`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=30) as `wfLP2Ih8Ihf`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=21) as `cX9iWJngdn6`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=80) as `DUSUrQh1DER`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=94) as `zL2OEumJbUB`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=73) as `AkS4kt55nwh`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=9 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `yVnbNlIh3ou`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=26) as `WJwfpgI07jR`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=29 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `Z7IrXvgBARZ`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=20 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `tk8uARt3eFY`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=90) as `U11sOEDOPyO`,(select cast(value as decimal(26,1)) from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=39 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `beEFugLyFQN`,(select value from trackedentitydatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=47) as `LIxlBc9CHWE`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=1) as `MJORRMzmtEO`,(select cast(value as decimal(26,1)) from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=2 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `vsQO1bgG0hV`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=4) as `cVB9xNMLqFB`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=5) as `xhG0NetnOiC`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=7) as `C10tJNGrUUV`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=6) as `UmNpRtSaWlu`,(select cast(value as decimal(26,1)) from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=8 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `eJxJeXimmOB`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=12) as `QhTUIzQ2Cro`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=13) as `ncN7oZJFXH1`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=14) as `aSX0p24Q3Ws`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=15) as `FuJAP0LgtBF`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=9) as `erxRiWMqlpz`,(select cast(value as decimal(26,1)) from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=10 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `gBvirIeI4kQ`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=11) as `SChj2rF71Zn`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=16) as `iv3wrjHYFdh`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=17) as `CRMOR7eXKjA`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=18) as `yd21kSQDgPm`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=19) as `RgJIOoQ2TNL`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=20) as `Q3k6ZYLOZW4`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=21) as `o5SnxY1h1YM`,(select value from trackedentityattributevalue where trackedentityinstanceid=pi.trackedentityinstanceid and trackedentityattributeid=22) as `OUunJaNbnUi`,psi.uid,ps.uid,psi.executiondate,psi.longitude,psi.latitude,ou.uid,ou.name,ou.code from programstageinstance psi left join programinstance pi on psi.programinstanceid=pi.programinstanceid left join programstage ps on psi.programstageid=ps.programstageid left join program pr on pi.programid=pr.programid left join trackedentityinstance pa on pi.trackedentityinstanceid=pa.trackedentityinstanceid left join organisationunit ou on psi.organisationunitid=ou.organisationunitid left join _orgunitstructure ous on psi.organisationunitid=ous.organisationunitid left join _dateperiodstructure dps on psi.executiondate=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 psi.executiondate is not null (JdbcEventAnalyticsTableManager.java [SimpleAsyncTaskExecutor-153])
* INFO 2014-06-05 11:36:25,678 Populated analytics tables: 0:00:00.405 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:25,679 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:25 IST 2014, message: Pruned analytics tables] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:26,471 Pruned analytics tables: 0:00:01.198 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:26,471 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:26 IST 2014, message: Applying aggregation levels] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:26,477 Applied aggregation levels: 0:00:01.204 (Clock.java [taskScheduler-2])
* INFO 2014-06-05 11:36:26,478 [Level: INFO, category: DATAMART, time: Thu Jun 05 11:36:26 IST 2014, message: Creating indexes] (InMemoryNotifier.java [taskScheduler-2])
* INFO 2014-06-05 11:36:26,479 No of indexes: 230 (DefaultAnalyticsTableService.java [taskScheduler-2])
* INFO 2014-06-05 11:36:26,650 Created index: `in_uidlevel1_analytics_event_temp_2014_N1vNV1bQajX_uR5Ay` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-155])
* INFO 2014-06-05 11:36:26,786 Created index: `in_uidlevel2_analytics_event_temp_2014_N1vNV1bQajX_s3uuU` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-156])
* INFO 2014-06-05 11:36:26,921 Created index: `in_uidlevel3_analytics_event_temp_2014_N1vNV1bQajX_uNJ0n` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-157])
* INFO 2014-06-05 11:36:27,078 Created index: `in_daily_analytics_event_temp_2014_N1vNV1bQajX_DGDYN` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-155])
* INFO 2014-06-05 11:36:27,247 Created index: `in_weekly_analytics_event_temp_2014_N1vNV1bQajX_ERZ67` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-156])
* INFO 2014-06-05 11:36:27,449 Created index: `in_monthly_analytics_event_temp_2014_N1vNV1bQajX_o8Gug` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-157])
* INFO 2014-06-05 11:36:27,586 Created index: `in_bimonthly_analytics_event_temp_2014_N1vNV1bQajX_JdXsJ` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-155])
* INFO 2014-06-05 11:36:27,721 Created index: `in_quarterly_analytics_event_temp_2014_N1vNV1bQajX_N1B77` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-156])
* INFO 2014-06-05 11:36:27,879 Created index: `in_sixmonthly_analytics_event_temp_2014_N1vNV1bQajX_hEwIC` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-157])
* INFO 2014-06-05 11:36:28,048 Created index: `in_sixmonthlyapril_analytics_event_temp_2014_N1vNV1bQajX_FMbBV` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-155])
* INFO 2014-06-05 11:36:28,205 Created index: `in_yearly_analytics_event_temp_2014_N1vNV1bQajX_ziSRY` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-156])
* INFO 2014-06-05 11:36:28,407 Created index: `in_financialapril_analytics_event_temp_2014_N1vNV1bQajX_JoQxI` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-157])
* INFO 2014-06-05 11:36:28,579 Created index: `in_financialjuly_analytics_event_temp_2014_N1vNV1bQajX_AjIto` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-155])
* INFO 2014-06-05 11:36:28,747 Created index: `in_financialoct_analytics_event_temp_2014_N1vNV1bQajX_pHvEc` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-156])
* INFO 2014-06-05 11:36:28,906 Created index: `in_GqgcmzgHQXt_analytics_event_temp_2014_N1vNV1bQajX_Jgw0w` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-157])
* INFO 2014-06-05 11:36:29,041 Created index: `in_c2l0paX05kh_analytics_event_temp_2014_N1vNV1bQajX_nqga2` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-155])
* INFO 2014-06-05 11:36:29,178 Created index: `in_CnC8sb2n1VZ_analytics_event_temp_2014_N1vNV1bQajX_MCp1s` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-156])
* INFO 2014-06-05 11:36:29,324 Created index: `in_fGahYAjRkZQ_analytics_event_temp_2014_N1vNV1bQajX_TQgqq` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-157])
* INFO 2014-06-05 11:36:29,638 Created index: `in_bUrbjpJa8EC_analytics_event_temp_2014_N1vNV1bQajX_r2gQu` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-155])
* INFO 2014-06-05 11:36:30,107 Created index: `in_l99dMZByxwA_analytics_event_temp_2014_N1vNV1bQajX_welGB` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-156])
* INFO 2014-06-05 11:36:30,365 Created index: `in_yHEdFtWhrgQ_analytics_event_temp_2014_N1vNV1bQajX_HCFQ1` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-157])
* INFO 2014-06-05 11:36:30,523 Created index: `in_LDBgHTyoArb_analytics_event_temp_2014_N1vNV1bQajX_jT7nK` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-155])
* INFO 2014-06-05 11:36:30,790 Created index: `in_ZGY6AsIs6hT_analytics_event_temp_2014_N1vNV1bQajX_OuENi` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-156])
* INFO 2014-06-05 11:36:31,012 Created index: `in_jFrDhbnfbXk_analytics_event_temp_2014_N1vNV1bQajX_Du9Nd` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-157])
* INFO 2014-06-05 11:36:31,171 Created index: `in_zT1xmebG22q_analytics_event_temp_2014_N1vNV1bQajX_nII62` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-155])
* INFO 2014-06-05 11:36:31,318 Created index: `in_aKYCqJoIODU_analytics_event_temp_2014_N1vNV1bQajX_gYVCx` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-156])
* INFO 2014-06-05 11:36:31,550 Created index: `in_J1gjv4X5isz_analytics_event_temp_2014_N1vNV1bQajX_dAxPY` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-157])
* INFO 2014-06-05 11:36:31,697 Created index: `in_nuI61F7eGY8_analytics_event_temp_2014_N1vNV1bQajX_K9nxb` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-155])
* INFO 2014-06-05 11:36:31,855 Created index: `in_OVD6Pr5BJ9a_analytics_event_temp_2014_N1vNV1bQajX_NOsh0` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-156])
* INFO 2014-06-05 11:36:32,001 Created index: `in_MhgY1Hd1XLP_analytics_event_temp_2014_N1vNV1bQajX_GH6xe` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-157])
* INFO 2014-06-05 11:36:32,159 Created index: `in_XLQJ7fE1QdQ_analytics_event_temp_2014_N1vNV1bQajX_VB1RM` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-155])
* INFO 2014-06-05 11:36:32,316 Created index: `in_YYc3ygpLjt1_analytics_event_temp_2014_N1vNV1bQajX_i50Ls` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-156])
* INFO 2014-06-05 11:36:32,535 Created index: `in_y9DcSfWuObO_analytics_event_temp_2014_N1vNV1bQajX_L9amz` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-157])
* INFO 2014-06-05 11:36:32,689 Created index: `in_ubjiJ7PLMCI_analytics_event_temp_2014_N1vNV1bQajX_abAnd` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-155])
* INFO 2014-06-05 11:36:32,836 Created index: `in_k0qTCTSRyCf_analytics_event_temp_2014_N1vNV1bQajX_upbHd` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-156])
* INFO 2014-06-05 11:36:33,016 Created index: `in_pDPGMpgew6y_analytics_event_temp_2014_N1vNV1bQajX_Bk4k2` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-157])
* INFO 2014-06-05 11:36:33,151 Created index: `in_jykNnXYHpZr_analytics_event_temp_2014_N1vNV1bQajX_XnxE2` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-155])
* INFO 2014-06-05 11:36:33,299 Created index: `in_xeUjAMCHJnZ_analytics_event_temp_2014_N1vNV1bQajX_j3b9a` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-156])
* INFO 2014-06-05 11:36:33,502 Created index: `in_nHHqStYs5C0_analytics_event_temp_2014_N1vNV1bQajX_iejtu` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-157])
* INFO 2014-06-05 11:36:33,671 Created index: `in_Y3SA8rQQICg_analytics_event_temp_2014_N1vNV1bQajX_Weclj` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-155])
* INFO 2014-06-05 11:36:33,839 Created index: `in_thsSPQngCJs_analytics_event_temp_2014_N1vNV1bQajX_Vfm6o` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-156])
* INFO 2014-06-05 11:36:33,985 Created index: `in_FbD2bjCyfSV_analytics_event_temp_2014_N1vNV1bQajX_j6toK` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-157])
* INFO 2014-06-05 11:36:34,122 Created index: `in_VlDv3n4CWoo_analytics_event_temp_2014_N1vNV1bQajX_tgQRG` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-155])
* INFO 2014-06-05 11:36:34,280 Created index: `in_ztRRR3Xx3CI_analytics_event_temp_2014_N1vNV1bQajX_WNE1I` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-156])
* INFO 2014-06-05 11:36:34,507 Created index: `in_oB2EZNAAKdH_analytics_event_temp_2014_N1vNV1bQajX_qXe6t` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-157])
* INFO 2014-06-05 11:36:34,672 Created index: `in_O3XH16kXAhG_analytics_event_temp_2014_N1vNV1bQajX_gsBId` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-155])
* INFO 2014-06-05 11:36:34,831 Created index: `in_NCmbNi8UC8U_analytics_event_temp_2014_N1vNV1bQajX_wgYnY` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-156])
* INFO 2014-06-05 11:36:34,977 Created index: `in_OZmm5VSBZ94_analytics_event_temp_2014_N1vNV1bQajX_N5kG3` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-157])
* INFO 2014-06-05 11:36:35,125 Created index: `in_Wn9dJQovCEq_analytics_event_temp_2014_N1vNV1bQajX_BcB07` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-155])
* INFO 2014-06-05 11:36:35,273 Created index: `in_TWX9SGCA7aO_analytics_event_temp_2014_N1vNV1bQajX_tALh4` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-156])
* INFO 2014-06-05 11:36:35,541 Created index: `in_v7YRJhSYLCO_analytics_event_temp_2014_N1vNV1bQajX_J1tm8` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-157])
* INFO 2014-06-05 11:36:35,676 Created index: `in_Xg4tA0i7mAh_analytics_event_temp_2014_N1vNV1bQajX_tgLST` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-155])
* INFO 2014-06-05 11:36:35,822 Created index: `in_Ksoq7YJoij8_analytics_event_temp_2014_N1vNV1bQajX_Oex23` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-156])
* INFO 2014-06-05 11:36:35,981 Created index: `in_H0iY8iy55XY_analytics_event_temp_2014_N1vNV1bQajX_gyBXx` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-157])
* INFO 2014-06-05 11:36:36,139 Created index: `in_iBgLoG57OY0_analytics_event_temp_2014_N1vNV1bQajX_LOoEf` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-155])
* INFO 2014-06-05 11:36:36,309 Created index: `in_F9RGslVQIKr_analytics_event_temp_2014_N1vNV1bQajX_sHtNC` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-156])
* INFO 2014-06-05 11:36:36,511 Created index: `in_jwr6Ba6BI7U_analytics_event_temp_2014_N1vNV1bQajX_RMOku` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-157])
* INFO 2014-06-05 11:36:36,668 Created index: `in_x6YOnc9cq9j_analytics_event_temp_2014_N1vNV1bQajX_AUGuG` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-155])
* INFO 2014-06-05 11:36:36,816 Created index: `in_YUciCU57O70_analytics_event_temp_2014_N1vNV1bQajX_vyTZF` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-156])
* INFO 2014-06-05 11:36:36,974 Created index: `in_xfAqwpm0SzZ_analytics_event_temp_2014_N1vNV1bQajX_NNHLH` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-157])
* INFO 2014-06-05 11:36:37,120 Created index: `in_aUR8tzHDiD7_analytics_event_temp_2014_N1vNV1bQajX_K5yYC` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-155])
* INFO 2014-06-05 11:36:37,255 Created index: `in_MfJzyIv3duo_analytics_event_temp_2014_N1vNV1bQajX_L9moq` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-156])
* INFO 2014-06-05 11:36:37,453 Created index: `in_NZBfuIYRcu6_analytics_event_temp_2014_N1vNV1bQajX_etaWM` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-157])
* INFO 2014-06-05 11:36:37,626 Created index: `in_zExtGFIDiDo_analytics_event_temp_2014_N1vNV1bQajX_phCBq` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-155])
* INFO 2014-06-05 11:36:37,628 [Level: ERROR, category: DATAMART, time: Thu Jun 05 11:36:37 IST 2014, message: Process failed: Exception during execution] (InMemoryNotifier.java [taskScheduler-2])
* ERROR 2014-06-05 11:36:37,673 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-2])
java.lang.RuntimeException: Exception during execution
at org.hisp.dhis.system.util.ConcurrentUtils.waitForCompletion(ConcurrentUtils.java:55)
at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.createIndexes(DefaultAnalyticsTableService.java:272)
at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.update(DefaultAnalyticsTableService.java:132)
at org.hisp.dhis.analytics.scheduling.AnalyticsTableTask.run(AnalyticsTableTask.java:139)
at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:53)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:744)
Caused by: java.util.concurrent.ExecutionException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [create index `in_zL2OEumJbUB_analytics_event_temp_2014_N1vNV1bQajX_Oi8Qa` on analytics_event_temp_2014_N1vNV1bQajX (`zL2OEumJbUB`)]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Too many keys specified; max 64 keys allowed
at java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.util.concurrent.FutureTask.get(FutureTask.java:188)
at org.hisp.dhis.system.util.ConcurrentUtils.waitForCompletion(ConcurrentUtils.java:51)
... 12 more
Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [create index `in_zL2OEumJbUB_analytics_event_temp_2014_N1vNV1bQajX_Oi8Qa` on analytics_event_temp_2014_N1vNV1bQajX (`zL2OEumJbUB`)]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Too many keys specified; max 64 keys allowed
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:95)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
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.AbstractJdbcTableManager.createIndexesAsync(AbstractJdbcTableManager.java:175)
at sun.reflect.GeneratedMethodAccessor966.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(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.run(FutureTask.java:262)
... 1 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Too many keys specified; max 64 keys allowed
at sun.reflect.GeneratedConstructorAccessor73.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
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)
... 11 more
* WARN 2014-06-05 11:37:15,188 baseType was not found, returning. (WebUtils.java [http-bio-8080-exec-125])
* WARN 2014-06-05 11:37:21,809 baseType was not found, returning. (WebUtils.java [http-bio-8080-exec-124])
* WARN 2014-06-05 12:35:09,696 baseType was not found, returning. (WebUtils.java [http-bio-8080-exec-122])
Attachment:
dhis2_datamart error.png
Description: PNG image
Follow ups
