* INFO  2014-03-27 09:38:52,064 Login success for user: 'admin', ip: '0:0:0:0:0:0:0:1' (DefaultUserAuditService.java [http-bio-8080-exec-9])
* INFO  2014-03-27 09:39:20,886 Drop view SQL: DROP VIEW IF EXISTS `_view_sql` (JdbcSqlViewExpandStore.java [taskScheduler-1])
* INFO  2014-03-27 09:39:21,019 Create organisation unit structure table SQL: CREATE TABLE _orgunitstructure ( organisationunitid INTEGER NOT NULL PRIMARY KEY, level INTEGER, `idlevel1` INTEGER, `uidlevel1` CHARACTER(11), `idlevel2` INTEGER, `uidlevel2` CHARACTER(11), `idlevel3` INTEGER, `uidlevel3` CHARACTER(11), `idlevel4` INTEGER, `uidlevel4` CHARACTER(11), `idlevel5` INTEGER, `uidlevel5` CHARACTER(11)); (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2014-03-27 09:39:22,054 Organisation unit structure table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  2014-03-27 09:39:22,190 Create category option combo name table SQL: CREATE TABLE _categoryoptioncomboname ( categoryoptioncomboid INTEGER NOT NULL PRIMARY KEY, categoryoptioncomboname VARCHAR(250) ) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2014-03-27 09:39:22,447 Category option combo name table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  2014-03-27 09:39:22,556 Create data element group set table SQL: CREATE TABLE _dataelementgroupsetstructure ( dataelementid INTEGER NOT NULL, dataelementname VARCHAR (250), `Movimento Mensal` VARCHAR (250), `m0CO4DRdSSX` CHARACTER(11), PRIMARY KEY ( dataelementid ) ) (CreateDataElementGroupSetTableStatement.java [taskScheduler-1])
* INFO  2014-03-27 09:39:22,726 Data element group set table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  2014-03-27 09:39:22,810 Create indicator group set table SQL: CREATE TABLE _indicatorgroupsetstructure ( indicatorid INTEGER NOT NULL, indicatorname VARCHAR (250), PRIMARY KEY ( indicatorid ) ) (CreateIndicatorGroupSetTableStatement.java [taskScheduler-1])
* INFO  2014-03-27 09:39:22,919 Indicator group set table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  2014-03-27 09:39:23,120 Create organisation unit group set table SQL: CREATE TABLE _organisationunitgroupsetstructure ( organisationunitid INTEGER NOT NULL, organisationunitname VARCHAR (250), `Condição` VARCHAR (250), `OG1iex40dgt` CHARACTER(11), `Objeto do Contrato` VARCHAR (250), `mOSYLiJl2Rr` CHARACTER(11), `Ownership` VARCHAR (250), `urRM7RqSmsQ` CHARACTER(11), `Propriedade` VARCHAR (250), `l6sVEPoDs4c` CHARACTER(11), `Status` VARCHAR (250), `fyG1zvnm5kk` CHARACTER(11), `Tipo de Contrato` VARCHAR (250), `eYLfn5pOt0G` CHARACTER(11), `Tipo de Posto` VARCHAR (250), `z0YbxVyixIH` CHARACTER(11), `Type` VARCHAR (250), `RWuSZi04nxa` CHARACTER(11), PRIMARY KEY ( organisationunitid ) ) (CreateOrganisationUnitGroupSetTableStatement.java [taskScheduler-1])
* INFO  2014-03-27 09:39:23,525 Organisation unit group set table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  2014-03-27 09:39:23,634 Create category structure table SQL: CREATE TABLE _categorystructure ( categoryoptioncomboid INTEGER NOT NULL, categoryoptioncomboname VARCHAR (250), `default` VARCHAR (250), `ojcGTx135x8` CHARACTER(11), `Dias da Semana` VARCHAR (250), `fj5pVD6YODD` CHARACTER(11), `Horário` VARCHAR (250), `kdUgt4t78Lf` CHARACTER(11), `Idade 20 anos` VARCHAR (250), `Q0kwehltBxu` CHARACTER(11), `Idade PF` VARCHAR (250), `T9SDeRBqDJr` CHARACTER(11), `Movimento de Estoque` VARCHAR (250), `TokJOSLwyKI` CHARACTER(11), `Planejamento Familiar - métodos` VARCHAR (250), `GKIHxHw8SMk` CHARACTER(11), `Sexo` VARCHAR (250), `AkFam24kaJy` CHARACTER(11), `Tipo cliente` VARCHAR (250), `NpmjkUytguw` CHARACTER(11), `Turno` VARCHAR (250), `hUaEljgcWCd` CHARACTER(11), PRIMARY KEY ( categoryoptioncomboid ) ) (CreateCategoryTableStatement.java [taskScheduler-1])
* INFO  2014-03-27 09:39:23,794 Category table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  2014-03-27 09:39:23,953 Create data element structure SQL: CREATE TABLE _dataelementstructure ( dataelementid INTEGER NOT NULL PRIMARY KEY, dataelementname VARCHAR(250), periodtypeid INTEGER, periodtypename VARCHAR(250) ) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2014-03-27 09:39:24,437 Data element table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  2014-03-27 09:39:24,556 Create period structure SQL: CREATE TABLE _periodstructure (periodid INTEGER NOT NULL PRIMARY KEY, iso VARCHAR(10) NOT NULL, daysno INTEGER NOT NULL, `daily` VARCHAR(10), `weekly` VARCHAR(10), `monthly` VARCHAR(10), `bimonthly` VARCHAR(10), `quarterly` VARCHAR(10), `sixmonthly` VARCHAR(10), `yearly` VARCHAR(10), `financialapril` VARCHAR(10), `financialjuly` VARCHAR(10), `financialoct` VARCHAR(10)) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2014-03-27 09:39:24,696 Date period table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  2014-03-27 09:39:24,750 Create date period structure SQL: CREATE TABLE _dateperiodstructure (dateperiod DATE NOT NULL PRIMARY KEY, `daily` VARCHAR(10), `weekly` VARCHAR(10), `monthly` VARCHAR(10), `bimonthly` VARCHAR(10), `quarterly` VARCHAR(10), `sixmonthly` VARCHAR(10), `yearly` VARCHAR(10), `financialapril` VARCHAR(10), `financialjuly` VARCHAR(10), `financialoct` VARCHAR(10)) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2014-03-27 09:39:34,506 Period table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  2014-03-27 09:39:34,654 Create data element category option combo SQL: CREATE TABLE _dataelementcategoryoptioncombo (dataelementuid VARCHAR(11) NOT NULL, categoryoptioncombouid VARCHAR(11) NOT NULL) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2014-03-27 09:39:34,654 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-1])
* INFO  2014-03-27 09:39:34,667 Create data element category option combo index SQL: CREATE INDEX dataelement_categoryoptioncombo ON _dataelementcategoryoptioncombo (dataelementuid, categoryoptioncombouid) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2014-03-27 09:39:34,802 Data element category option combo table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  2014-03-27 09:39:34,807 Drop view SQL: DROP VIEW IF EXISTS `_view_sql` (JdbcSqlViewExpandStore.java [taskScheduler-1])
* INFO  2014-03-27 09:39:34,837 [Level: INFO, category: DATAMART, time: Thu Mar 27 09:39:34 GMT-03:00 2014, message: Updating resource tables] (InMemoryNotifier.java [taskScheduler-1])
* INFO  2014-03-27 09:39:34,840 Drop view SQL: DROP VIEW IF EXISTS `_view_sql` (JdbcSqlViewExpandStore.java [taskScheduler-1])
* INFO  2014-03-27 09:39:34,898 Create organisation unit structure table SQL: CREATE TABLE _orgunitstructure ( organisationunitid INTEGER NOT NULL PRIMARY KEY, level INTEGER, `idlevel1` INTEGER, `uidlevel1` CHARACTER(11), `idlevel2` INTEGER, `uidlevel2` CHARACTER(11), `idlevel3` INTEGER, `uidlevel3` CHARACTER(11), `idlevel4` INTEGER, `uidlevel4` CHARACTER(11), `idlevel5` INTEGER, `uidlevel5` CHARACTER(11)); (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2014-03-27 09:39:35,269 Organisation unit structure table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  2014-03-27 09:39:35,344 Create category option combo name table SQL: CREATE TABLE _categoryoptioncomboname ( categoryoptioncomboid INTEGER NOT NULL PRIMARY KEY, categoryoptioncomboname VARCHAR(250) ) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2014-03-27 09:39:35,522 Category option combo name table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  2014-03-27 09:39:35,637 Create data element group set table SQL: CREATE TABLE _dataelementgroupsetstructure ( dataelementid INTEGER NOT NULL, dataelementname VARCHAR (250), `Movimento Mensal` VARCHAR (250), `m0CO4DRdSSX` CHARACTER(11), PRIMARY KEY ( dataelementid ) ) (CreateDataElementGroupSetTableStatement.java [taskScheduler-1])
* INFO  2014-03-27 09:39:35,947 Data element group set table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  2014-03-27 09:39:36,638 Create indicator group set table SQL: CREATE TABLE _indicatorgroupsetstructure ( indicatorid INTEGER NOT NULL, indicatorname VARCHAR (250), PRIMARY KEY ( indicatorid ) ) (CreateIndicatorGroupSetTableStatement.java [taskScheduler-1])
* INFO  2014-03-27 09:39:36,735 Indicator group set table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  2014-03-27 09:39:40,266 Create organisation unit group set table SQL: CREATE TABLE _organisationunitgroupsetstructure ( organisationunitid INTEGER NOT NULL, organisationunitname VARCHAR (250), `Condição` VARCHAR (250), `OG1iex40dgt` CHARACTER(11), `Objeto do Contrato` VARCHAR (250), `mOSYLiJl2Rr` CHARACTER(11), `Ownership` VARCHAR (250), `urRM7RqSmsQ` CHARACTER(11), `Propriedade` VARCHAR (250), `l6sVEPoDs4c` CHARACTER(11), `Status` VARCHAR (250), `fyG1zvnm5kk` CHARACTER(11), `Tipo de Contrato` VARCHAR (250), `eYLfn5pOt0G` CHARACTER(11), `Tipo de Posto` VARCHAR (250), `z0YbxVyixIH` CHARACTER(11), `Type` VARCHAR (250), `RWuSZi04nxa` CHARACTER(11), PRIMARY KEY ( organisationunitid ) ) (CreateOrganisationUnitGroupSetTableStatement.java [taskScheduler-1])
* INFO  2014-03-27 09:39:40,599 Organisation unit group set table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  2014-03-27 09:39:40,698 Create category structure table SQL: CREATE TABLE _categorystructure ( categoryoptioncomboid INTEGER NOT NULL, categoryoptioncomboname VARCHAR (250), `default` VARCHAR (250), `ojcGTx135x8` CHARACTER(11), `Dias da Semana` VARCHAR (250), `fj5pVD6YODD` CHARACTER(11), `Horário` VARCHAR (250), `kdUgt4t78Lf` CHARACTER(11), `Idade 20 anos` VARCHAR (250), `Q0kwehltBxu` CHARACTER(11), `Idade PF` VARCHAR (250), `T9SDeRBqDJr` CHARACTER(11), `Movimento de Estoque` VARCHAR (250), `TokJOSLwyKI` CHARACTER(11), `Planejamento Familiar - métodos` VARCHAR (250), `GKIHxHw8SMk` CHARACTER(11), `Sexo` VARCHAR (250), `AkFam24kaJy` CHARACTER(11), `Tipo cliente` VARCHAR (250), `NpmjkUytguw` CHARACTER(11), `Turno` VARCHAR (250), `hUaEljgcWCd` CHARACTER(11), PRIMARY KEY ( categoryoptioncomboid ) ) (CreateCategoryTableStatement.java [taskScheduler-1])
* INFO  2014-03-27 09:39:40,836 Category table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  2014-03-27 09:39:40,901 Create data element structure SQL: CREATE TABLE _dataelementstructure ( dataelementid INTEGER NOT NULL PRIMARY KEY, dataelementname VARCHAR(250), periodtypeid INTEGER, periodtypename VARCHAR(250) ) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2014-03-27 09:39:42,648 Data element table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  2014-03-27 09:39:42,703 Create period structure SQL: CREATE TABLE _periodstructure (periodid INTEGER NOT NULL PRIMARY KEY, iso VARCHAR(10) NOT NULL, daysno INTEGER NOT NULL, `daily` VARCHAR(10), `weekly` VARCHAR(10), `monthly` VARCHAR(10), `bimonthly` VARCHAR(10), `quarterly` VARCHAR(10), `sixmonthly` VARCHAR(10), `yearly` VARCHAR(10), `financialapril` VARCHAR(10), `financialjuly` VARCHAR(10), `financialoct` VARCHAR(10)) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2014-03-27 09:39:42,829 Date period table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  2014-03-27 09:39:42,903 Create date period structure SQL: CREATE TABLE _dateperiodstructure (dateperiod DATE NOT NULL PRIMARY KEY, `daily` VARCHAR(10), `weekly` VARCHAR(10), `monthly` VARCHAR(10), `bimonthly` VARCHAR(10), `quarterly` VARCHAR(10), `sixmonthly` VARCHAR(10), `yearly` VARCHAR(10), `financialapril` VARCHAR(10), `financialjuly` VARCHAR(10), `financialoct` VARCHAR(10)) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2014-03-27 09:39:51,784 Period table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  2014-03-27 09:39:52,280 Create data element category option combo SQL: CREATE TABLE _dataelementcategoryoptioncombo (dataelementuid VARCHAR(11) NOT NULL, categoryoptioncombouid VARCHAR(11) NOT NULL) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2014-03-27 09:39:52,280 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-1])
* INFO  2014-03-27 09:39:52,293 Create data element category option combo index SQL: CREATE INDEX dataelement_categoryoptioncombo ON _dataelementcategoryoptioncombo (dataelementuid, categoryoptioncombouid) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2014-03-27 09:39:52,483 Data element category option combo table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  2014-03-27 09:39:52,489 Drop view SQL: DROP VIEW IF EXISTS `_view_sql` (JdbcSqlViewExpandStore.java [taskScheduler-1])
* INFO  2014-03-27 09:39:52,525 [Level: INFO, category: DATAMART, time: Thu Mar 27 09:39:52 GMT-03:00 2014, message: Updating analytics tables] (InMemoryNotifier.java [taskScheduler-1])
* INFO  2014-03-27 09:39:52,531 Starting update, no of processes: 2: 0:00:00.000 (Clock.java [taskScheduler-1])
* INFO  2014-03-27 09:39:52,902 Get tables using earliest: 2012-01-01 00:00:00.0, latest: 2014-01-31 00:00:00.0 (AbstractJdbcTableManager.java [taskScheduler-1])
* INFO  2014-03-27 09:39:52,924 Partition tables: [analytics_2012, analytics_2013, analytics_2014], last 3 years: false: 0:00:00.396 (Clock.java [taskScheduler-1])
* INFO  2014-03-27 09:39:52,924 [Level: INFO, category: DATAMART, time: Thu Mar 27 09:39:52 GMT-03:00 2014, message: Creating analytics tables] (InMemoryNotifier.java [taskScheduler-1])
* INFO  2014-03-27 09:39:52,939 Create SQL: create table analytics_temp_2012 (`m0CO4DRdSSX` character(11),`z0YbxVyixIH` character(11),`l6sVEPoDs4c` character(11),`fyG1zvnm5kk` character(11),`OG1iex40dgt` character(11),`eYLfn5pOt0G` character(11),`mOSYLiJl2Rr` character(11),`RWuSZi04nxa` character(11),`urRM7RqSmsQ` character(11),`uidlevel1` character(11),`uidlevel2` character(11),`uidlevel3` character(11),`uidlevel4` character(11),`uidlevel5` character(11),`daily` character varying(10),`weekly` character varying(10),`monthly` character varying(10),`bimonthly` character varying(10),`quarterly` character varying(10),`sixmonthly` character varying(10),`yearly` character varying(10),`financialapril` character varying(10),`financialjuly` character varying(10),`financialoct` character varying(10),`de` character(11) not null,`co` character(11) not null,`level` integer,daysxvalue decimal(26,1), daysno integer not null, value decimal(26,1))  (JdbcAnalyticsTableManager.java [taskScheduler-1])
* INFO  2014-03-27 09:39:53,088 Create SQL: create table analytics_temp_2013 (`m0CO4DRdSSX` character(11),`z0YbxVyixIH` character(11),`l6sVEPoDs4c` character(11),`fyG1zvnm5kk` character(11),`OG1iex40dgt` character(11),`eYLfn5pOt0G` character(11),`mOSYLiJl2Rr` character(11),`RWuSZi04nxa` character(11),`urRM7RqSmsQ` character(11),`uidlevel1` character(11),`uidlevel2` character(11),`uidlevel3` character(11),`uidlevel4` character(11),`uidlevel5` character(11),`daily` character varying(10),`weekly` character varying(10),`monthly` character varying(10),`bimonthly` character varying(10),`quarterly` character varying(10),`sixmonthly` character varying(10),`yearly` character varying(10),`financialapril` character varying(10),`financialjuly` character varying(10),`financialoct` character varying(10),`de` character(11) not null,`co` character(11) not null,`level` integer,daysxvalue decimal(26,1), daysno integer not null, value decimal(26,1))  (JdbcAnalyticsTableManager.java [taskScheduler-1])
* INFO  2014-03-27 09:39:53,188 Create SQL: create table analytics_temp_2014 (`m0CO4DRdSSX` character(11),`z0YbxVyixIH` character(11),`l6sVEPoDs4c` character(11),`fyG1zvnm5kk` character(11),`OG1iex40dgt` character(11),`eYLfn5pOt0G` character(11),`mOSYLiJl2Rr` character(11),`RWuSZi04nxa` character(11),`urRM7RqSmsQ` character(11),`uidlevel1` character(11),`uidlevel2` character(11),`uidlevel3` character(11),`uidlevel4` character(11),`uidlevel5` character(11),`daily` character varying(10),`weekly` character varying(10),`monthly` character varying(10),`bimonthly` character varying(10),`quarterly` character varying(10),`sixmonthly` character varying(10),`yearly` character varying(10),`financialapril` character varying(10),`financialjuly` character varying(10),`financialoct` character varying(10),`de` character(11) not null,`co` character(11) not null,`level` integer,daysxvalue decimal(26,1), daysno integer not null, value decimal(26,1))  (JdbcAnalyticsTableManager.java [taskScheduler-1])
* INFO  2014-03-27 09:39:53,275 Created analytics tables: 0:00:00.747 (Clock.java [taskScheduler-1])
* INFO  2014-03-27 09:39:53,275 [Level: INFO, category: DATAMART, time: Thu Mar 27 09:39:53 GMT-03:00 2014, message: Populating analytics tables] (InMemoryNotifier.java [taskScheduler-1])
* INFO  2014-03-27 09:39:53,276 Populate table task number: 2 (DefaultAnalyticsTableService.java [taskScheduler-1])
* INFO  2014-03-27 09:39:53,942 Populate SQL: insert into analytics_temp_2012 (`m0CO4DRdSSX`,`z0YbxVyixIH`,`l6sVEPoDs4c`,`fyG1zvnm5kk`,`OG1iex40dgt`,`eYLfn5pOt0G`,`mOSYLiJl2Rr`,`RWuSZi04nxa`,`urRM7RqSmsQ`,`uidlevel1`,`uidlevel2`,`uidlevel3`,`uidlevel4`,`uidlevel5`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`yearly`,`financialapril`,`financialjuly`,`financialoct`,`de`,`co`,`level`,daysxvalue, daysno, value) select degs.`m0CO4DRdSSX`,ougs.`z0YbxVyixIH`,ougs.`l6sVEPoDs4c`,ougs.`fyG1zvnm5kk`,ougs.`OG1iex40dgt`,ougs.`eYLfn5pOt0G`,ougs.`mOSYLiJl2Rr`,ougs.`RWuSZi04nxa`,ougs.`urRM7RqSmsQ`,ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,ous.`uidlevel4`,ous.`uidlevel5`,ps.`daily`,ps.`weekly`,ps.`monthly`,ps.`bimonthly`,ps.`quarterly`,ps.`sixmonthly`,ps.`yearly`,ps.`financialapril`,ps.`financialjuly`,ps.`financialoct`,de.uid,co.uid,ous.level,cast(dv.value as decimal(26,1)) * ps.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 _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 >= '2012-01-01' and pe.startdate <= '2012-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-1])
* INFO  2014-03-27 09:39:53,959 Populate SQL: insert into analytics_temp_2013 (`m0CO4DRdSSX`,`z0YbxVyixIH`,`l6sVEPoDs4c`,`fyG1zvnm5kk`,`OG1iex40dgt`,`eYLfn5pOt0G`,`mOSYLiJl2Rr`,`RWuSZi04nxa`,`urRM7RqSmsQ`,`uidlevel1`,`uidlevel2`,`uidlevel3`,`uidlevel4`,`uidlevel5`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`yearly`,`financialapril`,`financialjuly`,`financialoct`,`de`,`co`,`level`,daysxvalue, daysno, value) select degs.`m0CO4DRdSSX`,ougs.`z0YbxVyixIH`,ougs.`l6sVEPoDs4c`,ougs.`fyG1zvnm5kk`,ougs.`OG1iex40dgt`,ougs.`eYLfn5pOt0G`,ougs.`mOSYLiJl2Rr`,ougs.`RWuSZi04nxa`,ougs.`urRM7RqSmsQ`,ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,ous.`uidlevel4`,ous.`uidlevel5`,ps.`daily`,ps.`weekly`,ps.`monthly`,ps.`bimonthly`,ps.`quarterly`,ps.`sixmonthly`,ps.`yearly`,ps.`financialapril`,ps.`financialjuly`,ps.`financialoct`,de.uid,co.uid,ous.level,cast(dv.value as decimal(26,1)) * ps.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 _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 >= '2013-01-01' and pe.startdate <= '2013-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-2])
* INFO  2014-03-27 09:39:55,997 Populate SQL: insert into analytics_temp_2012 (`m0CO4DRdSSX`,`z0YbxVyixIH`,`l6sVEPoDs4c`,`fyG1zvnm5kk`,`OG1iex40dgt`,`eYLfn5pOt0G`,`mOSYLiJl2Rr`,`RWuSZi04nxa`,`urRM7RqSmsQ`,`uidlevel1`,`uidlevel2`,`uidlevel3`,`uidlevel4`,`uidlevel5`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`yearly`,`financialapril`,`financialjuly`,`financialoct`,`de`,`co`,`level`,daysxvalue, daysno, value) select degs.`m0CO4DRdSSX`,ougs.`z0YbxVyixIH`,ougs.`l6sVEPoDs4c`,ougs.`fyG1zvnm5kk`,ougs.`OG1iex40dgt`,ougs.`eYLfn5pOt0G`,ougs.`mOSYLiJl2Rr`,ougs.`RWuSZi04nxa`,ougs.`urRM7RqSmsQ`,ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,ous.`uidlevel4`,ous.`uidlevel5`,ps.`daily`,ps.`weekly`,ps.`monthly`,ps.`bimonthly`,ps.`quarterly`,ps.`sixmonthly`,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 _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 >= '2012-01-01' and pe.startdate <= '2012-12-31' and dv.value is not null and dv.value = 'true' (JdbcAnalyticsTableManager.java [SimpleAsyncTaskExecutor-1])
* INFO  2014-03-27 09:39:56,178 Populate SQL: insert into analytics_temp_2012 (`m0CO4DRdSSX`,`z0YbxVyixIH`,`l6sVEPoDs4c`,`fyG1zvnm5kk`,`OG1iex40dgt`,`eYLfn5pOt0G`,`mOSYLiJl2Rr`,`RWuSZi04nxa`,`urRM7RqSmsQ`,`uidlevel1`,`uidlevel2`,`uidlevel3`,`uidlevel4`,`uidlevel5`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`yearly`,`financialapril`,`financialjuly`,`financialoct`,`de`,`co`,`level`,daysxvalue, daysno, value) select degs.`m0CO4DRdSSX`,ougs.`z0YbxVyixIH`,ougs.`l6sVEPoDs4c`,ougs.`fyG1zvnm5kk`,ougs.`OG1iex40dgt`,ougs.`eYLfn5pOt0G`,ougs.`mOSYLiJl2Rr`,ougs.`RWuSZi04nxa`,ougs.`urRM7RqSmsQ`,ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,ous.`uidlevel4`,ous.`uidlevel5`,ps.`daily`,ps.`weekly`,ps.`monthly`,ps.`bimonthly`,ps.`quarterly`,ps.`sixmonthly`,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 _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 >= '2012-01-01' and pe.startdate <= '2012-12-31' and dv.value is not null and dv.value = 'false' (JdbcAnalyticsTableManager.java [SimpleAsyncTaskExecutor-1])
* INFO  2014-03-27 09:39:56,375 Populate SQL: insert into analytics_temp_2012 (`m0CO4DRdSSX`,`z0YbxVyixIH`,`l6sVEPoDs4c`,`fyG1zvnm5kk`,`OG1iex40dgt`,`eYLfn5pOt0G`,`mOSYLiJl2Rr`,`RWuSZi04nxa`,`urRM7RqSmsQ`,`uidlevel1`,`uidlevel2`,`uidlevel3`,`uidlevel4`,`uidlevel5`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`yearly`,`financialapril`,`financialjuly`,`financialoct`,`de`,`co`,`level`,daysxvalue, daysno, value) select degs.`m0CO4DRdSSX`,ougs.`z0YbxVyixIH`,ougs.`l6sVEPoDs4c`,ougs.`fyG1zvnm5kk`,ougs.`OG1iex40dgt`,ougs.`eYLfn5pOt0G`,ougs.`mOSYLiJl2Rr`,ougs.`RWuSZi04nxa`,ougs.`urRM7RqSmsQ`,ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,ous.`uidlevel4`,ous.`uidlevel5`,ps.`daily`,ps.`weekly`,ps.`monthly`,ps.`bimonthly`,ps.`quarterly`,ps.`sixmonthly`,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 _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 >= '2012-01-01' and pe.startdate <= '2012-12-31' and dv.value is not null and dv.value = 'true' (JdbcAnalyticsTableManager.java [SimpleAsyncTaskExecutor-1])
* INFO  2014-03-27 09:39:56,560 Populate SQL: insert into analytics_temp_2014 (`m0CO4DRdSSX`,`z0YbxVyixIH`,`l6sVEPoDs4c`,`fyG1zvnm5kk`,`OG1iex40dgt`,`eYLfn5pOt0G`,`mOSYLiJl2Rr`,`RWuSZi04nxa`,`urRM7RqSmsQ`,`uidlevel1`,`uidlevel2`,`uidlevel3`,`uidlevel4`,`uidlevel5`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`yearly`,`financialapril`,`financialjuly`,`financialoct`,`de`,`co`,`level`,daysxvalue, daysno, value) select degs.`m0CO4DRdSSX`,ougs.`z0YbxVyixIH`,ougs.`l6sVEPoDs4c`,ougs.`fyG1zvnm5kk`,ougs.`OG1iex40dgt`,ougs.`eYLfn5pOt0G`,ougs.`mOSYLiJl2Rr`,ougs.`RWuSZi04nxa`,ougs.`urRM7RqSmsQ`,ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,ous.`uidlevel4`,ous.`uidlevel5`,ps.`daily`,ps.`weekly`,ps.`monthly`,ps.`bimonthly`,ps.`quarterly`,ps.`sixmonthly`,ps.`yearly`,ps.`financialapril`,ps.`financialjuly`,ps.`financialoct`,de.uid,co.uid,ous.level,cast(dv.value as decimal(26,1)) * ps.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 _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-1])
* INFO  2014-03-27 09:39:57,335 Populate SQL: insert into analytics_temp_2014 (`m0CO4DRdSSX`,`z0YbxVyixIH`,`l6sVEPoDs4c`,`fyG1zvnm5kk`,`OG1iex40dgt`,`eYLfn5pOt0G`,`mOSYLiJl2Rr`,`RWuSZi04nxa`,`urRM7RqSmsQ`,`uidlevel1`,`uidlevel2`,`uidlevel3`,`uidlevel4`,`uidlevel5`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`yearly`,`financialapril`,`financialjuly`,`financialoct`,`de`,`co`,`level`,daysxvalue, daysno, value) select degs.`m0CO4DRdSSX`,ougs.`z0YbxVyixIH`,ougs.`l6sVEPoDs4c`,ougs.`fyG1zvnm5kk`,ougs.`OG1iex40dgt`,ougs.`eYLfn5pOt0G`,ougs.`mOSYLiJl2Rr`,ougs.`RWuSZi04nxa`,ougs.`urRM7RqSmsQ`,ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,ous.`uidlevel4`,ous.`uidlevel5`,ps.`daily`,ps.`weekly`,ps.`monthly`,ps.`bimonthly`,ps.`quarterly`,ps.`sixmonthly`,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 _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-1])
* INFO  2014-03-27 09:39:57,529 Populate SQL: insert into analytics_temp_2014 (`m0CO4DRdSSX`,`z0YbxVyixIH`,`l6sVEPoDs4c`,`fyG1zvnm5kk`,`OG1iex40dgt`,`eYLfn5pOt0G`,`mOSYLiJl2Rr`,`RWuSZi04nxa`,`urRM7RqSmsQ`,`uidlevel1`,`uidlevel2`,`uidlevel3`,`uidlevel4`,`uidlevel5`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`yearly`,`financialapril`,`financialjuly`,`financialoct`,`de`,`co`,`level`,daysxvalue, daysno, value) select degs.`m0CO4DRdSSX`,ougs.`z0YbxVyixIH`,ougs.`l6sVEPoDs4c`,ougs.`fyG1zvnm5kk`,ougs.`OG1iex40dgt`,ougs.`eYLfn5pOt0G`,ougs.`mOSYLiJl2Rr`,ougs.`RWuSZi04nxa`,ougs.`urRM7RqSmsQ`,ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,ous.`uidlevel4`,ous.`uidlevel5`,ps.`daily`,ps.`weekly`,ps.`monthly`,ps.`bimonthly`,ps.`quarterly`,ps.`sixmonthly`,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 _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-1])
* INFO  2014-03-27 09:39:57,717 Populate SQL: insert into analytics_temp_2014 (`m0CO4DRdSSX`,`z0YbxVyixIH`,`l6sVEPoDs4c`,`fyG1zvnm5kk`,`OG1iex40dgt`,`eYLfn5pOt0G`,`mOSYLiJl2Rr`,`RWuSZi04nxa`,`urRM7RqSmsQ`,`uidlevel1`,`uidlevel2`,`uidlevel3`,`uidlevel4`,`uidlevel5`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`yearly`,`financialapril`,`financialjuly`,`financialoct`,`de`,`co`,`level`,daysxvalue, daysno, value) select degs.`m0CO4DRdSSX`,ougs.`z0YbxVyixIH`,ougs.`l6sVEPoDs4c`,ougs.`fyG1zvnm5kk`,ougs.`OG1iex40dgt`,ougs.`eYLfn5pOt0G`,ougs.`mOSYLiJl2Rr`,ougs.`RWuSZi04nxa`,ougs.`urRM7RqSmsQ`,ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,ous.`uidlevel4`,ous.`uidlevel5`,ps.`daily`,ps.`weekly`,ps.`monthly`,ps.`bimonthly`,ps.`quarterly`,ps.`sixmonthly`,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 _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-1])
* INFO  2014-03-27 09:39:58,365 Populate SQL: insert into analytics_temp_2013 (`m0CO4DRdSSX`,`z0YbxVyixIH`,`l6sVEPoDs4c`,`fyG1zvnm5kk`,`OG1iex40dgt`,`eYLfn5pOt0G`,`mOSYLiJl2Rr`,`RWuSZi04nxa`,`urRM7RqSmsQ`,`uidlevel1`,`uidlevel2`,`uidlevel3`,`uidlevel4`,`uidlevel5`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`yearly`,`financialapril`,`financialjuly`,`financialoct`,`de`,`co`,`level`,daysxvalue, daysno, value) select degs.`m0CO4DRdSSX`,ougs.`z0YbxVyixIH`,ougs.`l6sVEPoDs4c`,ougs.`fyG1zvnm5kk`,ougs.`OG1iex40dgt`,ougs.`eYLfn5pOt0G`,ougs.`mOSYLiJl2Rr`,ougs.`RWuSZi04nxa`,ougs.`urRM7RqSmsQ`,ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,ous.`uidlevel4`,ous.`uidlevel5`,ps.`daily`,ps.`weekly`,ps.`monthly`,ps.`bimonthly`,ps.`quarterly`,ps.`sixmonthly`,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 _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 >= '2013-01-01' and pe.startdate <= '2013-12-31' and dv.value is not null and dv.value = 'true' (JdbcAnalyticsTableManager.java [SimpleAsyncTaskExecutor-2])
* INFO  2014-03-27 09:39:58,522 Populate SQL: insert into analytics_temp_2013 (`m0CO4DRdSSX`,`z0YbxVyixIH`,`l6sVEPoDs4c`,`fyG1zvnm5kk`,`OG1iex40dgt`,`eYLfn5pOt0G`,`mOSYLiJl2Rr`,`RWuSZi04nxa`,`urRM7RqSmsQ`,`uidlevel1`,`uidlevel2`,`uidlevel3`,`uidlevel4`,`uidlevel5`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`yearly`,`financialapril`,`financialjuly`,`financialoct`,`de`,`co`,`level`,daysxvalue, daysno, value) select degs.`m0CO4DRdSSX`,ougs.`z0YbxVyixIH`,ougs.`l6sVEPoDs4c`,ougs.`fyG1zvnm5kk`,ougs.`OG1iex40dgt`,ougs.`eYLfn5pOt0G`,ougs.`mOSYLiJl2Rr`,ougs.`RWuSZi04nxa`,ougs.`urRM7RqSmsQ`,ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,ous.`uidlevel4`,ous.`uidlevel5`,ps.`daily`,ps.`weekly`,ps.`monthly`,ps.`bimonthly`,ps.`quarterly`,ps.`sixmonthly`,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 _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 >= '2013-01-01' and pe.startdate <= '2013-12-31' and dv.value is not null and dv.value = 'false' (JdbcAnalyticsTableManager.java [SimpleAsyncTaskExecutor-2])
* INFO  2014-03-27 09:39:58,672 Populate SQL: insert into analytics_temp_2013 (`m0CO4DRdSSX`,`z0YbxVyixIH`,`l6sVEPoDs4c`,`fyG1zvnm5kk`,`OG1iex40dgt`,`eYLfn5pOt0G`,`mOSYLiJl2Rr`,`RWuSZi04nxa`,`urRM7RqSmsQ`,`uidlevel1`,`uidlevel2`,`uidlevel3`,`uidlevel4`,`uidlevel5`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`yearly`,`financialapril`,`financialjuly`,`financialoct`,`de`,`co`,`level`,daysxvalue, daysno, value) select degs.`m0CO4DRdSSX`,ougs.`z0YbxVyixIH`,ougs.`l6sVEPoDs4c`,ougs.`fyG1zvnm5kk`,ougs.`OG1iex40dgt`,ougs.`eYLfn5pOt0G`,ougs.`mOSYLiJl2Rr`,ougs.`RWuSZi04nxa`,ougs.`urRM7RqSmsQ`,ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,ous.`uidlevel4`,ous.`uidlevel5`,ps.`daily`,ps.`weekly`,ps.`monthly`,ps.`bimonthly`,ps.`quarterly`,ps.`sixmonthly`,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 _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 >= '2013-01-01' and pe.startdate <= '2013-12-31' and dv.value is not null and dv.value = 'true' (JdbcAnalyticsTableManager.java [SimpleAsyncTaskExecutor-2])
* INFO  2014-03-27 09:39:58,813 Populated analytics tables: 0:00:06.285 (Clock.java [taskScheduler-1])
* INFO  2014-03-27 09:39:58,813 [Level: INFO, category: DATAMART, time: Thu Mar 27 09:39:58 GMT-03:00 2014, message: Pruned analytics tables] (InMemoryNotifier.java [taskScheduler-1])
* INFO  2014-03-27 09:39:59,125 Pruned analytics tables: 0:00:06.597 (Clock.java [taskScheduler-1])
* INFO  2014-03-27 09:39:59,125 [Level: INFO, category: DATAMART, time: Thu Mar 27 09:39:59 GMT-03:00 2014, message: Applying aggregation levels] (InMemoryNotifier.java [taskScheduler-1])
* INFO  2014-03-27 09:39:59,187 Applied aggregation levels: 0:00:06.659 (Clock.java [taskScheduler-1])
* INFO  2014-03-27 09:39:59,187 [Level: INFO, category: DATAMART, time: Thu Mar 27 09:39:59 GMT-03:00 2014, message: Creating indexes] (InMemoryNotifier.java [taskScheduler-1])
* INFO  2014-03-27 09:39:59,188 No of indexes: 81 (DefaultAnalyticsTableService.java [taskScheduler-1])
* INFO  2014-03-27 09:39:59,719 Created index: `in_z0YbxVyixIH_analytics_temp_2012_oRGkF` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:00,094 Created index: `in_m0CO4DRdSSX_analytics_temp_2012_n3ClI` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:00,399 Created index: `in_l6sVEPoDs4c_analytics_temp_2012_UQQ8C` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:00,790 Created index: `in_fyG1zvnm5kk_analytics_temp_2012_yFCcS` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:01,106 Created index: `in_OG1iex40dgt_analytics_temp_2012_UCbsU` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:01,401 Created index: `in_eYLfn5pOt0G_analytics_temp_2012_WUBaY` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:01,661 Created index: `in_mOSYLiJl2Rr_analytics_temp_2012_rDoFd` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:01,959 Created index: `in_RWuSZi04nxa_analytics_temp_2012_ekEh8` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:02,338 Created index: `in_urRM7RqSmsQ_analytics_temp_2012_pCX4M` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:02,689 Created index: `in_uidlevel1_analytics_temp_2012_rbaBy` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:03,027 Created index: `in_uidlevel2_analytics_temp_2012_L7HU3` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:03,365 Created index: `in_uidlevel3_analytics_temp_2012_yFsWu` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:03,673 Created index: `in_uidlevel4_analytics_temp_2012_x4WTs` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:03,981 Created index: `in_uidlevel5_analytics_temp_2012_Z8LLV` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:04,353 Created index: `in_daily_analytics_temp_2012_bZFIA` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:04,688 Created index: `in_weekly_analytics_temp_2012_kBnuE` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:04,991 Created index: `in_monthly_analytics_temp_2012_sM9LN` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:05,305 Created index: `in_bimonthly_analytics_temp_2012_GMwwO` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:05,619 Created index: `in_quarterly_analytics_temp_2012_ZBCi2` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:05,942 Created index: `in_sixmonthly_analytics_temp_2012_V07Y5` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:06,274 Created index: `in_yearly_analytics_temp_2012_TeV8i` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:06,595 Created index: `in_financialapril_analytics_temp_2012_WIY0P` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:06,938 Created index: `in_financialjuly_analytics_temp_2012_h7EzJ` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:07,256 Created index: `in_financialoct_analytics_temp_2012_ER5lx` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:07,657 Created index: `in_de_analytics_temp_2012_iKfbF` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:08,339 Created index: `in_co_analytics_temp_2012_CZ41K` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:08,720 Created index: `in_level_analytics_temp_2012_DiV8z` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:11,026 Created index: `in_m0CO4DRdSSX_analytics_temp_2013_RpeUL` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:11,861 Created index: `in_z0YbxVyixIH_analytics_temp_2013_LVP80` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:12,485 Created index: `in_l6sVEPoDs4c_analytics_temp_2013_aHPEU` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:13,140 Created index: `in_fyG1zvnm5kk_analytics_temp_2013_Cks5g` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:13,848 Created index: `in_OG1iex40dgt_analytics_temp_2013_hbGlj` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:14,770 Created index: `in_eYLfn5pOt0G_analytics_temp_2013_WgYQw` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:15,435 Created index: `in_mOSYLiJl2Rr_analytics_temp_2013_LEpyV` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:16,438 Created index: `in_RWuSZi04nxa_analytics_temp_2013_U4zUa` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:17,574 Created index: `in_urRM7RqSmsQ_analytics_temp_2013_IKUf6` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:18,793 Created index: `in_uidlevel1_analytics_temp_2013_yraK4` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:19,954 Created index: `in_uidlevel2_analytics_temp_2013_kmkFJ` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:20,728 Created index: `in_uidlevel3_analytics_temp_2013_gdy7d` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:21,617 Created index: `in_uidlevel4_analytics_temp_2013_HqkwZ` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:22,514 Created index: `in_uidlevel5_analytics_temp_2013_ocDQ0` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:23,158 Created index: `in_daily_analytics_temp_2013_RXZKb` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:23,835 Created index: `in_weekly_analytics_temp_2013_BMhQA` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:24,761 Created index: `in_monthly_analytics_temp_2013_rwKv0` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:25,749 Created index: `in_bimonthly_analytics_temp_2013_xDKwt` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:26,611 Created index: `in_quarterly_analytics_temp_2013_m8u50` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:27,490 Created index: `in_sixmonthly_analytics_temp_2013_NZ1wS` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:28,158 Created index: `in_yearly_analytics_temp_2013_msmGw` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:29,033 Created index: `in_financialapril_analytics_temp_2013_yVEYX` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:29,917 Created index: `in_financialjuly_analytics_temp_2013_W1yLs` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:30,794 Created index: `in_financialoct_analytics_temp_2013_tOJTC` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:31,853 Created index: `in_de_analytics_temp_2013_tvMtr` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:32,903 Created index: `in_co_analytics_temp_2013_T7k7x` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:33,177 Created index: `in_m0CO4DRdSSX_analytics_temp_2014_CxraV` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:33,337 Created index: `in_z0YbxVyixIH_analytics_temp_2014_TIjH7` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:33,699 Created index: `in_l6sVEPoDs4c_analytics_temp_2014_UUei5` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:33,914 Created index: `in_fyG1zvnm5kk_analytics_temp_2014_B815Q` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:33,914 Created index: `in_level_analytics_temp_2013_oAO76` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:34,022 Created index: `in_OG1iex40dgt_analytics_temp_2014_O6Y3B` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:34,155 Created index: `in_eYLfn5pOt0G_analytics_temp_2014_k71dt` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:34,289 Created index: `in_mOSYLiJl2Rr_analytics_temp_2014_XGXGp` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:34,420 Created index: `in_RWuSZi04nxa_analytics_temp_2014_KsMiJ` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:34,533 Created index: `in_urRM7RqSmsQ_analytics_temp_2014_odCbG` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:34,686 Created index: `in_uidlevel1_analytics_temp_2014_btHjJ` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:34,843 Created index: `in_uidlevel2_analytics_temp_2014_r52dL` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:34,976 Created index: `in_uidlevel3_analytics_temp_2014_BLbR3` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:35,117 Created index: `in_uidlevel4_analytics_temp_2014_CHcKM` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:35,259 Created index: `in_uidlevel5_analytics_temp_2014_Txdnr` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:35,381 Created index: `in_daily_analytics_temp_2014_bWy8g` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:35,524 Created index: `in_weekly_analytics_temp_2014_mQQF0` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:35,660 Created index: `in_monthly_analytics_temp_2014_VQblp` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:35,790 Created index: `in_bimonthly_analytics_temp_2014_JJTcw` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:35,970 Created index: `in_quarterly_analytics_temp_2014_L3mTF` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:36,313 Created index: `in_sixmonthly_analytics_temp_2014_DaDHm` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:36,468 Created index: `in_yearly_analytics_temp_2014_FjX5T` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:36,611 Created index: `in_financialapril_analytics_temp_2014_jxBMN` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:36,752 Created index: `in_financialjuly_analytics_temp_2014_w6Cxm` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:36,898 Created index: `in_financialoct_analytics_temp_2014_skCsW` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:37,033 Created index: `in_de_analytics_temp_2014_DswmW` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:37,188 Created index: `in_co_analytics_temp_2014_Td3DS` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-3])
* INFO  2014-03-27 09:40:37,308 Created index: `in_level_analytics_temp_2014_v1JZX` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  2014-03-27 09:40:37,309 Created indexes: 0:00:44.781 (Clock.java [taskScheduler-1])
* INFO  2014-03-27 09:40:37,309 [Level: INFO, category: DATAMART, time: Thu Mar 27 09:40:37 GMT-03:00 2014, message: Vacuuming tables] (InMemoryNotifier.java [taskScheduler-1])
* INFO  2014-03-27 09:40:37,310 Vacuumed tables: 0:00:44.782 (Clock.java [taskScheduler-1])
* INFO  2014-03-27 09:40:37,310 [Level: INFO, category: DATAMART, time: Thu Mar 27 09:40:37 GMT-03:00 2014, message: Swapping analytics tables] (InMemoryNotifier.java [taskScheduler-1])
* INFO  2014-03-27 09:40:37,318 Vacuum SQL: optimize table analytics_temp_2012; (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-5])
* INFO  2014-03-27 09:40:37,319 Vacuum SQL: optimize table analytics_temp_2013; (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-6])
* INFO  2014-03-27 09:40:53,428 Vacuum SQL: optimize table analytics_temp_2014; (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-5])
* INFO  2014-03-27 09:41:14,630 Table update done: 0:01:22.102 (Clock.java [taskScheduler-1])
* INFO  2014-03-27 09:41:14,631 [Level: INFO, category: DATAMART, time: Thu Mar 27 09:41:14 GMT-03:00 2014, message: Table update done] (InMemoryNotifier.java [taskScheduler-1])
* INFO  2014-03-27 09:41:14,631 [Level: INFO, category: DATAMART, time: Thu Mar 27 09:41:14 GMT-03:00 2014, message: Updating completeness tables] (InMemoryNotifier.java [taskScheduler-1])
* INFO  2014-03-27 09:41:14,631 Starting update, no of processes: 2: 0:00:00.000 (Clock.java [taskScheduler-1])
* INFO  2014-03-27 09:41:14,733 Get tables using earliest: 2012-01-01 00:00:00.0, latest: 2014-01-31 00:00:00.0 (AbstractJdbcTableManager.java [taskScheduler-1])
* INFO  2014-03-27 09:41:14,748 Partition tables: [completeness_2012, completeness_2013, completeness_2014], last 3 years: false: 0:00:00.117 (Clock.java [taskScheduler-1])
* INFO  2014-03-27 09:41:14,748 [Level: INFO, category: DATAMART, time: Thu Mar 27 09:41:14 GMT-03:00 2014, message: Creating analytics tables] (InMemoryNotifier.java [taskScheduler-1])
* INFO  2014-03-27 09:41:14,756 Create SQL: create table completeness_temp_2012 (`z0YbxVyixIH` character(11),`l6sVEPoDs4c` character(11),`fyG1zvnm5kk` character(11),`OG1iex40dgt` character(11),`eYLfn5pOt0G` character(11),`mOSYLiJl2Rr` character(11),`RWuSZi04nxa` character(11),`urRM7RqSmsQ` character(11),`uidlevel1` character(11),`uidlevel2` character(11),`uidlevel3` character(11),`uidlevel4` character(11),`uidlevel5` character(11),`daily` character varying(10),`weekly` character varying(10),`monthly` character varying(10),`bimonthly` character varying(10),`quarterly` character varying(10),`sixmonthly` character varying(10),`yearly` character varying(10),`ds` character(11) not null,value date)  (JdbcCompletenessTableManager.java [taskScheduler-1])
* INFO  2014-03-27 09:41:14,856 Create SQL: create table completeness_temp_2013 (`z0YbxVyixIH` character(11),`l6sVEPoDs4c` character(11),`fyG1zvnm5kk` character(11),`OG1iex40dgt` character(11),`eYLfn5pOt0G` character(11),`mOSYLiJl2Rr` character(11),`RWuSZi04nxa` character(11),`urRM7RqSmsQ` character(11),`uidlevel1` character(11),`uidlevel2` character(11),`uidlevel3` character(11),`uidlevel4` character(11),`uidlevel5` character(11),`daily` character varying(10),`weekly` character varying(10),`monthly` character varying(10),`bimonthly` character varying(10),`quarterly` character varying(10),`sixmonthly` character varying(10),`yearly` character varying(10),`ds` character(11) not null,value date)  (JdbcCompletenessTableManager.java [taskScheduler-1])
* INFO  2014-03-27 09:41:14,951 Create SQL: create table completeness_temp_2014 (`z0YbxVyixIH` character(11),`l6sVEPoDs4c` character(11),`fyG1zvnm5kk` character(11),`OG1iex40dgt` character(11),`eYLfn5pOt0G` character(11),`mOSYLiJl2Rr` character(11),`RWuSZi04nxa` character(11),`urRM7RqSmsQ` character(11),`uidlevel1` character(11),`uidlevel2` character(11),`uidlevel3` character(11),`uidlevel4` character(11),`uidlevel5` character(11),`daily` character varying(10),`weekly` character varying(10),`monthly` character varying(10),`bimonthly` character varying(10),`quarterly` character varying(10),`sixmonthly` character varying(10),`yearly` character varying(10),`ds` character(11) not null,value date)  (JdbcCompletenessTableManager.java [taskScheduler-1])
* INFO  2014-03-27 09:41:15,021 Created analytics tables: 0:00:00.390 (Clock.java [taskScheduler-1])
* INFO  2014-03-27 09:41:15,022 [Level: INFO, category: DATAMART, time: Thu Mar 27 09:41:15 GMT-03:00 2014, message: Populating analytics tables] (InMemoryNotifier.java [taskScheduler-1])
* INFO  2014-03-27 09:41:15,022 Populate table task number: 2 (DefaultAnalyticsTableService.java [taskScheduler-1])
* INFO  2014-03-27 09:41:15,037 Populate SQL: insert into completeness_temp_2012 (`z0YbxVyixIH`,`l6sVEPoDs4c`,`fyG1zvnm5kk`,`OG1iex40dgt`,`eYLfn5pOt0G`,`mOSYLiJl2Rr`,`RWuSZi04nxa`,`urRM7RqSmsQ`,`uidlevel1`,`uidlevel2`,`uidlevel3`,`uidlevel4`,`uidlevel5`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`yearly`,`ds`,value) select ougs.`z0YbxVyixIH`,ougs.`l6sVEPoDs4c`,ougs.`fyG1zvnm5kk`,ougs.`OG1iex40dgt`,ougs.`eYLfn5pOt0G`,ougs.`mOSYLiJl2Rr`,ougs.`RWuSZi04nxa`,ougs.`urRM7RqSmsQ`,ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,ous.`uidlevel4`,ous.`uidlevel5`,ps.`daily`,ps.`weekly`,ps.`monthly`,ps.`bimonthly`,ps.`quarterly`,ps.`sixmonthly`,ps.`yearly`,ds.uid,cdr.date as value from completedatasetregistration cdr left join _organisationunitgroupsetstructure ougs on cdr.sourceid=ougs.organisationunitid left join _orgunitstructure ous on cdr.sourceid=ous.organisationunitid left join _periodstructure ps on cdr.periodid=ps.periodid left join period pe on cdr.periodid=pe.periodid left join dataset ds on cdr.datasetid=ds.datasetid where pe.startdate >= '2012-01-01' and pe.startdate <= '2012-12-31'and cdr.date is not null (JdbcCompletenessTableManager.java [SimpleAsyncTaskExecutor-7])
* INFO  2014-03-27 09:41:15,037 Populate SQL: insert into completeness_temp_2013 (`z0YbxVyixIH`,`l6sVEPoDs4c`,`fyG1zvnm5kk`,`OG1iex40dgt`,`eYLfn5pOt0G`,`mOSYLiJl2Rr`,`RWuSZi04nxa`,`urRM7RqSmsQ`,`uidlevel1`,`uidlevel2`,`uidlevel3`,`uidlevel4`,`uidlevel5`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`yearly`,`ds`,value) select ougs.`z0YbxVyixIH`,ougs.`l6sVEPoDs4c`,ougs.`fyG1zvnm5kk`,ougs.`OG1iex40dgt`,ougs.`eYLfn5pOt0G`,ougs.`mOSYLiJl2Rr`,ougs.`RWuSZi04nxa`,ougs.`urRM7RqSmsQ`,ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,ous.`uidlevel4`,ous.`uidlevel5`,ps.`daily`,ps.`weekly`,ps.`monthly`,ps.`bimonthly`,ps.`quarterly`,ps.`sixmonthly`,ps.`yearly`,ds.uid,cdr.date as value from completedatasetregistration cdr left join _organisationunitgroupsetstructure ougs on cdr.sourceid=ougs.organisationunitid left join _orgunitstructure ous on cdr.sourceid=ous.organisationunitid left join _periodstructure ps on cdr.periodid=ps.periodid left join period pe on cdr.periodid=pe.periodid left join dataset ds on cdr.datasetid=ds.datasetid where pe.startdate >= '2013-01-01' and pe.startdate <= '2013-12-31'and cdr.date is not null (JdbcCompletenessTableManager.java [SimpleAsyncTaskExecutor-8])
* INFO  2014-03-27 09:41:15,598 Populate SQL: insert into completeness_temp_2014 (`z0YbxVyixIH`,`l6sVEPoDs4c`,`fyG1zvnm5kk`,`OG1iex40dgt`,`eYLfn5pOt0G`,`mOSYLiJl2Rr`,`RWuSZi04nxa`,`urRM7RqSmsQ`,`uidlevel1`,`uidlevel2`,`uidlevel3`,`uidlevel4`,`uidlevel5`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`yearly`,`ds`,value) select ougs.`z0YbxVyixIH`,ougs.`l6sVEPoDs4c`,ougs.`fyG1zvnm5kk`,ougs.`OG1iex40dgt`,ougs.`eYLfn5pOt0G`,ougs.`mOSYLiJl2Rr`,ougs.`RWuSZi04nxa`,ougs.`urRM7RqSmsQ`,ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,ous.`uidlevel4`,ous.`uidlevel5`,ps.`daily`,ps.`weekly`,ps.`monthly`,ps.`bimonthly`,ps.`quarterly`,ps.`sixmonthly`,ps.`yearly`,ds.uid,cdr.date as value from completedatasetregistration cdr left join _organisationunitgroupsetstructure ougs on cdr.sourceid=ougs.organisationunitid left join _orgunitstructure ous on cdr.sourceid=ous.organisationunitid left join _periodstructure ps on cdr.periodid=ps.periodid left join period pe on cdr.periodid=pe.periodid left join dataset ds on cdr.datasetid=ds.datasetid where pe.startdate >= '2014-01-01' and pe.startdate <= '2014-12-31'and cdr.date is not null (JdbcCompletenessTableManager.java [SimpleAsyncTaskExecutor-7])
* INFO  2014-03-27 09:41:16,064 Populated analytics tables: 0:00:01.433 (Clock.java [taskScheduler-1])
* INFO  2014-03-27 09:41:16,064 [Level: INFO, category: DATAMART, time: Thu Mar 27 09:41:16 GMT-03:00 2014, message: Pruned analytics tables] (InMemoryNotifier.java [taskScheduler-1])
* INFO  2014-03-27 09:41:16,315 Pruned analytics tables: 0:00:01.684 (Clock.java [taskScheduler-1])
* INFO  2014-03-27 09:41:16,315 [Level: INFO, category: DATAMART, time: Thu Mar 27 09:41:16 GMT-03:00 2014, message: Applying aggregation levels] (InMemoryNotifier.java [taskScheduler-1])
* INFO  2014-03-27 09:41:16,323 Applied aggregation levels: 0:00:01.692 (Clock.java [taskScheduler-1])
* INFO  2014-03-27 09:41:16,323 [Level: INFO, category: DATAMART, time: Thu Mar 27 09:41:16 GMT-03:00 2014, message: Creating indexes] (InMemoryNotifier.java [taskScheduler-1])
* INFO  2014-03-27 09:41:16,323 No of indexes: 63 (DefaultAnalyticsTableService.java [taskScheduler-1])
* INFO  2014-03-27 09:41:16,533 Created index: `in_l6sVEPoDs4c_completeness_temp_2012_nDgmI` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-10])
* INFO  2014-03-27 09:41:16,698 Created index: `in_z0YbxVyixIH_completeness_temp_2012_vTBmG` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-9])
* INFO  2014-03-27 09:41:16,903 Created index: `in_fyG1zvnm5kk_completeness_temp_2012_RE3pE` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-10])
* INFO  2014-03-27 09:41:17,095 Created index: `in_OG1iex40dgt_completeness_temp_2012_YvBRj` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-9])
* INFO  2014-03-27 09:41:17,276 Created index: `in_eYLfn5pOt0G_completeness_temp_2012_MJhsO` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-10])
* INFO  2014-03-27 09:41:17,419 Created index: `in_mOSYLiJl2Rr_completeness_temp_2012_Kf8y1` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-9])
* INFO  2014-03-27 09:41:17,597 Created index: `in_RWuSZi04nxa_completeness_temp_2012_Rsp0x` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-10])
* INFO  2014-03-27 09:41:17,763 Created index: `in_urRM7RqSmsQ_completeness_temp_2012_PC1C3` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-9])
* INFO  2014-03-27 09:41:18,206 Created index: `in_uidlevel1_completeness_temp_2012_KVvcP` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-10])
* INFO  2014-03-27 09:41:18,429 Created index: `in_uidlevel2_completeness_temp_2012_zNLpC` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-9])
* INFO  2014-03-27 09:41:18,605 Created index: `in_uidlevel3_completeness_temp_2012_OFSb8` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-10])
* INFO  2014-03-27 09:41:18,809 Created index: `in_uidlevel4_completeness_temp_2012_KbNCF` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-9])
* INFO  2014-03-27 09:41:18,953 Created index: `in_uidlevel5_completeness_temp_2012_hmPWu` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-10])
* INFO  2014-03-27 09:41:19,229 Created index: `in_daily_completeness_temp_2012_sizh1` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-9])
* INFO  2014-03-27 09:41:19,461 Created index: `in_weekly_completeness_temp_2012_zowhW` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-10])
* INFO  2014-03-27 09:41:19,661 Created index: `in_monthly_completeness_temp_2012_jlK6R` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-9])
* INFO  2014-03-27 09:41:19,838 Created index: `in_bimonthly_completeness_temp_2012_hF1Mt` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-10])
* INFO  2014-03-27 09:41:40,074 Populate SQL: insert into analytics_event_temp_2012_Rxf3GkBK3CZ (`uidlevel1`,`uidlevel2`,`uidlevel3`,`uidlevel4`,`uidlevel5`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`yearly`,`financialapril`,`financialjuly`,`financialoct`,`DUgwMwZWqQ6`,`VUV9Y68G7XE`,`vFr0643uIxg`,`oAKzRm8vyBr`,`eGztKsq1jia`,`jk77HaM4JgB`,`gLhzTbevx76`,`j82k1ixyKG2`,`Yd0xhROmK7s`,`f4zRR3HiuCZ`,`Q1RTkc3j71t`,`bhSulsMihxB`,`F7aDH6oHoEK`,`MIUR41RJ7c1`,`FYiSqzxE1L6`,`pspudRhtjEa`,`QPOP4upYaJw`,`rC8XccfNffE`,`talH411bGxz`,`u4Qi6TiSDXO`,`FL7NpbKJJ0h`,`c0HqKH3Msth`,`O7ED8yAS31V`,`VaDBUpHginK`,`pBQ3tsUewxw`,`cTJg2h24MuH`,`rAGbzWM4AFm`,`das71R8kjmp`,`hfBzS3KONz8`,`SobrntCw0Tf`,`Fyf50KDg6wA`,`A3kG6yP3Tb2`,`mYswsfZtxyZ`,`xOSoYINYG1B`,`gTv59gcmnzR`,`NtBQBCO6Qcr`,`xRyt5JQH7zD`,`bNZmFwYIx5r`,`xVZvYuesq1k`,`fpbcIxP9vyZ`,`LEwtdxiwWfy`,psi,ps,executiondate,longitude,latitude,ou,ouname,oucode) select ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,ous.`uidlevel4`,ous.`uidlevel5`,dps.`daily`,dps.`weekly`,dps.`monthly`,dps.`bimonthly`,dps.`quarterly`,dps.`sixmonthly`,dps.`yearly`,dps.`financialapril`,dps.`financialjuly`,dps.`financialoct`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=333) as `DUgwMwZWqQ6`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=305) as `VUV9Y68G7XE`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=328 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `vFr0643uIxg`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=308) as `oAKzRm8vyBr`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=276) as `eGztKsq1jia`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=289 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `jk77HaM4JgB`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=281 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `gLhzTbevx76`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=327 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `j82k1ixyKG2`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=296) as `Yd0xhROmK7s`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=303) as `f4zRR3HiuCZ`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=306 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `Q1RTkc3j71t`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=307 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `bhSulsMihxB`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=286 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `F7aDH6oHoEK`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=336) as `MIUR41RJ7c1`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=280 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `FYiSqzxE1L6`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=330 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `pspudRhtjEa`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=279) as `QPOP4upYaJw`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=294 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `rC8XccfNffE`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=283 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `talH411bGxz`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=331 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `u4Qi6TiSDXO`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=290 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `FL7NpbKJJ0h`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=278) as `c0HqKH3Msth`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=332 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `O7ED8yAS31V`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=282 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `VaDBUpHginK`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=277) as `pBQ3tsUewxw`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=304 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `cTJg2h24MuH`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=275 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `rAGbzWM4AFm`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=295) as `das71R8kjmp`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=297) as `hfBzS3KONz8`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=325 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `SobrntCw0Tf`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=284 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `Fyf50KDg6wA`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=302) as `A3kG6yP3Tb2`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=335) as `mYswsfZtxyZ`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=293 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `xOSoYINYG1B`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=285 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `gTv59gcmnzR`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=301) as `NtBQBCO6Qcr`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=334) as `xRyt5JQH7zD`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=288 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `bNZmFwYIx5r`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=326 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `xVZvYuesq1k`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=329 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `fpbcIxP9vyZ`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=287 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `LEwtdxiwWfy`,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 patient pa on pi.patientid=pa.patientid 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 >= '2012-01-01' and psi.executiondate <= '2012-12-31' and pr.programid=3 and psi.organisationunitid is not null and psi.executiondate is not null (JdbcEventAnalyticsTableManager.java [SimpleAsyncTaskExecutor-20])
* INFO  2014-03-27 09:41:40,397 Populate SQL: insert into analytics_event_temp_2013_OApyMUCqMnw (`uidlevel1`,`uidlevel2`,`uidlevel3`,`uidlevel4`,`uidlevel5`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`yearly`,`financialapril`,`financialjuly`,`financialoct`,`xfjgIAbmlw0`,`rk9NUud9qIN`,`aPuokp7fCpf`,`WoS6ilw6y9Z`,`p6GemAvyvdu`,`Uyu04nyMqXE`,`Sue4pg7aIxz`,`cPh5SmI8Y7H`,`qmvrm7HxRDH`,`mv5N8hKpHX1`,`RgYAhPfaU3l`,`tmi1KlBLlOK`,`YUOJdOkXtr1`,`G1yajc8Xkec`,`VbMnuDnauWk`,`SIAw7aUYBRN`,`dAMc7zEcdH1`,`mECYGQUoXjC`,`UeKTdsnhuTv`,`pPQEPgNd3HH`,`MT9O6DStNCG`,`jz6YB1tTRq3`,`qMUToUeUJa2`,`AWkWRlWuDiM`,`moG6T0LAiXD`,`sVPKqquZE0c`,`VTBzoVWJ9Go`,`T8nQbBeaLVQ`,`PCAowcWbOIr`,`VU1zsJawhgB`,`nuuz1HG6zGr`,`nSNQ103KziK`,`b4H0jBUNRII`,`OTSgE5rSeLs`,`gqDOGiTTJNb`,`GK3v1SRsGkT`,`O2pBRS8E9lA`,`FYr3Pw3xaB7`,`yz15DXlCc77`,`yQk0yjn6jWd`,`vjUr1o14nfJ`,`WQO5Uh8LCh1`,`D2sxWrZE16E`,`ndW0ybelAy7`,`NbEYBNsw1TX`,`lg9l4x9yQ3h`,`PPaewbLxLOF`,`H4ihYR0AXGK`,`Ie0OjIB8H0I`,`QfUIrcDU4O1`,`Dz55DEZ4ipi`,`N0hWKaU5LcY`,`fyyXPHMRey0`,`TDw4V3lVVnN`,`B2HUapjElVz`,`q4Uf7YpBSuR`,`rHFEmuTeNud`,`BWg1swhPsLZ`,`vyQPMCEycON`,`LokSP9bYaa1`,`CjMkEhfgTNW`,`UZDMNRQLceH`,`GLN4bDmgGpR`,`dBqS7UvJd7K`,`vFkGJbSd7WA`,`G4B1Lf63W0X`,`MgBywmPgmek`,`QPDdeGmEw7R`,`fOr7uamrnrc`,`Apn3V8L0Abe`,`kwIoYixO5Bt`,`U4psib5CnXh`,`YFAenyqbWJH`,`bzcxg2i4Jxa`,`dcsI0p1ey6X`,`Wuawykaym6d`,`mKKRb7rTz4i`,`laRXYFIoTJG`,`E33Fje80YqW`,`jHOrChygRJX`,`NTCC5cw7vYd`,`GuvtzwaOX9v`,`FJObZrsvnpw`,`AHeUbZi0HuA`,`FQwW8msBOHt`,`LhPnk9J1OFO`,`pD30iwhv3ir`,`cDqM78CI4PT`,`h3S5tVVMyRa`,`L81diHHEOGO`,`sTEiAmpx2Ga`,`vxnG7TbhQH7`,`ko1u8vhLRG6`,`FecKvoKall3`,`Pn3tgEuDZix`,`g41fWLW9VEh`,`pw5Ntiw9Rag`,`cAD81lcEPO9`,`o2LIE9aXxfH`,`a46aX3Jf1hf`,`BUcS4bq8hnd`,`j4x8Lx0VndK`,`COZrXo3XiQw`,`jDqdtVxQwQB`,`faibBtM3iPM`,`AqH4x9ql6ba`,`DvpGpmJkTVZ`,`dlibOZ5OKDm`,`Le0Xo9mBRkg`,`cYhwWMK20tT`,`Vh2GRNpo4SO`,`hIIIGvvRpgw`,`CejQJePWMXq`,`h7SRyXR4ntv`,`H16f0ytB8ym`,`SsHHXRo2HOd`,psi,ps,executiondate,longitude,latitude,ou,ouname,oucode) select ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,ous.`uidlevel4`,ous.`uidlevel5`,dps.`daily`,dps.`weekly`,dps.`monthly`,dps.`bimonthly`,dps.`quarterly`,dps.`sixmonthly`,dps.`yearly`,dps.`financialapril`,dps.`financialjuly`,dps.`financialoct`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=169) as `xfjgIAbmlw0`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=310) as `rk9NUud9qIN`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=94) as `aPuokp7fCpf`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=119) as `WoS6ilw6y9Z`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=129) as `p6GemAvyvdu`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=121) as `Uyu04nyMqXE`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=105) as `Sue4pg7aIxz`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=321) as `cPh5SmI8Y7H`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=258 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `qmvrm7HxRDH`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=91) as `mv5N8hKpHX1`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=150 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `RgYAhPfaU3l`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=107) as `tmi1KlBLlOK`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=133) as `YUOJdOkXtr1`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=109) as `G1yajc8Xkec`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=167) as `VbMnuDnauWk`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=164) as `SIAw7aUYBRN`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=126) as `dAMc7zEcdH1`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=177) as `mECYGQUoXjC`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=132) as `UeKTdsnhuTv`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=95) as `pPQEPgNd3HH`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=123) as `MT9O6DStNCG`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=193) as `jz6YB1tTRq3`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=142) as `qMUToUeUJa2`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=319) as `AWkWRlWuDiM`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=134) as `moG6T0LAiXD`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=185 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `sVPKqquZE0c`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=131) as `VTBzoVWJ9Go`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=190) as `T8nQbBeaLVQ`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=309) as `PCAowcWbOIr`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=93) as `VU1zsJawhgB`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=184 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `nuuz1HG6zGr`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=194) as `nSNQ103KziK`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=176) as `b4H0jBUNRII`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=168) as `OTSgE5rSeLs`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=160) as `gqDOGiTTJNb`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=149 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `GK3v1SRsGkT`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=152 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `O2pBRS8E9lA`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=110) as `FYr3Pw3xaB7`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=182 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `yz15DXlCc77`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=118) as `yQk0yjn6jWd`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=138) as `vjUr1o14nfJ`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=117) as `WQO5Uh8LCh1`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=166) as `D2sxWrZE16E`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=125) as `ndW0ybelAy7`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=316) as `NbEYBNsw1TX`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=189) as `lg9l4x9yQ3h`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=161) as `PPaewbLxLOF`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=165) as `H4ihYR0AXGK`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=179) as `Ie0OjIB8H0I`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=120) as `QfUIrcDU4O1`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=313) as `Dz55DEZ4ipi`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=311) as `N0hWKaU5LcY`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=102) as `fyyXPHMRey0`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=103) as `TDw4V3lVVnN`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=180) as `B2HUapjElVz`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=171) as `q4Uf7YpBSuR`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=122) as `rHFEmuTeNud`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=170) as `BWg1swhPsLZ`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=172) as `vyQPMCEycON`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=136) as `LokSP9bYaa1`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=153 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `CjMkEhfgTNW`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=112) as `UZDMNRQLceH`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=141) as `GLN4bDmgGpR`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=108) as `dBqS7UvJd7K`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=113) as `vFkGJbSd7WA`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=320) as `G4B1Lf63W0X`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=101) as `MgBywmPgmek`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=187) as `QPDdeGmEw7R`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=315) as `fOr7uamrnrc`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=155 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `Apn3V8L0Abe`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=191) as `kwIoYixO5Bt`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=318) as `U4psib5CnXh`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=128) as `YFAenyqbWJH`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=100) as `bzcxg2i4Jxa`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=163) as `dcsI0p1ey6X`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=314) as `Wuawykaym6d`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=127) as `mKKRb7rTz4i`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=162) as `laRXYFIoTJG`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=192) as `E33Fje80YqW`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=322) as `jHOrChygRJX`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=178) as `NTCC5cw7vYd`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=104) as `GuvtzwaOX9v`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=158 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `FJObZrsvnpw`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=116) as `AHeUbZi0HuA`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=124) as `FQwW8msBOHt`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=115) as `LhPnk9J1OFO`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=173) as `pD30iwhv3ir`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=148 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `cDqM78CI4PT`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=92) as `h3S5tVVMyRa`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=186) as `L81diHHEOGO`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=154 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `sTEiAmpx2Ga`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=146 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `vxnG7TbhQH7`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=174) as `ko1u8vhLRG6`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=317) as `FecKvoKall3`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=145 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `Pn3tgEuDZix`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=135) as `g41fWLW9VEh`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=175 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `pw5Ntiw9Rag`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=151 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `cAD81lcEPO9`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=140) as `o2LIE9aXxfH`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=324) as `a46aX3Jf1hf`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=111) as `BUcS4bq8hnd`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=139) as `j4x8Lx0VndK`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=312) as `COZrXo3XiQw`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=323) as `jDqdtVxQwQB`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=137) as `faibBtM3iPM`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=147 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `AqH4x9ql6ba`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=156 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `DvpGpmJkTVZ`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=106) as `dlibOZ5OKDm`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=159) as `Le0Xo9mBRkg`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=144 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `cYhwWMK20tT`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=157 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `Vh2GRNpo4SO`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=188) as `hIIIGvvRpgw`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=181) as `CejQJePWMXq`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=130) as `h7SRyXR4ntv`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=143 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `H16f0ytB8ym`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=183 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `SsHHXRo2HOd`,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 patient pa on pi.patientid=pa.patientid 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 >= '2013-01-01' and psi.executiondate <= '2013-12-31' and pr.programid=1 and psi.organisationunitid is not null and psi.executiondate is not null (JdbcEventAnalyticsTableManager.java [SimpleAsyncTaskExecutor-20])
* INFO  2014-03-27 09:41:40,511 Populate SQL: insert into analytics_event_temp_2013_MQEdhAykSEG (`uidlevel1`,`uidlevel2`,`uidlevel3`,`uidlevel4`,`uidlevel5`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`yearly`,`financialapril`,`financialjuly`,`financialoct`,`EyBbIzuPF5O`,`I948alxq2QA`,`aJdrpgX3nUF`,`xJ4Gl8H7uKk`,`KzA18BDzKw4`,psi,ps,executiondate,longitude,latitude,ou,ouname,oucode) select ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,ous.`uidlevel4`,ous.`uidlevel5`,dps.`daily`,dps.`weekly`,dps.`monthly`,dps.`bimonthly`,dps.`quarterly`,dps.`sixmonthly`,dps.`yearly`,dps.`financialapril`,dps.`financialjuly`,dps.`financialoct`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=87 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `EyBbIzuPF5O`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=88) as `I948alxq2QA`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=86 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `aJdrpgX3nUF`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=89) as `xJ4Gl8H7uKk`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=90) as `KzA18BDzKw4`,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 patient pa on pi.patientid=pa.patientid 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 >= '2013-01-01' and psi.executiondate <= '2013-12-31' and pr.programid=2 and psi.organisationunitid is not null and psi.executiondate is not null (JdbcEventAnalyticsTableManager.java [SimpleAsyncTaskExecutor-19])
* INFO  2014-03-27 09:41:40,522 Populate SQL: insert into analytics_event_temp_2013_Rxf3GkBK3CZ (`uidlevel1`,`uidlevel2`,`uidlevel3`,`uidlevel4`,`uidlevel5`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`yearly`,`financialapril`,`financialjuly`,`financialoct`,`DUgwMwZWqQ6`,`VUV9Y68G7XE`,`vFr0643uIxg`,`oAKzRm8vyBr`,`eGztKsq1jia`,`jk77HaM4JgB`,`gLhzTbevx76`,`j82k1ixyKG2`,`Yd0xhROmK7s`,`f4zRR3HiuCZ`,`Q1RTkc3j71t`,`bhSulsMihxB`,`F7aDH6oHoEK`,`MIUR41RJ7c1`,`FYiSqzxE1L6`,`pspudRhtjEa`,`QPOP4upYaJw`,`rC8XccfNffE`,`talH411bGxz`,`u4Qi6TiSDXO`,`FL7NpbKJJ0h`,`c0HqKH3Msth`,`O7ED8yAS31V`,`VaDBUpHginK`,`pBQ3tsUewxw`,`cTJg2h24MuH`,`rAGbzWM4AFm`,`das71R8kjmp`,`hfBzS3KONz8`,`SobrntCw0Tf`,`Fyf50KDg6wA`,`A3kG6yP3Tb2`,`mYswsfZtxyZ`,`xOSoYINYG1B`,`gTv59gcmnzR`,`NtBQBCO6Qcr`,`xRyt5JQH7zD`,`bNZmFwYIx5r`,`xVZvYuesq1k`,`fpbcIxP9vyZ`,`LEwtdxiwWfy`,psi,ps,executiondate,longitude,latitude,ou,ouname,oucode) select ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,ous.`uidlevel4`,ous.`uidlevel5`,dps.`daily`,dps.`weekly`,dps.`monthly`,dps.`bimonthly`,dps.`quarterly`,dps.`sixmonthly`,dps.`yearly`,dps.`financialapril`,dps.`financialjuly`,dps.`financialoct`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=333) as `DUgwMwZWqQ6`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=305) as `VUV9Y68G7XE`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=328 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `vFr0643uIxg`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=308) as `oAKzRm8vyBr`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=276) as `eGztKsq1jia`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=289 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `jk77HaM4JgB`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=281 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `gLhzTbevx76`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=327 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `j82k1ixyKG2`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=296) as `Yd0xhROmK7s`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=303) as `f4zRR3HiuCZ`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=306 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `Q1RTkc3j71t`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=307 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `bhSulsMihxB`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=286 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `F7aDH6oHoEK`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=336) as `MIUR41RJ7c1`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=280 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `FYiSqzxE1L6`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=330 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `pspudRhtjEa`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=279) as `QPOP4upYaJw`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=294 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `rC8XccfNffE`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=283 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `talH411bGxz`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=331 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `u4Qi6TiSDXO`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=290 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `FL7NpbKJJ0h`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=278) as `c0HqKH3Msth`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=332 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `O7ED8yAS31V`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=282 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `VaDBUpHginK`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=277) as `pBQ3tsUewxw`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=304 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `cTJg2h24MuH`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=275 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `rAGbzWM4AFm`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=295) as `das71R8kjmp`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=297) as `hfBzS3KONz8`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=325 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `SobrntCw0Tf`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=284 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `Fyf50KDg6wA`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=302) as `A3kG6yP3Tb2`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=335) as `mYswsfZtxyZ`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=293 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `xOSoYINYG1B`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=285 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `gTv59gcmnzR`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=301) as `NtBQBCO6Qcr`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=334) as `xRyt5JQH7zD`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=288 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `bNZmFwYIx5r`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=326 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `xVZvYuesq1k`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=329 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `fpbcIxP9vyZ`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=287 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `LEwtdxiwWfy`,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 patient pa on pi.patientid=pa.patientid 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 >= '2013-01-01' and psi.executiondate <= '2013-12-31' and pr.programid=3 and psi.organisationunitid is not null and psi.executiondate is not null (JdbcEventAnalyticsTableManager.java [SimpleAsyncTaskExecutor-19])
* INFO  2014-03-27 09:41:43,306 Populate SQL: insert into analytics_event_temp_2014_OApyMUCqMnw (`uidlevel1`,`uidlevel2`,`uidlevel3`,`uidlevel4`,`uidlevel5`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`yearly`,`financialapril`,`financialjuly`,`financialoct`,`xfjgIAbmlw0`,`rk9NUud9qIN`,`aPuokp7fCpf`,`WoS6ilw6y9Z`,`p6GemAvyvdu`,`Uyu04nyMqXE`,`Sue4pg7aIxz`,`cPh5SmI8Y7H`,`qmvrm7HxRDH`,`mv5N8hKpHX1`,`RgYAhPfaU3l`,`tmi1KlBLlOK`,`YUOJdOkXtr1`,`G1yajc8Xkec`,`VbMnuDnauWk`,`SIAw7aUYBRN`,`dAMc7zEcdH1`,`mECYGQUoXjC`,`UeKTdsnhuTv`,`pPQEPgNd3HH`,`MT9O6DStNCG`,`jz6YB1tTRq3`,`qMUToUeUJa2`,`AWkWRlWuDiM`,`moG6T0LAiXD`,`sVPKqquZE0c`,`VTBzoVWJ9Go`,`T8nQbBeaLVQ`,`PCAowcWbOIr`,`VU1zsJawhgB`,`nuuz1HG6zGr`,`nSNQ103KziK`,`b4H0jBUNRII`,`OTSgE5rSeLs`,`gqDOGiTTJNb`,`GK3v1SRsGkT`,`O2pBRS8E9lA`,`FYr3Pw3xaB7`,`yz15DXlCc77`,`yQk0yjn6jWd`,`vjUr1o14nfJ`,`WQO5Uh8LCh1`,`D2sxWrZE16E`,`ndW0ybelAy7`,`NbEYBNsw1TX`,`lg9l4x9yQ3h`,`PPaewbLxLOF`,`H4ihYR0AXGK`,`Ie0OjIB8H0I`,`QfUIrcDU4O1`,`Dz55DEZ4ipi`,`N0hWKaU5LcY`,`fyyXPHMRey0`,`TDw4V3lVVnN`,`B2HUapjElVz`,`q4Uf7YpBSuR`,`rHFEmuTeNud`,`BWg1swhPsLZ`,`vyQPMCEycON`,`LokSP9bYaa1`,`CjMkEhfgTNW`,`UZDMNRQLceH`,`GLN4bDmgGpR`,`dBqS7UvJd7K`,`vFkGJbSd7WA`,`G4B1Lf63W0X`,`MgBywmPgmek`,`QPDdeGmEw7R`,`fOr7uamrnrc`,`Apn3V8L0Abe`,`kwIoYixO5Bt`,`U4psib5CnXh`,`YFAenyqbWJH`,`bzcxg2i4Jxa`,`dcsI0p1ey6X`,`Wuawykaym6d`,`mKKRb7rTz4i`,`laRXYFIoTJG`,`E33Fje80YqW`,`jHOrChygRJX`,`NTCC5cw7vYd`,`GuvtzwaOX9v`,`FJObZrsvnpw`,`AHeUbZi0HuA`,`FQwW8msBOHt`,`LhPnk9J1OFO`,`pD30iwhv3ir`,`cDqM78CI4PT`,`h3S5tVVMyRa`,`L81diHHEOGO`,`sTEiAmpx2Ga`,`vxnG7TbhQH7`,`ko1u8vhLRG6`,`FecKvoKall3`,`Pn3tgEuDZix`,`g41fWLW9VEh`,`pw5Ntiw9Rag`,`cAD81lcEPO9`,`o2LIE9aXxfH`,`a46aX3Jf1hf`,`BUcS4bq8hnd`,`j4x8Lx0VndK`,`COZrXo3XiQw`,`jDqdtVxQwQB`,`faibBtM3iPM`,`AqH4x9ql6ba`,`DvpGpmJkTVZ`,`dlibOZ5OKDm`,`Le0Xo9mBRkg`,`cYhwWMK20tT`,`Vh2GRNpo4SO`,`hIIIGvvRpgw`,`CejQJePWMXq`,`h7SRyXR4ntv`,`H16f0ytB8ym`,`SsHHXRo2HOd`,psi,ps,executiondate,longitude,latitude,ou,ouname,oucode) select ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,ous.`uidlevel4`,ous.`uidlevel5`,dps.`daily`,dps.`weekly`,dps.`monthly`,dps.`bimonthly`,dps.`quarterly`,dps.`sixmonthly`,dps.`yearly`,dps.`financialapril`,dps.`financialjuly`,dps.`financialoct`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=169) as `xfjgIAbmlw0`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=310) as `rk9NUud9qIN`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=94) as `aPuokp7fCpf`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=119) as `WoS6ilw6y9Z`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=129) as `p6GemAvyvdu`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=121) as `Uyu04nyMqXE`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=105) as `Sue4pg7aIxz`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=321) as `cPh5SmI8Y7H`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=258 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `qmvrm7HxRDH`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=91) as `mv5N8hKpHX1`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=150 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `RgYAhPfaU3l`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=107) as `tmi1KlBLlOK`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=133) as `YUOJdOkXtr1`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=109) as `G1yajc8Xkec`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=167) as `VbMnuDnauWk`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=164) as `SIAw7aUYBRN`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=126) as `dAMc7zEcdH1`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=177) as `mECYGQUoXjC`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=132) as `UeKTdsnhuTv`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=95) as `pPQEPgNd3HH`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=123) as `MT9O6DStNCG`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=193) as `jz6YB1tTRq3`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=142) as `qMUToUeUJa2`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=319) as `AWkWRlWuDiM`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=134) as `moG6T0LAiXD`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=185 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `sVPKqquZE0c`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=131) as `VTBzoVWJ9Go`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=190) as `T8nQbBeaLVQ`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=309) as `PCAowcWbOIr`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=93) as `VU1zsJawhgB`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=184 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `nuuz1HG6zGr`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=194) as `nSNQ103KziK`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=176) as `b4H0jBUNRII`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=168) as `OTSgE5rSeLs`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=160) as `gqDOGiTTJNb`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=149 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `GK3v1SRsGkT`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=152 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `O2pBRS8E9lA`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=110) as `FYr3Pw3xaB7`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=182 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `yz15DXlCc77`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=118) as `yQk0yjn6jWd`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=138) as `vjUr1o14nfJ`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=117) as `WQO5Uh8LCh1`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=166) as `D2sxWrZE16E`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=125) as `ndW0ybelAy7`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=316) as `NbEYBNsw1TX`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=189) as `lg9l4x9yQ3h`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=161) as `PPaewbLxLOF`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=165) as `H4ihYR0AXGK`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=179) as `Ie0OjIB8H0I`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=120) as `QfUIrcDU4O1`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=313) as `Dz55DEZ4ipi`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=311) as `N0hWKaU5LcY`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=102) as `fyyXPHMRey0`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=103) as `TDw4V3lVVnN`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=180) as `B2HUapjElVz`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=171) as `q4Uf7YpBSuR`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=122) as `rHFEmuTeNud`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=170) as `BWg1swhPsLZ`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=172) as `vyQPMCEycON`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=136) as `LokSP9bYaa1`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=153 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `CjMkEhfgTNW`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=112) as `UZDMNRQLceH`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=141) as `GLN4bDmgGpR`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=108) as `dBqS7UvJd7K`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=113) as `vFkGJbSd7WA`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=320) as `G4B1Lf63W0X`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=101) as `MgBywmPgmek`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=187) as `QPDdeGmEw7R`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=315) as `fOr7uamrnrc`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=155 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `Apn3V8L0Abe`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=191) as `kwIoYixO5Bt`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=318) as `U4psib5CnXh`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=128) as `YFAenyqbWJH`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=100) as `bzcxg2i4Jxa`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=163) as `dcsI0p1ey6X`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=314) as `Wuawykaym6d`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=127) as `mKKRb7rTz4i`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=162) as `laRXYFIoTJG`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=192) as `E33Fje80YqW`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=322) as `jHOrChygRJX`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=178) as `NTCC5cw7vYd`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=104) as `GuvtzwaOX9v`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=158 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `FJObZrsvnpw`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=116) as `AHeUbZi0HuA`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=124) as `FQwW8msBOHt`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=115) as `LhPnk9J1OFO`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=173) as `pD30iwhv3ir`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=148 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `cDqM78CI4PT`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=92) as `h3S5tVVMyRa`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=186) as `L81diHHEOGO`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=154 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `sTEiAmpx2Ga`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=146 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `vxnG7TbhQH7`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=174) as `ko1u8vhLRG6`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=317) as `FecKvoKall3`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=145 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `Pn3tgEuDZix`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=135) as `g41fWLW9VEh`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=175 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `pw5Ntiw9Rag`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=151 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `cAD81lcEPO9`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=140) as `o2LIE9aXxfH`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=324) as `a46aX3Jf1hf`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=111) as `BUcS4bq8hnd`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=139) as `j4x8Lx0VndK`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=312) as `COZrXo3XiQw`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=323) as `jDqdtVxQwQB`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=137) as `faibBtM3iPM`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=147 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `AqH4x9ql6ba`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=156 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `DvpGpmJkTVZ`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=106) as `dlibOZ5OKDm`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=159) as `Le0Xo9mBRkg`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=144 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `cYhwWMK20tT`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=157 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `Vh2GRNpo4SO`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=188) as `hIIIGvvRpgw`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=181) as `CejQJePWMXq`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=130) as `h7SRyXR4ntv`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=143 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `H16f0ytB8ym`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=183 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `SsHHXRo2HOd`,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 patient pa on pi.patientid=pa.patientid 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-19])
* INFO  2014-03-27 09:41:43,442 Populate SQL: insert into analytics_event_temp_2014_MQEdhAykSEG (`uidlevel1`,`uidlevel2`,`uidlevel3`,`uidlevel4`,`uidlevel5`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`yearly`,`financialapril`,`financialjuly`,`financialoct`,`EyBbIzuPF5O`,`I948alxq2QA`,`aJdrpgX3nUF`,`xJ4Gl8H7uKk`,`KzA18BDzKw4`,psi,ps,executiondate,longitude,latitude,ou,ouname,oucode) select ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,ous.`uidlevel4`,ous.`uidlevel5`,dps.`daily`,dps.`weekly`,dps.`monthly`,dps.`bimonthly`,dps.`quarterly`,dps.`sixmonthly`,dps.`yearly`,dps.`financialapril`,dps.`financialjuly`,dps.`financialoct`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=87 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `EyBbIzuPF5O`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=88) as `I948alxq2QA`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=86 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `aJdrpgX3nUF`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=89) as `xJ4Gl8H7uKk`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=90) as `KzA18BDzKw4`,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 patient pa on pi.patientid=pa.patientid 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-19])
* INFO  2014-03-27 09:41:43,452 Populate SQL: insert into analytics_event_temp_2014_Rxf3GkBK3CZ (`uidlevel1`,`uidlevel2`,`uidlevel3`,`uidlevel4`,`uidlevel5`,`daily`,`weekly`,`monthly`,`bimonthly`,`quarterly`,`sixmonthly`,`yearly`,`financialapril`,`financialjuly`,`financialoct`,`DUgwMwZWqQ6`,`VUV9Y68G7XE`,`vFr0643uIxg`,`oAKzRm8vyBr`,`eGztKsq1jia`,`jk77HaM4JgB`,`gLhzTbevx76`,`j82k1ixyKG2`,`Yd0xhROmK7s`,`f4zRR3HiuCZ`,`Q1RTkc3j71t`,`bhSulsMihxB`,`F7aDH6oHoEK`,`MIUR41RJ7c1`,`FYiSqzxE1L6`,`pspudRhtjEa`,`QPOP4upYaJw`,`rC8XccfNffE`,`talH411bGxz`,`u4Qi6TiSDXO`,`FL7NpbKJJ0h`,`c0HqKH3Msth`,`O7ED8yAS31V`,`VaDBUpHginK`,`pBQ3tsUewxw`,`cTJg2h24MuH`,`rAGbzWM4AFm`,`das71R8kjmp`,`hfBzS3KONz8`,`SobrntCw0Tf`,`Fyf50KDg6wA`,`A3kG6yP3Tb2`,`mYswsfZtxyZ`,`xOSoYINYG1B`,`gTv59gcmnzR`,`NtBQBCO6Qcr`,`xRyt5JQH7zD`,`bNZmFwYIx5r`,`xVZvYuesq1k`,`fpbcIxP9vyZ`,`LEwtdxiwWfy`,psi,ps,executiondate,longitude,latitude,ou,ouname,oucode) select ous.`uidlevel1`,ous.`uidlevel2`,ous.`uidlevel3`,ous.`uidlevel4`,ous.`uidlevel5`,dps.`daily`,dps.`weekly`,dps.`monthly`,dps.`bimonthly`,dps.`quarterly`,dps.`sixmonthly`,dps.`yearly`,dps.`financialapril`,dps.`financialjuly`,dps.`financialoct`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=333) as `DUgwMwZWqQ6`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=305) as `VUV9Y68G7XE`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=328 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `vFr0643uIxg`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=308) as `oAKzRm8vyBr`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=276) as `eGztKsq1jia`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=289 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `jk77HaM4JgB`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=281 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `gLhzTbevx76`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=327 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `j82k1ixyKG2`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=296) as `Yd0xhROmK7s`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=303) as `f4zRR3HiuCZ`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=306 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `Q1RTkc3j71t`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=307 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `bhSulsMihxB`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=286 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `F7aDH6oHoEK`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=336) as `MIUR41RJ7c1`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=280 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `FYiSqzxE1L6`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=330 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `pspudRhtjEa`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=279) as `QPOP4upYaJw`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=294 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `rC8XccfNffE`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=283 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `talH411bGxz`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=331 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `u4Qi6TiSDXO`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=290 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `FL7NpbKJJ0h`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=278) as `c0HqKH3Msth`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=332 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `O7ED8yAS31V`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=282 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `VaDBUpHginK`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=277) as `pBQ3tsUewxw`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=304 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `cTJg2h24MuH`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=275 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `rAGbzWM4AFm`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=295) as `das71R8kjmp`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=297) as `hfBzS3KONz8`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=325 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `SobrntCw0Tf`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=284 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `Fyf50KDg6wA`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=302) as `A3kG6yP3Tb2`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=335) as `mYswsfZtxyZ`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=293 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `xOSoYINYG1B`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=285 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `gTv59gcmnzR`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=301) as `NtBQBCO6Qcr`,(select value from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=334) as `xRyt5JQH7zD`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=288 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `bNZmFwYIx5r`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=326 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `xVZvYuesq1k`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=329 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `fpbcIxP9vyZ`,(select cast(value as decimal(26,1)) from patientdatavalue where programstageinstanceid=psi.programstageinstanceid and dataelementid=287 and value regexp '^(-?[0-9]+)(\.[0-9]+)?(E\d+)?$') as `LEwtdxiwWfy`,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 patient pa on pi.patientid=pa.patientid 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=3 and psi.organisationunitid is not null and psi.executiondate is not null (JdbcEventAnalyticsTableManager.java [SimpleAsyncTaskExecutor-19])
* INFO  2014-03-27 09:41:45,174 Populated analytics tables: 0:00:07.091 (Clock.java [taskScheduler-1])
* INFO  2014-03-27 09:41:45,175 [Level: INFO, category: DATAMART, time: Thu Mar 27 09:41:45 GMT-03:00 2014, message: Pruned analytics tables] (InMemoryNotifier.java [taskScheduler-1])
* INFO  2014-03-27 09:41:46,226 Drop SQL: drop table analytics_event_temp_2012_MQEdhAykSEG (AbstractJdbcTableManager.java [taskScheduler-1])
* INFO  2014-03-27 09:41:47,352 Drop SQL: drop table analytics_event_temp_2013_MQEdhAykSEG (AbstractJdbcTableManager.java [taskScheduler-1])
* INFO  2014-03-27 09:41:48,879 Drop SQL: drop table analytics_event_temp_2014_MQEdhAykSEG (AbstractJdbcTableManager.java [taskScheduler-1])
* INFO  2014-03-27 09:41:49,066 Pruned analytics tables: 0:00:10.983 (Clock.java [taskScheduler-1])
* INFO  2014-03-27 09:41:49,066 [Level: INFO, category: DATAMART, time: Thu Mar 27 09:41:49 GMT-03:00 2014, message: Applying aggregation levels] (InMemoryNotifier.java [taskScheduler-1])
* INFO  2014-03-27 09:41:49,071 Applied aggregation levels: 0:00:10.988 (Clock.java [taskScheduler-1])
* INFO  2014-03-27 09:41:49,071 [Level: INFO, category: DATAMART, time: Thu Mar 27 09:41:49 GMT-03:00 2014, message: Creating indexes] (InMemoryNotifier.java [taskScheduler-1])
* INFO  2014-03-27 09:41:49,073 No of indexes: 609 (DefaultAnalyticsTableService.java [taskScheduler-1])
* INFO  2014-03-27 09:41:49,314 Created index: `in_uidlevel2_analytics_event_temp_2012_OApyMUCqMnw_U420Q` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-22])
* INFO  2014-03-27 09:41:49,413 Created index: `in_uidlevel1_analytics_event_temp_2012_OApyMUCqMnw_swYBj` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-21])
* INFO  2014-03-27 09:41:49,530 Created index: `in_uidlevel3_analytics_event_temp_2012_OApyMUCqMnw_tbjle` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-22])
* INFO  2014-03-27 09:41:49,662 Created index: `in_uidlevel4_analytics_event_temp_2012_OApyMUCqMnw_FafXJ` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-21])
* INFO  2014-03-27 09:41:49,791 Created index: `in_uidlevel5_analytics_event_temp_2012_OApyMUCqMnw_RNbty` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-22])
* INFO  2014-03-27 09:41:49,929 Created index: `in_daily_analytics_event_temp_2012_OApyMUCqMnw_Fz3ka` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-21])
* INFO  2014-03-27 09:41:50,044 Created index: `in_weekly_analytics_event_temp_2012_OApyMUCqMnw_p8SPt` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-22])
* INFO  2014-03-27 09:41:50,316 Created index: `in_monthly_analytics_event_temp_2012_OApyMUCqMnw_eBya6` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-21])
* INFO  2014-03-27 09:41:50,452 Created index: `in_bimonthly_analytics_event_temp_2012_OApyMUCqMnw_VvziU` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-22])
* INFO  2014-03-27 09:41:50,635 Created index: `in_quarterly_analytics_event_temp_2012_OApyMUCqMnw_qmS46` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-21])
* INFO  2014-03-27 09:41:50,840 Created index: `in_sixmonthly_analytics_event_temp_2012_OApyMUCqMnw_j608J` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-22])
* INFO  2014-03-27 09:41:50,993 Created index: `in_yearly_analytics_event_temp_2012_OApyMUCqMnw_A0X74` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-21])
* INFO  2014-03-27 09:41:51,118 Created index: `in_financialapril_analytics_event_temp_2012_OApyMUCqMnw_WSY9i` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-22])
* INFO  2014-03-27 09:41:51,316 Created index: `in_financialjuly_analytics_event_temp_2012_OApyMUCqMnw_DTH8E` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-21])
* INFO  2014-03-27 09:41:51,456 Created index: `in_financialoct_analytics_event_temp_2012_OApyMUCqMnw_uWJor` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-22])
* INFO  2014-03-27 09:41:51,600 Created index: `in_xfjgIAbmlw0_analytics_event_temp_2012_OApyMUCqMnw_qxjrH` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-21])
* INFO  2014-03-27 09:41:51,761 Created index: `in_rk9NUud9qIN_analytics_event_temp_2012_OApyMUCqMnw_DJgmW` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-22])
* INFO  2014-03-27 09:41:51,969 Created index: `in_aPuokp7fCpf_analytics_event_temp_2012_OApyMUCqMnw_e2MHO` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-21])
* INFO  2014-03-27 09:41:52,317 Created index: `in_WoS6ilw6y9Z_analytics_event_temp_2012_OApyMUCqMnw_lxr29` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-22])
* INFO  2014-03-27 09:41:52,444 Created index: `in_p6GemAvyvdu_analytics_event_temp_2012_OApyMUCqMnw_w8zSV` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-21])
* INFO  2014-03-27 09:41:52,676 Created index: `in_Uyu04nyMqXE_analytics_event_temp_2012_OApyMUCqMnw_lvwh1` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-22])
* INFO  2014-03-27 09:41:52,820 Created index: `in_Sue4pg7aIxz_analytics_event_temp_2012_OApyMUCqMnw_vojkj` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-21])
* INFO  2014-03-27 09:41:52,986 Created index: `in_cPh5SmI8Y7H_analytics_event_temp_2012_OApyMUCqMnw_vamIb` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-22])
* INFO  2014-03-27 09:41:53,131 Created index: `in_qmvrm7HxRDH_analytics_event_temp_2012_OApyMUCqMnw_iQfTI` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-21])
* INFO  2014-03-27 09:41:53,583 Created index: `in_mv5N8hKpHX1_analytics_event_temp_2012_OApyMUCqMnw_UHt9n` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-22])
* INFO  2014-03-27 09:41:53,727 Created index: `in_RgYAhPfaU3l_analytics_event_temp_2012_OApyMUCqMnw_FBJMk` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-21])
* INFO  2014-03-27 09:41:53,904 Created index: `in_tmi1KlBLlOK_analytics_event_temp_2012_OApyMUCqMnw_A8IAM` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-22])
* INFO  2014-03-27 09:41:54,070 Created index: `in_YUOJdOkXtr1_analytics_event_temp_2012_OApyMUCqMnw_lPmLf` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-21])
* INFO  2014-03-27 09:41:54,231 Created index: `in_G1yajc8Xkec_analytics_event_temp_2012_OApyMUCqMnw_Wuo81` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-22])
* INFO  2014-03-27 09:41:54,330 Created index: `in_VbMnuDnauWk_analytics_event_temp_2012_OApyMUCqMnw_bFs2Z` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-21])
* INFO  2014-03-27 09:41:54,501 Created index: `in_SIAw7aUYBRN_analytics_event_temp_2012_OApyMUCqMnw_y8B7d` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-22])
* INFO  2014-03-27 09:41:54,634 Created index: `in_dAMc7zEcdH1_analytics_event_temp_2012_OApyMUCqMnw_YCdQw` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-21])
* INFO  2014-03-27 09:41:54,800 Created index: `in_mECYGQUoXjC_analytics_event_temp_2012_OApyMUCqMnw_RSkPJ` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-22])
* INFO  2014-03-27 09:41:54,943 Created index: `in_UeKTdsnhuTv_analytics_event_temp_2012_OApyMUCqMnw_OXQAS` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-21])
* INFO  2014-03-27 09:41:55,049 Created index: `in_pPQEPgNd3HH_analytics_event_temp_2012_OApyMUCqMnw_BWvfO` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-22])
* INFO  2014-03-27 09:41:55,353 Created index: `in_MT9O6DStNCG_analytics_event_temp_2012_OApyMUCqMnw_mqDVJ` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-21])
* INFO  2014-03-27 09:41:55,679 Created index: `in_jz6YB1tTRq3_analytics_event_temp_2012_OApyMUCqMnw_NSowM` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-22])
* INFO  2014-03-27 09:41:55,961 Created index: `in_qMUToUeUJa2_analytics_event_temp_2012_OApyMUCqMnw_hj9CU` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-21])
* INFO  2014-03-27 09:41:56,116 Created index: `in_AWkWRlWuDiM_analytics_event_temp_2012_OApyMUCqMnw_ZoY15` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-22])
* INFO  2014-03-27 09:41:56,310 Created index: `in_moG6T0LAiXD_analytics_event_temp_2012_OApyMUCqMnw_fOnm7` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-21])
* INFO  2014-03-27 09:41:56,487 Created index: `in_sVPKqquZE0c_analytics_event_temp_2012_OApyMUCqMnw_ps6Ea` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-22])
* INFO  2014-03-27 09:41:56,647 Created index: `in_VTBzoVWJ9Go_analytics_event_temp_2012_OApyMUCqMnw_hb8FI` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-21])
* INFO  2014-03-27 09:41:56,804 Created index: `in_T8nQbBeaLVQ_analytics_event_temp_2012_OApyMUCqMnw_e9oQW` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-22])
* INFO  2014-03-27 09:41:56,962 Created index: `in_PCAowcWbOIr_analytics_event_temp_2012_OApyMUCqMnw_jPo5u` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-21])
* INFO  2014-03-27 09:41:57,095 Created index: `in_VU1zsJawhgB_analytics_event_temp_2012_OApyMUCqMnw_fs6aJ` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-22])
* INFO  2014-03-27 09:41:57,294 Created index: `in_nuuz1HG6zGr_analytics_event_temp_2012_OApyMUCqMnw_r2uCc` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-21])
* INFO  2014-03-27 09:41:57,438 Created index: `in_nSNQ103KziK_analytics_event_temp_2012_OApyMUCqMnw_FXGiL` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-22])
* INFO  2014-03-27 09:41:57,587 Created index: `in_b4H0jBUNRII_analytics_event_temp_2012_OApyMUCqMnw_lsaIn` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-21])
* INFO  2014-03-27 09:41:57,761 Created index: `in_OTSgE5rSeLs_analytics_event_temp_2012_OApyMUCqMnw_aY948` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-22])
* INFO  2014-03-27 09:41:57,919 Created index: `in_gqDOGiTTJNb_analytics_event_temp_2012_OApyMUCqMnw_EaaEK` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-21])
* INFO  2014-03-27 09:41:58,068 Created index: `in_GK3v1SRsGkT_analytics_event_temp_2012_OApyMUCqMnw_bCO6k` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-22])
* INFO  2014-03-27 09:41:58,206 Created index: `in_O2pBRS8E9lA_analytics_event_temp_2012_OApyMUCqMnw_jIy6G` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-21])
* INFO  2014-03-27 09:41:58,362 Created index: `in_FYr3Pw3xaB7_analytics_event_temp_2012_OApyMUCqMnw_wnQ5l` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-22])
* INFO  2014-03-27 09:41:58,505 Created index: `in_yz15DXlCc77_analytics_event_temp_2012_OApyMUCqMnw_fvdGI` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-21])
* INFO  2014-03-27 09:41:58,679 Created index: `in_yQk0yjn6jWd_analytics_event_temp_2012_OApyMUCqMnw_O4yK6` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-22])
* INFO  2014-03-27 09:41:58,834 Created index: `in_vjUr1o14nfJ_analytics_event_temp_2012_OApyMUCqMnw_M5SCq` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-21])
* INFO  2014-03-27 09:41:59,014 Created index: `in_WQO5Uh8LCh1_analytics_event_temp_2012_OApyMUCqMnw_u0IxC` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-22])
* INFO  2014-03-27 09:41:59,199 Created index: `in_D2sxWrZE16E_analytics_event_temp_2012_OApyMUCqMnw_htr9F` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-21])
* INFO  2014-03-27 09:41:59,377 Created index: `in_ndW0ybelAy7_analytics_event_temp_2012_OApyMUCqMnw_dkrzN` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-22])
* INFO  2014-03-27 09:41:59,520 Created index: `in_NbEYBNsw1TX_analytics_event_temp_2012_OApyMUCqMnw_Qrgno` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-21])
* INFO  2014-03-27 09:41:59,664 Created index: `in_lg9l4x9yQ3h_analytics_event_temp_2012_OApyMUCqMnw_bIV3E` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-22])
* INFO  2014-03-27 09:41:59,820 Created index: `in_PPaewbLxLOF_analytics_event_temp_2012_OApyMUCqMnw_HLfcT` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-21])
* INFO  2014-03-27 09:42:00,098 Created index: `in_H4ihYR0AXGK_analytics_event_temp_2012_OApyMUCqMnw_xWgE2` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-22])
* INFO  2014-03-27 09:42:00,226 Created index: `in_Ie0OjIB8H0I_analytics_event_temp_2012_OApyMUCqMnw_JHz2k` (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-21])
* INFO  2014-03-27 09:42:00,230 [Level: ERROR, category: DATAMART, time: Thu Mar 27 09:42:00 GMT-03:00 2014, message: Process failed: Exception during execution] (InMemoryNotifier.java [taskScheduler-1])
* INFO  2014-03-27 09:42:00,535 SMSLib: A Java API library for sending and receiving SMS via a GSM modem or other supported gateways.
This software is distributed under the terms of the Apache v2.0 License.
Web Site: http://smslib.org (Service.java [taskScheduler-1])
* INFO  2014-03-27 09:42:00,535 Version: 3.5.3 (Service.java [taskScheduler-1])
* INFO  2014-03-27 09:42:00,536 JRE Version: 1.7.0_07 (Service.java [taskScheduler-1])
* INFO  2014-03-27 09:42:00,536 JRE Impl Version: 23.3-b01 (Service.java [taskScheduler-1])
* INFO  2014-03-27 09:42:00,536 O/S: Windows 7 / x86 / 6.1 (Service.java [taskScheduler-1])
* ERROR 2014-03-27 09:42:00,577 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-1])
java.lang.RuntimeException: Exception during execution
	at org.hisp.dhis.system.util.ConcurrentUtils.waitForCompletion(ConcurrentUtils.java:55)
	at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.createIndexes(DefaultAnalyticsTableService.java:266)
	at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.update(DefaultAnalyticsTableService.java:128)
	at org.hisp.dhis.analytics.scheduling.AnalyticsTableTask.run(AnalyticsTableTask.java:132)
	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$Sync.innerRun(FutureTask.java:334)
	at java.util.concurrent.FutureTask.run(FutureTask.java:166)
	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:1110)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
	at java.lang.Thread.run(Thread.java:722)
Caused by: java.util.concurrent.ExecutionException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [create index `in_Dz55DEZ4ipi_analytics_event_temp_2012_OApyMUCqMnw_PXhtK` on analytics_event_temp_2012_OApyMUCqMnw (`Dz55DEZ4ipi`)]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Too many keys specified; max 64 keys allowed
	at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:252)
	at java.util.concurrent.FutureTask.get(FutureTask.java:111)
	at org.hisp.dhis.system.util.ConcurrentUtils.waitForCompletion(ConcurrentUtils.java:51)
	... 13 more
Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [create index `in_Dz55DEZ4ipi_analytics_event_temp_2012_OApyMUCqMnw_PXhtK` on analytics_event_temp_2012_OApyMUCqMnw (`Dz55DEZ4ipi`)]; 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:164)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:601)
	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$Sync.innerRun(FutureTask.java:334)
	at java.util.concurrent.FutureTask.run(FutureTask.java:166)
	... 1 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Too many keys specified; max 64 keys allowed
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
	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)
	... 13 more