* INFO 12:00:09,683 [Level: INFO, category: DATAMART, time: Thu Jun 28 12:00:09 WAT 2012, message: Exporting data for indicators] (InMemoryNotifier.java [taskScheduler-2]) * INFO 12:00:11,491 Indicator export task done (DefaultIndicatorDataMart.java [SimpleAsyncTaskExecutor-39]) * INFO 12:00:11,620 Indicator export task done (DefaultIndicatorDataMart.java [SimpleAsyncTaskExecutor-38]) * INFO 12:00:11,683 Indicator export task done (DefaultIndicatorDataMart.java [SimpleAsyncTaskExecutor-40]) * INFO 12:00:11,684 Exported values for indicators (27), pages: 3, Mem used: 247, max: 247, free: 77: 0:00:05.815 (Clock.java [taskScheduler-2]) * INFO 12:00:11,684 [Level: INFO, category: DATAMART, time: Thu Jun 28 12:00:11 WAT 2012, message: Creating database indexes] (InMemoryNotifier.java [taskScheduler-2]) * INFO 12:00:11,686 Dropped aggregated org unit data cache, Mem used: 247, max: 247, free: 77: 0:00:05.817 (Clock.java [taskScheduler-2]) * INFO 12:00:11,818 Created org unit indexes: 0:00:05.949 (Clock.java [taskScheduler-2]) * INFO 12:00:11,819 Aggregated organisation unit data export done: 0:00:05.950 (Clock.java [taskScheduler-2]) * INFO 12:00:11,819 Dropped crosstab table: 0:00:05.950 (Clock.java [taskScheduler-2]) * INFO 12:00:11,820 Data mart export process completed: 0:00:05.951 (Clock.java [taskScheduler-2]) * INFO 12:00:11,820 [Level: INFO, category: DATAMART, time: Thu Jun 28 12:00:11 WAT 2012, message: Data mart process completed] (InMemoryNotifier.java [taskScheduler-2]) * INFO 12:00:11,822 Data completeness export process started, number of CPU cores: 4, Mem used: 247, max: 247, free: 65: 0:00:00.000 (Clock.java [taskScheduler-2]) * INFO 12:00:11,822 [Level: INFO, category: DATAMART, time: Thu Jun 28 12:00:11 WAT 2012, message: Completeness export process started] (InMemoryNotifier.java [taskScheduler-2]) * INFO 12:00:11,823 Dropped potential index: 0:00:00.001 (Clock.java [taskScheduler-2]) * INFO 12:00:11,830 Deleted existing completeness data: 0:00:00.008 (Clock.java [taskScheduler-2]) * INFO 12:00:11,831 [Level: INFO, category: DATAMART, time: Thu Jun 28 12:00:11 WAT 2012, message: Exporting completeness for data sets] (InMemoryNotifier.java [taskScheduler-2]) * INFO 12:00:11,997 Completeness export task done (AbstractDataSetCompletenessService.java [SimpleAsyncTaskExecutor-44]) * INFO 12:00:12,040 Completeness export task done (AbstractDataSetCompletenessService.java [SimpleAsyncTaskExecutor-41]) * INFO 12:00:12,047 Completeness export task done (AbstractDataSetCompletenessService.java [SimpleAsyncTaskExecutor-42]) * INFO 12:00:12,057 Completeness export task done (AbstractDataSetCompletenessService.java [SimpleAsyncTaskExecutor-43]) * INFO 12:00:12,061 Created index: 0:00:00.238 (Clock.java [taskScheduler-2]) * INFO 12:00:12,061 Completeness export process completed: 0:00:00.239 (Clock.java [taskScheduler-2]) * INFO 12:00:12,061 [Level: INFO, category: DATAMART, time: Thu Jun 28 12:00:12 WAT 2012, message: Completeness process completed] (InMemoryNotifier.java [taskScheduler-2]) * INFO 12:00:59,635 Reporting period date default: Apr to Jun 2012 (DefaultReportTableService.java [433222@qtp-21290107-32]) * INFO 12:00:59,636 Parent organisation unit: Nigeria (DefaultReportTableService.java [433222@qtp-21290107-32]) * INFO 12:01:58,347 Reporting period date default: Apr to Jun 2012 (DefaultReportTableService.java [21423794@qtp-21290107-34]) * INFO 12:01:58,347 Parent organisation unit: Nigeria (DefaultReportTableService.java [21423794@qtp-21290107-34]) * INFO 12:07:14,152 Reporting period date default: Apr to Jun 2012 (DefaultReportTableService.java [18152546@qtp-21290107-38]) * INFO 12:07:14,153 Parent organisation unit: Nigeria (DefaultReportTableService.java [18152546@qtp-21290107-38]) * INFO 12:09:08,604 Reporting period date default: Apr to Jun 2012 (DefaultReportTableService.java [18152546@qtp-21290107-38]) * INFO 12:09:08,605 Parent organisation unit: Nigeria (DefaultReportTableService.java [18152546@qtp-21290107-38]) * INFO 12:10:20,384 Reporting period date default: Apr to Jun 2012 (DefaultReportTableService.java [18152546@qtp-21290107-38]) * INFO 12:10:20,385 Parent organisation unit: Nigeria (DefaultReportTableService.java [18152546@qtp-21290107-38]) * INFO 23:37:48,731 Graceful shutdown... (TrayApp.java [AWT-EventQueue-0]) * INFO 23:37:48,732 Lifecycle: server stopping (TrayApp.java [AWT-EventQueue-0]) * INFO 23:37:48,987 De-registering jdbc driver: sun.jdbc.odbc.JdbcOdbcDriver@1d8131b (StartupListener.java [AWT-EventQueue-0]) * INFO 23:37:48,988 De-registering jdbc driver: org.hsqldb.jdbc.JDBCDriver@1ffb848 (StartupListener.java [AWT-EventQueue-0]) * INFO 23:37:48,988 De-registering jdbc driver: com.mysql.jdbc.Driver@192fd15 (StartupListener.java [AWT-EventQueue-0]) * INFO 23:37:48,989 De-registering jdbc driver: org.postgresql.Driver@d829b1 (StartupListener.java [AWT-EventQueue-0]) * INFO 23:37:48,990 De-registering jdbc driver: org.h2.Driver@1e89ac1 (StartupListener.java [AWT-EventQueue-0]) * INFO 23:37:49,175 Camel context stopped (DHIS2LifecycleStrategy.java [AWT-EventQueue-0]) * INFO 23:37:49,629 Lifecycle: server stopped (TrayApp.java [AWT-EventQueue-0]) * INFO 23:37:49,767 Exiting... (TrayApp.java [AWT-EventQueue-0]) * INFO 23:49:31,216 Environment variable DHIS2_HOME: null (TrayApp.java [main]) * INFO 23:49:31,265 Initialising DHIS 2 Live... (TrayApp.java [main]) * INFO 23:49:31,636 Loading DHIS 2 on port: 8082 (WebAppServer.java [main]) * INFO 23:49:31,737 Setting DHIS 2 web app context to: /C:/dhis2-live-2.8/dhis-live/webapps/dhis (WebAppServer.java [main]) * INFO 23:49:31,744 Lifecycle: server starting (TrayApp.java [Thread-2]) * INFO 23:49:46,422 System property dhis2.home points to /C:/dhis2-live-2.8/dhis-live/conf (DefaultLocationManager.java [Thread-2]) * INFO 23:50:22,677 Found the following message senders: [org.hisp.dhis.message.EmailMessageSender@17f23d0] (DefaultMessageService.java [Thread-2]) * INFO 23:50:37,094 Camel context started (DHIS2LifecycleStrategy.java [Thread-2]) * INFO 23:50:37,292 Camel endpoint added: spring-event://default (DHIS2LifecycleStrategy.java [Thread-2]) * INFO 23:50:37,347 Executing startup routine [1 of 9, runlevel 1]: TableAlteror (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 23:50:37,915 Tables updated (TableAlteror.java [Thread-2]) * INFO 23:50:37,916 Executing startup routine [2 of 9, runlevel 2]: IdentityPopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 23:50:37,970 Executing startup routine [3 of 9, runlevel 2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 23:50:38,593 Executing startup routine [4 of 9, runlevel 3]: TableCreator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 23:50:38,653 Executing startup routine [5 of 9, runlevel 3]: DataElementDefaultDimensionPopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 23:50:38,823 Linked default category with default concept (DataElementDefaultDimensionPopulator.java [Thread-2]) * INFO 23:50:38,863 Executing startup routine [6 of 9, runlevel 4]: PatientTableAlteror (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 23:50:38,873 Executing startup routine [7 of 9, runlevel 5]: OrganisationUnitGroupSetPopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 23:50:38,883 Executing startup routine [8 of 9, runlevel 5]: DataEntryFormUpgrader (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 23:50:38,883 Upgraded custom case entry form identifiers: 0 (DataEntryFormUpgrader.java [Thread-2]) * INFO 23:50:38,883 Executing startup routine [9 of 9, runlevel 5]: ProgramAttributePopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 23:50:38,883 All startup routines done (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 23:50:47,199 Lifecycle: server started (TrayApp.java [Thread-2]) * INFO 23:56:13,635 User login success: 'admin' (DefaultUserAuditService.java [29569540@qtp-31931917-2]) * INFO 23:59:04,384 Dropped all sql views (GenerateResourceTableAction.java [29569540@qtp-31931917-2]) * INFO 23:59:04,415 Create organisation unit structure table SQL: CREATE TABLE _orgunitstructure ( organisationunitid INTEGER NOT NULL, level INTEGER, idlevel1 INTEGER, idlevel2 INTEGER, idlevel3 INTEGER, idlevel4 INTEGER, PRIMARY KEY ( organisationunitid ) ); (JdbcResourceTableStore.java [29569540@qtp-31931917-2]) * INFO 23:59:04,497 Create data element group set table SQL: CREATE TABLE _dataelementgroupsetstructure ( dataelementid INTEGER NOT NULL, dataelementname VARCHAR (250), PRIMARY KEY ( dataelementid ) ) (CreateDataElementGroupSetTableStatement.java [29569540@qtp-31931917-2]) * INFO 23:59:04,520 Create indicator group set table SQL: CREATE TABLE _indicatorgroupsetstructure ( indicatorid INTEGER NOT NULL, indicatorname VARCHAR (250), PRIMARY KEY ( indicatorid ) ) (CreateIndicatorGroupSetTableStatement.java [29569540@qtp-31931917-2]) * INFO 23:59:04,534 Create organisation unit group set table SQL: CREATE TABLE _organisationunitgroupsetstructure ( organisationunitid INTEGER NOT NULL, organisationunitname VARCHAR (250), ownership VARCHAR (250), type VARCHAR (250), PRIMARY KEY ( organisationunitid ) ) (CreateOrganisationUnitGroupSetTableStatement.java [29569540@qtp-31931917-2]) * INFO 23:59:04,560 Create category structure table SQL: CREATE TABLE _categorystructure ( categoryoptioncomboid INTEGER NOT NULL, categoryoptioncomboname VARCHAR (250), age VARCHAR (250), _default VARCHAR (250), gender VARCHAR (250), reach VARCHAR (250), religion VARCHAR (250), PRIMARY KEY ( categoryoptioncomboid ) ) (CreateCategoryTableStatement.java [29569540@qtp-31931917-2]) * INFO 23:59:04,604 Create category option combo name table SQL: CREATE TABLE _categoryoptioncomboname ( categoryoptioncomboid INTEGER NOT NULL, categoryoptioncomboname VARCHAR(250) ) (JdbcResourceTableStore.java [29569540@qtp-31931917-2]) * INFO 23:59:04,620 Create data element structure SQL: CREATE TABLE _dataelementstructure ( dataelementid INTEGER NOT NULL, dataelementname VARCHAR(250), periodtypeid INTEGER, periodtypename VARCHAR(250) ) (JdbcResourceTableStore.java [29569540@qtp-31931917-2]) * INFO 23:59:04,629 Generated resource tables (GenerateResourceTableAction.java [29569540@qtp-31931917-2]) * INFO 23:59:04,634 Created all views (GenerateResourceTableAction.java [29569540@qtp-31931917-2]) * INFO 00:16:53,518 User login success: 'admin' (DefaultUserAuditService.java [506319@qtp-31931917-6]) * INFO 00:17:05,135 Export started (ExportPipeThread.java [Thread-25]) * INFO 00:17:05,377 Export done (ExportPipeThread.java [Thread-25]) * INFO 00:17:13,151 Export started (ExportPipeThread.java [Thread-26]) * INFO 00:17:13,305 Export done (ExportPipeThread.java [Thread-26]) * INFO 00:17:55,979 User login success: 'admin' (DefaultUserAuditService.java [506319@qtp-31931917-6]) * INFO 00:18:01,550 Export started (ExportPipeThread.java [Thread-27]) * INFO 00:18:01,680 Export done (ExportPipeThread.java [Thread-27]) * INFO 00:18:39,783 DataMart export request from admin @ 127.0.0.1 (ExportDataMartAction.java [506319@qtp-31931917-6]) * INFO 00:18:39,873 Exporting for Nigeria at level: Project (ExportPivotViewService.java [506319@qtp-31931917-6]) * INFO 00:18:39,916 DataMart export request from admin @ 127.0.0.1 (ExportDataMartAction.java [21122439@qtp-31931917-7]) * INFO 00:18:39,951 DataMart export request from admin @ 127.0.0.1 (ExportDataMartAction.java [23751133@qtp-31931917-12]) * INFO 00:18:39,954 DataMart export request from admin @ 127.0.0.1 (ExportDataMartAction.java [20825862@qtp-31931917-13]) * INFO 00:18:40,076 DataMart export request from admin @ 127.0.0.1 (ExportDataMartAction.java [2069949@qtp-31931917-10]) * INFO 00:18:40,091 Exporting for Nigeria at level: Project (ExportPivotViewService.java [20825862@qtp-31931917-13]) * INFO 00:18:40,093 DataMart export request from admin @ 127.0.0.1 (ExportDataMartAction.java [7699298@qtp-31931917-8]) * INFO 00:18:40,104 DataMart export request from admin @ 127.0.0.1 (ExportDataMartAction.java [22610021@qtp-31931917-11]) * INFO 00:18:40,107 no periods to export (ExportPivotViewService.java [2069949@qtp-31931917-10]) * INFO 00:18:40,140 Exporting for Nigeria at level: Project (ExportPivotViewService.java [21122439@qtp-31931917-7]) * INFO 00:18:40,145 Exporting for Nigeria at level: Project (ExportPivotViewService.java [23751133@qtp-31931917-12]) * INFO 00:18:40,173 Exporting for Nigeria at level: Project (ExportPivotViewService.java [7699298@qtp-31931917-8]) * INFO 00:18:40,189 DataMart export request from admin @ 127.0.0.1 (ExportDataMartAction.java [19253096@qtp-31931917-9]) * INFO 00:18:40,198 Exporting for Nigeria at level: Project (ExportPivotViewService.java [22610021@qtp-31931917-11]) * INFO 00:18:40,221 no periods to export (ExportPivotViewService.java [19253096@qtp-31931917-9]) * INFO 00:21:42,418 Graceful shutdown... (TrayApp.java [AWT-EventQueue-0]) * INFO 00:21:42,419 Lifecycle: server stopping (TrayApp.java [AWT-EventQueue-0]) * INFO 00:21:42,448 De-registering jdbc driver: sun.jdbc.odbc.JdbcOdbcDriver@608f91 (StartupListener.java [AWT-EventQueue-0]) * INFO 00:21:42,448 De-registering jdbc driver: org.hsqldb.jdbc.JDBCDriver@8392b5 (StartupListener.java [AWT-EventQueue-0]) * INFO 00:21:42,448 De-registering jdbc driver: com.mysql.jdbc.Driver@acb53c (StartupListener.java [AWT-EventQueue-0]) * INFO 00:21:42,449 De-registering jdbc driver: org.postgresql.Driver@11ad2ea (StartupListener.java [AWT-EventQueue-0]) * INFO 00:21:42,449 De-registering jdbc driver: org.h2.Driver@d829b1 (StartupListener.java [AWT-EventQueue-0]) * INFO 00:21:42,476 Camel context stopped (DHIS2LifecycleStrategy.java [AWT-EventQueue-0]) * INFO 00:21:42,620 Lifecycle: server stopped (TrayApp.java [AWT-EventQueue-0]) * INFO 00:21:42,652 Exiting... (TrayApp.java [AWT-EventQueue-0]) * INFO 08:47:33,979 Environment variable DHIS2_HOME: null (TrayApp.java [main]) * INFO 08:47:34,088 Initialising DHIS 2 Live... (TrayApp.java [main]) * INFO 08:47:34,291 Loading DHIS 2 on port: 8082 (WebAppServer.java [main]) * INFO 08:47:34,338 Setting DHIS 2 web app context to: /C:/dhis2-live-2.8/dhis-live/webapps/dhis (WebAppServer.java [main]) * INFO 08:47:34,353 Lifecycle: server starting (TrayApp.java [Thread-2]) * INFO 08:47:57,051 System property dhis2.home points to /C:/dhis2-live-2.8/dhis-live/conf (DefaultLocationManager.java [Thread-2]) * INFO 08:48:29,752 Found the following message senders: [org.hisp.dhis.message.EmailMessageSender@157b620] (DefaultMessageService.java [Thread-2]) * INFO 08:48:42,950 Camel context started (DHIS2LifecycleStrategy.java [Thread-2]) * INFO 08:48:43,293 Camel endpoint added: spring-event://default (DHIS2LifecycleStrategy.java [Thread-2]) * INFO 08:48:43,308 Executing startup routine [1 of 9, runlevel 1]: TableAlteror (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 08:48:43,698 Tables updated (TableAlteror.java [Thread-2]) * INFO 08:48:43,714 Executing startup routine [2 of 9, runlevel 2]: IdentityPopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 08:48:43,714 Executing startup routine [3 of 9, runlevel 2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 08:48:44,260 Executing startup routine [4 of 9, runlevel 3]: TableCreator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 08:48:44,307 Executing startup routine [5 of 9, runlevel 3]: DataElementDefaultDimensionPopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 08:48:44,354 Linked default category with default concept (DataElementDefaultDimensionPopulator.java [Thread-2]) * INFO 08:48:44,385 Executing startup routine [6 of 9, runlevel 4]: PatientTableAlteror (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 08:48:44,400 Executing startup routine [7 of 9, runlevel 5]: OrganisationUnitGroupSetPopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 08:48:44,400 Executing startup routine [8 of 9, runlevel 5]: DataEntryFormUpgrader (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 08:48:44,400 Upgraded custom case entry form identifiers: 0 (DataEntryFormUpgrader.java [Thread-2]) * INFO 08:48:44,400 Executing startup routine [9 of 9, runlevel 5]: ProgramAttributePopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 08:48:44,400 All startup routines done (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 08:48:53,168 Lifecycle: server started (TrayApp.java [Thread-2]) * INFO 17:00:04,916 Graceful shutdown... (TrayApp.java [AWT-EventQueue-0]) * INFO 17:00:04,947 Lifecycle: server stopping (TrayApp.java [AWT-EventQueue-0]) * INFO 17:00:05,867 De-registering jdbc driver: sun.jdbc.odbc.JdbcOdbcDriver@b42b66 (StartupListener.java [AWT-EventQueue-0]) * INFO 17:00:05,883 De-registering jdbc driver: org.hsqldb.jdbc.JDBCDriver@7c9f6b (StartupListener.java [AWT-EventQueue-0]) * INFO 17:00:05,883 De-registering jdbc driver: com.mysql.jdbc.Driver@70be2b (StartupListener.java [AWT-EventQueue-0]) * INFO 17:00:05,898 De-registering jdbc driver: org.postgresql.Driver@124f571 (StartupListener.java [AWT-EventQueue-0]) * INFO 17:00:05,914 De-registering jdbc driver: org.h2.Driver@1f56830 (StartupListener.java [AWT-EventQueue-0]) * INFO 17:00:10,859 Camel context stopped (DHIS2LifecycleStrategy.java [AWT-EventQueue-0]) * INFO 17:00:11,920 Lifecycle: server stopped (TrayApp.java [AWT-EventQueue-0]) * INFO 17:00:11,951 Exiting... (TrayApp.java [AWT-EventQueue-0]) * INFO 03:04:12,538 Environment variable DHIS2_HOME: null (TrayApp.java [main]) * INFO 03:04:13,037 Initialising DHIS 2 Live... (TrayApp.java [main]) * INFO 03:04:14,207 Loading DHIS 2 on port: 8082 (WebAppServer.java [main]) * INFO 03:04:14,582 Setting DHIS 2 web app context to: /C:/dhis2-live-2.8/dhis-live/webapps/dhis (WebAppServer.java [main]) * INFO 03:04:14,613 Lifecycle: server starting (TrayApp.java [Thread-2]) * INFO 03:04:32,948 System property dhis2.home points to /C:/dhis2-live-2.8/dhis-live/conf (DefaultLocationManager.java [Thread-2]) * INFO 03:05:08,004 Found the following message senders: [org.hisp.dhis.message.EmailMessageSender@91da40] (DefaultMessageService.java [Thread-2]) * INFO 03:05:21,195 Camel context started (DHIS2LifecycleStrategy.java [Thread-2]) * INFO 03:05:21,507 Camel endpoint added: spring-event://default (DHIS2LifecycleStrategy.java [Thread-2]) * INFO 03:05:21,523 Executing startup routine [1 of 9, runlevel 1]: TableAlteror (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 03:05:22,194 Tables updated (TableAlteror.java [Thread-2]) * INFO 03:05:22,194 Executing startup routine [2 of 9, runlevel 2]: IdentityPopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 03:05:22,256 Executing startup routine [3 of 9, runlevel 2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 03:05:22,334 Executing startup routine [4 of 9, runlevel 3]: TableCreator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 03:05:22,911 Executing startup routine [5 of 9, runlevel 3]: DataElementDefaultDimensionPopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 03:05:23,005 Linked default category with default concept (DataElementDefaultDimensionPopulator.java [Thread-2]) * INFO 03:05:23,052 Executing startup routine [6 of 9, runlevel 4]: PatientTableAlteror (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 03:05:23,052 Executing startup routine [7 of 9, runlevel 5]: OrganisationUnitGroupSetPopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 03:05:23,067 Executing startup routine [8 of 9, runlevel 5]: DataEntryFormUpgrader (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 03:05:23,067 Upgraded custom case entry form identifiers: 0 (DataEntryFormUpgrader.java [Thread-2]) * INFO 03:05:23,067 Executing startup routine [9 of 9, runlevel 5]: ProgramAttributePopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 03:05:23,067 All startup routines done (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 03:05:31,039 Lifecycle: server started (TrayApp.java [Thread-2]) * INFO 03:05:58,386 User login success: 'admin' (DefaultUserAuditService.java [4256705@qtp-7683106-0]) * ERROR 03:06:01,217 Error while reading RSS, you are probably not connected to the internet (RssContentProvider.java [25015104@qtp-7683106-5]) java.net.UnknownHostException: news.yahoo.com at java.net.AbstractPlainSocketImpl.connect(Unknown Source) at java.net.PlainSocketImpl.connect(Unknown Source) at java.net.SocksSocketImpl.connect(Unknown Source) at java.net.Socket.connect(Unknown Source) at java.net.Socket.connect(Unknown Source) at sun.net.NetworkClient.doConnect(Unknown Source) at sun.net.www.http.HttpClient.openServer(Unknown Source) at sun.net.www.http.HttpClient.openServer(Unknown Source) at sun.net.www.http.HttpClient.(Unknown Source) at sun.net.www.http.HttpClient.New(Unknown Source) at sun.net.www.http.HttpClient.New(Unknown Source) at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(Unknown Source) at sun.net.www.protocol.http.HttpURLConnection.plainConnect(Unknown Source) at sun.net.www.protocol.http.HttpURLConnection.connect(Unknown Source) at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source) at org.springframework.core.io.UrlResource.getInputStream(UrlResource.java:124) at org.hisp.dhis.dashboard.provider.RssContentProvider.getRss(RssContentProvider.java:101) at org.hisp.dhis.dashboard.provider.RssContentProvider.provide(RssContentProvider.java:86) at org.hisp.dhis.dashboard.manager.DefaultDashboardManager.getContent(DefaultDashboardManager.java:101) at org.hisp.dhis.dashboard.action.ProvideContentAction.execute(ProvideContentAction.java:126) 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 com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:453) at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:292) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:255) at org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:87) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) at org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:90) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) at org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:96) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) at org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:118) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) at org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:81) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) at org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettingInterceptor.java:89) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) at org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:88) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) at org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInterceptor.java:84) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) at org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterceptor.java:103) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) at org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:137) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:211) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:190) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) at org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:100) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54) at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:510) at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:434) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:101) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:119) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:440) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:326) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:926) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) * INFO 03:08:29,644 User login success: 'admin' (DefaultUserAuditService.java [19735831@qtp-7683106-7]) * INFO 03:09:01,953 DataMart export request from admin @ 127.0.0.1 (ExportDataMartAction.java [9815756@qtp-7683106-6]) * INFO 03:09:01,963 DataMart export request from admin @ 127.0.0.1 (ExportDataMartAction.java [4256705@qtp-7683106-0]) * INFO 03:09:02,093 DataMart export request from admin @ 127.0.0.1 (ExportDataMartAction.java [9904659@qtp-7683106-3]) * INFO 03:09:02,093 Exporting for Nigeria at level: Project (ExportPivotViewService.java [4256705@qtp-7683106-0]) * INFO 03:09:02,103 Exporting for Nigeria at level: Project (ExportPivotViewService.java [9815756@qtp-7683106-6]) * INFO 03:09:02,103 DataMart export request from admin @ 127.0.0.1 (ExportDataMartAction.java [19735831@qtp-7683106-7]) * INFO 03:09:02,163 Exporting for Nigeria at level: Project (ExportPivotViewService.java [19735831@qtp-7683106-7]) * INFO 03:09:02,173 Exporting for Nigeria at level: Project (ExportPivotViewService.java [9904659@qtp-7683106-3]) * INFO 16:55:34,813 Environment variable DHIS2_HOME: null (TrayApp.java [main]) * INFO 16:55:35,578 Initialising DHIS 2 Live... (TrayApp.java [main]) * INFO 16:55:36,858 Loading DHIS 2 on port: 8082 (WebAppServer.java [main]) * INFO 16:55:37,098 Setting DHIS 2 web app context to: /C:/dhis2-live-2.8/dhis-live/webapps/dhis (WebAppServer.java [main]) * INFO 16:55:37,116 Lifecycle: server starting (TrayApp.java [Thread-2]) * INFO 16:55:58,318 System property dhis2.home points to /C:/dhis2-live-2.8/dhis-live/conf (DefaultLocationManager.java [Thread-2]) * INFO 16:56:58,232 Found the following message senders: [org.hisp.dhis.message.EmailMessageSender@cd9511] (DefaultMessageService.java [Thread-2]) * INFO 16:57:11,096 Camel context started (DHIS2LifecycleStrategy.java [Thread-2]) * INFO 16:57:11,446 Camel endpoint added: spring-event://default (DHIS2LifecycleStrategy.java [Thread-2]) * INFO 16:57:11,466 Executing startup routine [1 of 9, runlevel 1]: TableAlteror (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 16:57:11,836 Tables updated (TableAlteror.java [Thread-2]) * INFO 16:57:11,836 Executing startup routine [2 of 9, runlevel 2]: IdentityPopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 16:57:11,896 Executing startup routine [3 of 9, runlevel 2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 16:57:11,936 Executing startup routine [4 of 9, runlevel 3]: TableCreator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 16:57:12,006 Executing startup routine [5 of 9, runlevel 3]: DataElementDefaultDimensionPopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 16:57:12,066 Linked default category with default concept (DataElementDefaultDimensionPopulator.java [Thread-2]) * INFO 16:57:12,126 Executing startup routine [6 of 9, runlevel 4]: PatientTableAlteror (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 16:57:12,136 Executing startup routine [7 of 9, runlevel 5]: OrganisationUnitGroupSetPopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 16:57:12,136 Executing startup routine [8 of 9, runlevel 5]: DataEntryFormUpgrader (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 16:57:12,146 Upgraded custom case entry form identifiers: 0 (DataEntryFormUpgrader.java [Thread-2]) * INFO 16:57:12,146 Executing startup routine [9 of 9, runlevel 5]: ProgramAttributePopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 16:57:12,146 All startup routines done (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 16:57:20,404 Lifecycle: server started (TrayApp.java [Thread-2]) * INFO 08:32:18,124 User login success: 'admin' (DefaultUserAuditService.java [29468299@qtp-21951033-0]) * ERROR 08:32:34,161 Error while reading RSS, you are probably not connected to the internet (RssContentProvider.java [29468299@qtp-21951033-0]) java.net.UnknownHostException: news.yahoo.com at java.net.AbstractPlainSocketImpl.connect(Unknown Source) at java.net.PlainSocketImpl.connect(Unknown Source) at java.net.SocksSocketImpl.connect(Unknown Source) at java.net.Socket.connect(Unknown Source) at java.net.Socket.connect(Unknown Source) at sun.net.NetworkClient.doConnect(Unknown Source) at sun.net.www.http.HttpClient.openServer(Unknown Source) at sun.net.www.http.HttpClient.openServer(Unknown Source) at sun.net.www.http.HttpClient.(Unknown Source) at sun.net.www.http.HttpClient.New(Unknown Source) at sun.net.www.http.HttpClient.New(Unknown Source) at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(Unknown Source) at sun.net.www.protocol.http.HttpURLConnection.plainConnect(Unknown Source) at sun.net.www.protocol.http.HttpURLConnection.connect(Unknown Source) at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source) at org.springframework.core.io.UrlResource.getInputStream(UrlResource.java:124) at org.hisp.dhis.dashboard.provider.RssContentProvider.getRss(RssContentProvider.java:101) at org.hisp.dhis.dashboard.provider.RssContentProvider.provide(RssContentProvider.java:86) at org.hisp.dhis.dashboard.manager.DefaultDashboardManager.getContent(DefaultDashboardManager.java:101) at org.hisp.dhis.dashboard.action.ProvideContentAction.execute(ProvideContentAction.java:126) 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 com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:453) at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:292) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:255) at org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:87) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) at org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:90) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) at org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:96) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) at org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:118) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) at org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:81) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) at org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettingInterceptor.java:89) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) at org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:88) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) at org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInterceptor.java:84) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) at org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterceptor.java:103) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) at org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:137) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:211) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:190) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) at org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:100) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249) at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54) at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:510) at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:434) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:101) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:119) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:440) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:326) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:926) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) * INFO 08:34:00,115 Content-type: application/octet-stream, filename: C:\Users\DGM\AppData\Local\Temp\Jetty_0_0_0_0_8082_dhis____.jo8ie7\upload__3ab25c6e_138560f4d6f__8000_00000001.tmp (ImportAction.java [8560525@qtp-21951033-4]) * INFO 08:34:00,146 Internal process started (AbstractStatementInternalProcess.java [Thread-32]) * INFO 08:34:00,147 Importing stream (DefaultImportService.java [Thread-32]) * INFO 08:34:00,499 Transforming stream (DefaultImportService.java [Thread-32]) * INFO 08:34:00,501 File C:\dhis2-live-2.8\dhis-live\conf\transform\transforms.xml does not exist (DefaultLocationManager.java [Thread-32]) * INFO 08:34:00,666 Loading transformer from classpath: gml2dxf.xsl (LocManagerXSLTLocator.java [Thread-32]) * INFO 08:34:05,424 Transform successful (DefaultImportService.java [Thread-32]) * INFO 08:34:05,487 Deleted previewed objects (DXFConverter.java [Thread-32]) * ERROR 08:34:05,612 Internal process failed (AbstractStatementInternalProcess.java [Thread-32]) java.lang.NullPointerException at org.hisp.dhis.organisationunit.OrganisationUnit.equals(OrganisationUnit.java:552) at org.hibernate.type.descriptor.java.SerializableTypeDescriptor.areEqual(SerializableTypeDescriptor.java:86) at org.hibernate.type.descriptor.java.SerializableTypeDescriptor.areEqual(SerializableTypeDescriptor.java:39) at org.hibernate.type.AbstractStandardBasicType.isEqual(AbstractStandardBasicType.java:196) at org.hibernate.type.AbstractStandardBasicType.isSame(AbstractStandardBasicType.java:186) at org.hibernate.type.AbstractStandardBasicType.isDirty(AbstractStandardBasicType.java:222) at org.hibernate.type.AbstractStandardBasicType.isDirty(AbstractStandardBasicType.java:218) at org.hibernate.type.TypeHelper.findDirty(TypeHelper.java:294) at org.hibernate.persister.entity.AbstractEntityPersister.findDirty(AbstractEntityPersister.java:3820) at org.hibernate.event.internal.DefaultFlushEntityEventListener.dirtyCheck(DefaultFlushEntityEventListener.java:536) at org.hibernate.event.internal.DefaultFlushEntityEventListener.isUpdateNecessary(DefaultFlushEntityEventListener.java:243) at org.hibernate.event.internal.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:172) at org.hibernate.event.internal.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:225) at org.hibernate.event.internal.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:99) at org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:55) at org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1099) at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1528) at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:374) at org.hibernate.internal.CriteriaImpl.uniqueResult(CriteriaImpl.java:396) at org.hisp.dhis.hibernate.HibernateGenericStore.getObject(HibernateGenericStore.java:175) at org.hisp.dhis.hibernate.HibernateGenericStore.getByName(HibernateGenericStore.java:235) at org.hisp.dhis.organisationunit.DefaultOrganisationUnitService.getOrganisationUnitByName(DefaultOrganisationUnitService.java:202) 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:318) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at $Proxy56.getOrganisationUnitByName(Unknown Source) at org.hisp.dhis.importexport.importer.OrganisationUnitImporter.getMatching(OrganisationUnitImporter.java:94) at org.hisp.dhis.importexport.importer.OrganisationUnitImporter.getMatching(OrganisationUnitImporter.java:44) at org.hisp.dhis.importexport.importer.AbstractImporter.read(AbstractImporter.java:84) at org.hisp.dhis.importexport.importer.OrganisationUnitImporter.importObject(OrganisationUnitImporter.java:64) at org.hisp.dhis.importexport.dxf.converter.OrganisationUnitConverter.read(OrganisationUnitConverter.java:239) at org.hisp.dhis.importexport.invoker.DefaultConverterInvoker.invokeRead(DefaultConverterInvoker.java:45) 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:318) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at $Proxy111.invokeRead(Unknown Source) at org.hisp.dhis.importexport.dxf.converter.DXFConverter.read(DXFConverter.java:783) at org.hisp.dhis.importexport.DefaultImportService.importData(DefaultImportService.java:186) at org.hisp.dhis.importexport.ImportInternalProcess.executeStatements(ImportInternalProcess.java:89) at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:103) at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:40) at org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:125) at java.lang.Thread.run(Unknown Source) * INFO 12:39:21,839 Environment variable DHIS2_HOME: null (TrayApp.java [main]) * INFO 12:39:21,870 Initialising DHIS 2 Live... (TrayApp.java [main]) * INFO 12:39:22,026 Loading DHIS 2 on port: 8082 (WebAppServer.java [main]) * INFO 12:39:22,088 Setting DHIS 2 web app context to: /C:/dhis2-live-2.8/dhis-live/webapps/dhis (WebAppServer.java [main]) * INFO 12:39:22,088 Lifecycle: server starting (TrayApp.java [Thread-2]) * INFO 12:39:41,684 System property dhis2.home points to /C:/dhis2-live-2.8/dhis-live/conf (DefaultLocationManager.java [Thread-2]) * INFO 12:40:37,623 Found the following message senders: [org.hisp.dhis.message.EmailMessageSender@cee8b1] (DefaultMessageService.java [Thread-2]) * INFO 12:40:50,669 Camel context started (DHIS2LifecycleStrategy.java [Thread-2]) * INFO 12:40:51,121 Camel endpoint added: spring-event://default (DHIS2LifecycleStrategy.java [Thread-2]) * INFO 12:40:51,137 Executing startup routine [1 of 9, runlevel 1]: TableAlteror (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 12:40:51,589 Tables updated (TableAlteror.java [Thread-2]) * INFO 12:40:51,589 Executing startup routine [2 of 9, runlevel 2]: IdentityPopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 12:40:51,652 Executing startup routine [3 of 9, runlevel 2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 12:40:51,745 Executing startup routine [4 of 9, runlevel 3]: TableCreator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 12:40:51,808 Executing startup routine [5 of 9, runlevel 3]: DataElementDefaultDimensionPopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 12:40:51,870 Linked default category with default concept (DataElementDefaultDimensionPopulator.java [Thread-2]) * INFO 12:40:51,901 Executing startup routine [6 of 9, runlevel 4]: PatientTableAlteror (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 12:40:51,917 Executing startup routine [7 of 9, runlevel 5]: OrganisationUnitGroupSetPopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 12:40:51,917 Executing startup routine [8 of 9, runlevel 5]: DataEntryFormUpgrader (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 12:40:51,917 Upgraded custom case entry form identifiers: 0 (DataEntryFormUpgrader.java [Thread-2]) * INFO 12:40:51,917 Executing startup routine [9 of 9, runlevel 5]: ProgramAttributePopulator (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 12:40:51,917 All startup routines done (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 12:41:00,448 Lifecycle: server started (TrayApp.java [Thread-2]) * INFO 12:52:41,242 User login success: 'admin' (DefaultUserAuditService.java [12512205@qtp-21290107-0]) * INFO 12:57:16,152 Content-type: application/octet-stream, filename: C:\Users\DGM\AppData\Local\Temp\Jetty_0_0_0_0_8082_dhis____.jo8ie7\upload_6ac866a_1385c26b0e8__8000_00000001.tmp (ImportAction.java [9006607@qtp-21290107-7]) * INFO 12:57:16,184 Internal process started (AbstractStatementInternalProcess.java [Thread-28]) * INFO 12:57:16,185 Importing stream (DefaultImportService.java [Thread-28]) * INFO 12:57:16,190 Transforming stream (DefaultImportService.java [Thread-28]) * INFO 12:57:16,192 File C:\dhis2-live-2.8\dhis-live\conf\transform\transforms.xml does not exist (DefaultLocationManager.java [Thread-28]) * INFO 12:57:17,209 Loading transformer from classpath: gml2dxf.xsl (LocManagerXSLTLocator.java [Thread-28]) * INFO 12:57:21,203 Transform successful (DefaultImportService.java [Thread-28]) * INFO 12:57:21,242 Deleted previewed objects (DXFConverter.java [Thread-28]) * ERROR 12:57:21,463 Internal process failed (AbstractStatementInternalProcess.java [Thread-28]) org.hibernate.exception.DataException: Value too long for column "OBJECT BINARY(65535)": "X'aced00057372002f6f72672e686973702e646869732e6f7267616e69736174696f6e756e69742e4f7267616e69736174696f6e556e6974110bcade4098be5b... (102690)"; SQL statement: insert into importobject (importobjectid, status, classname, groupmembertype, object, compareobject) values (null, ?, ?, ?, ?, ?) [22001-154] at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:134) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110) at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129) at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81) at $Proxy123.executeUpdate(Unknown Source) at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:96) at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:58) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2764) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3275) at org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:81) at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:362) at org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:203) at org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:183) at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:167) at org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:320) at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:287) at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:193) at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:126) at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:204) at org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:55) at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:189) at org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:49) at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:90) at org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:670) at org.hibernate.internal.SessionImpl.save(SessionImpl.java:662) at org.hibernate.internal.SessionImpl.save(SessionImpl.java:658) at org.hisp.dhis.importexport.hibernate.HibernateImportObjectStore.addImportObject(HibernateImportObjectStore.java:72) at org.hisp.dhis.importexport.service.DefaultImportObjectService.addImportObject(DefaultImportObjectService.java:240) 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:318) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at $Proxy110.addImportObject(Unknown Source) at org.hisp.dhis.importexport.importer.AbstractImporter.read(AbstractImporter.java:121) at org.hisp.dhis.importexport.importer.OrganisationUnitImporter.importObject(OrganisationUnitImporter.java:64) at org.hisp.dhis.importexport.dxf.converter.OrganisationUnitConverter.read(OrganisationUnitConverter.java:239) at org.hisp.dhis.importexport.invoker.DefaultConverterInvoker.invokeRead(DefaultConverterInvoker.java:45) 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:318) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at $Proxy111.invokeRead(Unknown Source) at org.hisp.dhis.importexport.dxf.converter.DXFConverter.read(DXFConverter.java:783) at org.hisp.dhis.importexport.DefaultImportService.importData(DefaultImportService.java:186) at org.hisp.dhis.importexport.ImportInternalProcess.executeStatements(ImportInternalProcess.java:89) at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:103) at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:40) at org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:125) at java.lang.Thread.run(Unknown Source) Caused by: org.h2.jdbc.JdbcSQLException: Value too long for column "OBJECT BINARY(65535)": "X'aced00057372002f6f72672e686973702e646869732e6f7267616e69736174696f6e756e69742e4f7267616e69736174696f6e556e6974110bcade4098be5b... (102690)"; SQL statement: insert into importobject (importobjectid, status, classname, groupmembertype, object, compareobject) values (null, ?, ?, ?, ?, ?) [22001-154] at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) at org.h2.message.DbException.get(DbException.java:167) at org.h2.table.Column.validateConvertUpdateSequence(Column.java:319) at org.h2.table.Table.validateConvertUpdateSequence(Table.java:669) at org.h2.command.dml.Insert.insertRows(Insert.java:122) at org.h2.command.dml.Insert.update(Insert.java:86) at org.h2.command.CommandContainer.update(CommandContainer.java:69) at org.h2.command.Command.executeUpdate(Command.java:212) at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:143) at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:129) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105) 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.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122) ... 58 more