* INFO 2016-01-13 09:48:36,895 Added root logger using file: C:\DHIS2\logs\dhis.log (Log4JLogConfigInitializer.java [localhost-startStop-2]) * WARN 2016-01-13 09:48:54,303 RP discovery / realm validation disabled; (RealmVerifier.java [localhost-startStop-2]) * INFO 2016-01-13 09:49:00,714 Executing startup routine [1 of 13, runlevel 1]: InitTableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-2]) * INFO 2016-01-13 09:49:03,210 Executing startup routine [2 of 13, runlevel 2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-2]) * INFO 2016-01-13 09:49:04,188 Executing startup routine [3 of 13, runlevel 3]: DataElementDefaultDimensionPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-2]) * INFO 2016-01-13 09:49:05,236 Added default category (DataElementDefaultDimensionPopulator.java [localhost-startStop-2]) * INFO 2016-01-13 09:49:05,251 Executing startup routine [4 of 13, runlevel 4]: ReportingIdentityPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-2]) * INFO 2016-01-13 09:49:05,987 Executing startup routine [5 of 13, runlevel 4]: IdentityPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-2]) * INFO 2016-01-13 09:49:06,446 Executing startup routine [6 of 13, runlevel 5]: TableCreator (DefaultStartupRoutineExecutor.java [localhost-startStop-2]) * INFO 2016-01-13 09:49:06,554 Created table/index dataapproval_unique (TableCreator.java [localhost-startStop-2]) * INFO 2016-01-13 09:49:06,612 Created table/index in_datavalueaudit (TableCreator.java [localhost-startStop-2]) * INFO 2016-01-13 09:49:06,698 Created table/index in_trackedentityattributevalue_attributeid (TableCreator.java [localhost-startStop-2]) * INFO 2016-01-13 09:49:06,698 Executing startup routine [7 of 13, runlevel 6]: TableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-2]) * INFO 2016-01-13 09:49:26,491 Tables updated (TableAlteror.java [localhost-startStop-2]) * INFO 2016-01-13 09:49:26,492 Executing startup routine [8 of 13, runlevel 7]: TrackedEntityTableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-2]) * INFO 2016-01-13 09:49:31,670 Executing startup routine [9 of 13, runlevel 9]: FavoriteDataItemUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-2]) * INFO 2016-01-13 09:49:31,675 Executing startup routine [10 of 13, runlevel 10]: FavoriteDataItemUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-2]) * INFO 2016-01-13 09:49:31,685 Upgraded custom case entry form identifiers (DataEntryFormUpgrader.java [localhost-startStop-2]) * INFO 2016-01-13 09:49:31,686 Executing startup routine [11 of 13, runlevel 11]: ExpressionUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-2]) * INFO 2016-01-13 09:49:31,704 Executing startup routine [12 of 13, runlevel 12]: ConfigurationPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-2]) * INFO 2016-01-13 09:49:31,719 Executing startup routine [13 of 13, runlevel 13]: I18nLocalePopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-2]) * INFO 2016-01-13 09:49:31,920 Populated default locales (I18nLocalePopulator.java [localhost-startStop-2]) * INFO 2016-01-13 09:49:31,920 All startup routines done (DefaultStartupRoutineExecutor.java [localhost-startStop-2]) * INFO 2016-01-13 09:50:01,287 De-registering jdbc driver: org.postgresql.Driver@253a39b4 (StartupListener.java [localhost-startStop-2]) * INFO 2016-01-13 09:51:39,289 Added root logger using file: C:\DHIS2\logs\dhis.log (Log4JLogConfigInitializer.java [localhost-startStop-1]) * WARN 2016-01-13 09:51:54,221 RP discovery / realm validation disabled; (RealmVerifier.java [localhost-startStop-1]) * INFO 2016-01-13 09:52:01,130 Executing startup routine [1 of 13, runlevel 1]: InitTableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 09:52:03,393 Executing startup routine [2 of 13, runlevel 2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 09:52:03,423 Executing startup routine [3 of 13, runlevel 3]: DataElementDefaultDimensionPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 09:52:05,281 Executing startup routine [4 of 13, runlevel 4]: ReportingIdentityPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 09:52:05,432 Executing startup routine [5 of 13, runlevel 4]: IdentityPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 09:52:05,719 1 last updated set on trackedentity (IdentityPopulator.java [localhost-startStop-1]) * INFO 2016-01-13 09:52:05,721 1 created timestamps set on trackedentity (IdentityPopulator.java [localhost-startStop-1]) * INFO 2016-01-13 09:52:06,329 Executing startup routine [6 of 13, runlevel 5]: TableCreator (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 09:52:06,385 Executing startup routine [7 of 13, runlevel 6]: TableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 09:52:23,283 Tables updated (TableAlteror.java [localhost-startStop-1]) * INFO 2016-01-13 09:52:23,284 Executing startup routine [8 of 13, runlevel 7]: TrackedEntityTableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 09:52:26,913 Executing startup routine [9 of 13, runlevel 9]: FavoriteDataItemUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 09:52:26,918 Executing startup routine [10 of 13, runlevel 10]: FavoriteDataItemUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 09:52:26,923 Upgraded custom case entry form identifiers (DataEntryFormUpgrader.java [localhost-startStop-1]) * INFO 2016-01-13 09:52:26,924 Executing startup routine [11 of 13, runlevel 11]: ExpressionUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 09:52:26,938 Executing startup routine [12 of 13, runlevel 12]: ConfigurationPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 09:52:26,943 Executing startup routine [13 of 13, runlevel 13]: I18nLocalePopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 09:52:26,957 All startup routines done (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * WARN 2016-01-13 09:54:14,788 Authentication event AuthenticationSuccessEvent: admin; details: org.springframework.security.web.authentication.WebAuthenticationDetails@166c8: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 58C22D28C4D1C7F11B7560B7BCE03CEB (LoggerListener.java [http-nio-8282-exec-7]) * WARN 2016-01-13 09:54:14,789 Authentication event SessionFixationProtectionEvent: admin; details: org.springframework.security.web.authentication.WebAuthenticationDetails@166c8: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 58C22D28C4D1C7F11B7560B7BCE03CEB (LoggerListener.java [http-nio-8282-exec-7]) * WARN 2016-01-13 09:54:14,789 Authentication event InteractiveAuthenticationSuccessEvent: admin; details: org.springframework.security.web.authentication.WebAuthenticationDetails@166c8: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 58C22D28C4D1C7F11B7560B7BCE03CEB (LoggerListener.java [http-nio-8282-exec-7]) * INFO 2016-01-13 09:54:14,800 'admin' update org.hisp.dhis.user.UserCredentials, name: admin admin, uid: hFZq09PyWFK (AuditLogUtil.java [http-nio-8282-exec-7]) * INFO 2016-01-13 09:55:55,864 'admin' create org.hisp.dhis.organisationunit.OrganisationUnit, name: Tanzania, uid: l09alaQ8mkB (AuditLogUtil.java [http-nio-8282-exec-7]) * INFO 2016-01-13 09:55:55,910 'admin' update org.hisp.dhis.organisationunit.OrganisationUnit, name: Tanzania, uid: l09alaQ8mkB (AuditLogUtil.java [http-nio-8282-exec-7]) * INFO 2016-01-13 09:56:28,363 'admin' create org.hisp.dhis.organisationunit.OrganisationUnit, name: Dar es salaam, uid: QibgUxtydlH (AuditLogUtil.java [http-nio-8282-exec-7]) * INFO 2016-01-13 09:56:28,504 'admin' update org.hisp.dhis.organisationunit.OrganisationUnit, name: Dar es salaam, uid: QibgUxtydlH (AuditLogUtil.java [http-nio-8282-exec-7]) * INFO 2016-01-13 09:56:48,771 'admin' create org.hisp.dhis.organisationunit.OrganisationUnit, name: Arusha, uid: irfhvHK5i3F (AuditLogUtil.java [http-nio-8282-exec-1]) * INFO 2016-01-13 09:56:49,016 'admin' update org.hisp.dhis.organisationunit.OrganisationUnit, name: Arusha, uid: irfhvHK5i3F (AuditLogUtil.java [http-nio-8282-exec-1]) * INFO 2016-01-13 09:57:11,616 'admin' create org.hisp.dhis.organisationunit.OrganisationUnit, name: Kinondoni, uid: Qhj6SKK7Liv (AuditLogUtil.java [http-nio-8282-exec-5]) * INFO 2016-01-13 09:57:11,706 'admin' update org.hisp.dhis.organisationunit.OrganisationUnit, name: Kinondoni, uid: Qhj6SKK7Liv (AuditLogUtil.java [http-nio-8282-exec-5]) * INFO 2016-01-13 09:57:30,645 'admin' create org.hisp.dhis.organisationunit.OrganisationUnit, name: Ilala, uid: SSxfMrzyurh (AuditLogUtil.java [http-nio-8282-exec-7]) * INFO 2016-01-13 09:57:30,926 'admin' update org.hisp.dhis.organisationunit.OrganisationUnit, name: Ilala, uid: SSxfMrzyurh (AuditLogUtil.java [http-nio-8282-exec-7]) * INFO 2016-01-13 09:57:48,980 'admin' create org.hisp.dhis.organisationunit.OrganisationUnit, name: Temeke, uid: oHmvE2Lyscs (AuditLogUtil.java [http-nio-8282-exec-6]) * INFO 2016-01-13 09:57:49,005 'admin' update org.hisp.dhis.organisationunit.OrganisationUnit, name: Temeke, uid: oHmvE2Lyscs (AuditLogUtil.java [http-nio-8282-exec-6]) * INFO 2016-01-13 09:58:11,157 'admin' create org.hisp.dhis.organisationunit.OrganisationUnitLevel, name: National, uid: kpFJwZqXZO4 (AuditLogUtil.java [http-nio-8282-exec-1]) * INFO 2016-01-13 09:58:11,212 'admin' create org.hisp.dhis.organisationunit.OrganisationUnitLevel, name: District, uid: wl9IBa4Tlsi (AuditLogUtil.java [http-nio-8282-exec-1]) * INFO 2016-01-13 09:58:11,216 'admin' create org.hisp.dhis.organisationunit.OrganisationUnitLevel, name: Region, uid: i7EtA63V9Re (AuditLogUtil.java [http-nio-8282-exec-1]) * INFO 2016-01-13 09:58:59,139 'admin' create org.hisp.dhis.dataelement.DataElement, name: Total Monthly Collection Estimation, uid: lHx7tAXxo6O (AuditLogUtil.java [http-nio-8282-exec-3]) * INFO 2016-01-13 09:58:59,222 'admin' update org.hisp.dhis.dataelement.DataElement, name: Total Monthly Collection Estimation, uid: lHx7tAXxo6O (AuditLogUtil.java [http-nio-8282-exec-3]) * INFO 2016-01-13 09:59:27,655 'admin' create org.hisp.dhis.dataelement.DataElement, name: Total Monthly Revenue Collection, uid: OCXEZsxd2Te (AuditLogUtil.java [http-nio-8282-exec-3]) * INFO 2016-01-13 09:59:27,823 'admin' update org.hisp.dhis.dataelement.DataElement, name: Total Monthly Revenue Collection, uid: OCXEZsxd2Te (AuditLogUtil.java [http-nio-8282-exec-3]) * INFO 2016-01-13 10:00:12,532 'admin' create org.hisp.dhis.dataset.DataSet, name: Monthly Estimation Collection, uid: H5vZPM1ht21 (AuditLogUtil.java [http-nio-8282-exec-8]) * INFO 2016-01-13 10:00:43,497 'admin' create org.hisp.dhis.dataset.DataSet, name: Monthly Revenue Collection, uid: A6EDk6blDj9 (AuditLogUtil.java [http-nio-8282-exec-6]) * INFO 2016-01-13 10:01:27,995 'admin' update org.hisp.dhis.dataset.DataSet, name: Monthly Estimation Collection, uid: H5vZPM1ht21 (AuditLogUtil.java [http-nio-8282-exec-2]) * INFO 2016-01-13 10:01:42,042 'admin' update org.hisp.dhis.dataset.DataSet, name: Monthly Revenue Collection, uid: A6EDk6blDj9 (AuditLogUtil.java [http-nio-8282-exec-9]) * INFO 2016-01-13 10:01:58,808 'admin' create org.hisp.dhis.period.Period, name: 201512, uid: 201512 (AuditLogUtil.java [http-nio-8282-exec-4]) * INFO 2016-01-13 10:02:04,450 Validate data set: Monthly Estimation Collection period: Monthly Tue Dec 01 00:00:00 EAT 2015 Thu Dec 31 00:00:00 EAT 2015 source: Ilala attribute combo: default (DefaultValidationRuleService.java [http-nio-8282-exec-1]) * INFO 2016-01-13 10:02:14,677 Validate data set: Monthly Revenue Collection period: Monthly Tue Dec 01 00:00:00 EAT 2015 Thu Dec 31 00:00:00 EAT 2015 source: Ilala attribute combo: default (DefaultValidationRuleService.java [http-nio-8282-exec-2]) * INFO 2016-01-13 10:02:32,924 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Wed Jan 13 10:02:32 EAT 2016, message: Analytics table update process started] (InMemoryNotifier.java [taskScheduler-1]) * INFO 2016-01-13 10:02:32,924 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Wed Jan 13 10:02:32 EAT 2016, message: Updating resource tables] (InMemoryNotifier.java [taskScheduler-1]) * INFO 2016-01-13 10:02:33,408 Create table SQL: create table _orgunitstructure_temp (organisationunitid integer not null primary key, organisationunituid character(11), level integer, "idlevel1" integer, "uidlevel1" character(11), "idlevel2" integer, "uidlevel2" character(11), "idlevel3" integer, "uidlevel3" character(11)); (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:33,483 Populate table content rows: 6 (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:33,495 Create index SQL: create unique index in_orgunitstructure_organisationunituid_BI9T7 on _orgunitstructure_temp(organisationunituid) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:33,535 Swapped resource table, done: _orgunitstructure (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:33,628 Create table SQL: create table _categoryoptioncomboname_temp (categoryoptioncomboid integer not null primary key, categoryoptioncomboname varchar(255), approvallevel integer) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:33,687 Populate table content rows: 1 (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:33,699 Swapped resource table, done: _categoryoptioncomboname (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:33,743 Create table SQL: create table _categoryoptiongroupsetstructure_temp (categoryoptioncomboid integer not null, primary key (categoryoptioncomboid)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:33,798 Populate table content rows: 1 (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:33,803 Swapped resource table, done: _categoryoptiongroupsetstructure (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:33,808 Create table SQL: create table _dataelementgroupsetstructure_temp (dataelementid integer not null, dataelementname varchar(230), primary key (dataelementid)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:33,865 Populate table SQL: insert into _dataelementgroupsetstructure_temp select d.dataelementid as dataelementid, d.name as dataelementname from dataelement d (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:33,901 Swapped resource table, done: _dataelementgroupsetstructure (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:33,931 Create table SQL: create table _indicatorgroupsetstructure_temp (indicatorid integer not null, indicatorname varchar(230), primary key (indicatorid)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:33,990 Populate table SQL: insert into _indicatorgroupsetstructure_temp select i.indicatorid as indicatorid, i.name as indicatorname from indicator i (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:33,994 Swapped resource table, done: _indicatorgroupsetstructure (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,084 Create table SQL: create table _organisationunitgroupsetstructure_temp (organisationunitid integer not null, organisationunitname varchar(230), primary key (organisationunitid)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,152 Populate table SQL: insert into _organisationunitgroupsetstructure_temp select ou.organisationunitid as organisationunitid, ou.name as organisationunitname from organisationunit ou (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,156 Swapped resource table, done: _organisationunitgroupsetstructure (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,206 Create table SQL: create table _categorystructure_temp (categoryoptioncomboid integer not null, categoryoptioncomboname varchar(230), "default" varchar(230), "l4m2ffDxjH3" character(11), primary key (categoryoptioncomboid)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,276 Populate table SQL: insert into _categorystructure_temp select coc.categoryoptioncomboid as cocid, coc.name as cocname, (select co.name from categoryoptioncombos_categoryoptions cocco inner join dataelementcategoryoption co on cocco.categoryoptionid = co.categoryoptionid inner join categories_categoryoptions cco on co.categoryoptionid = cco.categoryoptionid where coc.categoryoptioncomboid = cocco.categoryoptioncomboid and cco.categoryid = 13 limit 1) as "default", (select co.uid from categoryoptioncombos_categoryoptions cocco inner join dataelementcategoryoption co on cocco.categoryoptionid = co.categoryoptionid inner join categories_categoryoptions cco on co.categoryoptionid = cco.categoryoptionid where coc.categoryoptioncomboid = cocco.categoryoptioncomboid and cco.categoryid = 13 limit 1) as "l4m2ffDxjH3" from categoryoptioncombo coc (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,298 Swapped resource table, done: _categorystructure (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,330 Create table SQL: CREATE TABLE _dataelementstructure_temp (dataelementid INTEGER NOT NULL PRIMARY KEY, dataelementuid CHARACTER(11), dataelementname VARCHAR(230), datasetid INTEGER, datasetuid CHARACTER(11), datasetname VARCHAR(230), datasetapprovallevel INTEGER, periodtypeid INTEGER, periodtypename VARCHAR(230)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,431 Populate table content rows: 2 (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,439 Create index SQL: create unique index in_dataelementstructure_dataelementuid_y2cZC on _dataelementstructure_temp(dataelementuid); (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,495 Create index SQL: create index in_dataelementstructure_datasetid_xG9KQ on _dataelementstructure_temp(datasetid); (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,560 Create index SQL: create index in_dataelementstructure_datasetuid_l98kM on _dataelementstructure_temp(datasetuid); (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,625 Create index SQL: create index in_dataelementstructure_periodtypeid_HBCLO on _dataelementstructure_temp(periodtypeid); (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,699 Swapped resource table, done: _dataelementstructure (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,740 Create table SQL: CREATE TABLE _periodstructure_temp (periodid INTEGER NOT NULL PRIMARY KEY, iso VARCHAR(15) NOT NULL, daysno INTEGER NOT NULL, "daily" VARCHAR(15), "weekly" VARCHAR(15), "monthly" VARCHAR(15), "bimonthly" VARCHAR(15), "quarterly" VARCHAR(15), "sixmonthly" VARCHAR(15), "sixmonthlyapril" VARCHAR(15), "yearly" VARCHAR(15), "financialapril" VARCHAR(15), "financialjuly" VARCHAR(15), "financialoct" VARCHAR(15)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,919 Populate table content rows: 1 (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,928 Create index SQL: create unique index in_periodstructure_iso_NGEZy on _periodstructure_temp(iso) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 10:02:34,988 Swapped resource table, done: _periodstructure (JdbcResourceTableStore.java [taskScheduler-1]) * ERROR 2016-01-13 10:03:08,026 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-1]) com.google.common.util.concurrent.ExecutionError: java.lang.OutOfMemoryError: GC overhead limit exceeded at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2201) at com.google.common.cache.LocalCache.get(LocalCache.java:3937) at com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4739) at org.hisp.dhis.period.PeriodType.createPeriod(PeriodType.java:276) at org.hisp.dhis.resourcetable.table.DatePeriodResourceTable.getPopulateTempTableContent(DatePeriodResourceTable.java:106) at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.generateResourceTable(JdbcResourceTableStore.java:75) at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDatePeriodTable(DefaultResourceTableService.java:206) 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.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201) at com.sun.proxy.$Proxy140.generateDatePeriodTable(Unknown Source) at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.generateResourceTables(DefaultAnalyticsTableService.java:180) at org.hisp.dhis.analytics.table.scheduling.AnalyticsTableTask.call(AnalyticsTableTask.java:138) at org.hisp.dhis.security.NoSecurityContextRunnable.run(NoSecurityContextRunnable.java:47) at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.OutOfMemoryError: GC overhead limit exceeded at org.hisp.dhis.calendar.DateTimeUnit.fromJodaDateTime(DateTimeUnit.java:352) at org.hisp.dhis.calendar.ChronologyBasedCalendar.plusMonths(ChronologyBasedCalendar.java:286) at org.hisp.dhis.period.BiMonthlyPeriodType.createPeriod(BiMonthlyPeriodType.java:74) at org.hisp.dhis.period.PeriodType.lambda$createPeriod$1(PeriodType.java:276) at org.hisp.dhis.period.PeriodType$$Lambda$46/954455367.call(Unknown Source) at com.google.common.cache.LocalCache$LocalManualCache$1.load(LocalCache.java:4742) at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527) at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319) at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282) at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197) at com.google.common.cache.LocalCache.get(LocalCache.java:3937) at com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4739) at org.hisp.dhis.period.PeriodType.createPeriod(PeriodType.java:276) at org.hisp.dhis.resourcetable.table.DatePeriodResourceTable.getPopulateTempTableContent(DatePeriodResourceTable.java:106) at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.generateResourceTable(JdbcResourceTableStore.java:75) at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDatePeriodTable(DefaultResourceTableService.java:206) 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.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201) at com.sun.proxy.$Proxy140.generateDatePeriodTable(Unknown Source) at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.generateResourceTables(DefaultAnalyticsTableService.java:180) at org.hisp.dhis.analytics.table.scheduling.AnalyticsTableTask.call(AnalyticsTableTask.java:138) at org.hisp.dhis.security.NoSecurityContextRunnable.run(NoSecurityContextRunnable.java:47) at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) * INFO 2016-01-13 10:23:52,241 Information schema analytics SQL: select table_name from information_schema.tables where table_name like 'analytics%' and table_type = 'BASE TABLE' (JdbcPartitionManager.java [http-nio-8282-exec-3]) * INFO 2016-01-13 10:23:53,230 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-1]) org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "dx","monthly","uidlevel3","co", sum(value) as value from analytics_2015 where "dx" in ('lHx7tAXxo6O') and "monthly" in ('201512') and "uidlevel3" in ('SSxfMrzyurh') group by "dx","monthly","uidlevel3","co"]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "analytics_2015" does not exist Position: 66 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471) at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:395) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:143) 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:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:110) at java.util.concurrent.FutureTask.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2015" does not exist Position: 66 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:405) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:285) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405) ... 14 more * INFO 2016-01-13 10:23:53,444 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-2]) org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "dx","monthly","uidlevel3", sum(value) as value from analytics_2015 where "dx" in ('lHx7tAXxo6O') and "monthly" in ('201512') and "uidlevel3" in ('SSxfMrzyurh') group by "dx","monthly","uidlevel3"]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "analytics_2015" does not exist Position: 61 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471) at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:395) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:143) 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:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:110) at java.util.concurrent.FutureTask.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2015" does not exist Position: 61 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:405) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:285) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405) ... 14 more * INFO 2016-01-13 10:24:01,279 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-3]) org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "dx","monthly","uidlevel3","co", sum(value) as value from analytics_2015 where "dx" in ('lHx7tAXxo6O') and "monthly" in ('201512') and "uidlevel3" in ('Qhj6SKK7Liv') group by "dx","monthly","uidlevel3","co"]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "analytics_2015" does not exist Position: 66 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471) at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:395) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:143) 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:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:110) at java.util.concurrent.FutureTask.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2015" does not exist Position: 66 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:405) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:285) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405) ... 14 more * INFO 2016-01-13 10:24:01,321 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-4]) org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "dx","monthly","uidlevel3", sum(value) as value from analytics_2015 where "dx" in ('lHx7tAXxo6O') and "monthly" in ('201512') and "uidlevel3" in ('Qhj6SKK7Liv') group by "dx","monthly","uidlevel3"]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "analytics_2015" does not exist Position: 61 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471) at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:395) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:143) 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:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:110) at java.util.concurrent.FutureTask.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2015" does not exist Position: 61 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:405) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:285) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405) ... 14 more * INFO 2016-01-13 10:24:10,298 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-5]) org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "dx","monthly","uidlevel3","co", sum(value) as value from analytics_2015 where "dx" in ('lHx7tAXxo6O') and "monthly" in ('201512') and "uidlevel3" in ('oHmvE2Lyscs') group by "dx","monthly","uidlevel3","co"]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "analytics_2015" does not exist Position: 66 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471) at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:395) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:143) 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:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:110) at java.util.concurrent.FutureTask.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2015" does not exist Position: 66 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:405) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:285) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405) ... 14 more * INFO 2016-01-13 10:24:10,722 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-6]) org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "dx","monthly","uidlevel3", sum(value) as value from analytics_2015 where "dx" in ('lHx7tAXxo6O') and "monthly" in ('201512') and "uidlevel3" in ('oHmvE2Lyscs') group by "dx","monthly","uidlevel3"]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "analytics_2015" does not exist Position: 61 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471) at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:395) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:143) 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:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:110) at java.util.concurrent.FutureTask.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2015" does not exist Position: 61 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:405) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:285) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405) ... 14 more * INFO 2016-01-13 10:24:18,278 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-7]) org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "dx","monthly","uidlevel2","co", sum(value) as value from analytics_2015 where "dx" in ('lHx7tAXxo6O') and "monthly" in ('201512') and "uidlevel2" in ('QibgUxtydlH') group by "dx","monthly","uidlevel2","co"]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "analytics_2015" does not exist Position: 66 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471) at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:395) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:143) 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:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:110) at java.util.concurrent.FutureTask.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2015" does not exist Position: 66 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:405) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:285) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405) ... 14 more * INFO 2016-01-13 10:24:18,315 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-8]) org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "dx","monthly","uidlevel2", sum(value) as value from analytics_2015 where "dx" in ('lHx7tAXxo6O') and "monthly" in ('201512') and "uidlevel2" in ('QibgUxtydlH') group by "dx","monthly","uidlevel2"]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "analytics_2015" does not exist Position: 61 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471) at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:395) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:143) 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:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:110) at java.util.concurrent.FutureTask.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2015" does not exist Position: 61 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:405) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:285) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405) ... 14 more * INFO 2016-01-13 10:24:46,660 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-9]) org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "dx","monthly", count(value) as value from analytics_completeness_2015 where "dx" in ('A6EDk6blDj9') and "monthly" in ('201501', '201502', '201503', '201504', '201505', '201506', '201507', '201508', '201509', '201510', '201511', '201512') and ( "uidlevel1" in ('l09alaQ8mkB') ) group by "dx","monthly"]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "analytics_completeness_2015" does not exist Position: 51 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471) at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:395) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:143) 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:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:110) at java.util.concurrent.FutureTask.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_completeness_2015" does not exist Position: 51 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:405) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:285) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405) ... 14 more * INFO 2016-01-13 10:24:46,966 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-10]) org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "dx", count(value) as value from analytics_completenesstarget where "dx" in ('A6EDk6blDj9') and ( "uidlevel1" in ('l09alaQ8mkB') ) group by "dx"]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "analytics_completenesstarget" does not exist Position: 41 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471) at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:395) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:143) 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:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:110) at java.util.concurrent.FutureTask.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_completenesstarget" does not exist Position: 41 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:405) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:285) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405) ... 14 more * INFO 2016-01-13 10:25:04,803 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-11]) org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "dx","monthly", count(value) as value from analytics_completeness_2015 where "dx" in ('A6EDk6blDj9') and "monthly" in ('201501', '201502', '201503', '201504', '201505', '201506', '201507', '201508', '201509', '201510', '201511', '201512') and ( "uidlevel3" in ('SSxfMrzyurh') ) group by "dx","monthly"]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "analytics_completeness_2015" does not exist Position: 51 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471) at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:395) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:143) 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:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:110) at java.util.concurrent.FutureTask.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_completeness_2015" does not exist Position: 51 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:405) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:285) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405) ... 14 more * INFO 2016-01-13 10:25:04,806 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-12]) org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "dx", count(value) as value from analytics_completenesstarget where "dx" in ('A6EDk6blDj9') and ( "uidlevel3" in ('SSxfMrzyurh') ) group by "dx"]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "analytics_completenesstarget" does not exist Position: 41 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471) at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:395) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:143) 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:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:110) at java.util.concurrent.FutureTask.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_completenesstarget" does not exist Position: 41 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:405) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:285) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405) ... 14 more * INFO 2016-01-13 10:25:09,719 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-13]) org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "dx","monthly", count(value) as value from analytics_completeness_2015 where "dx" in ('A6EDk6blDj9') and "monthly" in ('201501', '201502', '201503', '201504', '201505', '201506', '201507', '201508', '201509', '201510', '201511', '201512') and ( "uidlevel3" in ('Qhj6SKK7Liv') ) group by "dx","monthly"]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "analytics_completeness_2015" does not exist Position: 51 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471) at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:395) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:143) 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:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:110) at java.util.concurrent.FutureTask.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_completeness_2015" does not exist Position: 51 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:405) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:285) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405) ... 14 more * INFO 2016-01-13 10:25:10,547 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-14]) org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "dx", count(value) as value from analytics_completenesstarget where "dx" in ('A6EDk6blDj9') and ( "uidlevel3" in ('Qhj6SKK7Liv') ) group by "dx"]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "analytics_completenesstarget" does not exist Position: 41 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471) at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:395) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:143) 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:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:110) at java.util.concurrent.FutureTask.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_completenesstarget" does not exist Position: 41 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:405) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:285) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405) ... 14 more * WARN 2016-01-13 10:58:56,446 Authentication event AuthenticationSuccessEvent: admin; details: org.springframework.security.web.authentication.WebAuthenticationDetails@43458: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 04D0F8E90897D203FA52713AF1F9E3D0 (LoggerListener.java [http-nio-8282-exec-10]) * WARN 2016-01-13 10:58:56,698 Authentication event SessionFixationProtectionEvent: admin; details: org.springframework.security.web.authentication.WebAuthenticationDetails@43458: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 04D0F8E90897D203FA52713AF1F9E3D0 (LoggerListener.java [http-nio-8282-exec-10]) * WARN 2016-01-13 10:58:56,698 Authentication event InteractiveAuthenticationSuccessEvent: admin; details: org.springframework.security.web.authentication.WebAuthenticationDetails@43458: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 04D0F8E90897D203FA52713AF1F9E3D0 (LoggerListener.java [http-nio-8282-exec-10]) * INFO 2016-01-13 10:58:56,700 'admin' update org.hisp.dhis.user.UserCredentials, name: admin admin, uid: liwphLSvbVr (AuditLogUtil.java [http-nio-8282-exec-10]) * INFO 2016-01-13 11:02:02,272 De-registering jdbc driver: org.postgresql.Driver@4e3b5af1 (StartupListener.java [localhost-startStop-2]) * INFO 2016-01-13 11:07:00,360 Added root logger using file: C:\DHIS2\logs\dhis.log (Log4JLogConfigInitializer.java [localhost-startStop-1]) * WARN 2016-01-13 11:07:17,620 RP discovery / realm validation disabled; (RealmVerifier.java [localhost-startStop-1]) * INFO 2016-01-13 11:07:24,397 Executing startup routine [1 of 13, runlevel 1]: InitTableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 11:07:29,078 Executing startup routine [2 of 13, runlevel 2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 11:07:29,224 Executing startup routine [3 of 13, runlevel 3]: DataElementDefaultDimensionPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 11:07:31,729 Executing startup routine [4 of 13, runlevel 4]: ReportingIdentityPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 11:07:32,729 Executing startup routine [5 of 13, runlevel 4]: IdentityPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 11:07:36,398 Executing startup routine [6 of 13, runlevel 5]: TableCreator (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 11:07:36,530 Executing startup routine [7 of 13, runlevel 6]: TableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 11:07:56,255 Tables updated (TableAlteror.java [localhost-startStop-1]) * INFO 2016-01-13 11:07:56,256 Executing startup routine [8 of 13, runlevel 7]: TrackedEntityTableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 11:08:00,582 Executing startup routine [9 of 13, runlevel 9]: FavoriteDataItemUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 11:08:00,587 Executing startup routine [10 of 13, runlevel 10]: FavoriteDataItemUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 11:08:00,592 Upgraded custom case entry form identifiers (DataEntryFormUpgrader.java [localhost-startStop-1]) * INFO 2016-01-13 11:08:00,592 Executing startup routine [11 of 13, runlevel 11]: ExpressionUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 11:08:00,640 Executing startup routine [12 of 13, runlevel 12]: ConfigurationPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 11:08:00,671 Executing startup routine [13 of 13, runlevel 13]: I18nLocalePopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 11:08:00,894 All startup routines done (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * WARN 2016-01-13 11:29:44,747 Authentication event AuthenticationSuccessEvent: admin; details: org.springframework.security.web.authentication.WebAuthenticationDetails@0: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: A332DE7DCD9156D3A6ED796FE65F91D5 (LoggerListener.java [http-nio-8282-exec-5]) * WARN 2016-01-13 11:29:44,749 Authentication event SessionFixationProtectionEvent: admin; details: org.springframework.security.web.authentication.WebAuthenticationDetails@0: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: A332DE7DCD9156D3A6ED796FE65F91D5 (LoggerListener.java [http-nio-8282-exec-5]) * WARN 2016-01-13 11:29:44,750 Authentication event InteractiveAuthenticationSuccessEvent: admin; details: org.springframework.security.web.authentication.WebAuthenticationDetails@0: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: A332DE7DCD9156D3A6ED796FE65F91D5 (LoggerListener.java [http-nio-8282-exec-5]) * INFO 2016-01-13 11:29:44,752 'admin' update org.hisp.dhis.user.UserCredentials, name: admin admin, uid: rABfL22CYc8 (AuditLogUtil.java [http-nio-8282-exec-5]) * INFO 2016-01-13 11:30:45,461 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Wed Jan 13 11:30:45 EAT 2016, message: Analytics table update process started] (InMemoryNotifier.java [taskScheduler-1]) * INFO 2016-01-13 11:30:45,461 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Wed Jan 13 11:30:45 EAT 2016, message: Updating resource tables] (InMemoryNotifier.java [taskScheduler-1]) * INFO 2016-01-13 11:30:45,585 Create table SQL: create table _orgunitstructure_temp (organisationunitid integer not null primary key, organisationunituid character(11), level integer, "idlevel1" integer, "uidlevel1" character(11), "idlevel2" integer, "uidlevel2" character(11), "idlevel3" integer, "uidlevel3" character(11)); (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:45,660 Populate table content rows: 6 (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:46,155 Create index SQL: create unique index in_orgunitstructure_organisationunituid_hylF7 on _orgunitstructure_temp(organisationunituid) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:46,225 Swapped resource table, done: _orgunitstructure (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:46,336 Create table SQL: create table _categoryoptioncomboname_temp (categoryoptioncomboid integer not null primary key, categoryoptioncomboname varchar(255), approvallevel integer) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:46,411 Populate table content rows: 1 (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:46,439 Swapped resource table, done: _categoryoptioncomboname (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:46,727 Create table SQL: create table _categoryoptiongroupsetstructure_temp (categoryoptioncomboid integer not null, primary key (categoryoptioncomboid)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:46,956 Populate table content rows: 1 (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:46,981 Swapped resource table, done: _categoryoptiongroupsetstructure (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:47,028 Create table SQL: create table _dataelementgroupsetstructure_temp (dataelementid integer not null, dataelementname varchar(230), primary key (dataelementid)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:47,100 Populate table SQL: insert into _dataelementgroupsetstructure_temp select d.dataelementid as dataelementid, d.name as dataelementname from dataelement d (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:47,120 Swapped resource table, done: _dataelementgroupsetstructure (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:47,192 Create table SQL: create table _indicatorgroupsetstructure_temp (indicatorid integer not null, indicatorname varchar(230), primary key (indicatorid)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:47,255 Populate table SQL: insert into _indicatorgroupsetstructure_temp select i.indicatorid as indicatorid, i.name as indicatorname from indicator i (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:47,263 Swapped resource table, done: _indicatorgroupsetstructure (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:47,273 Create table SQL: create table _organisationunitgroupsetstructure_temp (organisationunitid integer not null, organisationunitname varchar(230), primary key (organisationunitid)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:47,351 Populate table SQL: insert into _organisationunitgroupsetstructure_temp select ou.organisationunitid as organisationunitid, ou.name as organisationunitname from organisationunit ou (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:47,356 Swapped resource table, done: _organisationunitgroupsetstructure (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:47,821 Create table SQL: create table _categorystructure_temp (categoryoptioncomboid integer not null, categoryoptioncomboname varchar(230), "default" varchar(230), "l4m2ffDxjH3" character(11), primary key (categoryoptioncomboid)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:47,999 Populate table SQL: insert into _categorystructure_temp select coc.categoryoptioncomboid as cocid, coc.name as cocname, (select co.name from categoryoptioncombos_categoryoptions cocco inner join dataelementcategoryoption co on cocco.categoryoptionid = co.categoryoptionid inner join categories_categoryoptions cco on co.categoryoptionid = cco.categoryoptionid where coc.categoryoptioncomboid = cocco.categoryoptioncomboid and cco.categoryid = 13 limit 1) as "default", (select co.uid from categoryoptioncombos_categoryoptions cocco inner join dataelementcategoryoption co on cocco.categoryoptionid = co.categoryoptionid inner join categories_categoryoptions cco on co.categoryoptionid = cco.categoryoptionid where coc.categoryoptioncomboid = cocco.categoryoptioncomboid and cco.categoryid = 13 limit 1) as "l4m2ffDxjH3" from categoryoptioncombo coc (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:48,019 Swapped resource table, done: _categorystructure (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:48,174 Create table SQL: CREATE TABLE _dataelementstructure_temp (dataelementid INTEGER NOT NULL PRIMARY KEY, dataelementuid CHARACTER(11), dataelementname VARCHAR(230), datasetid INTEGER, datasetuid CHARACTER(11), datasetname VARCHAR(230), datasetapprovallevel INTEGER, periodtypeid INTEGER, periodtypename VARCHAR(230)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:48,278 Populate table content rows: 2 (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:48,286 Create index SQL: create unique index in_dataelementstructure_dataelementuid_PiXls on _dataelementstructure_temp(dataelementuid); (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:48,335 Create index SQL: create index in_dataelementstructure_datasetid_vYyQk on _dataelementstructure_temp(datasetid); (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:48,385 Create index SQL: create index in_dataelementstructure_datasetuid_X3Sui on _dataelementstructure_temp(datasetuid); (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:48,435 Create index SQL: create index in_dataelementstructure_periodtypeid_oxKH0 on _dataelementstructure_temp(periodtypeid); (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:48,516 Swapped resource table, done: _dataelementstructure (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:49,054 Create table SQL: CREATE TABLE _periodstructure_temp (periodid INTEGER NOT NULL PRIMARY KEY, iso VARCHAR(15) NOT NULL, daysno INTEGER NOT NULL, "daily" VARCHAR(15), "weekly" VARCHAR(15), "monthly" VARCHAR(15), "bimonthly" VARCHAR(15), "quarterly" VARCHAR(15), "sixmonthly" VARCHAR(15), "sixmonthlyapril" VARCHAR(15), "yearly" VARCHAR(15), "financialapril" VARCHAR(15), "financialjuly" VARCHAR(15), "financialoct" VARCHAR(15)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:49,214 Populate table content rows: 1 (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:49,221 Create index SQL: create unique index in_periodstructure_iso_ZN0DD on _periodstructure_temp(iso) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 11:30:49,304 Swapped resource table, done: _periodstructure (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 12:09:35,316 Create table SQL: create table _dateperiodstructure_temp (dateperiod date not null primary key, "daily" varchar(15), "weekly" varchar(15), "monthly" varchar(15), "bimonthly" varchar(15), "quarterly" varchar(15), "sixmonthly" varchar(15), "sixmonthlyapril" varchar(15), "yearly" varchar(15), "financialapril" varchar(15), "financialjuly" varchar(15), "financialoct" varchar(15)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 2016-01-13 12:09:36,255 Populate table content rows: 18263 (JdbcResourceTableStore.java [taskScheduler-1]) * ERROR 2016-01-13 12:19:18,637 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-1]) java.lang.OutOfMemoryError: Java heap space * WARN 2016-01-13 13:04:43,442 Authentication event AuthenticationSuccessEvent: admin; details: org.springframework.security.web.authentication.WebAuthenticationDetails@fffe9938: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 520F4FEA336AB1EEE99AEB6856F84BC4 (LoggerListener.java [http-nio-8282-exec-1]) * WARN 2016-01-13 13:04:43,458 Authentication event SessionFixationProtectionEvent: admin; details: org.springframework.security.web.authentication.WebAuthenticationDetails@fffe9938: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 520F4FEA336AB1EEE99AEB6856F84BC4 (LoggerListener.java [http-nio-8282-exec-1]) * WARN 2016-01-13 13:04:43,458 Authentication event InteractiveAuthenticationSuccessEvent: admin; details: org.springframework.security.web.authentication.WebAuthenticationDetails@fffe9938: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 520F4FEA336AB1EEE99AEB6856F84BC4 (LoggerListener.java [http-nio-8282-exec-1]) * INFO 2016-01-13 13:04:43,458 'admin' update org.hisp.dhis.user.UserCredentials, name: admin admin, uid: K12mgZrNBhY (AuditLogUtil.java [http-nio-8282-exec-1]) * INFO 2016-01-13 13:09:09,927 De-registering jdbc driver: org.postgresql.Driver@5682e95a (StartupListener.java [localhost-startStop-2]) * INFO 2016-01-13 13:12:53,674 Added root logger using file: C:\DHIS2\logs\dhis.log (Log4JLogConfigInitializer.java [localhost-startStop-1]) * WARN 2016-01-13 13:13:09,390 RP discovery / realm validation disabled; (RealmVerifier.java [localhost-startStop-1]) * INFO 2016-01-13 13:13:18,560 Executing startup routine [1 of 13, runlevel 1]: InitTableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 13:13:24,594 Executing startup routine [2 of 13, runlevel 2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 13:13:24,707 Executing startup routine [3 of 13, runlevel 3]: DataElementDefaultDimensionPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 13:13:27,247 Executing startup routine [4 of 13, runlevel 4]: ReportingIdentityPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 13:13:28,144 Executing startup routine [5 of 13, runlevel 4]: IdentityPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 13:13:30,788 Executing startup routine [6 of 13, runlevel 5]: TableCreator (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 13:13:30,906 Executing startup routine [7 of 13, runlevel 6]: TableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 13:13:52,941 Tables updated (TableAlteror.java [localhost-startStop-1]) * INFO 2016-01-13 13:13:52,942 Executing startup routine [8 of 13, runlevel 7]: TrackedEntityTableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 13:13:58,121 Executing startup routine [9 of 13, runlevel 9]: FavoriteDataItemUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 13:13:58,130 Executing startup routine [10 of 13, runlevel 10]: FavoriteDataItemUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 13:13:58,134 Upgraded custom case entry form identifiers (DataEntryFormUpgrader.java [localhost-startStop-1]) * INFO 2016-01-13 13:13:58,135 Executing startup routine [11 of 13, runlevel 11]: ExpressionUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 13:13:58,180 Executing startup routine [12 of 13, runlevel 12]: ConfigurationPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 13:13:58,274 Executing startup routine [13 of 13, runlevel 13]: I18nLocalePopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * INFO 2016-01-13 13:13:58,426 All startup routines done (DefaultStartupRoutineExecutor.java [localhost-startStop-1]) * WARN 2016-01-13 13:15:06,008 Authentication event AuthenticationSuccessEvent: admin; details: org.springframework.security.web.authentication.WebAuthenticationDetails@166c8: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 95D6886277381F4737040C201F38A3E8 (LoggerListener.java [http-nio-8282-exec-2]) * WARN 2016-01-13 13:15:06,009 Authentication event SessionFixationProtectionEvent: admin; details: org.springframework.security.web.authentication.WebAuthenticationDetails@166c8: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 95D6886277381F4737040C201F38A3E8 (LoggerListener.java [http-nio-8282-exec-2]) * WARN 2016-01-13 13:15:06,010 Authentication event InteractiveAuthenticationSuccessEvent: admin; details: org.springframework.security.web.authentication.WebAuthenticationDetails@166c8: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: 95D6886277381F4737040C201F38A3E8 (LoggerListener.java [http-nio-8282-exec-2]) * INFO 2016-01-13 13:15:06,013 'admin' update org.hisp.dhis.user.UserCredentials, name: admin admin, uid: UpIaeMQCfnX (AuditLogUtil.java [http-nio-8282-exec-2]) * INFO 2016-01-13 13:15:20,530 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Wed Jan 13 13:15:20 EAT 2016, message: Analytics table update process started] (InMemoryNotifier.java [taskScheduler-2]) * INFO 2016-01-13 13:15:20,531 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Wed Jan 13 13:15:20 EAT 2016, message: Updating resource tables] (InMemoryNotifier.java [taskScheduler-2]) * INFO 2016-01-13 13:15:20,583 Create table SQL: create table _orgunitstructure_temp (organisationunitid integer not null primary key, organisationunituid character(11), level integer, "idlevel1" integer, "uidlevel1" character(11), "idlevel2" integer, "uidlevel2" character(11), "idlevel3" integer, "uidlevel3" character(11)); (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:21,140 Populate table content rows: 6 (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:21,163 Create index SQL: create unique index in_orgunitstructure_organisationunituid_x79sT on _orgunitstructure_temp(organisationunituid) (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:21,221 Swapped resource table, done: _orgunitstructure (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:21,981 Create table SQL: create table _categoryoptioncomboname_temp (categoryoptioncomboid integer not null primary key, categoryoptioncomboname varchar(255), approvallevel integer) (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:22,049 Populate table content rows: 1 (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:22,054 Swapped resource table, done: _categoryoptioncomboname (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:22,162 Create table SQL: create table _categoryoptiongroupsetstructure_temp (categoryoptioncomboid integer not null, primary key (categoryoptioncomboid)) (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:22,249 Populate table content rows: 1 (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:22,268 Swapped resource table, done: _categoryoptiongroupsetstructure (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:23,188 Create table SQL: create table _dataelementgroupsetstructure_temp (dataelementid integer not null, dataelementname varchar(230), primary key (dataelementid)) (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:23,298 Populate table SQL: insert into _dataelementgroupsetstructure_temp select d.dataelementid as dataelementid, d.name as dataelementname from dataelement d (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:23,321 Swapped resource table, done: _dataelementgroupsetstructure (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:23,735 Create table SQL: create table _indicatorgroupsetstructure_temp (indicatorid integer not null, indicatorname varchar(230), primary key (indicatorid)) (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:23,806 Populate table SQL: insert into _indicatorgroupsetstructure_temp select i.indicatorid as indicatorid, i.name as indicatorname from indicator i (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:23,811 Swapped resource table, done: _indicatorgroupsetstructure (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:23,869 Create table SQL: create table _organisationunitgroupsetstructure_temp (organisationunitid integer not null, organisationunitname varchar(230), primary key (organisationunitid)) (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:23,944 Populate table SQL: insert into _organisationunitgroupsetstructure_temp select ou.organisationunitid as organisationunitid, ou.name as organisationunitname from organisationunit ou (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:23,950 Swapped resource table, done: _organisationunitgroupsetstructure (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:24,083 Create table SQL: create table _categorystructure_temp (categoryoptioncomboid integer not null, categoryoptioncomboname varchar(230), "default" varchar(230), "l4m2ffDxjH3" character(11), primary key (categoryoptioncomboid)) (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:24,173 Populate table SQL: insert into _categorystructure_temp select coc.categoryoptioncomboid as cocid, coc.name as cocname, (select co.name from categoryoptioncombos_categoryoptions cocco inner join dataelementcategoryoption co on cocco.categoryoptionid = co.categoryoptionid inner join categories_categoryoptions cco on co.categoryoptionid = cco.categoryoptionid where coc.categoryoptioncomboid = cocco.categoryoptioncomboid and cco.categoryid = 13 limit 1) as "default", (select co.uid from categoryoptioncombos_categoryoptions cocco inner join dataelementcategoryoption co on cocco.categoryoptionid = co.categoryoptionid inner join categories_categoryoptions cco on co.categoryoptionid = cco.categoryoptionid where coc.categoryoptioncomboid = cocco.categoryoptioncomboid and cco.categoryid = 13 limit 1) as "l4m2ffDxjH3" from categoryoptioncombo coc (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:24,210 Swapped resource table, done: _categorystructure (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:24,627 Create table SQL: CREATE TABLE _dataelementstructure_temp (dataelementid INTEGER NOT NULL PRIMARY KEY, dataelementuid CHARACTER(11), dataelementname VARCHAR(230), datasetid INTEGER, datasetuid CHARACTER(11), datasetname VARCHAR(230), datasetapprovallevel INTEGER, periodtypeid INTEGER, periodtypename VARCHAR(230)) (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:25,025 Populate table content rows: 2 (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:25,032 Create index SQL: create unique index in_dataelementstructure_dataelementuid_mxPfm on _dataelementstructure_temp(dataelementuid); (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:25,263 Create index SQL: create index in_dataelementstructure_datasetid_UaluM on _dataelementstructure_temp(datasetid); (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:25,550 Create index SQL: create index in_dataelementstructure_datasetuid_KvxNa on _dataelementstructure_temp(datasetuid); (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:25,730 Create index SQL: create index in_dataelementstructure_periodtypeid_V9R6C on _dataelementstructure_temp(periodtypeid); (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:25,804 Swapped resource table, done: _dataelementstructure (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:26,843 Create table SQL: CREATE TABLE _periodstructure_temp (periodid INTEGER NOT NULL PRIMARY KEY, iso VARCHAR(15) NOT NULL, daysno INTEGER NOT NULL, "daily" VARCHAR(15), "weekly" VARCHAR(15), "monthly" VARCHAR(15), "bimonthly" VARCHAR(15), "quarterly" VARCHAR(15), "sixmonthly" VARCHAR(15), "sixmonthlyapril" VARCHAR(15), "yearly" VARCHAR(15), "financialapril" VARCHAR(15), "financialjuly" VARCHAR(15), "financialoct" VARCHAR(15)) (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:26,920 Populate table content rows: 1 (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:26,922 Create index SQL: create unique index in_periodstructure_iso_ByMOH on _periodstructure_temp(iso) (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:15:27,006 Swapped resource table, done: _periodstructure (JdbcResourceTableStore.java [taskScheduler-2]) * INFO 2016-01-13 13:16:11,414 Information schema analytics SQL: select table_name from information_schema.tables where table_name like 'analytics%' and table_type = 'BASE TABLE' (JdbcPartitionManager.java [http-nio-8282-exec-8]) * INFO 2016-01-13 13:16:13,678 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-1]) org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "dx","monthly", count(value) as value from analytics_completeness_2015 where "dx" in ('A6EDk6blDj9') and "monthly" in ('201501', '201502', '201503', '201504', '201505', '201506', '201507', '201508', '201509', '201510', '201511', '201512') and ( "uidlevel1" in ('l09alaQ8mkB') ) group by "dx","monthly"]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "analytics_completeness_2015" does not exist Position: 51 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471) at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:395) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:143) 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:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:110) at java.util.concurrent.FutureTask.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_completeness_2015" does not exist Position: 51 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:405) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:285) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405) ... 14 more * INFO 2016-01-13 13:16:14,431 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-2]) org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "dx", count(value) as value from analytics_completenesstarget where "dx" in ('A6EDk6blDj9') and ( "uidlevel1" in ('l09alaQ8mkB') ) group by "dx"]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "analytics_completenesstarget" does not exist Position: 41 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471) at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:395) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:143) 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:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:110) at java.util.concurrent.FutureTask.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_completenesstarget" does not exist Position: 41 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:405) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:285) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405) ... 14 more * ERROR 2016-01-13 13:16:53,352 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-2]) com.google.common.util.concurrent.ExecutionError: java.lang.OutOfMemoryError: GC overhead limit exceeded at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2201) at com.google.common.cache.LocalCache.get(LocalCache.java:3937) at com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4739) at org.hisp.dhis.period.PeriodType.createPeriod(PeriodType.java:276) at org.hisp.dhis.resourcetable.table.DatePeriodResourceTable.getPopulateTempTableContent(DatePeriodResourceTable.java:106) at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.generateResourceTable(JdbcResourceTableStore.java:75) at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDatePeriodTable(DefaultResourceTableService.java:206) 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.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201) at com.sun.proxy.$Proxy140.generateDatePeriodTable(Unknown Source) at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.generateResourceTables(DefaultAnalyticsTableService.java:180) at org.hisp.dhis.analytics.table.scheduling.AnalyticsTableTask.call(AnalyticsTableTask.java:138) at org.hisp.dhis.security.NoSecurityContextRunnable.run(NoSecurityContextRunnable.java:47) at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.OutOfMemoryError: GC overhead limit exceeded at sun.util.locale.provider.DecimalFormatSymbolsProviderImpl.getInstance(Unknown Source) at java.text.DecimalFormatSymbols.getInstance(Unknown Source) at java.util.Formatter.getZero(Unknown Source) at java.util.Formatter.(Unknown Source) at java.util.Formatter.(Unknown Source) at java.lang.String.format(Unknown Source) at org.hisp.dhis.period.FinancialJulyPeriodType.getIsoDate(FinancialJulyPeriodType.java:67) at org.hisp.dhis.period.PeriodType.toIsoPeriod(PeriodType.java:295) at org.hisp.dhis.period.FinancialPeriodType.createPeriod(FinancialPeriodType.java:80) at org.hisp.dhis.period.PeriodType.lambda$createPeriod$1(PeriodType.java:276) at org.hisp.dhis.period.PeriodType$$Lambda$36/2104682310.call(Unknown Source) at com.google.common.cache.LocalCache$LocalManualCache$1.load(LocalCache.java:4742) at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527) at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319) at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282) at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197) at com.google.common.cache.LocalCache.get(LocalCache.java:3937) at com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4739) at org.hisp.dhis.period.PeriodType.createPeriod(PeriodType.java:276) at org.hisp.dhis.resourcetable.table.DatePeriodResourceTable.getPopulateTempTableContent(DatePeriodResourceTable.java:106) at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.generateResourceTable(JdbcResourceTableStore.java:75) at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDatePeriodTable(DefaultResourceTableService.java:206) 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.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201) at com.sun.proxy.$Proxy140.generateDatePeriodTable(Unknown Source) at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.generateResourceTables(DefaultAnalyticsTableService.java:180) at org.hisp.dhis.analytics.table.scheduling.AnalyticsTableTask.call(AnalyticsTableTask.java:138) at org.hisp.dhis.security.NoSecurityContextRunnable.run(NoSecurityContextRunnable.java:47) * INFO 2016-01-13 13:17:54,256 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-3]) org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "dx","monthly","uidlevel3","co", sum(value) as value from analytics_2015 where "dx" in ('lHx7tAXxo6O') and "monthly" in ('201512') and "uidlevel3" in ('SSxfMrzyurh') group by "dx","monthly","uidlevel3","co"]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "analytics_2015" does not exist Position: 66 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471) at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:395) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:143) 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:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:110) at java.util.concurrent.FutureTask.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2015" does not exist Position: 66 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:405) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:285) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405) ... 14 more * INFO 2016-01-13 13:17:54,267 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-4]) org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "dx","monthly","uidlevel3", sum(value) as value from analytics_2015 where "dx" in ('lHx7tAXxo6O') and "monthly" in ('201512') and "uidlevel3" in ('SSxfMrzyurh') group by "dx","monthly","uidlevel3"]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "analytics_2015" does not exist Position: 61 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471) at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:395) at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:143) 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:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:110) at java.util.concurrent.FutureTask.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2015" does not exist Position: 61 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:405) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:285) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:455) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405) ... 14 more * WARN 2016-01-13 13:18:54,849 Help file: help_content_en_.xml not available on classpath, falling back to defaul (DefaultHelpManager.java [http-nio-8282-exec-5])