rfriedman@debbie-birx:~$ cd dhis-live
rfriedman@debbie-birx:~/dhis-live$ ./startup.sh
Starting DHIS2 live ...
* INFO  14:59:21,246 Environment variable DHIS2_HOME: null (TrayApp.java [main])
* INFO  14:59:21,362 Initialising DHIS 2 Live... (TrayApp.java [main])
* INFO  14:59:21,478 Loading DHIS 2 on port: 8082 (WebAppServer.java [main])
2013-06-13 14:59:21.490:INFO::Logging to STDERR via org.mortbay.log.StdErrLog
* INFO  14:59:21,529 Setting DHIS 2 web app context to: /home/rfriedman/dhis-live/webapps/dhis (WebAppServer.java [main])
* INFO  14:59:21,530 Lifecycle: server starting (TrayApp.java [Thread-2])
2013-06-13 14:59:21.615:INFO::jetty-6.1.x
2013-06-13 14:59:21.913:INFO::NO JSP Support for /, did not find org.apache.jasper.servlet.JspServlet
2013-06-13 14:59:22.551:INFO:/:Initializing Spring root WebApplicationContext
* INFO  14:59:28,810 System property dhis2.home points to /home/rfriedman/dhis-live/conf (DefaultLocationManager.java [Thread-2])
* WARN  14:59:40,815 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.smscommand.SMSCode]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* WARN  14:59:40,853 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.interpretation.Interpretation]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* WARN  14:59:40,919 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.smscommand.SMSCommand]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* WARN  14:59:41,091 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.period.RelativePeriods]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* WARN  14:59:41,162 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.program.ProgramExpression]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* WARN  14:59:41,168 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.interpretation.InterpretationComment]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* WARN  14:59:41,347 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.dataelement.DataElementCategoryDimension.items]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* WARN  14:59:41,350 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.dataelement.DataElementGroupSet.userGroupAccesses]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* WARN  14:59:41,352 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.indicator.Indicator.userGroupAccesses]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* WARN  14:59:41,356 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.reporttable.ReportTable.userGroupAccesses]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* WARN  14:59:41,359 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.patientreport.PatientTabularReport.userGroupAccesses]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* WARN  14:59:41,361 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.dataelement.DataElementCategoryOption.categories]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* WARN  14:59:41,363 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.user.UserGroup.attributeValues]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* WARN  14:59:41,365 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.indicator.IndicatorGroupSet.userGroupAccesses]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* WARN  14:59:41,367 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.dataelement.DataElementGroup.userGroupAccesses]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* WARN  14:59:41,370 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.dataelement.DataElementGroup.attributeValues]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* WARN  14:59:41,372 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.indicator.IndicatorGroup.userGroupAccesses]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* WARN  14:59:41,375 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.user.UserGroup.userGroupAccesses]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* WARN  14:59:41,378 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.mapping.Map.userGroupAccesses]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* WARN  14:59:41,381 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.dataset.DataSet.organisationUnitGroups]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* WARN  14:59:41,383 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.program.Program.userGroupAccesses]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* WARN  14:59:41,386 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.chart.Chart.userGroupAccesses]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* WARN  14:59:41,401 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.patientreport.PatientAggregateReport.userGroupAccesses]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* WARN  14:59:41,404 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.datadictionary.DataDictionary.userGroupAccesses]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* WARN  14:59:41,407 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.dataset.DataSet.userGroupAccesses]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* WARN  14:59:41,409 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.patientreport.PatientTabularReport.organisationUnits]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* WARN  14:59:41,411 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.document.Document.userGroupAccesses]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* WARN  14:59:41,415 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.report.Report.userGroupAccesses]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* WARN  14:59:41,417 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.organisationunit.OrganisationUnitGroup.dataSets]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* WARN  14:59:41,423 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.user.User.groups]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* WARN  14:59:41,433 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.organisationunit.OrganisationUnitGroup.attributeValues]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* WARN  14:59:41,440 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.smscommand.SMSCommand.codes]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* WARN  14:59:41,444 HHH020003: Could not find a specific ehcache configuration for cache named [org.hisp.dhis.indicator.IndicatorGroup.attributeValues]; using defaults. (AbstractEhcacheRegionFactory.java [Thread-2])
* ERROR 14:59:42,991 HHH000388: Unsuccessful: alter table dataelementcategoryoption add constraint fk_dataelementcategory_conceptid foreign key (conceptid) references concept (SchemaUpdate.java [Thread-2])
* ERROR 14:59:42,992 Constraint "FK_DATAELEMENTCATEGORY_CONCEPTID" already exists; SQL statement:
alter table dataelementcategoryoption add constraint fk_dataelementcategory_conceptid foreign key (conceptid) references concept [90045-166] (SchemaUpdate.java [Thread-2])
* ERROR 14:59:42,998 HHH000388: Unsuccessful: alter table interpretationcomment add constraint fk_interpretation_userid foreign key (userid) references userinfo (SchemaUpdate.java [Thread-2])
* ERROR 14:59:43,008 Constraint "FK_INTERPRETATION_USERID" already exists; SQL statement:
alter table interpretationcomment add constraint fk_interpretation_userid foreign key (userid) references userinfo [90045-166] (SchemaUpdate.java [Thread-2])
* ERROR 14:59:43,015 HHH000388: Unsuccessful: alter table patienttabularreport add constraint fk_patientaggregatereport_programstage foreign key (programstageid) references programstage (SchemaUpdate.java [Thread-2])
* ERROR 14:59:43,024 Constraint "FK_PATIENTAGGREGATEREPORT_PROGRAMSTAGE" already exists; SQL statement:
alter table patienttabularreport add constraint fk_patientaggregatereport_programstage foreign key (programstageid) references programstage [90045-166] (SchemaUpdate.java [Thread-2])
* ERROR 14:59:43,031 HHH000388: Unsuccessful: alter table report add constraint fk_report_relativeperiodsid foreign key (relativeperiodsid) references relativeperiods (SchemaUpdate.java [Thread-2])
* ERROR 14:59:43,043 Constraint "FK_REPORT_RELATIVEPERIODSID" already exists; SQL statement:
alter table report add constraint fk_report_relativeperiodsid foreign key (relativeperiodsid) references relativeperiods [90045-166] (SchemaUpdate.java [Thread-2])
* ERROR 14:59:43,057 HHH000388: Unsuccessful: alter table reporttable add constraint fk_report_relativeperiodsid foreign key (relativeperiodsid) references relativeperiods (SchemaUpdate.java [Thread-2])
* ERROR 14:59:43,059 Constraint "FK_REPORT_RELATIVEPERIODSID" already exists; SQL statement:
alter table reporttable add constraint fk_report_relativeperiodsid foreign key (relativeperiodsid) references relativeperiods [90045-166] (SchemaUpdate.java [Thread-2])
* ERROR 14:59:43,065 HHH000388: Unsuccessful: alter table usergroupmembers add constraint fk_usergroup_userid foreign key (userid) references userinfo (SchemaUpdate.java [Thread-2])
* ERROR 14:59:43,072 Constraint "FK_USERGROUP_USERID" already exists; SQL statement:
alter table usergroupmembers add constraint fk_usergroup_userid foreign key (userid) references userinfo [90045-166] (SchemaUpdate.java [Thread-2])
* INFO  14:59:47,098 Found the following message senders: [org.hisp.dhis.sms.outbound.SmsSender@7f7d58, org.hisp.dhis.message.EmailMessageSender@7fe8ac] (DefaultMessageService.java [Thread-2])
* INFO  14:59:59,839 Camel context started (DHIS2LifecycleStrategy.java [Thread-2])
* INFO  14:59:59,840 Searching for routes in directory: /home/rfriedman/dhis-live/conf/routes (DHIS2LifecycleStrategy.java [Thread-2])
* INFO  15:00:01,501 Executing startup routine [1 of 10, runlevel 1]: TableAlteror (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO  15:00:01,765 Tables updated (TableAlteror.java [Thread-2])
* INFO  15:00:01,766 Executing startup routine [2 of 10, runlevel 1]: MapViewUpgrader (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO  15:00:01,777 Executing startup routine [3 of 10, runlevel 2]: IdentityPopulator (DefaultStartupRoutineExecutor.java [Thread-2])
2013-06-13 15:00:02.006:WARN::Failed startup of context org.mortbay.jetty.webapp.WebAppContext@1664de3{/,/home/rfriedman/dhis-live/webapps/dhis}
java.lang.RuntimeException: Failed to run startup routines: StatementCallback; uncategorized SQLException for SQL [ALTER TABLE chart ADD CONSTRAINT chart_uid_key UNIQUE(uid)]; SQL state [90045]; error code [90045]; Constraint "CHART_UID_KEY" already exists; SQL statement:|ALTER TABLE chart ADD CONSTRAINT chart_uid_key UNIQUE(uid) [90045-166]; nested exception is org.h2.jdbc.JdbcSQLException: Constraint "CHART_UID_KEY" already exists; SQL statement:|ALTER TABLE chart ADD CONSTRAINT chart_uid_key UNIQUE(uid) [90045-166]
	at org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:70)
	at org.mortbay.jetty.handler.ContextHandler.startContext(ContextHandler.java:548)
	at org.mortbay.jetty.servlet.Context.startContext(Context.java:136)
	at org.mortbay.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1272)
	at org.mortbay.jetty.handler.ContextHandler.doStart(ContextHandler.java:517)
	at org.mortbay.jetty.webapp.WebAppContext.doStart(WebAppContext.java:489)
	at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
	at org.mortbay.jetty.handler.HandlerWrapper.doStart(HandlerWrapper.java:130)
	at org.mortbay.jetty.Server.doStart(Server.java:224)
	at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
	at org.hisp.dhis.WebAppServer.run(WebAppServer.java:110)
