dhis2-users team mailing list archive

Thread
Date

Creating charts, maps and tables in dhis2-live 2.14

To: dhis2-users <dhis2-users@xxxxxxxxxxxxxxxxxxx>
From: Marta Vila <martavila@xxxxxxxxx>
Date: Mon, 3 Feb 2014 18:15:16 +0100

Dear all,

I have imported some data into a 2.14 dhis2-live and run the analytics
process.

Version:2.14 Build revision:13752 Build date:2014-01-31 16:41
It has gone well, and I´ve checked with an SQL view that the analytics
table and its values are there. However when I when I try to create a
chart, table or map, I get the "Values not found" message.

Having a look at the log (complete log attached)

** INFO  17:45:29,251 Query failed, likely because the requested analytics
table does not exist (JdbcAnalyticsManager.java
[SimpleAsyncTaskExecutor-6])*
*org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad
SQL grammar [select "uidlevel4","de", sum(value) as value from
analytics_2011 where "uidlevel4" in (**'zXcr52pysDR', 'dOfLwJp4HCR',
'ZZ2j0yKuZu8', 'xTki3rdk7cd', 'Y5pHHOo6Omn'**) and "de" in ('gUvSpUrTCCH')
and ("yearly" in ('2011')) group by "uidlevel4","de"]; nested exception is
org.h2.jdbc.JdbcSQLException: Column "de" not found; SQL statement:*
*select "uidlevel4","de", sum(value) as value from analytics_2011 where
"uidlevel4" in ('u4Idnn89LtY', 'XGPQ2WduCfW', 'S4cPuE2d3dv', 'OCtV1PUshto',
'pBihSffHkhT') and "de" in ('gUvSpUrTCCH') and ("yearly" in ('2011')) group
by "uidlevel4","de" [42122-173]*

It seems like the query fails because "de" does not exist... However in the
DB I see column a column DE and H2 is not supposed to be case sensitive.

I found that it may be acting like this because of the double quote
https://groups.google.com/forum/#!topic/h2-database/UXI2Mz5HM3s
<https://groups.google.com/forum/#!topic/h2-database/UXI2Mz5HM3s>
, tried an SQL view without the quotes and worked so...

In case this is the problem... is there any way it can be solved?

thanks!!

* INFO  07:24:32,990 Environment variable DHIS2_HOME: null (TrayApp.java [main])
* INFO  17:34:51,172 Environment variable DHIS2_HOME: D:\dhis (TrayApp.java [main])
* INFO  17:34:51,457 Initialising DHIS 2 Live... (TrayApp.java [main])
* INFO  17:34:52,006 Loading DHIS 2 on port: 8082 (WebAppServer.java [main])
* INFO  17:34:52,162 Setting DHIS 2 web app context to: /C:/Live 31 enero - new/webapps/dhis (WebAppServer.java [main])
* INFO  17:34:52,163 Lifecycle: server starting (TrayApp.java [Thread-2])
* INFO  17:35:07,214 System property dhis2.home points to /C:/Live 31 enero - new/conf (DefaultLocationManager.java [Thread-2])
* INFO  17:35:08,767 Hibernate configuration loaded, using dialect: org.hibernate.dialect.H2Dialect (DefaultHibernateConfigurationProvider.java [Thread-2])
* INFO  17:35:27,835 Found the following message senders: [org.hisp.dhis.message.EmailMessageSender@5868d3, org.hisp.dhis.sms.SmsMessageSender@4a3572] (DefaultMessageService.java [Thread-2])
* INFO  17:35:36,367 Detected apps: [] (DefaultAppManager.java [Thread-2])
* INFO  17:35:41,756 Executing startup routine [1 of 11, runlevel 1]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO  17:35:41,823 Executing startup routine [2 of 11, runlevel 1]: DataElementDefaultDimensionPopulator (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO  17:35:41,847 Added default concept (DataElementDefaultDimensionPopulator.java [Thread-2])
* INFO  17:35:42,010 Added default category (DataElementDefaultDimensionPopulator.java [Thread-2])
* INFO  17:35:42,028 Linked default category with default concept (DataElementDefaultDimensionPopulator.java [Thread-2])
* INFO  17:35:42,035 Executing startup routine [3 of 11, runlevel 2]: TableAlteror (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO  17:35:42,424 Data value table upgraded with attributeoptioncomboid column (TableAlteror.java [Thread-2])
* INFO  17:35:42,433 Tables updated (TableAlteror.java [Thread-2])
* INFO  17:35:42,433 Executing startup routine [4 of 11, runlevel 3]: IdentityPopulator (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO  17:35:42,584 Executing startup routine [5 of 11, runlevel 3]: TableCreator (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO  17:35:42,586 Created table/index messageconversation_lastmessage (TableCreator.java [Thread-2])
* INFO  17:35:42,587 Created table/index interpretation_lastupdated (TableCreator.java [Thread-2])
* INFO  17:35:42,587 Executing startup routine [6 of 11, runlevel 4]: PatientTableAlteror (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO  17:35:42,655 Inserted data into program_attributes table. (TableAlteror.java [Thread-2])
* INFO  17:35:42,655 Inserted data into program_identifiertypes table. (TableAlteror.java [Thread-2])
* INFO  17:35:42,656 Dropped program_patientattributes table. (TableAlteror.java [Thread-2])
* INFO  17:35:42,656 Dropped program_patientidentifiertypes table. (TableAlteror.java [Thread-2])
* INFO  17:35:42,657 Executing startup routine [7 of 11, runlevel 4]: MapViewUpgrader (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO  17:35:42,661 Executing startup routine [8 of 11, runlevel 5]: DataEntryFormUpgrader (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO  17:35:42,662 Upgraded custom case entry form identifiers (DataEntryFormUpgrader.java [Thread-2])
* INFO  17:35:42,663 Executing startup routine [9 of 11, runlevel 6]: ExpressionUpgrader (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO  17:35:42,688 Executing startup routine [10 of 11, runlevel 7]: ConfigurationPopulator (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO  17:35:42,691 Executing startup routine [11 of 11, runlevel 7]: I18nLocalePopulator (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO  17:35:42,739 Populated default locales (I18nLocalePopulator.java [Thread-2])
* INFO  17:35:42,740 All startup routines done (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO  17:35:55,426 Lifecycle: server started (TrayApp.java [Thread-2])
* INFO  17:36:20,407 Login success for user: 'admin', ip: '0:0:0:0:0:0:0:1' (DefaultUserAuditService.java [13643508@qtp-11616363-5])
* INFO  17:36:45,717 User 'admin' started import at Fri Jan 31 17:36:45 CET 2014 (DefaultImportService.java [taskScheduler-1])
* INFO  17:36:45,719 [Level: INFO, category: METADATA_IMPORT, time: Fri Jan 31 17:36:45 CET 2014, message: Importing meta-data] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:36:45,722 Building object-bridge maps (preheatCache: true). (DefaultObjectBridge.java [taskScheduler-1])
* WARN  17:36:45,758 No IdentifiableObjectStore found for class: class org.hisp.dhis.user.UserCredentials (DefaultIdentifiableObjectManager.java [taskScheduler-1])
* WARN  17:36:45,759 No IdentifiableObjectStore found for class: class org.hisp.dhis.user.UserCredentials (DefaultIdentifiableObjectManager.java [taskScheduler-1])
* WARN  17:36:45,759 No IdentifiableObjectStore found for class: class org.hisp.dhis.user.UserCredentials (DefaultIdentifiableObjectManager.java [taskScheduler-1])
* WARN  17:36:45,760 No IdentifiableObjectStore found for class: class org.hisp.dhis.user.UserCredentials (DefaultIdentifiableObjectManager.java [taskScheduler-1])
* INFO  17:36:46,879 Building object-bridge maps took 1,12 seconds. (DefaultObjectBridge.java [taskScheduler-1])
* INFO  17:36:46,929 [Level: INFO, category: METADATA_IMPORT, time: Fri Jan 31 17:36:46 CET 2014, message: Importing 1 Concepts] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:36:46,950 [Level: INFO, category: METADATA_IMPORT, time: Fri Jan 31 17:36:46 CET 2014, message: Importing 77 OrganisationUnits] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:36:47,191 [Level: INFO, category: METADATA_IMPORT, time: Fri Jan 31 17:36:47 CET 2014, message: Importing 6 OrganisationUnitLevels] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:36:47,201 [Level: INFO, category: METADATA_IMPORT, time: Fri Jan 31 17:36:47 CET 2014, message: Importing 22 OrganisationUnitGroups] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:36:47,246 [Level: INFO, category: METADATA_IMPORT, time: Fri Jan 31 17:36:47 CET 2014, message: Importing 3 OrganisationUnitGroupSets] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:36:47,255 [Level: INFO, category: METADATA_IMPORT, time: Fri Jan 31 17:36:47 CET 2014, message: Importing 3 CategoryOptions] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:36:47,258 [Level: INFO, category: METADATA_IMPORT, time: Fri Jan 31 17:36:47 CET 2014, message: Importing 2 Categories] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:36:47,263 [Level: INFO, category: METADATA_IMPORT, time: Fri Jan 31 17:36:47 CET 2014, message: Importing 2 CategoryCombos] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:36:47,267 [Level: INFO, category: METADATA_IMPORT, time: Fri Jan 31 17:36:47 CET 2014, message: Importing 4 CategoryOptionCombos] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:36:47,275 [Level: INFO, category: METADATA_IMPORT, time: Fri Jan 31 17:36:47 CET 2014, message: Importing 76 DataElements] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:36:47,408 [Level: INFO, category: METADATA_IMPORT, time: Fri Jan 31 17:36:47 CET 2014, message: Importing 2 DataElementGroups] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:36:47,418 [Level: INFO, category: METADATA_IMPORT, time: Fri Jan 31 17:36:47 CET 2014, message: Importing 1 DataElementGroupSets] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:36:47,424 [Level: INFO, category: METADATA_IMPORT, time: Fri Jan 31 17:36:47 CET 2014, message: Importing 4 DataSets] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:36:47,505 [Level: INFO, category: METADATA_IMPORT, time: Fri Jan 31 17:36:47 CET 2014, message: Importing 4 UserRoles] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:36:47,511 [Level: INFO, category: METADATA_IMPORT, time: Fri Jan 31 17:36:47 CET 2014, message: Importing 3 ReportTables] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:36:48,201 [Level: INFO, category: METADATA_IMPORT, time: Fri Jan 31 17:36:48 CET 2014, message: Importing 11 Charts] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:36:49,175 [Level: INFO, category: METADATA_IMPORT, time: Fri Jan 31 17:36:49 CET 2014, message: Importing 7 MapViews] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:36:49,216 [Level: INFO, category: METADATA_IMPORT, time: Fri Jan 31 17:36:49 CET 2014, message: Importing 4 Maps] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:36:49,227 [Level: INFO, category: METADATA_IMPORT, time: Fri Jan 31 17:36:49 CET 2014, message: Import done. Completed in 3,51 seconds.] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:37:13,561 'admin' update org.hisp.dhis.user.User, name: admin admin, uid: aCGdlXxwMWT (AuditLogUtil.java [18987457@qtp-11616363-6])
* INFO  17:37:13,563 'admin' update org.hisp.dhis.user.User, name: admin admin, uid: aCGdlXxwMWT (AuditLogUtil.java [18987457@qtp-11616363-6])
* INFO  17:38:17,368 [data element id scheme: UID, org unit id scheme: UID, dry run: false, async: false, strategy: NEW_AND_UPDATES, skip check: false] (ImportDataValueAction.java [18987457@qtp-11616363-6])
* INFO  17:38:17,411 [Level: INFO, category: DATAVALUE_IMPORT, time: Fri Jan 31 17:38:17 CET 2014, message: Process started] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:38:17,485 [Level: INFO, category: DATAVALUE_IMPORT, time: Fri Jan 31 17:38:17 CET 2014, message: Importing data values] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:38:17,486 importing data values (DefaultDataValueSetService.java [taskScheduler-1])
* INFO  17:38:17,974 'admin' create org.hisp.dhis.period.Period, name: 201112, uid: 201112 (AuditLogUtil.java [taskScheduler-1])
* INFO  17:38:17,986 'admin' create org.hisp.dhis.period.Period, name: 201107, uid: 201107 (AuditLogUtil.java [taskScheduler-1])
* INFO  17:38:18,012 'admin' create org.hisp.dhis.period.Period, name: 201108, uid: 201108 (AuditLogUtil.java [taskScheduler-1])
* INFO  17:38:18,021 'admin' create org.hisp.dhis.period.Period, name: 201111, uid: 201111 (AuditLogUtil.java [taskScheduler-1])
* INFO  17:38:18,031 'admin' create org.hisp.dhis.period.Period, name: 201110, uid: 201110 (AuditLogUtil.java [taskScheduler-1])
* INFO  17:38:18,240 [Level: INFO, category: DATAVALUE_IMPORT, time: Fri Jan 31 17:38:18 CET 2014, message: Import done] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:38:44,172 [Level: INFO, category: RESOURCETABLE_UPDATE, time: Fri Jan 31 17:38:44 CET 2014, message: Generating resource tables] (InMemoryNotifier.java [taskScheduler-2])
* INFO  17:38:44,183 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), "idlevel6" INTEGER, "uidlevel6" CHARACTER(11)); (JdbcResourceTableStore.java [taskScheduler-2])
* INFO  17:38:44,305 Organisation unit structure table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO  17:38:44,308 Create category option combo name table SQL: CREATE TABLE _categoryoptioncomboname ( categoryoptioncomboid INTEGER NOT NULL PRIMARY KEY, categoryoptioncomboname VARCHAR(250) ) (JdbcResourceTableStore.java [taskScheduler-2])
* INFO  17:38:44,321 Category option combo name table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO  17:38:44,367 Create data element group set table SQL: CREATE TABLE _dataelementgroupsetstructure ( dataelementid INTEGER NOT NULL, dataelementname VARCHAR (250), "Health Data Elements " VARCHAR (250), "mCaHnjHSgW0" CHARACTER(11), PRIMARY KEY ( dataelementid ) ) (CreateDataElementGroupSetTableStatement.java [taskScheduler-2])
* INFO  17:38:44,382 Data element group set table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO  17:38:44,388 Create indicator group set table SQL: CREATE TABLE _indicatorgroupsetstructure ( indicatorid INTEGER NOT NULL, indicatorname VARCHAR (250), PRIMARY KEY ( indicatorid ) ) (CreateIndicatorGroupSetTableStatement.java [taskScheduler-2])
* INFO  17:38:44,389 Indicator group set table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO  17:38:44,406 Create organisation unit group set table SQL: CREATE TABLE _organisationunitgroupsetstructure ( organisationunitid INTEGER NOT NULL, organisationunitname VARCHAR (250), "Ownership" VARCHAR (250), "xPpF0XXMxdT" CHARACTER(11), "Type" VARCHAR (250), "nLsuwTKm63F" CHARACTER(11), "Type of Health Facility" VARCHAR (250), "tzIlEDCf6Ke" CHARACTER(11), PRIMARY KEY ( organisationunitid ) ) (CreateOrganisationUnitGroupSetTableStatement.java [taskScheduler-2])
* INFO  17:38:44,429 Organisation unit group set table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO  17:38:44,436 Create category structure table SQL: CREATE TABLE _categorystructure ( categoryoptioncomboid INTEGER NOT NULL, categoryoptioncomboname VARCHAR (250), "Age groups under/over 5" VARCHAR (250), "g1FhSyJjgMf" CHARACTER(11), "default" VARCHAR (250), "fotp6ViKEQv" CHARACTER(11), PRIMARY KEY ( categoryoptioncomboid ) ) (CreateCategoryTableStatement.java [taskScheduler-2])
* INFO  17:38:44,444 Category table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO  17:38:44,460 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-2])
* INFO  17:38:44,504 Data element table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO  17:38:44,514 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-2])
* INFO  17:38:44,525 Date period table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO  17:38:44,526 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-2])
* INFO  17:38:52,728 Period table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO  17:38:52,731 Create data element category option combo SQL: CREATE TABLE _dataelementcategoryoptioncombo (dataelementuid VARCHAR(11) NOT NULL, categoryoptioncombouid VARCHAR(11) NOT NULL) (JdbcResourceTableStore.java [taskScheduler-2])
* INFO  17:38:52,732 Insert data element category option combo SQL: insert into _dataelementcategoryoptioncombo (dataelementuid, categoryoptioncombouid) select de.uid as dataelementuid, coc.uid as categoryoptioncombouid from dataelement de join categorycombos_optioncombos cc on de.categorycomboid = cc.categorycomboid join categoryoptioncombo coc on cc.categoryoptioncomboid = coc.categoryoptioncomboid (JdbcResourceTableStore.java [taskScheduler-2])
* INFO  17:38:52,738 Create data element category option combo index SQL: CREATE INDEX dataelement_categoryoptioncombo ON _dataelementcategoryoptioncombo (dataelementuid, categoryoptioncombouid) (JdbcResourceTableStore.java [taskScheduler-2])
* INFO  17:38:52,741 Data element category option combo table generated (DefaultResourceTableService.java [taskScheduler-2])
* INFO  17:38:52,743 [Level: INFO, category: RESOURCETABLE_UPDATE, time: Fri Jan 31 17:38:52 CET 2014, message: Resource tables generated] (InMemoryNotifier.java [taskScheduler-2])
* INFO  17:39:03,391 [Level: INFO, category: RESOURCETABLE_UPDATE, time: Fri Jan 31 17:39:03 CET 2014, message: Generating resource tables] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:39:03,401 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), "idlevel6" INTEGER, "uidlevel6" CHARACTER(11)); (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  17:39:03,421 Organisation unit structure table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  17:39:03,424 Create category option combo name table SQL: CREATE TABLE _categoryoptioncomboname ( categoryoptioncomboid INTEGER NOT NULL PRIMARY KEY, categoryoptioncomboname VARCHAR(250) ) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  17:39:03,429 Category option combo name table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  17:39:03,504 Create data element group set table SQL: CREATE TABLE _dataelementgroupsetstructure ( dataelementid INTEGER NOT NULL, dataelementname VARCHAR (250), "Health Data Elements " VARCHAR (250), "mCaHnjHSgW0" CHARACTER(11), PRIMARY KEY ( dataelementid ) ) (CreateDataElementGroupSetTableStatement.java [taskScheduler-1])
* INFO  17:39:03,508 Data element group set table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  17:39:03,514 Create indicator group set table SQL: CREATE TABLE _indicatorgroupsetstructure ( indicatorid INTEGER NOT NULL, indicatorname VARCHAR (250), PRIMARY KEY ( indicatorid ) ) (CreateIndicatorGroupSetTableStatement.java [taskScheduler-1])
* INFO  17:39:03,515 Indicator group set table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  17:39:03,528 Create organisation unit group set table SQL: CREATE TABLE _organisationunitgroupsetstructure ( organisationunitid INTEGER NOT NULL, organisationunitname VARCHAR (250), "Ownership" VARCHAR (250), "xPpF0XXMxdT" CHARACTER(11), "Type" VARCHAR (250), "nLsuwTKm63F" CHARACTER(11), "Type of Health Facility" VARCHAR (250), "tzIlEDCf6Ke" CHARACTER(11), PRIMARY KEY ( organisationunitid ) ) (CreateOrganisationUnitGroupSetTableStatement.java [taskScheduler-1])
* INFO  17:39:03,535 Organisation unit group set table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  17:39:03,540 Create category structure table SQL: CREATE TABLE _categorystructure ( categoryoptioncomboid INTEGER NOT NULL, categoryoptioncomboname VARCHAR (250), "Age groups under/over 5" VARCHAR (250), "g1FhSyJjgMf" CHARACTER(11), "default" VARCHAR (250), "fotp6ViKEQv" CHARACTER(11), PRIMARY KEY ( categoryoptioncomboid ) ) (CreateCategoryTableStatement.java [taskScheduler-1])
* INFO  17:39:03,543 Category table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  17:39:03,554 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  17:39:03,561 Data element table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  17:39:03,565 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  17:39:03,569 Date period table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  17:39:03,605 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  17:39:11,093 Period table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  17:39:11,096 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  17:39:11,097 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  17:39:11,102 Create data element category option combo index SQL: CREATE INDEX dataelement_categoryoptioncombo ON _dataelementcategoryoptioncombo (dataelementuid, categoryoptioncombouid) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  17:39:11,104 Data element category option combo table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  17:39:11,108 [Level: INFO, category: RESOURCETABLE_UPDATE, time: Fri Jan 31 17:39:11 CET 2014, message: Resource tables generated] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:39:11,109 [Level: INFO, category: DATAMART, time: Fri Jan 31 17:39:11 CET 2014, message: Updating resource tables] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:39:11,112 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), "idlevel6" INTEGER, "uidlevel6" CHARACTER(11)); (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  17:39:11,136 Organisation unit structure table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  17:39:11,140 Create category option combo name table SQL: CREATE TABLE _categoryoptioncomboname ( categoryoptioncomboid INTEGER NOT NULL PRIMARY KEY, categoryoptioncomboname VARCHAR(250) ) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  17:39:11,143 Category option combo name table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  17:39:11,167 Create data element group set table SQL: CREATE TABLE _dataelementgroupsetstructure ( dataelementid INTEGER NOT NULL, dataelementname VARCHAR (250), "Health Data Elements " VARCHAR (250), "mCaHnjHSgW0" CHARACTER(11), PRIMARY KEY ( dataelementid ) ) (CreateDataElementGroupSetTableStatement.java [taskScheduler-1])
* INFO  17:39:11,171 Data element group set table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  17:39:11,178 Create indicator group set table SQL: CREATE TABLE _indicatorgroupsetstructure ( indicatorid INTEGER NOT NULL, indicatorname VARCHAR (250), PRIMARY KEY ( indicatorid ) ) (CreateIndicatorGroupSetTableStatement.java [taskScheduler-1])
* INFO  17:39:11,179 Indicator group set table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  17:39:11,196 Create organisation unit group set table SQL: CREATE TABLE _organisationunitgroupsetstructure ( organisationunitid INTEGER NOT NULL, organisationunitname VARCHAR (250), "Ownership" VARCHAR (250), "xPpF0XXMxdT" CHARACTER(11), "Type" VARCHAR (250), "nLsuwTKm63F" CHARACTER(11), "Type of Health Facility" VARCHAR (250), "tzIlEDCf6Ke" CHARACTER(11), PRIMARY KEY ( organisationunitid ) ) (CreateOrganisationUnitGroupSetTableStatement.java [taskScheduler-1])
* INFO  17:39:11,205 Organisation unit group set table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  17:39:11,213 Create category structure table SQL: CREATE TABLE _categorystructure ( categoryoptioncomboid INTEGER NOT NULL, categoryoptioncomboname VARCHAR (250), "Age groups under/over 5" VARCHAR (250), "g1FhSyJjgMf" CHARACTER(11), "default" VARCHAR (250), "fotp6ViKEQv" CHARACTER(11), PRIMARY KEY ( categoryoptioncomboid ) ) (CreateCategoryTableStatement.java [taskScheduler-1])
* INFO  17:39:11,215 Category table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  17:39:11,229 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  17:39:11,236 Data element table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  17:39:11,240 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  17:39:11,244 Date period table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  17:39:11,260 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  17:39:15,480 Period table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  17:39:15,481 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  17:39:15,482 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  17:39:15,484 Create data element category option combo index SQL: CREATE INDEX dataelement_categoryoptioncombo ON _dataelementcategoryoptioncombo (dataelementuid, categoryoptioncombouid) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  17:39:15,484 Data element category option combo table generated (DefaultResourceTableService.java [taskScheduler-1])
* INFO  17:39:15,485 [Level: INFO, category: DATAMART, time: Fri Jan 31 17:39:15 CET 2014, message: Updating analytics tables] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:39:15,489 Starting update, no of processes: 3: 0:00:00.000 (Clock.java [taskScheduler-1])
* INFO  17:39:15,507 Get tables using earliest: 2011-01-01 00:00:00.0, latest: 2011-12-31 00:00:00.0 (AbstractJdbcTableManager.java [taskScheduler-1])
* INFO  17:39:15,521 Partition tables: [analytics_2011], last 3 years: false: 0:00:00.034 (Clock.java [taskScheduler-1])
* INFO  17:39:15,522 [Level: INFO, category: DATAMART, time: Fri Jan 31 17:39:15 CET 2014, message: Creating analytics tables] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:39:15,623 Create SQL: create table analytics_temp_2011 ("mCaHnjHSgW0" character(11),"tzIlEDCf6Ke" character(11),"xPpF0XXMxdT" character(11),"nLsuwTKm63F" character(11),"uidlevel1" character(11),"uidlevel2" character(11),"uidlevel3" character(11),"uidlevel4" character(11),"uidlevel5" character(11),"uidlevel6" 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 double, daysno integer not null, value double)  (JdbcAnalyticsTableManager.java [taskScheduler-1])
* INFO  17:39:15,624 Created analytics tables: 0:00:00.137 (Clock.java [taskScheduler-1])
* INFO  17:39:15,625 [Level: INFO, category: DATAMART, time: Fri Jan 31 17:39:15 CET 2014, message: Populating analytics tables] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:39:15,625 Populate table task number: 1 (DefaultAnalyticsTableService.java [taskScheduler-1])
* INFO  17:39:15,633 Populate SQL: insert into analytics_temp_2011 ("mCaHnjHSgW0","tzIlEDCf6Ke","xPpF0XXMxdT","nLsuwTKm63F","uidlevel1","uidlevel2","uidlevel3","uidlevel4","uidlevel5","uidlevel6","daily","weekly","monthly","bimonthly","quarterly","sixmonthly","yearly","financialapril","financialjuly","financialoct",de,co,level,daysxvalue, daysno, value) select degs."mCaHnjHSgW0",ougs."tzIlEDCf6Ke",ougs."xPpF0XXMxdT",ougs."nLsuwTKm63F",ous."uidlevel1",ous."uidlevel2",ous."uidlevel3",ous."uidlevel4",ous."uidlevel5",ous."uidlevel6",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 double) * ps.daysno as daysxvalue, ps.daysno as daysno, cast(dv.value as double) 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 >= '2011-01-01' and pe.startdate <= '2011-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  17:39:15,719 Populate SQL: insert into analytics_temp_2011 ("mCaHnjHSgW0","tzIlEDCf6Ke","xPpF0XXMxdT","nLsuwTKm63F","uidlevel1","uidlevel2","uidlevel3","uidlevel4","uidlevel5","uidlevel6","daily","weekly","monthly","bimonthly","quarterly","sixmonthly","yearly","financialapril","financialjuly","financialoct",de,co,level,daysxvalue, daysno, value) select degs."mCaHnjHSgW0",ougs."tzIlEDCf6Ke",ougs."xPpF0XXMxdT",ougs."nLsuwTKm63F",ous."uidlevel1",ous."uidlevel2",ous."uidlevel3",ous."uidlevel4",ous."uidlevel5",ous."uidlevel6",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 >= '2011-01-01' and pe.startdate <= '2011-12-31' and dv.value is not null and dv.value = 'true' (JdbcAnalyticsTableManager.java [SimpleAsyncTaskExecutor-1])
* INFO  17:39:15,726 Populate SQL: insert into analytics_temp_2011 ("mCaHnjHSgW0","tzIlEDCf6Ke","xPpF0XXMxdT","nLsuwTKm63F","uidlevel1","uidlevel2","uidlevel3","uidlevel4","uidlevel5","uidlevel6","daily","weekly","monthly","bimonthly","quarterly","sixmonthly","yearly","financialapril","financialjuly","financialoct",de,co,level,daysxvalue, daysno, value) select degs."mCaHnjHSgW0",ougs."tzIlEDCf6Ke",ougs."xPpF0XXMxdT",ougs."nLsuwTKm63F",ous."uidlevel1",ous."uidlevel2",ous."uidlevel3",ous."uidlevel4",ous."uidlevel5",ous."uidlevel6",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 >= '2011-01-01' and pe.startdate <= '2011-12-31' and dv.value is not null and dv.value = 'false' (JdbcAnalyticsTableManager.java [SimpleAsyncTaskExecutor-1])
* INFO  17:39:15,733 Populate SQL: insert into analytics_temp_2011 ("mCaHnjHSgW0","tzIlEDCf6Ke","xPpF0XXMxdT","nLsuwTKm63F","uidlevel1","uidlevel2","uidlevel3","uidlevel4","uidlevel5","uidlevel6","daily","weekly","monthly","bimonthly","quarterly","sixmonthly","yearly","financialapril","financialjuly","financialoct",de,co,level,daysxvalue, daysno, value) select degs."mCaHnjHSgW0",ougs."tzIlEDCf6Ke",ougs."xPpF0XXMxdT",ougs."nLsuwTKm63F",ous."uidlevel1",ous."uidlevel2",ous."uidlevel3",ous."uidlevel4",ous."uidlevel5",ous."uidlevel6",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 >= '2011-01-01' and pe.startdate <= '2011-12-31' and dv.value is not null and dv.value = 'true' (JdbcAnalyticsTableManager.java [SimpleAsyncTaskExecutor-1])
* INFO  17:39:15,734 Populated analytics tables: 0:00:00.247 (Clock.java [taskScheduler-1])
* INFO  17:39:15,734 [Level: INFO, category: DATAMART, time: Fri Jan 31 17:39:15 CET 2014, message: Pruned analytics tables] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:39:15,736 Pruned analytics tables: 0:00:00.249 (Clock.java [taskScheduler-1])
* INFO  17:39:15,736 [Level: INFO, category: DATAMART, time: Fri Jan 31 17:39:15 CET 2014, message: Applying aggregation levels] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:39:15,745 Applied aggregation levels: 0:00:00.258 (Clock.java [taskScheduler-1])
* INFO  17:39:15,745 [Level: INFO, category: DATAMART, time: Fri Jan 31 17:39:15 CET 2014, message: Creating indexes] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:39:15,746 No of indexes: 23 (DefaultAnalyticsTableService.java [taskScheduler-1])
* INFO  17:39:15,749 Created index: "in_mCaHnjHSgW0_analytics_temp_2011_B5GZllWdJ4h" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  17:39:15,754 Created index: "in_tzIlEDCf6Ke_analytics_temp_2011_rwva26AtKnx" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-5])
* INFO  17:39:15,756 Created index: "in_xPpF0XXMxdT_analytics_temp_2011_hKq4dkP1tYi" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-6])
* INFO  17:39:15,759 Created index: "in_uidlevel1_analytics_temp_2011_N9pz2tx4HCf" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-5])
* INFO  17:39:15,761 Created index: "in_nLsuwTKm63F_analytics_temp_2011_jT1lTGj6JJ1" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  17:39:15,763 Created index: "in_uidlevel3_analytics_temp_2011_NEXds5yJLTn" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-5])
* INFO  17:39:15,766 Created index: "in_uidlevel2_analytics_temp_2011_XczrQy1BN8I" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-6])
* INFO  17:39:15,767 Created index: "in_uidlevel5_analytics_temp_2011_nM9XPk5cKPP" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-5])
* INFO  17:39:15,770 Created index: "in_uidlevel4_analytics_temp_2011_VETBprDktSm" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  17:39:15,772 Created index: "in_daily_analytics_temp_2011_idFwUzsL46M" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-5])
* INFO  17:39:15,775 Created index: "in_uidlevel6_analytics_temp_2011_IeWuSnhTCkS" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-6])
* INFO  17:39:15,777 Created index: "in_monthly_analytics_temp_2011_Wh7gmdNlXLb" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-5])
* INFO  17:39:15,779 Created index: "in_weekly_analytics_temp_2011_AwtV3FyXyaP" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  17:39:15,782 Created index: "in_quarterly_analytics_temp_2011_K5gwUr0IBvJ" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-5])
* INFO  17:39:15,784 Created index: "in_bimonthly_analytics_temp_2011_E7p7z5sZByi" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-6])
* INFO  17:39:15,786 Created index: "in_yearly_analytics_temp_2011_yl0OZX4a4o1" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-5])
* INFO  17:39:15,789 Created index: "in_sixmonthly_analytics_temp_2011_ZBMlE8H4dcm" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  17:39:15,791 Created index: "in_financialjuly_analytics_temp_2011_urXOgSXrbP1" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-5])
* INFO  17:39:15,794 Created index: "in_financialapril_analytics_temp_2011_LbXRFOlWf3L" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-6])
* INFO  17:39:15,798 Created index: "in_de_analytics_temp_2011_HFBjIV6ZIgg" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-5])
* INFO  17:39:15,800 Created index: "in_financialoct_analytics_temp_2011_Owh2hiqHgSh" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-4])
* INFO  17:39:15,803 Created index: "in_level_analytics_temp_2011_mFdatsIt1gC" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-5])
* INFO  17:39:15,805 Created index: "in_co_analytics_temp_2011_XQQvu2VblDN" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-6])
* INFO  17:39:15,805 Created indexes: 0:00:00.318 (Clock.java [taskScheduler-1])
* INFO  17:39:15,805 [Level: INFO, category: DATAMART, time: Fri Jan 31 17:39:15 CET 2014, message: Vacuuming tables] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:39:15,806 Vacuum SQL: null (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-7])
* INFO  17:39:15,806 Vacuumed tables: 0:00:00.319 (Clock.java [taskScheduler-1])
* INFO  17:39:15,807 [Level: INFO, category: DATAMART, time: Fri Jan 31 17:39:15 CET 2014, message: Swapping analytics tables] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:39:15,809 Table update done: 0:00:00.322 (Clock.java [taskScheduler-1])
* INFO  17:39:15,809 [Level: INFO, category: DATAMART, time: Fri Jan 31 17:39:15 CET 2014, message: Table update done] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:39:15,809 [Level: INFO, category: DATAMART, time: Fri Jan 31 17:39:15 CET 2014, message: Updating completeness tables] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:39:15,810 Starting update, no of processes: 3: 0:00:00.000 (Clock.java [taskScheduler-1])
* INFO  17:39:15,810 [Level: INFO, category: DATAMART, time: Fri Jan 31 17:39:15 CET 2014, message: Table not valid, aborted update] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:39:15,810 [Level: INFO, category: DATAMART, time: Fri Jan 31 17:39:15 CET 2014, message: Updating compeleteness target table] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:39:15,811 Starting update, no of processes: 3: 0:00:00.000 (Clock.java [taskScheduler-1])
* INFO  17:39:15,825 Partition tables: [completenesstarget], last 3 years: false: 0:00:00.014 (Clock.java [taskScheduler-1])
* INFO  17:39:15,825 [Level: INFO, category: DATAMART, time: Fri Jan 31 17:39:15 CET 2014, message: Creating analytics tables] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:39:15,829 Create SQL: create table completenesstarget_temp ("tzIlEDCf6Ke" character(11),"xPpF0XXMxdT" character(11),"nLsuwTKm63F" character(11),"uidlevel1" character(11),"uidlevel2" character(11),"uidlevel3" character(11),"uidlevel4" character(11),"uidlevel5" character(11),"uidlevel6" character(11),ds character(11) not null,value double precision)  (JdbcCompletenessTargetTableManager.java [taskScheduler-1])
* INFO  17:39:15,829 Created analytics tables: 0:00:00.018 (Clock.java [taskScheduler-1])
* INFO  17:39:15,829 [Level: INFO, category: DATAMART, time: Fri Jan 31 17:39:15 CET 2014, message: Populating analytics tables] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:39:15,830 Populate table task number: 1 (DefaultAnalyticsTableService.java [taskScheduler-1])
* INFO  17:39:15,834 Populate SQL: insert into completenesstarget_temp ("tzIlEDCf6Ke","xPpF0XXMxdT","nLsuwTKm63F","uidlevel1","uidlevel2","uidlevel3","uidlevel4","uidlevel5","uidlevel6",ds,value) select ougs."tzIlEDCf6Ke",ougs."xPpF0XXMxdT",ougs."nLsuwTKm63F",ous."uidlevel1",ous."uidlevel2",ous."uidlevel3",ous."uidlevel4",ous."uidlevel5",ous."uidlevel6",ds.uid,1 as value from datasetsource dss left join dataset ds on dss.datasetid=ds.datasetid left join _orgunitstructure ous on dss.sourceid=ous.organisationunitid left join _organisationunitgroupsetstructure ougs on dss.sourceid=ougs.organisationunitid (JdbcCompletenessTargetTableManager.java [SimpleAsyncTaskExecutor-10])
* INFO  17:39:15,836 Populated analytics tables: 0:00:00.025 (Clock.java [taskScheduler-1])
* INFO  17:39:15,836 [Level: INFO, category: DATAMART, time: Fri Jan 31 17:39:15 CET 2014, message: Pruned analytics tables] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:39:15,837 Pruned analytics tables: 0:00:00.026 (Clock.java [taskScheduler-1])
* INFO  17:39:15,837 [Level: INFO, category: DATAMART, time: Fri Jan 31 17:39:15 CET 2014, message: Applying aggregation levels] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:39:15,841 Applied aggregation levels: 0:00:00.030 (Clock.java [taskScheduler-1])
* INFO  17:39:15,842 [Level: INFO, category: DATAMART, time: Fri Jan 31 17:39:15 CET 2014, message: Creating indexes] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:39:15,842 No of indexes: 10 (DefaultAnalyticsTableService.java [taskScheduler-1])
* INFO  17:39:15,844 Created index: "in_tzIlEDCf6Ke_completenesstarget_temp_shjaGWze7AN" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-13])
* INFO  17:39:15,845 Created index: "in_xPpF0XXMxdT_completenesstarget_temp_o7ithBJPjjv" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-15])
* INFO  17:39:15,845 Created index: "in_nLsuwTKm63F_completenesstarget_temp_jHQSU2tcEmP" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-14])
* INFO  17:39:15,846 Created index: "in_uidlevel1_completenesstarget_temp_vPI8YafH4Ed" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-13])
* INFO  17:39:15,846 Created index: "in_uidlevel2_completenesstarget_temp_raSb6Cazydb" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-15])
* INFO  17:39:15,846 Created index: "in_uidlevel3_completenesstarget_temp_rCu9J1fAmgW" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-14])
* INFO  17:39:15,846 Created index: "in_uidlevel5_completenesstarget_temp_kgDkawUH0DH" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-15])
* INFO  17:39:15,847 Created index: "in_uidlevel6_completenesstarget_temp_kjJ0rHEwPCN" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-14])
* INFO  17:39:15,847 Created index: "in_ds_completenesstarget_temp_LWfqosAXn1x" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-15])
* INFO  17:39:15,847 Created index: "in_uidlevel4_completenesstarget_temp_uu0mdMKRraG" (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-13])
* INFO  17:39:15,848 Created indexes: 0:00:00.037 (Clock.java [taskScheduler-1])
* INFO  17:39:15,848 [Level: INFO, category: DATAMART, time: Fri Jan 31 17:39:15 CET 2014, message: Vacuuming tables] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:39:15,849 Vacuum SQL: null (AbstractJdbcTableManager.java [SimpleAsyncTaskExecutor-16])
* INFO  17:39:15,849 Vacuumed tables: 0:00:00.038 (Clock.java [taskScheduler-1])
* INFO  17:39:15,849 [Level: INFO, category: DATAMART, time: Fri Jan 31 17:39:15 CET 2014, message: Swapping analytics tables] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:39:15,851 Table update done: 0:00:00.040 (Clock.java [taskScheduler-1])
* INFO  17:39:15,851 [Level: INFO, category: DATAMART, time: Fri Jan 31 17:39:15 CET 2014, message: Table update done] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:39:15,851 [Level: INFO, category: DATAMART, time: Fri Jan 31 17:39:15 CET 2014, message: Updating event analytics tables] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:39:15,852 Starting update, no of processes: 3: 0:00:00.000 (Clock.java [taskScheduler-1])
* INFO  17:39:15,852 [Level: INFO, category: DATAMART, time: Fri Jan 31 17:39:15 CET 2014, message: Table not valid, aborted update] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:39:15,852 [Level: INFO, category: DATAMART, time: Fri Jan 31 17:39:15 CET 2014, message: Analytics tables updated] (InMemoryNotifier.java [taskScheduler-1])
* INFO  17:40:13,239 Time: 9277 micros: Planned query, got: 1 for optimal: 4 (Timer.java [13411251@qtp-11616363-13])
* INFO  17:40:13,258 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-19])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "de","monthly", sum(value) as value from analytics_2011 where "de" in ('gUvSpUrTCCH') and "monthly" in ('201101', '201102', '201103', '201104', '201105', '201106') and ("uidlevel6" in ('BkRAoHaejFd')) group by "de","monthly"]; nested exception is org.h2.jdbc.JdbcSQLException: Column "de" not found; SQL statement:
select "de","monthly", sum(value) as value from analytics_2011 where "de" in ('gUvSpUrTCCH') and "monthly" in ('201101', '201102', '201103', '201104', '201105', '201106') and ("uidlevel6" in ('BkRAoHaejFd')) group by "de","monthly" [42122-173]
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:237)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
	at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:501)
	at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:315)
	at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:127)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:95)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: org.h2.jdbc.JdbcSQLException: Column "de" not found; SQL statement:
select "de","monthly", sum(value) as value from analytics_2011 where "de" in ('gUvSpUrTCCH') and "monthly" in ('201101', '201102', '201103', '201104', '201105', '201106') and ("uidlevel6" in ('BkRAoHaejFd')) group by "de","monthly" [42122-173]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:331)
	at org.h2.message.DbException.get(DbException.java:171)
	at org.h2.message.DbException.get(DbException.java:148)
	at org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:144)
	at org.h2.command.dml.Select.prepare(Select.java:808)
	at org.h2.command.Parser.prepareCommand(Parser.java:219)
	at org.h2.engine.Session.prepareLocal(Session.java:428)
	at org.h2.engine.Session.prepareCommand(Session.java:377)
	at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1138)
	at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:72)
	at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
	at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
	... 14 more
* INFO  17:40:13,262 Time: 32128 micros: Got aggregated values for query group (Timer.java [13411251@qtp-11616363-13])
* INFO  17:40:13,263 Time: 33116 micros: Got aggregated values (Timer.java [13411251@qtp-11616363-13])
* INFO  17:40:31,983 Time: 2324 micros: Planned query, got: 1 for optimal: 4 (Timer.java [13411251@qtp-11616363-13])
* INFO  17:40:31,989 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-20])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "de","monthly", sum(value) as value from analytics_2011 where "de" in ('gUvSpUrTCCH') and "monthly" in ('201101', '201102', '201103', '201104', '201105', '201106') and ("uidlevel5" in ('f1DjXJZyF5z')) group by "de","monthly"]; nested exception is org.h2.jdbc.JdbcSQLException: Column "de" not found; SQL statement:
select "de","monthly", sum(value) as value from analytics_2011 where "de" in ('gUvSpUrTCCH') and "monthly" in ('201101', '201102', '201103', '201104', '201105', '201106') and ("uidlevel5" in ('f1DjXJZyF5z')) group by "de","monthly" [42122-173]
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:237)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
	at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:501)
	at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:315)
	at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:127)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:95)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: org.h2.jdbc.JdbcSQLException: Column "de" not found; SQL statement:
