Problem starting DHIS2 Live

Hello,

I've had many configurations running on my machine, but currently I
seem unable to get DHIS2 Live to start.

Firefox tells me this:

HTTP ERROR: 503

Problem accessing /. Reason:

    SERVICE_UNAVAILABLE

Powered by Jetty://

But there is little info in the log below - It seems to skip all
startup steps after the first two, perhaps because it cannot connect
to a db?

* INFO 09:51:02,924 Environment variable DHIS2_HOME: null (TrayApp.java [main])
* INFO 09:51:02,955 Initialising DHIS 2 Live... (TrayApp.java [main])
* INFO 09:51:03,064 Couldn't load port number from
/V:/dhis-live/conf/jetty.port (WebAppServer.java [main])
* INFO 09:51:03,080 Loading DHIS 2 on port: 8080 (WebAppServer.java [main])
* INFO 09:51:03,111 Setting DHIS 2 web app context to:
/V:/dhis-live/webapps/dhis (WebAppServer.java [main])
* INFO 09:51:03,111 Lifecycle: server starting (TrayApp.java [main])
* INFO 09:51:08,064 System property dhis2.home points to
/V:/dhis-live/conf (DefaultLocationManager.java [main])
* INFO 09:52:26,706 Executing startup routine [1 of 13, runlevel 0]:
OpenHealthDataSourceWriter (DefaultStartupRoutineExecutor.java [main])
* INFO 09:52:26,706 Environment variable OPENHEALTH_HOME not set
(OpenHealthDataSourceWriter.java [main])
* INFO 09:52:26,706 Executing startup routine [2 of 13, runlevel 0]:
ReportTableUpgrader (DefaultStartupRoutineExecutor.java [main])
* INFO 09:52:55,800 Lifecycle: server started (TrayApp.java [main])

Knut

Lars,

I remember that there was a change some time back to the report table object that needed manual database fix in order to run properly (on databases that already had generated report tables).
I think this is what is causing this error, which I also got when trying to run the latest code with the demo database that comes with the DHIS 2.0.4 Live package.

Tried to search my mail to find your instructions for the database update fix, but couldn’t find it… please help.

Ola

···

On 27 May 2010 09:55, Knut Staring knutst@gmail.com wrote:

Hello,

I’ve had many configurations running on my machine, but currently I

seem unable to get DHIS2 Live to start.

Firefox tells me this:

HTTP ERROR: 503

Problem accessing /. Reason:

SERVICE_UNAVAILABLE

Powered by Jetty://

But there is little info in the log below - It seems to skip all

startup steps after the first two, perhaps because it cannot connect

to a db?

  • INFO 09:51:02,924 Environment variable DHIS2_HOME: null (TrayApp.java [main])

  • INFO 09:51:02,955 Initialising DHIS 2 Live… (TrayApp.java [main])

  • INFO 09:51:03,064 Couldn’t load port number from

/V:/dhis-live/conf/jetty.port (WebAppServer.java [main])

  • INFO 09:51:03,080 Loading DHIS 2 on port: 8080 (WebAppServer.java [main])

  • INFO 09:51:03,111 Setting DHIS 2 web app context to:

/V:/dhis-live/webapps/dhis (WebAppServer.java [main])

  • INFO 09:51:03,111 Lifecycle: server starting (TrayApp.java [main])

  • INFO 09:51:08,064 System property dhis2.home points to

/V:/dhis-live/conf (DefaultLocationManager.java [main])

  • INFO 09:52:26,706 Executing startup routine [1 of 13, runlevel 0]:

OpenHealthDataSourceWriter (DefaultStartupRoutineExecutor.java [main])

  • INFO 09:52:26,706 Environment variable OPENHEALTH_HOME not set

(OpenHealthDataSourceWriter.java [main])

  • INFO 09:52:26,706 Executing startup routine [2 of 13, runlevel 0]:

ReportTableUpgrader (DefaultStartupRoutineExecutor.java [main])

  • INFO 09:52:55,800 Lifecycle: server started (TrayApp.java [main])

Knut


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

This is caused by the upgrade of H2 database in 2.0.5-snapshot. The new H2 version is not compatible with databases created with the previous (as announced on the list). There has been a new sample database for H2 available on dhis2.org for some time: http://dhis2.org/download/dhis2demo-h2-2.0.5.zip

Lars

···

On Fri, May 28, 2010 at 3:00 PM, Ola Hodne Titlestad olatitle@gmail.com wrote:

Lars,

I remember that there was a change some time back to the report table object that needed manual database fix in order to run properly (on databases that already had generated report tables).
I think this is what is causing this error, which I also got when trying to run the latest code with the demo database that comes with the DHIS 2.0.4 Live package.

Tried to search my mail to find your instructions for the database update fix, but couldn’t find it… please help.

Ola

On 27 May 2010 09:55, Knut Staring knutst@gmail.com wrote:

Hello,

I’ve had many configurations running on my machine, but currently I

seem unable to get DHIS2 Live to start.

Firefox tells me this:

HTTP ERROR: 503

Problem accessing /. Reason:

SERVICE_UNAVAILABLE

Powered by Jetty://

But there is little info in the log below - It seems to skip all

startup steps after the first two, perhaps because it cannot connect

to a db?

  • INFO 09:51:02,924 Environment variable DHIS2_HOME: null (TrayApp.java [main])

  • INFO 09:51:02,955 Initialising DHIS 2 Live… (TrayApp.java [main])

  • INFO 09:51:03,064 Couldn’t load port number from

/V:/dhis-live/conf/jetty.port (WebAppServer.java [main])

  • INFO 09:51:03,080 Loading DHIS 2 on port: 8080 (WebAppServer.java [main])

  • INFO 09:51:03,111 Setting DHIS 2 web app context to:

/V:/dhis-live/webapps/dhis (WebAppServer.java [main])

  • INFO 09:51:03,111 Lifecycle: server starting (TrayApp.java [main])

  • INFO 09:51:08,064 System property dhis2.home points to

/V:/dhis-live/conf (DefaultLocationManager.java [main])

  • INFO 09:52:26,706 Executing startup routine [1 of 13, runlevel 0]:

OpenHealthDataSourceWriter (DefaultStartupRoutineExecutor.java [main])

  • INFO 09:52:26,706 Environment variable OPENHEALTH_HOME not set

(OpenHealthDataSourceWriter.java [main])

  • INFO 09:52:26,706 Executing startup routine [2 of 13, runlevel 0]:

ReportTableUpgrader (DefaultStartupRoutineExecutor.java [main])

  • INFO 09:52:55,800 Lifecycle: server started (TrayApp.java [main])

Knut


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp