* INFO 09:16:07,704 Linked default category with default concept (DataElementDefaultDimensionPopulator.java [Thread-2]) * INFO 09:16:07,891 Executing startup routine [4 of 14, runlevel 3]: TrackerIdentityPopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 09:16:08,968 Executing startup routine [5 of 14, runlevel 3]: ReportingIdentityPopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 09:16:09,592 Executing startup routine [6 of 14, runlevel 3]: TableAlteror (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 09:17:00,697 Tables updated (TableAlteror.java [Thread-2]) * INFO 09:17:00,697 Executing startup routine [7 of 14, runlevel 4]: TrackedEntityTableAlteror (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 09:17:11,758 Executing startup routine [8 of 14, runlevel 4]: IdentityPopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 09:17:12,881 Executing startup routine [9 of 14, runlevel 5]: TableCreator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 09:17:12,943 Executing startup routine [10 of 14, runlevel 7]: MapViewUpgrader (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 09:17:14,129 Executing startup routine [11 of 14, runlevel 7]: DataEntryFormUpgrader (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 09:17:14,144 Upgraded custom case entry form identifiers (DataEntryFormUpgrader.java [Thread-2]) * INFO 09:17:14,144 Executing startup routine [12 of 14, runlevel 8]: ExpressionUpgrader (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 09:17:14,238 Executing startup routine [13 of 14, runlevel 9]: ConfigurationPopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 09:17:14,269 Executing startup routine [14 of 14, runlevel 9]: I18nLocalePopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 09:17:14,332 All startup routines done (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 09:17:38,200 Lifecycle: server started (TrayApp.java [Thread-2]) * INFO 09:18:29,135 Login success for user: 'moungui', ip: '127.0.0.1' (DefaultUserAuditService.java [28609054@qtp-26411237-0]) * INFO 09:20:35,682 Starting min-max analysis, no of data elements: 2, no of org units: 1 (MinMaxOutlierAnalysisService.java [28609054@qtp-26411237-0]) * INFO 09:20:35,729 Validate data set: Surveillance MEV period: Weekly 2015-01-05 2015-01-11 source: CSI BOGO attribute combo: (default) (DefaultValidationRuleService.java [28609054@qtp-26411237-0]) * INFO 09:20:44,730 Starting min-max analysis, no of data elements: 2, no of org units: 1 (MinMaxOutlierAnalysisService.java [4826065@qtp-26411237-7]) * INFO 09:20:44,746 Validate data set: Surveillance MEV period: Weekly 2014-12-29 2015-01-04 source: CSI BOGO attribute combo: (default) (DefaultValidationRuleService.java [4826065@qtp-26411237-7]) * INFO 09:21:11,983 Graceful shutdown... (TrayApp.java [AWT-EventQueue-0]) * INFO 09:21:11,983 Lifecycle: server stopping (TrayApp.java [AWT-EventQueue-0]) * INFO 09:21:12,108 De-registering jdbc driver: org.h2.Driver@4383ef (StartupListener.java [AWT-EventQueue-0]) * INFO 09:21:12,108 De-registering jdbc driver: org.hsqldb.jdbc.JDBCDriver@1fdb9e4 (StartupListener.java [AWT-EventQueue-0]) * INFO 09:21:12,108 De-registering jdbc driver: com.mysql.jdbc.Driver@205a0d (StartupListener.java [AWT-EventQueue-0]) * INFO 09:21:12,108 De-registering jdbc driver: com.mysql.fabric.jdbc.FabricMySQLDriver@173312c (StartupListener.java [AWT-EventQueue-0]) * INFO 09:21:12,108 De-registering jdbc driver: org.postgresql.Driver@1d3d45a (StartupListener.java [AWT-EventQueue-0]) * INFO 09:21:12,592 Lifecycle: server stopped (TrayApp.java [AWT-EventQueue-0]) * INFO 09:21:12,592 Exiting... (TrayApp.java [AWT-EventQueue-0]) * INFO 12:55:37,186 Environment variable DHIS2_HOME: null (TrayApp.java [main]) * INFO 12:55:37,405 Initialising DHIS 2 Live... (TrayApp.java [main]) * INFO 12:55:37,732 Loading DHIS 2 on port: 8082 (WebAppServer.java [main]) * INFO 12:55:37,919 Setting DHIS 2 web app context to: /C:/DHIS2/dhis-live/webapps/dhis (WebAppServer.java [main]) * INFO 12:55:37,919 Lifecycle: server starting (TrayApp.java [Thread-2]) * INFO 12:55:58,449 System property dhis2.home points to /C:/DHIS2/dhis-live/conf (DefaultLocationManager.java [Thread-2]) * INFO 12:56:01,070 Hibernate configuration loaded, using dialect: org.hibernate.dialect.PostgreSQLDialect (DefaultHibernateConfigurationProvider.java [Thread-2]) * INFO 12:56:58,041 Found the following message senders: [org.hisp.dhis.message.EmailMessageSender@1a2d62f, org.hisp.dhis.sms.SmsMessageSender@ccb863] (DefaultMessageService.java [Thread-2]) * INFO 12:57:23,859 Detected apps: [] (DefaultAppManager.java [Thread-2]) * INFO 12:57:38,913 Executing startup routine [1 of 14, runlevel 1]: InitTableAlteror (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 12:57:40,848 Executing startup routine [2 of 14, runlevel 2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 12:57:40,972 Executing startup routine [3 of 14, runlevel 2]: DataElementDefaultDimensionPopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 12:57:41,253 Linked default category with default concept (DataElementDefaultDimensionPopulator.java [Thread-2]) * INFO 12:57:41,628 Executing startup routine [4 of 14, runlevel 3]: TrackerIdentityPopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 12:57:42,532 Executing startup routine [5 of 14, runlevel 3]: ReportingIdentityPopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 12:57:43,297 Executing startup routine [6 of 14, runlevel 3]: TableAlteror (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 12:58:27,336 Tables updated (TableAlteror.java [Thread-2]) * INFO 12:58:27,336 Executing startup routine [7 of 14, runlevel 4]: TrackedEntityTableAlteror (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 12:58:37,413 Executing startup routine [8 of 14, runlevel 4]: IdentityPopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 12:58:38,505 Executing startup routine [9 of 14, runlevel 5]: TableCreator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 12:58:38,552 Executing startup routine [10 of 14, runlevel 7]: MapViewUpgrader (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 12:58:39,800 Executing startup routine [11 of 14, runlevel 7]: DataEntryFormUpgrader (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 12:58:39,816 Upgraded custom case entry form identifiers (DataEntryFormUpgrader.java [Thread-2]) * INFO 12:58:39,816 Executing startup routine [12 of 14, runlevel 8]: ExpressionUpgrader (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 12:58:39,909 Executing startup routine [13 of 14, runlevel 9]: ConfigurationPopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 12:58:39,941 Executing startup routine [14 of 14, runlevel 9]: I18nLocalePopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 12:58:39,987 All startup routines done (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 12:59:02,483 Lifecycle: server started (TrayApp.java [Thread-2]) * INFO 13:19:07,009 Login failure for user: 'moungui', ip: '127.0.0.1' (DefaultUserAuditService.java [4007277@qtp-12525833-2]) * INFO 13:19:29,410 Login success for user: 'moungui', ip: '127.0.0.1' (DefaultUserAuditService.java [4007277@qtp-12525833-2]) * INFO 13:19:59,300 [Level: INFO, category: RESOURCETABLE_UPDATE, time: Sat May 09 13:19:59 WAT 2015, message: Generating resource tables] (InMemoryNotifier.java [taskScheduler-1]) * INFO 13:19:59,347 Using 3 organisation unit levels for org unit structure table (DefaultResourceTableService.java [taskScheduler-1]) * INFO 13:19:59,347 Create organisation unit structure table SQL: CREATE TABLE _orgunitstructure ( organisationunitid INTEGER NOT NULL PRIMARY KEY, organisationunituid CHARACTER(11), level INTEGER, "idlevel1" INTEGER, "uidlevel1" CHARACTER(11), "idlevel2" INTEGER, "uidlevel2" CHARACTER(11), "idlevel3" INTEGER, "uidlevel3" CHARACTER(11)); (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 13:19:59,425 Organisation unit structure table generated (DefaultResourceTableService.java [taskScheduler-1]) * INFO 13:19:59,518 Create category option combo name table SQL: CREATE TABLE _categoryoptioncomboname ( categoryoptioncomboid INTEGER NOT NULL PRIMARY KEY, categoryoptioncomboname VARCHAR(250), approvallevel INTEGER ) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 13:19:59,565 Category option combo name table generated (DefaultResourceTableService.java [taskScheduler-1]) * INFO 13:19:59,596 Create category option group set table SQL: CREATE TABLE _categoryoptiongroupsetstructure ( categoryoptioncomboid INTEGER NOT NULL, PRIMARY KEY ( categoryoptioncomboid ) ) (CreateCategoryOptionGroupSetTableStatement.java [taskScheduler-1]) * INFO 13:19:59,612 Category option group set table generated (DefaultResourceTableService.java [taskScheduler-1]) * INFO 13:19:59,612 Create data element group set table SQL: CREATE TABLE _dataelementgroupsetstructure ( dataelementid INTEGER NOT NULL, dataelementname VARCHAR (250), "Surveillance MEV" VARCHAR (250), "w7AuWhwfxhs" CHARACTER(11), PRIMARY KEY ( dataelementid ) ) (CreateDataElementGroupSetTableStatement.java [taskScheduler-1]) * INFO 13:19:59,628 Populate data element group set structure SQL: insert into _dataelementgroupsetstructure select d.dataelementid as dataelementid, d.name as dataelementname, (select deg.name from dataelementgroup deg inner join dataelementgroupmembers degm on degm.dataelementgroupid = deg.dataelementgroupid inner join dataelementgroupsetmembers degsm on degsm.dataelementgroupid = degm.dataelementgroupid and degsm.dataelementgroupsetid = 53 where degm.dataelementid = d.dataelementid limit 1) as "Surveillance MEV", (select deg.uid from dataelementgroup deg inner join dataelementgroupmembers degm on degm.dataelementgroupid = deg.dataelementgroupid inner join dataelementgroupsetmembers degsm on degsm.dataelementgroupid = degm.dataelementgroupid and degsm.dataelementgroupsetid = 53 where degm.dataelementid = d.dataelementid limit 1) as "w7AuWhwfxhs" from dataelement d (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 13:19:59,706 Data element group set table generated (DefaultResourceTableService.java [taskScheduler-1]) * INFO 13:19:59,721 Create indicator group set table SQL: CREATE TABLE _indicatorgroupsetstructure ( indicatorid INTEGER NOT NULL, indicatorname VARCHAR (250), PRIMARY KEY ( indicatorid ) ) (CreateIndicatorGroupSetTableStatement.java [taskScheduler-1]) * INFO 13:19:59,737 Populate indicator group set structure SQL: insert into _indicatorgroupsetstructure select i.indicatorid as indicatorid, i.name as indicatorname from indicator i (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 13:19:59,737 Indicator group set table generated (DefaultResourceTableService.java [taskScheduler-1]) * INFO 13:19:59,862 Create organisation unit group set table SQL: CREATE TABLE _organisationunitgroupsetstructure ( organisationunitid INTEGER NOT NULL, organisationunitname VARCHAR (250), PRIMARY KEY ( organisationunitid ) ) (CreateOrganisationUnitGroupSetTableStatement.java [taskScheduler-1]) * INFO 13:19:59,877 Populate organisation unit group set structure SQL: insert into _organisationunitgroupsetstructure select ou.organisationunitid as organisationunitid, ou.name as organisationunitname from organisationunit ou (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 13:19:59,877 Organisation unit group set table generated (DefaultResourceTableService.java [taskScheduler-1]) * INFO 13:19:59,877 Create category structure table SQL: CREATE TABLE _categorystructure ( categoryoptioncomboid INTEGER NOT NULL, categoryoptioncomboname VARCHAR (250), PRIMARY KEY ( categoryoptioncomboid ) ) (CreateCategoryTableStatement.java [taskScheduler-1]) * INFO 13:19:59,893 Populate category structure SQL: insert into _categorystructure select coc.categoryoptioncomboid as cocid, con.categoryoptioncomboname as cocname from categoryoptioncombo coc inner join _categoryoptioncomboname con on coc.categoryoptioncomboid = con.categoryoptioncomboid (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 13:19:59,893 Category table generated (DefaultResourceTableService.java [taskScheduler-1]) * INFO 13:19:59,908 Create data element structure SQL: CREATE TABLE _dataelementstructure ( dataelementid INTEGER NOT NULL PRIMARY KEY, dataelementuid CHARACTER(11), dataelementname VARCHAR(250), datasetid INTEGER, datasetuid CHARACTER(11), datasetname VARCHAR(250), datasetapprovallevel INTEGER, periodtypeid INTEGER, periodtypename VARCHAR(250) ) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 13:20:00,002 Data element table generated (DefaultResourceTableService.java [taskScheduler-1]) * INFO 13:20:00,018 Create period structure SQL: CREATE TABLE _periodstructure (periodid INTEGER NOT NULL PRIMARY KEY, iso VARCHAR(15) NOT NULL, daysno INTEGER NOT NULL, "daily" VARCHAR(15), "weekly" VARCHAR(15), "monthly" VARCHAR(15), "bimonthly" VARCHAR(15), "quarterly" VARCHAR(15), "sixmonthly" VARCHAR(15), "sixmonthlyapril" VARCHAR(15), "yearly" VARCHAR(15), "financialapril" VARCHAR(15), "financialjuly" VARCHAR(15), "financialoct" VARCHAR(15)) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 13:20:00,220 Date period table generated (DefaultResourceTableService.java [taskScheduler-1]) * INFO 13:20:00,236 Create date period structure SQL: CREATE TABLE _dateperiodstructure (dateperiod DATE NOT NULL PRIMARY KEY, "daily" VARCHAR(15), "weekly" VARCHAR(15), "monthly" VARCHAR(15), "bimonthly" VARCHAR(15), "quarterly" VARCHAR(15), "sixmonthly" VARCHAR(15), "sixmonthlyapril" VARCHAR(15), "yearly" VARCHAR(15), "financialapril" VARCHAR(15), "financialjuly" VARCHAR(15), "financialoct" VARCHAR(15)) (JdbcResourceTableStore.java [taskScheduler-1]) * WARN 13:20:03,434 Help file: help_content_fr_.xml not available on classpath, falling back to defaul (DefaultHelpManager.java [21090994@qtp-12525833-4]) * INFO 13:20:11,452 Period table generated (DefaultResourceTableService.java [taskScheduler-1]) * INFO 13:20:11,452 Create data element category option combo SQL: CREATE TABLE _dataelementcategoryoptioncombo (dataelementid INTEGER NOT NULL, dataelementuid VARCHAR(11) NOT NULL, categoryoptioncomboid INTEGER NOT NULL, categoryoptioncombouid VARCHAR(11) NOT NULL) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 13:20:11,484 Insert data element category option combo SQL: insert into _dataelementcategoryoptioncombo (dataelementid, dataelementuid, categoryoptioncomboid, categoryoptioncombouid) select de.dataelementid as dataelementid, de.uid as dataelementuid, coc.categoryoptioncomboid as categoryoptioncomboid, coc.uid as categoryoptioncombouid from dataelement de join categorycombos_optioncombos cc on de.categorycomboid = cc.categorycomboid join categoryoptioncombo coc on cc.categoryoptioncomboid = coc.categoryoptioncomboid (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 13:20:11,484 Create data element category option combo index SQL: CREATE INDEX dataelement_categoryoptioncombo ON _dataelementcategoryoptioncombo (dataelementuid, categoryoptioncombouid) (JdbcResourceTableStore.java [taskScheduler-1]) * INFO 13:20:11,499 Data element category option combo table generated (DefaultResourceTableService.java [taskScheduler-1]) * INFO 13:20:11,499 [Level: INFO, category: RESOURCETABLE_UPDATE, time: Sat May 09 13:20:11 WAT 2015, message: Resource tables generated: 0:00:12.199] (InMemoryNotifier.java [taskScheduler-1]) * INFO 13:21:09,406 Information schema analytics SQL: select table_name from information_schema.tables where table_name like 'analytics%' and table_type = 'BASE TABLE' (JdbcPartitionManager.java [4007277@qtp-12525833-2]) * INFO 13:21:09,484 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-2]) org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "de","monthly","co", sum(value) as value from analytics_2015 where "de" in ('gaM3RB379zu', 'whgcVZePTnL') and "monthly" in ('201501', '201502', '201503', '201504') and ( "uidlevel1" in ('JmWvlc9CbZh') ) group by "de","monthly","co"]; nested exception is org.postgresql.util.PSQLException: ERREUR: la relation « analytics_2015 » n'existe pas Position : 54 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:397) 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: ERREUR: la relation « analytics_2015 » n'existe pas Position : 54 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 13:21:09,500 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-1]) org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "de","monthly","co", sum(value) as value from analytics_2014 where "de" in ('gaM3RB379zu', 'whgcVZePTnL') and "monthly" in ('201405', '201406', '201407', '201408', '201409', '201410', '201411', '201412') and ( "uidlevel1" in ('JmWvlc9CbZh') ) group by "de","monthly","co"]; nested exception is org.postgresql.util.PSQLException: ERREUR: la relation « analytics_2014 » n'existe pas Position : 54 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:397) 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: ERREUR: la relation « analytics_2014 » n'existe pas Position : 54 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 13:21:28,532 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-4]) org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "de","monthly","co", sum(value) as value from analytics_2015 where "de" in ('gaM3RB379zu', 'whgcVZePTnL') and "monthly" in ('201501', '201502', '201503', '201504') and ( "uidlevel1" in ('JmWvlc9CbZh') ) group by "de","monthly","co"]; nested exception is org.postgresql.util.PSQLException: ERREUR: la relation « analytics_2015 » n'existe pas Position : 54 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:397) 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: ERREUR: la relation « analytics_2015 » n'existe pas Position : 54 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 13:21:28,532 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-3]) org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "de","monthly","co", sum(value) as value from analytics_2014 where "de" in ('gaM3RB379zu', 'whgcVZePTnL') and "monthly" in ('201405', '201406', '201407', '201408', '201409', '201410', '201411', '201412') and ( "uidlevel1" in ('JmWvlc9CbZh') ) group by "de","monthly","co"]; nested exception is org.postgresql.util.PSQLException: ERREUR: la relation « analytics_2014 » n'existe pas Position : 54 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:397) 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: ERREUR: la relation « analytics_2014 » n'existe pas Position : 54 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 13:21:28,563 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-5]) org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "ds","monthly", count(value) as value from analytics_completeness_2014 where "ds" in ('edrMo9SWXDi') and "monthly" in ('201405', '201406', '201407', '201408', '201409', '201410', '201411', '201412') and ( "uidlevel1" in ('JmWvlc9CbZh') ) group by "ds","monthly"]; nested exception is org.postgresql.util.PSQLException: ERREUR: la relation « analytics_completeness_2014 » n'existe pas 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:397) 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: ERREUR: la relation « analytics_completeness_2014 » n'existe pas 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 13:21:28,579 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-6]) org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "ds","monthly", count(value) as value from analytics_completeness_2015 where "ds" in ('edrMo9SWXDi') and "monthly" in ('201501', '201502', '201503', '201504') and ( "uidlevel1" in ('JmWvlc9CbZh') ) group by "ds","monthly"]; nested exception is org.postgresql.util.PSQLException: ERREUR: la relation « analytics_completeness_2015 » n'existe pas 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:397) 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: ERREUR: la relation « analytics_completeness_2015 » n'existe pas 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 13:21:28,626 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-7]) org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select "ds", count(value) as value from analytics_completenesstarget where "ds" in ('edrMo9SWXDi') and ( "uidlevel1" in ('JmWvlc9CbZh') ) group by "ds"]; nested exception is org.postgresql.util.PSQLException: ERREUR: la relation « analytics_completenesstarget » n'existe pas 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:397) 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: ERREUR: la relation « analytics_completenesstarget » n'existe pas 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