select "de","monthly", sum(value) as value from analytics_2011 where "de" in ('gUvSpUrTCCH') and "monthly" in ('201101', '201102', '201103', '201104', '201105', '201106') and ("uidlevel5" in ('f1DjXJZyF5z')) group by "de","monthly" [42122-173]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:331)
	at org.h2.message.DbException.get(DbException.java:171)
	at org.h2.message.DbException.get(DbException.java:148)
	at org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:144)
	at org.h2.command.dml.Select.prepare(Select.java:808)
	at org.h2.command.Parser.prepareCommand(Parser.java:219)
	at org.h2.engine.Session.prepareLocal(Session.java:428)
	at org.h2.engine.Session.prepareCommand(Session.java:377)
	at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1138)
	at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:72)
	at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
	at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
	... 14 more
* INFO  17:40:31,990 Time: 9407 micros: Got aggregated values for query group (Timer.java [13411251@qtp-11616363-13])
* INFO  17:40:31,991 Time: 10256 micros: Got aggregated values (Timer.java [13411251@qtp-11616363-13])
* INFO  17:40:53,783 Graceful shutdown... (TrayApp.java [AWT-EventQueue-0])
* INFO  17:40:53,784 Lifecycle: server stopping (TrayApp.java [AWT-EventQueue-0])
* INFO  17:40:53,859 De-registering jdbc driver: sun.jdbc.odbc.JdbcOdbcDriver@13abfd5 (StartupListener.java [AWT-EventQueue-0])
* INFO  17:40:53,860 De-registering jdbc driver: org.hsqldb.jdbc.JDBCDriver@e95eab (StartupListener.java [AWT-EventQueue-0])
* INFO  17:40:53,860 De-registering jdbc driver: com.mysql.jdbc.Driver@1557b72 (StartupListener.java [AWT-EventQueue-0])
* INFO  17:40:53,861 De-registering jdbc driver: org.postgresql.Driver@13f74c9 (StartupListener.java [AWT-EventQueue-0])
* INFO  17:40:53,861 De-registering jdbc driver: org.h2.Driver@10c4d47 (StartupListener.java [AWT-EventQueue-0])
* INFO  17:40:54,089 Lifecycle: server stopped (TrayApp.java [AWT-EventQueue-0])
* INFO  17:40:54,140 Exiting... (TrayApp.java [AWT-EventQueue-0])
* INFO  17:32:21,391 Environment variable DHIS2_HOME: D:\dhis (TrayApp.java [main])
* INFO  17:32:21,736 Initialising DHIS 2 Live... (TrayApp.java [main])
* INFO  17:32:22,475 Loading DHIS 2 on port: 8082 (WebAppServer.java [main])
* INFO  17:32:22,707 Setting DHIS 2 web app context to: /C:/Live 31 enero - new/webapps/dhis (WebAppServer.java [main])
* INFO  17:32:22,708 Lifecycle: server starting (TrayApp.java [Thread-2])
* INFO  17:32:38,866 System property dhis2.home points to /C:/Live 31 enero - new/conf (DefaultLocationManager.java [Thread-2])
* INFO  17:32:40,277 Hibernate configuration loaded, using dialect: org.hibernate.dialect.H2Dialect (DefaultHibernateConfigurationProvider.java [Thread-2])
* INFO  17:33:13,454 Found the following message senders: [org.hisp.dhis.message.EmailMessageSender@11b9a42, org.hisp.dhis.sms.SmsMessageSender@12c7823] (DefaultMessageService.java [Thread-2])
* INFO  17:33:22,496 Detected apps: [] (DefaultAppManager.java [Thread-2])
* INFO  17:33:28,708 Executing startup routine [1 of 11, runlevel 1]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO  17:33:28,758 Executing startup routine [2 of 11, runlevel 1]: DataElementDefaultDimensionPopulator (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO  17:33:28,952 Linked default category with default concept (DataElementDefaultDimensionPopulator.java [Thread-2])
* INFO  17:33:29,046 Executing startup routine [3 of 11, runlevel 2]: TableAlteror (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO  17:33:29,279 Data value table upgraded with attributeoptioncomboid column (TableAlteror.java [Thread-2])
* INFO  17:33:29,286 Tables updated (TableAlteror.java [Thread-2])
* INFO  17:33:29,287 Executing startup routine [4 of 11, runlevel 3]: IdentityPopulator (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO  17:33:29,523 Executing startup routine [5 of 11, runlevel 3]: TableCreator (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO  17:33:29,528 Executing startup routine [6 of 11, runlevel 4]: PatientTableAlteror (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO  17:33:29,667 Inserted data into program_attributes table. (TableAlteror.java [Thread-2])
* INFO  17:33:29,668 Inserted data into program_identifiertypes table. (TableAlteror.java [Thread-2])
* INFO  17:33:29,670 Dropped program_patientattributes table. (TableAlteror.java [Thread-2])
* INFO  17:33:29,670 Dropped program_patientidentifiertypes table. (TableAlteror.java [Thread-2])
* INFO  17:33:29,671 Executing startup routine [7 of 11, runlevel 4]: MapViewUpgrader (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO  17:33:29,678 Executing startup routine [8 of 11, runlevel 5]: DataEntryFormUpgrader (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO  17:33:29,686 Upgraded custom case entry form identifiers (DataEntryFormUpgrader.java [Thread-2])
* INFO  17:33:29,687 Executing startup routine [9 of 11, runlevel 6]: ExpressionUpgrader (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO  17:33:29,709 Executing startup routine [10 of 11, runlevel 7]: ConfigurationPopulator (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO  17:33:29,712 Executing startup routine [11 of 11, runlevel 7]: I18nLocalePopulator (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO  17:33:29,720 All startup routines done (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO  17:33:44,036 Lifecycle: server started (TrayApp.java [Thread-2])
* INFO  17:34:32,293 Login success for user: 'admin', ip: '0:0:0:0:0:0:0:1' (DefaultUserAuditService.java [21106666@qtp-18737428-0])
* INFO  17:35:18,891 Drop view SQL: DROP VIEW IF EXISTS "_view1391445318889" (JdbcSqlViewExpandStore.java [30071687@qtp-18737428-4])
* INFO  17:35:19,130 'admin' create org.hisp.dhis.sqlview.SqlView, name: Analitycs, uid: KzkUrzm0xu8 (AuditLogUtil.java [30071687@qtp-18737428-4])
* INFO  17:35:22,325 Drop view SQL: DROP VIEW IF EXISTS "_view_analitycs" (JdbcSqlViewExpandStore.java [19296999@qtp-18737428-3])
* INFO  17:35:25,689 Get view SQL: SELECT * FROM "_view_analitycs" (JdbcSqlViewExpandStore.java [16669943@qtp-18737428-5])
* INFO  17:38:00,912 Drop view SQL: DROP VIEW IF EXISTS "_view1391445480910" (JdbcSqlViewExpandStore.java [15765378@qtp-18737428-10])
* INFO  17:38:01,014 'admin' create org.hisp.dhis.sqlview.SqlView, name: data elements in analytics, uid: vYSupyafcpi (AuditLogUtil.java [15765378@qtp-18737428-10])
* INFO  17:38:04,108 Drop view SQL: DROP VIEW IF EXISTS "_view_data_elements_in_analytics" (JdbcSqlViewExpandStore.java [2489665@qtp-18737428-9])
* INFO  17:38:06,611 Get view SQL: SELECT * FROM "_view_data_elements_in_analytics" (JdbcSqlViewExpandStore.java [2489665@qtp-18737428-9])
* INFO  17:39:04,454 Time: 30351 micros: Planned query, got: 1 for optimal: 4 (Timer.java [30071687@qtp-18737428-4])
* INFO  17:39:04,469 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-1])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "de","monthly", sum(value) as value from analytics_2011 where "de" in ('gUvSpUrTCCH') and "monthly" in ('201101', '201102', '201103', '201104', '201105', '201106') and ("uidlevel6" in ('BkRAoHaejFd')) group by "de","monthly"]; nested exception is org.h2.jdbc.JdbcSQLException: Column "de" not found; SQL statement:
select "de","monthly", sum(value) as value from analytics_2011 where "de" in ('gUvSpUrTCCH') and "monthly" in ('201101', '201102', '201103', '201104', '201105', '201106') and ("uidlevel6" in ('BkRAoHaejFd')) group by "de","monthly" [42122-173]
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:237)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
	at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:501)
	at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:315)
	at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:127)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:95)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: org.h2.jdbc.JdbcSQLException: Column "de" not found; SQL statement:
select "de","monthly", sum(value) as value from analytics_2011 where "de" in ('gUvSpUrTCCH') and "monthly" in ('201101', '201102', '201103', '201104', '201105', '201106') and ("uidlevel6" in ('BkRAoHaejFd')) group by "de","monthly" [42122-173]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:331)
	at org.h2.message.DbException.get(DbException.java:171)
	at org.h2.message.DbException.get(DbException.java:148)
	at org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:144)
	at org.h2.command.dml.Select.prepare(Select.java:808)
	at org.h2.command.Parser.prepareCommand(Parser.java:219)
	at org.h2.engine.Session.prepareLocal(Session.java:428)
	at org.h2.engine.Session.prepareCommand(Session.java:377)
	at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1138)
	at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:72)
	at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
	at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
	... 14 more
* INFO  17:39:04,472 Time: 48534 micros: Got aggregated values for query group (Timer.java [30071687@qtp-18737428-4])
* INFO  17:39:04,473 Time: 49577 micros: Got aggregated values (Timer.java [30071687@qtp-18737428-4])
* INFO  17:41:30,194 Time: 5012 micros: Planned query, got: 1 for optimal: 4 (Timer.java [20546640@qtp-18737428-13])
* INFO  17:41:30,202 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-2])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "de","monthly", sum(value) as value from analytics_2011 where "de" in ('gUvSpUrTCCH') and "monthly" in ('201101', '201102', '201103', '201104', '201105', '201106') and ("uidlevel1" in ('t6lBye6jkqg')) group by "de","monthly"]; nested exception is org.h2.jdbc.JdbcSQLException: Column "de" not found; SQL statement:
select "de","monthly", sum(value) as value from analytics_2011 where "de" in ('gUvSpUrTCCH') and "monthly" in ('201101', '201102', '201103', '201104', '201105', '201106') and ("uidlevel1" in ('t6lBye6jkqg')) group by "de","monthly" [42122-173]
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:237)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
	at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:501)
	at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:315)
	at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:127)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:95)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: org.h2.jdbc.JdbcSQLException: Column "de" not found; SQL statement:
