dhis2-devs team mailing list archive

["jason.p.pickering" <727779@xxxxxxxxxxxxxxxxxx>]

These types of errors seem to result from incorrect permission settings
on the DB for the user which DHIS2 connects to the DB with.

** Changed in: dhis2
       Status: New => Invalid

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/727779

Title:
  startup-routines-fail-when-database-user-permissions-are-not-set

Status in DHIS 2 - District Health Information Software:
  Invalid

Bug description:
  * INFO  13:33:49,514 System property dhis2.home not set
  (DefaultLocationManager.java [Thread-2])
  * INFO  13:33:49,520 Environment variable DHIS2_HOME points to
  /etc/dhis2/ghain/ (DefaultLocationManager.java [Thread-2])
  * INFO  13:35:37,796 Executing startup routine [1 of 12, runlevel 1]:
  TableAlteror (DefaultStartupRoutineExecutor.java [Thread-2])
  * INFO  13:35:42,926 Tables updated (TableAlteror.java [Thread-2])
  * INFO  13:35:42,971 Executing startup routine [2 of 12, runlevel 2]:
  PeriodTypePopulator (DefaultStartupRoutineExecutor.java [Thread-2])
  * INFO  13:35:43,171 Executing startup routine [3 of 12, runlevel 3]:
  TableCreator (DefaultStartupRoutineExecutor.java [Thread-2])
  * INFO  13:35:43,311 Table aggregateddatavalue exists
  (TableCreator.java [Thread-2])
  * INFO  13:35:43,326 Table aggregatedindicatorvalue exists
  (TableCreator.java [Thread-2])
  * INFO  13:35:43,345 Index crosstab exists on table datavalue
  (TableCreator.java [Thread-2])
  * INFO  13:35:43,349 Table aggregateddatasetcompleteness exists
  (TableCreator.java [Thread-2])
  * INFO  13:35:43,354 Table datavaluearchive exists (TableCreator.java
  [Thread-2])
  * INFO  13:35:43,358 Table patientdatavaluearchive exists
  (TableCreator.java [Thread-2])
  * INFO  13:35:43,359 Executing startup routine [4 of 12, runlevel 3]:
  DataElementDefaultDimensionPopulator
  (DefaultStartupRoutineExecutor.java [Thread-2])
  * INFO  13:35:43,431 Linked default category with default concept
  (DataElementDefaultDimensionPopulator.java [Thread-2])
  * INFO  13:35:46,037 Executing startup routine [5 of 12, runlevel 3]:
  MultiDimensionExpressionUpgrader (DefaultStartupRoutineExecutor.java
  [Thread-2])
  * WARN  13:35:46,078 SQL Error: 0, SQLState: 42703
  (JDBCExceptionReporter.java [Thread-2])
  * ERROR 13:35:46,079 ERROR: column dataelemen1_.uuid does not exist
   Position: 166 (JDBCExceptionReporter.java [Thread-2])