dhis2-devs team mailing list archive

Thread
Date

Re: Migration from 2.11 to 2.14

To: Bharath <chbharathk@xxxxxxxxx>
From: Marcio Thome <mthome@xxxxxxxxxxxxx>
Date: Thu, 27 Mar 2014 10:36:05 -0300
Cc: dhis2-users <dhis2-users@xxxxxxxxxxxxxxxxxxx>, DHIS 2 Developers list <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
In-reply-to: <CAF6QxwYaVzBdzyNfYizcH2C4TjZKzz2sw3DKh5q=cn6FqZSEMg@mail.gmail.com>

Dear all

Thank you Bharath. It worked after runing the query to update datavalue
set attributeoptioncomboid = 1! It is not being done automatically in
MySQL, Lars. I can now visualize data entry done in 2.11 when running 2.14.
But I am still having an exception error when running analytics.

I am attaching the Tomcat script with the erorr as suggested by Jason
Pickering to see if you can help us sorting out why analytics is not
working. it seems the application is stoping at the following error:

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Too many keys
specified; max 64 keys allowed

Thank you all once again for helping.

Best

Márcio




2014-03-27 5:54 GMT-03:00 Bharath <chbharathk@xxxxxxxxx>:

> yes in mysql when we converted from 2.12 to 2.14 it doesn't work, I
> manually executed update query.
>
>
> On Thu, Mar 27, 2014 at 2:13 PM, Lars Helge Øverland <larshelge@xxxxxxxxx>wrote:
>
>>
>> On Mar 27, 2014 7:41 AM, "Bharath" <chbharathk@xxxxxxxxx> wrote:
>> >
>> > One thing you can check is datavalue  table.
>> > When you upgrade to 2.14, new column with the
>> name attributeoptioncomboid will be created in datavalue table and it will
>> populated with 0 by default. So you may run query to change this value from
>> 0 to default categoryoptioncomboid (most of the cases it will be 1).
>> >
>> > query will be some thing similar to: update datavalue
>> set attributeoptioncomboid = 1 (here 1 is default categoryoptioncomboid)
>>
>> Hi, this should happen automatically. Works on postgres, I guess what you
>> are saying is that it does not work on mysql?
>>
>> >
>> >
>> >
>> >
>> >
>> > On Wed, Mar 26, 2014 at 8:25 PM, Marcio Thome <mthome@xxxxxxxxxxxxx>
>> wrote:
>> >>
>> >> Hi all
>> >>
>> >>
>> >>
>> >> Is anyone out there that could help us in using DHIS2 2.14?
>> >>
>> >>
>> >>
>> >> I am not being able to migrate from 2.11 to 2.14. I run DHIS2 2.14
>> with the old MySQL database but cannot visualize the data in data entry or
>> in the reports. It is fine in 2.11. When I attempt to run Analytics I am
>> confronted with an exception error. All the screen shots are attached. I am
>> running on Apache Tomcat, MySQL, DHIS2 version 2.14 build 13815 and Version
>> 2.11 build 10550.
>> >>
>> >>
>> >>
>> >> Thank you for assisting. We are resisting in giving up on version 2.14
>> and hoping someone already had similar issues already resolved.
>> >>
>> >>
>> >>
>> >> Best
>> >>
>> >>
>> >>
>> >> Marcio
>> >>
>> >>
>> >>
>> >> --
>> >> Márcio Thomé
>> >>
>> >> Coordenador
>> >> Departamento de Avaliação e Estatísticas
>> >> BEMFAM - Bem Estar Familiar no Brasil
>> >> Avenida Carlos Chagas Filho, 791. Ilha do Fundão.
>> >> Rio de Janeiro. 21941-599
>> >> Tel.: 55-21-30057207 R. 2408
>> >> Skype: Marcio-Deav
>> >>
>> >> _______________________________________________
>> >> Mailing list: https://launchpad.net/~dhis2-devs
>> >> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> >> Unsubscribe : https://launchpad.net/~dhis2-devs
>> >> More help   : https://help.launchpad.net/ListHelp
>> >>
>> >
>> >
>> >
>> > --
>> >
>> > Regards,
>> > Bharath Kumar. Ch
>> >
>> > _______________________________________________
>> > Mailing list: https://launchpad.net/~dhis2-devs
>> > Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> > Unsubscribe : https://launchpad.net/~dhis2-devs
>> > More help   : https://help.launchpad.net/ListHelp
>> >
>>
>
>
>
> --
>
> Regards,
> Bharath Kumar. Ch
>



-- 
Márcio Thomé

Coordenador
Departamento de Avaliação e Estatísticas
BEMFAM - Bem Estar Familiar no Brasil

Avenida Carlos Chagas Filho, 791. Ilha do Fundão.
Rio de Janeiro. 21941-599
Tel.: 55-21-30057207 R. 2408
Skype: Marcio-Deav

* 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

References

Migration from 2.11 to 2.14
From: Marcio Thome, 2014-03-26
Re: Migration from 2.11 to 2.14
From: Bharath, 2014-03-27
Re: Migration from 2.11 to 2.14
From: Lars Helge Øverland, 2014-03-27
Re: Migration from 2.11 to 2.14
From: Bharath, 2014-03-27