2013-06-13 15:00:02.029:INFO::Started SelectChannelConnector@0.0.0.0:8082
* INFO  15:00:02,030 Lifecycle: server started (TrayApp.java [Thread-2])
* INFO  15:01:18,225 Graceful shutdown... (TrayApp.java [AWT-EventQueue-0])
* INFO  15:01:18,233 Lifecycle: server stopping (TrayApp.java [AWT-EventQueue-0])
2013-06-13 15:01:18.233:INFO::Stopped SelectChannelConnector@0.0.0.0:8082
* INFO  15:01:18,240 De-registering jdbc driver: com.mysql.jdbc.Driver@d642fd (StartupListener.java [AWT-EventQueue-0])
* INFO  15:01:18,240 De-registering jdbc driver: org.hsqldb.jdbc.JDBCDriver@1e68ce4 (StartupListener.java [AWT-EventQueue-0])
* INFO  15:01:18,240 De-registering jdbc driver: org.postgresql.Driver@16e14f9 (StartupListener.java [AWT-EventQueue-0])
* INFO  15:01:18,241 De-registering jdbc driver: org.h2.Driver@22ed4b (StartupListener.java [AWT-EventQueue-0])
2013-06-13 15:01:18.241:INFO:/:Closing Spring root WebApplicationContext
* INFO  15:01:18,324 Camel context stopped (DHIS2LifecycleStrategy.java [AWT-EventQueue-0])
* INFO  15:01:18,388 Lifecycle: server stopped (TrayApp.java [AWT-EventQueue-0])
* INFO  15:01:18,405 Exiting... (TrayApp.java [AWT-EventQueue-0])
DHIS2 live exited normally
rfriedman@debbie-birx:~/dhis-live$