select "de","monthly", sum(value) as value from analytics_2011 where "de" in ('gUvSpUrTCCH') and "monthly" in ('201101', '201102', '201103', '201104', '201105', '201106') and ("uidlevel1" in ('t6lBye6jkqg')) group by "de","monthly" [42122-173]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:331)
	at org.h2.message.DbException.get(DbException.java:171)
	at org.h2.message.DbException.get(DbException.java:148)
	at org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:144)
	at org.h2.command.dml.Select.prepare(Select.java:808)
	at org.h2.command.Parser.prepareCommand(Parser.java:219)
	at org.h2.engine.Session.prepareLocal(Session.java:428)
	at org.h2.engine.Session.prepareCommand(Session.java:377)
	at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1138)
	at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:72)
	at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
	at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
	... 14 more
* INFO  17:41:30,204 Time: 15606 micros: Got aggregated values for query group (Timer.java [20546640@qtp-18737428-13])
* INFO  17:41:30,206 Time: 17131 micros: Got aggregated values (Timer.java [20546640@qtp-18737428-13])
* INFO  17:44:06,325 Time: 111511 micros: Planned query, got: 3 for optimal: 4 (Timer.java [13211848@qtp-18737428-14])
* INFO  17:44:06,338 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-4])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "de","monthly", sum(value) as value from analytics_2014 where "de" in ('gUvSpUrTCCH') and "monthly" in ('201401') and ("uidlevel6" in ('BkRAoHaejFd')) group by "de","monthly"]; nested exception is org.h2.jdbc.JdbcSQLException: Table "ANALYTICS_2014" not found; SQL statement:
select "de","monthly", sum(value) as value from analytics_2014 where "de" in ('gUvSpUrTCCH') and "monthly" in ('201401') and ("uidlevel6" in ('BkRAoHaejFd')) group by "de","monthly" [42102-173]
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:237)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
	at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:501)
	at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:315)
	at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:127)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:95)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: org.h2.jdbc.JdbcSQLException: Table "ANALYTICS_2014" not found; SQL statement:
select "de","monthly", sum(value) as value from analytics_2014 where "de" in ('gUvSpUrTCCH') and "monthly" in ('201401') and ("uidlevel6" in ('BkRAoHaejFd')) group by "de","monthly" [42102-173]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:331)
	at org.h2.message.DbException.get(DbException.java:171)
	at org.h2.message.DbException.get(DbException.java:148)
	at org.h2.command.Parser.readTableOrView(Parser.java:4864)
	at org.h2.command.Parser.readTableFilter(Parser.java:1107)
	at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1713)
	at org.h2.command.Parser.parseSelectSimple(Parser.java:1821)
	at org.h2.command.Parser.parseSelectSub(Parser.java:1707)
	at org.h2.command.Parser.parseSelectUnion(Parser.java:1550)
	at org.h2.command.Parser.parseSelect(Parser.java:1538)
	at org.h2.command.Parser.parsePrepared(Parser.java:405)
	at org.h2.command.Parser.parse(Parser.java:279)
	at org.h2.command.Parser.parse(Parser.java:251)
	at org.h2.command.Parser.prepareCommand(Parser.java:218)
	at org.h2.engine.Session.prepareLocal(Session.java:428)
	at org.h2.engine.Session.prepareCommand(Session.java:377)
	at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1138)
	at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:72)
	at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
	at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
	... 14 more
* INFO  17:44:06,349 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-5])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "de","monthly", sum(value) as value from analytics_2011 where "de" in ('gUvSpUrTCCH') and "monthly" in ('201101', '201102', '201103', '201104', '201105', '201106') and ("uidlevel6" in ('BkRAoHaejFd')) group by "de","monthly"]; nested exception is org.h2.jdbc.JdbcSQLException: Column "de" not found; SQL statement:
select "de","monthly", sum(value) as value from analytics_2011 where "de" in ('gUvSpUrTCCH') and "monthly" in ('201101', '201102', '201103', '201104', '201105', '201106') and ("uidlevel6" in ('BkRAoHaejFd')) group by "de","monthly" [42122-173]
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:237)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
	at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:501)
	at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:315)
	at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:127)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:95)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: org.h2.jdbc.JdbcSQLException: Column "de" not found; SQL statement:
select "de","monthly", sum(value) as value from analytics_2011 where "de" in ('gUvSpUrTCCH') and "monthly" in ('201101', '201102', '201103', '201104', '201105', '201106') and ("uidlevel6" in ('BkRAoHaejFd')) group by "de","monthly" [42122-173]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:331)
	at org.h2.message.DbException.get(DbException.java:171)
	at org.h2.message.DbException.get(DbException.java:148)
	at org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:144)
	at org.h2.command.dml.Select.prepare(Select.java:808)
	at org.h2.command.Parser.prepareCommand(Parser.java:219)
	at org.h2.engine.Session.prepareLocal(Session.java:428)
	at org.h2.engine.Session.prepareCommand(Session.java:377)
	at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1138)
	at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:72)
	at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
	at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
	... 14 more
* INFO  17:44:06,353 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-3])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "de","monthly", sum(value) as value from analytics_2013 where "de" in ('gUvSpUrTCCH') and "monthly" in ('201302', '201303', '201304', '201305', '201306', '201307', '201308', '201309', '201310', '201311', '201312') and ("uidlevel6" in ('BkRAoHaejFd')) group by "de","monthly"]; nested exception is org.h2.jdbc.JdbcSQLException: Table "ANALYTICS_2013" not found; SQL statement:
select "de","monthly", sum(value) as value from analytics_2013 where "de" in ('gUvSpUrTCCH') and "monthly" in ('201302', '201303', '201304', '201305', '201306', '201307', '201308', '201309', '201310', '201311', '201312') and ("uidlevel6" in ('BkRAoHaejFd')) group by "de","monthly" [42102-173]
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:237)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
	at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:501)
	at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:315)
	at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:127)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:95)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: org.h2.jdbc.JdbcSQLException: Table "ANALYTICS_2013" not found; SQL statement:
select "de","monthly", sum(value) as value from analytics_2013 where "de" in ('gUvSpUrTCCH') and "monthly" in ('201302', '201303', '201304', '201305', '201306', '201307', '201308', '201309', '201310', '201311', '201312') and ("uidlevel6" in ('BkRAoHaejFd')) group by "de","monthly" [42102-173]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:331)
	at org.h2.message.DbException.get(DbException.java:171)
	at org.h2.message.DbException.get(DbException.java:148)
	at org.h2.command.Parser.readTableOrView(Parser.java:4864)
	at org.h2.command.Parser.readTableFilter(Parser.java:1107)
	at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1713)
	at org.h2.command.Parser.parseSelectSimple(Parser.java:1821)
	at org.h2.command.Parser.parseSelectSub(Parser.java:1707)
	at org.h2.command.Parser.parseSelectUnion(Parser.java:1550)
	at org.h2.command.Parser.parseSelect(Parser.java:1538)
	at org.h2.command.Parser.parsePrepared(Parser.java:405)
	at org.h2.command.Parser.parse(Parser.java:279)
	at org.h2.command.Parser.parse(Parser.java:251)
	at org.h2.command.Parser.prepareCommand(Parser.java:218)
	at org.h2.engine.Session.prepareLocal(Session.java:428)
	at org.h2.engine.Session.prepareCommand(Session.java:377)
	at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1138)
	at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:72)
	at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
	at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
	... 14 more
* INFO  17:44:06,356 Time: 142389 micros: Got aggregated values for query group (Timer.java [13211848@qtp-18737428-14])
* INFO  17:44:06,357 Time: 143758 micros: Got aggregated values (Timer.java [13211848@qtp-18737428-14])
* INFO  17:45:29,240 Time: 1426 micros: Planned query, got: 4 for optimal: 4 (Timer.java [13211848@qtp-18737428-14])
* INFO  17:45:29,246 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-7])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "uidlevel4","de", sum(value) as value from analytics_2011 where "uidlevel4" in ('zXcr52pysDR', 'dOfLwJp4HCR', 'ZZ2j0yKuZu8', 'xTki3rdk7cd', 'Y5pHHOo6Omn') and "de" in ('gUvSpUrTCCH') and ("yearly" in ('2011')) group by "uidlevel4","de"]; nested exception is org.h2.jdbc.JdbcSQLException: Column "de" not found; SQL statement:
select "uidlevel4","de", sum(value) as value from analytics_2011 where "uidlevel4" in ('zXcr52pysDR', 'dOfLwJp4HCR', 'ZZ2j0yKuZu8', 'xTki3rdk7cd', 'Y5pHHOo6Omn') and "de" in ('gUvSpUrTCCH') and ("yearly" in ('2011')) group by "uidlevel4","de" [42122-173]
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:237)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
	at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:501)
	at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:315)
	at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:127)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:95)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: org.h2.jdbc.JdbcSQLException: Column "de" not found; SQL statement:
select "uidlevel4","de", sum(value) as value from analytics_2011 where "uidlevel4" in ('zXcr52pysDR', 'dOfLwJp4HCR', 'ZZ2j0yKuZu8', 'xTki3rdk7cd', 'Y5pHHOo6Omn') and "de" in ('gUvSpUrTCCH') and ("yearly" in ('2011')) group by "uidlevel4","de" [42122-173]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:331)
	at org.h2.message.DbException.get(DbException.java:171)
	at org.h2.message.DbException.get(DbException.java:148)
	at org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:144)
	at org.h2.command.dml.Select.prepare(Select.java:808)
	at org.h2.command.Parser.prepareCommand(Parser.java:219)
	at org.h2.engine.Session.prepareLocal(Session.java:428)
	at org.h2.engine.Session.prepareCommand(Session.java:377)
	at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1138)
	at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:72)
	at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
	at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
	... 14 more
* INFO  17:45:29,247 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-9])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "uidlevel4","de", sum(value) as value from analytics_2011 where "uidlevel4" in ('RTDN8Yte0jQ', 'cKbG35hbHwC') and "de" in ('gUvSpUrTCCH') and ("yearly" in ('2011')) group by "uidlevel4","de"]; nested exception is org.h2.jdbc.JdbcSQLException: Column "de" not found; SQL statement:
select "uidlevel4","de", sum(value) as value from analytics_2011 where "uidlevel4" in ('RTDN8Yte0jQ', 'cKbG35hbHwC') and "de" in ('gUvSpUrTCCH') and ("yearly" in ('2011')) group by "uidlevel4","de" [42122-173]
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:237)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
	at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:501)
	at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:315)
	at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:127)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:95)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: org.h2.jdbc.JdbcSQLException: Column "de" not found; SQL statement:
select "uidlevel4","de", sum(value) as value from analytics_2011 where "uidlevel4" in ('RTDN8Yte0jQ', 'cKbG35hbHwC') and "de" in ('gUvSpUrTCCH') and ("yearly" in ('2011')) group by "uidlevel4","de" [42122-173]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:331)
	at org.h2.message.DbException.get(DbException.java:171)
	at org.h2.message.DbException.get(DbException.java:148)
	at org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:144)
	at org.h2.command.dml.Select.prepare(Select.java:808)
	at org.h2.command.Parser.prepareCommand(Parser.java:219)
	at org.h2.engine.Session.prepareLocal(Session.java:428)
	at org.h2.engine.Session.prepareCommand(Session.java:377)
	at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1138)
	at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:72)
	at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
	at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
	... 14 more
* INFO  17:45:29,247 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-8])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "uidlevel4","de", sum(value) as value from analytics_2011 where "uidlevel4" in ('k4EyVM131IT', 'hQ44nHlIhW8', 'vabBh5ZqPIs', 'C6hzmaFaH88', 'rqoTrQ3g388') and "de" in ('gUvSpUrTCCH') and ("yearly" in ('2011')) group by "uidlevel4","de"]; nested exception is org.h2.jdbc.JdbcSQLException: Column "de" not found; SQL statement:
select "uidlevel4","de", sum(value) as value from analytics_2011 where "uidlevel4" in ('k4EyVM131IT', 'hQ44nHlIhW8', 'vabBh5ZqPIs', 'C6hzmaFaH88', 'rqoTrQ3g388') and "de" in ('gUvSpUrTCCH') and ("yearly" in ('2011')) group by "uidlevel4","de" [42122-173]
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:237)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
	at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:501)
	at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:315)
	at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:127)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:95)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: org.h2.jdbc.JdbcSQLException: Column "de" not found; SQL statement:
select "uidlevel4","de", sum(value) as value from analytics_2011 where "uidlevel4" in ('k4EyVM131IT', 'hQ44nHlIhW8', 'vabBh5ZqPIs', 'C6hzmaFaH88', 'rqoTrQ3g388') and "de" in ('gUvSpUrTCCH') and ("yearly" in ('2011')) group by "uidlevel4","de" [42122-173]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:331)
	at org.h2.message.DbException.get(DbException.java:171)
	at org.h2.message.DbException.get(DbException.java:148)
	at org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:144)
	at org.h2.command.dml.Select.prepare(Select.java:808)
	at org.h2.command.Parser.prepareCommand(Parser.java:219)
	at org.h2.engine.Session.prepareLocal(Session.java:428)
	at org.h2.engine.Session.prepareCommand(Session.java:377)
	at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1138)
	at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:72)
	at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
	at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
	... 14 more
* INFO  17:45:29,251 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-6])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "uidlevel4","de", sum(value) as value from analytics_2011 where "uidlevel4" in ('u4Idnn89LtY', 'XGPQ2WduCfW', 'S4cPuE2d3dv', 'OCtV1PUshto', 'pBihSffHkhT') and "de" in ('gUvSpUrTCCH') and ("yearly" in ('2011')) group by "uidlevel4","de"]; nested exception is org.h2.jdbc.JdbcSQLException: Column "de" not found; SQL statement:
select "uidlevel4","de", sum(value) as value from analytics_2011 where "uidlevel4" in ('u4Idnn89LtY', 'XGPQ2WduCfW', 'S4cPuE2d3dv', 'OCtV1PUshto', 'pBihSffHkhT') and "de" in ('gUvSpUrTCCH') and ("yearly" in ('2011')) group by "uidlevel4","de" [42122-173]
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:237)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
	at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:501)
	at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:315)
	at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:127)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:95)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: org.h2.jdbc.JdbcSQLException: Column "de" not found; SQL statement:
select "uidlevel4","de", sum(value) as value from analytics_2011 where "uidlevel4" in ('u4Idnn89LtY', 'XGPQ2WduCfW', 'S4cPuE2d3dv', 'OCtV1PUshto', 'pBihSffHkhT') and "de" in ('gUvSpUrTCCH') and ("yearly" in ('2011')) group by "uidlevel4","de" [42122-173]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:331)
	at org.h2.message.DbException.get(DbException.java:171)
	at org.h2.message.DbException.get(DbException.java:148)
	at org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:144)
	at org.h2.command.dml.Select.prepare(Select.java:808)
	at org.h2.command.Parser.prepareCommand(Parser.java:219)
	at org.h2.engine.Session.prepareLocal(Session.java:428)
	at org.h2.engine.Session.prepareCommand(Session.java:377)
	at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1138)
	at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:72)
	at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
	at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
	... 14 more
* INFO  17:45:29,253 Time: 14071 micros: Got aggregated values for query group (Timer.java [13211848@qtp-18737428-14])
* INFO  17:45:29,254 Time: 14980 micros: Got aggregated values (Timer.java [13211848@qtp-18737428-14])
* INFO  17:51:40,889 Login success for user: 'admin', ip: '0:0:0:0:0:0:0:1' (DefaultUserAuditService.java [25989110@qtp-18737428-20])
* INFO  17:51:54,340 Get view SQL: SELECT * FROM "_view_analitycs" (JdbcSqlViewExpandStore.java [2989425@qtp-18737428-25])
* INFO  17:56:50,468 Drop view SQL: DROP VIEW IF EXISTS "_view1391446610466" (JdbcSqlViewExpandStore.java [4847180@qtp-18737428-19])
* INFO  17:56:50,524 'admin' create org.hisp.dhis.sqlview.SqlView, name: prueba, uid: LXIDGXfMf7q (AuditLogUtil.java [4847180@qtp-18737428-19])
* INFO  17:56:53,658 Drop view SQL: DROP VIEW IF EXISTS "_view_prueba" (JdbcSqlViewExpandStore.java [31018124@qtp-18737428-22])
* INFO  17:56:55,655 Get view SQL: SELECT * FROM "_view_prueba" (JdbcSqlViewExpandStore.java [31018124@qtp-18737428-22])
* INFO  17:57:24,720 Drop view SQL: DROP VIEW IF EXISTS "_view1391446644718" (JdbcSqlViewExpandStore.java [2989425@qtp-18737428-25])
* INFO  17:57:24,860 'admin' update org.hisp.dhis.sqlview.SqlView, name: prueba, uid: LXIDGXfMf7q (AuditLogUtil.java [19296999@qtp-18737428-3])
* INFO  17:57:28,444 Get view SQL: SELECT * FROM "_view_analitycs" (JdbcSqlViewExpandStore.java [31018124@qtp-18737428-22])
* INFO  17:57:51,796 Get view SQL: SELECT * FROM "_view_analitycs" (JdbcSqlViewExpandStore.java [31018124@qtp-18737428-22])
* INFO  17:58:03,344 Get view SQL: SELECT * FROM "_view_analitycs" (JdbcSqlViewExpandStore.java [15195003@qtp-18737428-23])
* INFO  18:02:02,499 Drop view SQL: DROP VIEW IF EXISTS "_view1391446922497" (JdbcSqlViewExpandStore.java [4847180@qtp-18737428-19])
* INFO  18:02:02,541 'admin' update org.hisp.dhis.sqlview.SqlView, name: prueba, uid: LXIDGXfMf7q (AuditLogUtil.java [4847180@qtp-18737428-19])
* INFO  18:02:07,415 Drop view SQL: DROP VIEW IF EXISTS "_view_prueba" (JdbcSqlViewExpandStore.java [33347207@qtp-18737428-26])
* INFO  18:02:09,891 Get view SQL: SELECT * FROM "_view_prueba" (JdbcSqlViewExpandStore.java [33347207@qtp-18737428-26])

Follow ups

Re: Creating charts, maps and tables in dhis2-live 2.14
From: Lars Helge Øverland, 2014-02-18